In SchoolFront Time & Attendance, districts have the ability to export employee pay rates from the system, mass update this data in the exported Excel grid, which can then be imported back into the system with the new data changes. This makes for a quick update of several or all Pay Rates in Time & Attendance. An example of when this may be useful would be when a bargaining unit agreement is ratified and entitles members to an increase in their rate of pay. The district could use this process to quickly update the pay rates for all members of the bargaining unit at once.
Applicable Roles:
HR Admin
HR Team
Business Office
Mass Update Pay Rates Process
- Navigate to Time & Attendance -> Import/Export -> Export/Import Pay Rates from the left navigation menu.
- Click the button for "Click here to download current data sheet to excel format".
- Update any necessary employee pay rates and save the file.
- Navigate to Time & Attendance -> Import/Export -> Export/Import Pay Rates again.
- Either click in the Import box to select your saved file from the directory, or drag & drop the file into the box.
Click the Preview Import button to review the changes - the system will tell you at the top in red if there are any errors. Scroll down through each entry to view then correct errors listed under the Error List column.
- Using the filter under the Has Errors (Checked) column can be helpful to bring up only those rows with errors.
- Correct all errors on the saved file and save again. Click the Cancel Import button, then upload again and click Preview Import. Repeat this process until no errors appear.
- Once all errors have been corrected and the preview looks ready to import, click the Import Data button to import the data with the changes.