All templates

Payroll Template and Reconciliation Workbook

Compare payroll totals, liability balances and dated payments in an editable reconciliation workbook.

Period and evidence

Use document references. Explain every signed adjustment here.

Pay-run totals

Liability balances

Net wages

Positive increases the liability. Negative reduces it.

PAYG withholding

Positive increases the liability. Negative reduces it.

Super

Positive increases the liability. Negative reduces it.

Other deductions

Positive increases the liability. Negative reduces it.

Payments

Payroll reconciliation

Enter payroll totals

Complete the period, pay-run totals and liability balances.

Use totals and document references only. Entries stay on this device and clear when you leave.

Bring Together Pay-Run Evidence

This payroll template compares entered pay-run totals with liability balances and dated payments. It creates an editable payroll reconciliation workbook, with separate differences for net wages, PAYG withholding, super and other deductions.

Gather approved pay-run summaries, the payroll journal and opening and closing liability reports. Keep bank payment files, bank statements, withholding reporting records and super fund receipt evidence with those reports.

Keep a payroll calendar beside the workpaper, with each pay-run period, pay date and planned payment date. Compare actual payment evidence with that calendar when investigating cut-off differences.

Use totals and document references in this workbook. Keep employee names, TFNs, bank details and individual payslips in the client’s authorised payroll records. The example contains fictional totals without employee details.

If you need to export employee data from Xero for a reconciliation, start with the Payroll Activity Summary report. Xero documents report exports to Excel. Match the selected reporting period and keep the original export with the workpaper.

This payroll Excel template reconciles outputs already calculated by the payroll system. Award rates, entitlements, tax withholding and super calculations stay in that system. Enter the resulting super liability separately from gross-to-net deductions.

For year-end reporting, ATO payment-summary guidance distinguishes payment summaries from information reported and finalised through Single Touch Payroll (STP). This workpaper is not an employee payment summary template or an STP report.

Reconcile Payroll and Liabilities

Calculated net pay equals gross pay less PAYG withholding and other deductions. Compare it with entered net pay. Gross and deductions must use the same basis, with each deduction included once. Enter reversals as signed amounts.

For each liability, expected closing equals opening balance plus the pay-run movement plus signed adjustments less payments inside the period. Net wages uses entered net pay as its movement. A difference equals ledger closing less expected closing.

Use positive balances for amounts owed and negative balances for debit amounts. A positive adjustment increases the liability. Record each adjustment’s journal reference and reason in Sources and adjustments. Never insert an unexplained balancing figure.

The fictional example has $10,000 gross pay, $2,300 withholding and $250 other deductions. Calculated and entered net pay both equal $7,450. Super adds a separate $1,200 liability.

The example’s $50 opening super liability is paid inside the period. Its $1,200 current-period super payment falls after period end. Expected and entered closing super liabilities both equal $1,200, with a $0 difference.

Use the reviewer evidence checklist as your payroll checklist for this reconciliation. Mark each item only after matching its supporting records and explaining any difference.

The audit payroll reconciliation template retains source references, preparer and reviewer references, a conclusion and an evidence checklist. Agreement of totals does not establish that pay rates, reporting or payment timing are correct.

Resolve and Retain Differences

A payment after period end stays outside the selected period’s movements. Retain its dated evidence against the closing liability and follow it into the next reconciliation. A payment on either period boundary is included.

Suppose a $500 super payment was posted to PAYG withholding. With the payment evidence correctly classified, the PAYG closing difference is negative $500 and the super difference is positive $500. Both accounts need investigation even though the differences sum to zero.

Correct the wrong ledger posting through an authorised journal and retain its reference. Do not rerun payroll or duplicate a bank payment to fix a posting error. Refresh the ledger balances after the correction.

An unpaid liability can reconcile when the closing account contains the amount still owed. Review payment obligations separately. The ATO’s super payment guidance distinguishes the reported super liability from receipt by the employee’s fund.

Download Excel workbook creates an editable .xlsx file containing the bridges, dated payments and reviewer checklist. Payments outside the period remain listed. A mismatch keeps a differences-required status in the workbook.

The exported amounts are editable values, without live spreadsheet formulas. After editing them in Excel, recalculate and review the schedules before retaining the reviewed version with the client’s period-end records.

The browser keeps entries on this device without uploads or storage. Clear entries and leaving the page remove the working details. Downloaded workbooks remain wherever you save them.