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.
To do this you:
- Add columns I and then M through W + column AC (Payroll Pre Tax Deductions). Column W contains ETP amounts. That should equal the Gross earnings section of the DAR - rounding
2. The payroll gross earnings column (AB) + lump sum D (column Q) should equal the DAR exactly.
For more information about EOFY, see our End of Financial Year 2015/2016 - Guide
If you have any questions or feedback, please let us know via firstname.lastname@example.org