Payroll Reconciliation: Check Payroll Against Your Books

Payroll reconciliation is the check that what you told your accounting system you paid people actually matches what your payroll provider paid them, and what left the bank. It sounds like it should be automatic, and mostly it is, until a pay period spans two months, a benefits deduction lands in the wrong account, or an employee's state withholding never gets updated after a move. Nearly one in five payroll runs in a traditional process carries an error of some kind (EY, cited by Paycom). Here is how to check gross wages, withholdings, employer taxes and net pay against the general ledger, the breakage points to expect, and a checklist you can run every month.

What payroll reconciliation actually checks

Your payroll provider produces a payroll register for every run: a detailed report showing, per employee, gross wages, every tax and benefits withholding, employer-side taxes, and net pay. Your accounting system separately books a payroll journal entryfor the same run, translating that same information into debits and credits against wage expense, tax expense, various liability accounts, and cash. Reconciliation is the process of confirming those two records agree. It matters because payroll is usually a business's largest single expense line, and because a mismatch there tends to mean either an employee was paid wrong, a tax liability is misstated, or both.

What you need before you start

Gather the payroll register for the period (most providers export this as a CSV or PDF), the GL detail for every payroll-related account (wage expense, payroll tax expense, benefits payable, tax withholding liabilities, and cash), and your bank statement showing the actual net-pay withdrawal. If your provider posts payroll through a clearing account rather than straight to cash, pull that account's activity too — it should sit at zero between pay runs if everything cleared correctly.

Payroll reconciliation, step by step

Step 1: Match gross wages

Total gross wages across all employees on the register and compare it to the wage expense booked in the GL for the same pay period. This is usually the easiest figure to tie out, since most systems post it as a single lump sum, and a mismatch here is often a sign the wrong pay period was booked entirely.

Step 2: Match withholdings and deductions

Break out employee withholdings (federal and state income tax, FICA) and voluntary deductions (health insurance, 401(k), garnishments) and check each category against its own GL liability account. Ensure gross-to-net calculations are accurate and that the correct tax rates and deductions were applied before assuming a variance is a coding error rather than a calculation one.

Step 3: Match employer-side taxes

Employer taxes — the employer's share of FICA, plus federal and state unemployment (FUTA/SUTA) — never touch the employee's pay cheque but still need to hit payroll tax expense and a corresponding liability account. This step is easy to skip because it does not show up anywhere on an employee's pay stub, but it is real cash the business owes.

Step 4: Match net pay to the bank

Compare the register's total net pay to bank withdrawals and verify individual payments were processed correctly, whether that is one lump direct-deposit batch or a series of individual transfers. If your payroll runs through a clearing account, that account should return to zero once the batch settles; a balance left sitting there after a few days is usually the first sign something did not reconcile cleanly.

Step 5: Investigate and resolve any variance

Work through likely causes before assuming the worst: a timing difference from a pay period crossing month end, a deduction posted to the wrong account, or a manual off-cycle payment that missed one side of the entry. Map each payroll expense type to its proper general ledger account and compare register totals to GL postings line by line rather than only checking the grand total, since two errors can offset each other and still look clean at the top level.

Worked example

A 40-person logistics firm runs biweekly payroll. For the June 15 pay run, the payroll register shows the following.

Total payroll cost — gross wages plus employer taxes — should be $138,230.00. But the GL payroll expense accounts for this run only total $136,990.00, a $1,240.00 shortfall. Investigating line by line, the bookkeeper finds that a $1,240.00 catch-up 401(k) employer match, agreed after an employee correction earlier in the year, was paid to the plan provider directly and never booked as payroll expense at all.

A single journal entry books the missing $1,240.00 to benefits expense and the corresponding liability, and the two records tie out. Nothing here was a payroll error in the sense of anyone being paid incorrectly; it was a posting gap between two systems that only monthly reconciliation was going to catch.

Common breakage points

Timing: accruals across a period boundary

When a pay period straddles month end, the days worked before the cutoff belong in that month's expense even though the actual pay run happens after it closes. Skipping this accrual understates expense in the closing month and overstates it in the next one — a classic timing difference, not a real error, but one that needs an entry (and a reversal) every single month if your pay cycle does not line up neatly with your accounting calendar.

Benefits deductions posted to the wrong account

Health insurance, 401(k) contributions and HSA deductions each need their own liability account, and it is easy for a new deduction code to get mapped to the wrong one, or to no specific account at all, especially after a benefits provider change. This tends to surface as a liability account that never clears to zero even though premiums are being paid correctly.

Multi-state and multi-locality tax setups

An employee who moves state, or who splits time between two work locations, needs their withholding setup updated in the payroll system — and if it is not, the register keeps withholding for the old jurisdiction while the actual tax liability has shifted. This is one of the more expensive breakage points to leave unresolved, since it compounds every pay period until a state notice arrives.

Monthly payroll reconciliation checklist

Run through the same list every period, in the same order, so nothing gets skipped:

1. Total gross wages on the register and match to GL wage expense.
2. Match each withholding and deduction category to its GL liability account.
3. Match employer-side taxes to payroll tax expense and the matching liability.
4. Match net pay to the actual bank withdrawal, or confirm the clearing account is at zero.
5. Confirm any period-end accrual was booked, and that last period's accrual reversed.
6. Check for off-cycle payments (bonuses, corrections, final pay) booked on only one side.
7. Document the variance found, if any, and the entry made to resolve it.

As Peggy James, a CPA and small-business consultant, puts it: "if you've been reconciling each payroll throughout the year, your [year-end] reconciliation will be quick. But if you haven't kept up, you'll need to go back and reconcile each payroll run to make sure everything matches your journals and bank statements" (OnPay). The checklist above is exactly what keeps that from turning into a scramble every December.

A composite example: catching a multi-state error early

A ten-person remote consultancy had one employee relocate from Ohio to Illinois in March. Payroll kept withholding Ohio state tax for two more pay periods before anyone updated the employee record. Because the firm reconciled payroll monthly rather than only at year end, the mismatch between the employee's new home address on file and the state tax liability account showed up in April's reconciliation, not in a January tax notice ten months later. The correction cost one amended filing and a short conversation with the employee; catching it in January instead would likely have meant penalty interest on top.

Where payroll fits in your wider close

Payroll reconciliation belongs on the same monthly schedule as your other control accounts — see our types of account reconciliation overview for how it sits alongside cash and AR, and our accounts receivable reconciliation guide and three-way match explainer for the other two big recurring checks most small businesses need each month. Add payroll as a fixed line on your month-end close checklist, and if you want a structured starting point rather than building one from scratch, the reconciliation template library includes a payroll tie-out template ready to adapt.

FAQs

A payroll reconciliation that runs every month, on the same checklist, is what keeps a $1,240.00 posting gap from turning into a year-end scramble or a state tax notice. See our pricing if you would rather bring payroll, AR and bank reconciliation together into one monthly routine instead of three separate spreadsheets.