A crucial part of wrapping up EOFY is reconciling the Payment Summary report to the Detailed Activity Report.
Once you have exported to excel (more about generating Payment Summaries HERE), your next task is to reconcile the spreadsheet to the Detailed Activity Report you've also downloaded to excel.
To do this...
Go to the Payment Summary report you've downloaded:
- Add the following columns:
- Column I
- Columns M through to T
- Column W (W being ETP amounts from the separate tab)
- Column AC (Payroll Pre Tax Deductions).
This total should equal the Gross earnings column of the DAR (- rounding)
2. The payroll gross earnings column (AB) in the Payment Summary report should be equal to the Gross earnings (column G) in the Detailed Activity Report exactly.
For more information about EOFY, see our End of Financial Year 2016-2017 - Guide
If you have any questions or feedback, please let us know via firstname.lastname@example.org