Reconciling the Payment Summary Report with the Detailed Activity Report is an important end-of-financial-year (EOFY) step. This process helps verify that the payroll figures reported are accurate and that the totals in both reports match before completing your year-end reporting.
Before you begin
Export both of the following reports to Microsoft Excel:
Payment Summary Report
Detailed Activity Report
Update the Payment Summary report
In the exported Payment Summary Report, add the following columns together to calculate the total reportable earnings:
Gross Payments (Column I)
Allowances (Column M)
Lump Sum A – Type R (Column N)
Lump Sum A – Type T (Column O)
Lump Sum B (Column P)
Lump Sum D (Column Q)
Lump Sum E (Column R)
CDEP Payments (Column S)
Exempt Foreign Employment Income (Column T)
ETP Amounts (Not Reported) (Column W)
Payroll Pre-Tax Deductions (Column AC)
The combined total should closely match the Gross Earnings total in the Detailed Activity Report (allowing for minor rounding differences).
Compare payroll gross earnings
Finally, compare the payroll gross earnings between the two reports:
Payment Summary Report: Payroll Gross Earnings (Column AB)
Detailed Activity Report: Gross Earnings (Column G)
These totals should match exactly.
Tip: If the totals do not reconcile, review any payroll adjustments, allowances, lump sum payments, pre-tax deductions, or other transactions processed during the financial year before completing your EOFY reporting.