Articles in this section

How to reconcile payroll balances for month-end and EOFY

Payroll EOFY

How to reconcile payroll balances for month-end and EOFY

Reconcile payroll, general ledger, and statutory reporting figures before rolling into a new period.

Overview

Reconciling payroll helps you identify which period is out of balance and ensures your payroll, general ledger, and statutory reporting figures align.

You can roll your Payroll module into the next period even if it does not reconcile. However, best practice is to complete reconciliation before rolling, so any discrepancies are clearly identified in the correct month.

Note: Complete payroll reconciliation before progressing to other EOFY payroll tasks wherever possible. This makes it easier to identify and resolve issues in the correct reporting period.

Step 1 — Reconcile accumulated pay to the general ledger

Confirms that payroll totals posted in Jobpac match your general ledger balances.

1Run the Accumulated Pay report.
Payroll > Payroll Reports > Accumulated Pay
2Run the Trial Balance report.
Finance > General Ledger > Reports > Trial Balance
3Run the Company Transactions report.
Payroll > Company Information > More Options > Company Transactions Report
4Compare the final totals across these three reports to confirm payroll postings align with the general ledger.

Step 2 — Reconcile accumulated pay to employee group (STP)

Ensures payroll totals align with Single Touch Payroll (STP) employee group values.

1Run the Accumulated Pay report.
Payroll > Payroll Reports > Accumulated Pay
2Run the STP2 Employee Gross Values report.
Payroll > Employee Information > STP2 Emp Gross Values
3If discrepancies are identified, run the following utility if required.
Payroll > Utilities > Fix Trans Group Tax Code
4Confirm the final totals match between the payroll and STP reports.

Step 3 — Reconcile leave entitlements to general ledger balances

Ensures leave accrual balances align with your general ledger leave provision accounts.

1Run the Leave Accruals report.
Payroll > Employee Reports > Leave Accruals
2Run the Trial Balance report.
Finance > General Ledger > Reports > Trial Balance
3Compare leave entitlement totals to the relevant leave provision accounts in the general ledger.
4Enter manual general ledger journals to adjust for any variance between the two reports.
5If required, run the following utility.
Payroll > Utilities > Recalculate Entitlements

Note: Actual leave entitlement provision values are not posted automatically by the Jobpac payroll system. These balances must be maintained manually using general ledger journals.

Step 4 — Reconcile superannuation

Ensures superannuation totals align across payroll, STP, and superannuation reporting.

1Run the Accumulated Pay report.
Payroll > Payroll Reports > Accumulated Pay
2Run the STP2 Employee Gross Values report.
Payroll > Employee Information > STP2 Emp Gross Values
3Run the Superannuation Reports.
Payroll > Other Reports > Superannuation Reports
4Compare the final superannuation totals across all reports and confirm they match each individual super fund balance.

You're done when:

✓ Accumulated pay totals match the general ledger trial balance
✓ Accumulated pay totals match the STP2 employee gross values
✓ Leave accrual balances match your GL leave provision accounts
✓ Superannuation totals match across payroll, STP, and super fund reports
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.