Prestige Student Management Systems
PROCESS FOR IMPORTING DISBURSEMENT JOURNALS
Introduction:
The purpose of this document is to complete the process for Importing disbursements from your financial aid third party processor.
Creating your import document:
You can can use either excel or google sheets to create your import. The required fields will be the field with the * next to the column header. The required fields for importing disbursements are.
- Voucher Number
- Social Security Number
- Date of Disbursement
- Amount
- Financial Aid Program Type
- Award Year (example 2018-2019 or 2019)
- Pay Period Hours
Column Header Tags
You will copy and paste the column header tags from the Import Data page.
Example of import Documents Setup:
|
VOUCHER# |
SSN |
DATE_OF_DISBURSEMENT |
AMOUNT |
FA_TYPE |
AWARD_YEAR |
PAY_PERIOD_HOURS |
|
19825 |
000-00-0000 |
1/29/2019 |
2100 |
PELL |
2018-2019 |
451 |
Import Location:
Step 1: Go to Setup & Customization/ Import Data
Step 2: Select Import Disbursement Payments
Step 3: Pick Import Type
Step 4: Pick Vendor Type
Step 5: Drag and Drop File or click Browse to load the document.
Step 6: Click Import
Once the Import is done if it states (15 records imported) the import had no errors, if an error occur it will give you the line # and type of error that occurred.
Example of Warning Errors:
|
WARNING: Line 2: SSN=;Financial Aid Program Type 'FPELL' is not recognized |
|
WARNING: Line 3: SSN=;Financial Aid Program Type 'FPELL' is not recognized |
|
WARNING: Line 4: SSN=;Financial Aid Program Type 'FPELL' is not recognized |
|
WARNING: Line 5: SSN=; is not recognized. |
|
WARNING: Line 6: SSN=; is not recognized. |
|
WARNING: Line 7: SSN=; is not recognized. |
Prestige School Management Systems