Paying Interest on Summer Pay: Paying Summer Pay Interest to Staff

Modified on Thu, Aug 29 at 4:19 PM

1. From the Payroll > Setup > Summer Pay > Interest Import screen you will load the file from which the interest earnings will be created.

2. The Interest Import Template

.Complete a simple Excel spreadsheet with the following columns:
- Staff ID#
- Interest Amount
Save the spreadsheet as a Tab Delimited file
On the screen, select which pay period the interest will be paid to the employees
Click the Choose File button and navigate to the location on your computer where you save the Tab Delimited file
Click the Upload and Import button and the file will be uploaded and the data pushed out to the employees' Other Earnings tab.

You will complete the Staff ID column, NOT the Staff Object Id column, with the employees' Staff ID number.

3. Once you have filled in the template for the staff members who are getting an interest payment, save the Excel template as a "tab delimited file":

4. Make sure you have properly configured the "Other Earning" type you are using to pay the Summer Pay INTEREST (not the same as the Summer Pay Other Earning).

If the Summer Pay Interest Other Earning is not yet setup, you must set it up now.

5. Upload the tab delimited file into SchoolFi using the Import tool on the Payroll→Setup→Summer Pay→Interest Import screen:

Go to the Payroll→Setup→Summer Pay→Interest Import screen.
Go to "Step 3" on that screen:
Select the Payroll in which the Summer Pay Interest is to be paid in the "Import into Payroll" field.
Select the file to upload - the tab delimited file you created from the completed Excel spreadsheet.
Click the button to do the actual import.
You should now check staff member's Personnel→Modify Staff→Payroll→Other Earnings screen to verify that the Interest Other Earning has been created.

NOTES: only taxes will come out of the interest earnings (will be very minimal). No other deductions should be coming out. Ignore any errors you receive about gross not equaling distributions. The interest earnings do not need account numbers.