A crucial part of wrapping up EOFY is reconciling the data you have sent to the ATO to the Detailed Activity Report (DAR).
If you are lodging payment summaries you will use the Payment Summary report - get this from Excel button on the payment summaries screen
More about generating Payment Summaries HERE.
Once you have your two reports (downloaded to excel spreadsheet) your next task is to reconcile the data within them.
If you're submitting payment summaries - 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).
2. The payroll gross earnings column (AB) in the Payment Summary report should be exactly the same as the Gross earnings (column G) in the Detailed Activity Report
The total from 1. should be the same as the total from 2. (allow for rounding)
If you have any questions or feedback, please let us know via support@yourpayroll.com.au