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 F and then I through T and then add the sum of column E on the ETP sheet. That should equal the Gross earnings section of the DAR - rounding
2. The payroll gross earnings column (X) + lump sum D (column N) + column E on the ETP sheet should equal the DAR exactly.
For more information about EOFY, see our End of Financial Year 2015/2016 - Guide