End of Year Reconciliation

Follow

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:

  1. 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

2017-06-20_12-17-53.jpg

 

          2. The payroll gross earnings column (AB) + lump sum D (column Q) should equal the DAR exactly.

2017-06-20_12-23-17.jpg

 

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 support@yourpayroll.com.au

 

 

Powered by Zendesk