Updated October 12, 2026
Directions
- 1 - Use this form to audit whether an employee has been overpaid or unpaid, then adjust the remaining salary.
- 2 - Fill in shaded cells only (if cell is not applicable, type "0")
- 3 - Run the Periodic Payroll Register report. From Date = 1st check of school year. To Date = most recent check.
- 4 - Add salary-related amounts together (i.e. salary, unpaid leave, retro pay, paid time off - excluding parental leave).
- 4a - do not include amounts for pay not related to the agreement (i.e. after-school, stipends, bonus, etc.)
- 5 - Add together all salary-related amounts (i.e. salary, unpaid leave, retro pay, paid time off - excluding parental leave).
- 6 - Once all shaded cells are filled, the adjusted pay will display in the red outlined box.
- 7 - Review the section at the bottom of the form to validate its accuracy.
Employee Information
Calculator and Results
(ex. 190 for teachers, 240 for admin, etc.)
For gross wages, follow above directions # 3-5
(use total annual salary as if employee is working all days)
(Include all paid time off (except parental leave))
(as shown on the periodic payroll register for parental leave)
(if all parental leave has not been paid, include remaining here)
(be sure to count all workdays to end of agreement)
(be sure to use the correct pay cycle as noted above)
- Daily Rate
- Projected Total Days
- Parental Leave Paid
- Parental Leave Owed
- Remaining Salary
- New Per Check Pay
The section to the right will auto-fill once the above calculator is complete.
If the form balance does not equal true, an error may be present in the above calculation - do not provide to the employee.
- # of days missed
- Amount of Unpaid Time
- Year End Wages
- Total Salary minus Year End Wages
- Does form balance?
Other Client Forms
Let’s Start a Conversation
Tell us what you are working on and we will tell you how we can help.
Talk with a Proactive CPA