Expected file format:
- Excel File
- Columns may appear in any order
- First row MUST contain the column names as described below
- All required columns must appear in the file. Other columns are optional.
- Columns are not case sensitive. Description is the same as DESCRIPTION.
- Existing staff are located by Staff Id or SSN
- New staff deductions are created.
- Existing deduction's current amounts are adjusted
Details for data in the template:
| Column | Sample Data | Required? | Notes |
| Staff Id | 1000 | YES | Staff Id field or SSN field is required. |
| SSN | 123-45-6789 | YES | Staff Id field or SSN field is required, Must be in the format '###-##-####'. |
| Last Name | Doe | No | |
| First Name | John | No | |
| Code | F403B | YES | Deduction Code MUST match the deduction code from SchoolFi and can be found on the Payroll >> Setup >> Deductions tab in the CODE column. |
| Per Pay Amount | 100.00 | YES | Must be a positive numerical value. |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article