Payroll is usually the largest cost in the business and one of the easiest places for errors and fraud to hide.
Reconcile payroll in three directions each month. Agree the payroll report totals to the journal posted in the ledger. Agree net pay to the bank payment. Then reconcile each payroll control account, such as tax, social security and pension deductions, so the balance equals the amount due to be paid over. Investigate starters, leavers and unusual changes against the previous month.
A payroll reconciliation shows that what the payroll system calculated, what the ledger recorded and what left the bank all agree, and that the amounts owed to the tax authority, pension provider and other third parties are complete and correct. It is one of the core accounts to reconcile monthly.
Take the payroll summary for the period and compare each total to the payroll journal posted:
| Payroll summary line | Ledger account |
|---|---|
| Gross pay | Wages and salaries expense (by department) |
| Employer social security contributions | Employer taxes expense |
| Employer pension contributions | Pension expense |
| Income tax and employee contributions deducted | Tax and social security control account |
| Pension deductions (employee and employer) | Pension control account |
| Other deductions | Other deductions control accounts |
| Net pay | Net wages control account (or bank) |
The journal must balance: gross pay plus employer costs equals net pay plus all deductions plus employer amounts payable. Any difference usually means a manual adjustment was made in one system but not the other.
Agree net pay on the payroll report to the payment file and the bank statement. If you use a net wages control account, it should clear to zero once the payment goes out. A balance left on it means a payment was missed, duplicated or paid at a different amount from the report.
Also check that the number of payments in the bank file equals the number of employees paid in the payroll report. A mismatch can point to a payment added outside the payroll system. See payment file tampering controls.
Each deductions control account should hold only the amount not yet paid over. Build a simple roll-forward for each:
Opening balance
+ Deductions and employer amounts from this period's payroll
− Payments made to the tax authority / pension provider
= Closing balance
The closing balance should equal the amount due on the next submission or return. If it doesn't, list the reconciling items: late payments, corrections to earlier periods, or amounts posted to the wrong account. A balance that grows month after month is a warning sign that something isn't being paid or cleared.
In Excel, with the opening balance in B2, period deductions in B3 and payments in B4:
=B2+B3-B4
compare to the amount on the submission in B6 with =B5-B6, which should be zero or fully explained.
Compare this month's payroll to last month's by employee. In Excel, with employee IDs in column A and gross pay in column C on both sheets:
=C2-XLOOKUP(A2,Prior!A:A,Prior!C:C,0)
Any employee returning a full amount was not paid last month: confirm they are a genuine starter. Then check the other way: every employee on last month's sheet who is missing this month should be a confirmed leaver. Review large changes against approved pay rises, overtime and bonuses. See reconciling with XLOOKUP.
For more, see payroll fraud red flags.
Someone independent of payroll processing should prepare or at least review the reconciliation. Payroll staff can provide the reports, but the person who can change employee records and pay rates should not be the person who confirms the result is correct.
In the UK, deductions are paid to HMRC through PAYE and reported under Real Time Information, with pension contributions under auto-enrolment rules. In the US, federal and state withholding and FICA are deposited with the IRS and state agencies on their own schedules. Rates, thresholds and deadlines change, so check the current rules with HMRC, the IRS or your state agency.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
Score a payment request against the warning signs of fraud. Free to use online.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
Every pay run for the bank and net pay check, and at least monthly for the ledger and control accounts.
Usually because payment to the tax authority falls after the month end, or because a correction from an earlier period is sitting in the account. Both should be listed as reconciling items.
Reconcile the totals first. Then review departmental coding, because wrong cost centres distort management accounts even when the totals agree.
Last updated 04 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.