Bookkeeping & payrollPayroll Reconciliation: How to Make Payroll, the Bank, and the Books Agree

There's a popular belief among business owners that if payroll ran and nobody called upset, payroll is fine.

It's a reasonable belief. The payroll provider calculated everything, people got paid, taxes were sent. What else is there?

There's the books. Payroll touches three separate records: the payroll provider's reports, your bank account and your general ledger. Each one can be right on its own while the three disagree with each other. Payroll reconciliation is the monthly habit of making them agree. This guide covers what to compare, a worked example with real-looking numbers, and the usual reasons things don't tie.

What payroll reconciliation actually compares

Each payroll run creates several kinds of numbers:

• Gross wages: total pay before anything is taken out.
• Employee withholdings: income taxes and the employee's share of Social Security and Medicare, held back from each paycheck.
• Employee deductions: things like 401(k) contributions and the employee's share of health premiums.
• Net pay: what actually lands in employees' bank accounts.
• Employer taxes: the employer's share of Social Security and Medicare, plus federal and state unemployment taxes.

In the books, gross wages and employer taxes are expenses. Withholdings, deductions and employer taxes start as liabilities (money you're holding to send to someone else) and drop to zero when they're paid.

A payroll reconciliation checks three things:

1. The payroll register totals match the payroll expense and liability entries in the general ledger.
2. The bank withdrawals match the net pay, tax payments and fees the provider says it took.
3. The payroll liability accounts on the balance sheet return to zero (or to a balance you can explain) after payments go out.

A worked example: one biweekly payroll, three records

Say you run a hypothetical nine-person bakery with biweekly payroll. One run looks like this on the payroll register:

• Gross wages: $28,000
• Employee taxes withheld: $5,600
• 401(k) deductions: $840
• Health premium deductions: $560
• Net pay: $21,000
• Employer taxes: $2,442

Check the math first. $28,000 minus $5,600, minus $840, minus $560 is $21,000. Good.

Now the bank. Over the next few days, you see:

• $21,000 out for direct deposits.
• $8,042 out for taxes ($5,600 withheld plus $2,442 employer share).
• $150 out for the provider's fee.

The $840 of 401(k) contributions goes to the retirement plan separately, and the $560 of health deductions offsets the premium you pay to the insurer each month.

Now the books. The payroll entry should show $28,000 to wage expense and $2,442 to payroll tax expense. On the liability side, the entry sets up $8,042 in tax liabilities, $840 owed to the 401(k) plan, $560 toward health premiums, and $21,000 in net pay. When each payment clears the bank, it reduces the matching liability.

After everything is paid, the tax and net pay liabilities sit at zero. If a liability has a leftover balance that grows every month, something isn't being recorded or matched correctly.

How to reconcile payroll each month

Here's how to reconcile payroll as part of the month-end routine:

1. Download the payroll register summary for every run in the month.
2. Total gross wages, employer taxes, withholdings, deductions and net pay.
3. Compare those totals to the payroll expense and liability accounts in the general ledger for the same period.
4. Match each payroll-related bank withdrawal to the provider's records, as part of your regular bank reconciliation process.
5. Review each payroll liability account. Payroll taxes withheld and employer taxes should clear after each deposit. Benefits liabilities should clear when the plan or insurer is paid.
6. Investigate any difference, fix it, and note what you found.

Each quarter, compare the quarterly payroll tax filings your provider submits with the totals in your books. At year-end, the W-2 totals should tie to the year's wage expense. Your payroll provider handles the filings, and your CPA reviews them in the context of your tax return. The bookkeeping job is making sure the ledger agrees.

Common reasons payroll doesn't tie

When the numbers disagree, start by checking these:

• The bank feed recorded payroll withdrawals as a lump "Payroll Expense," and the provider's sync also posted the full payroll entry. Now wages are counted twice.
• Employer taxes coded to the same account as wages, so labor costs look higher than they are and payroll tax looks like zero.
• Health premium deductions recorded as income instead of reducing the premium expense or liability.
• Manual checks, bonuses or voided paychecks that never made it into the books.
• A provider tax notice or penalty paid from the bank with no matching entry.
• Payroll timing across month-end: a pay period that ends March 29 but is paid April 3. On accrual books, those wages belong to March.

We see the first one a lot, and it's the easiest to fix going forward: let the payroll sync create the entry, and have the bank feed match to it rather than add a new expense.

Why this matters more than it looks

For many service businesses, payroll is the largest expense on the P&L. A small coding error repeated 26 times a year adds up. In businesses where labor is the product, like staffing and recruiting firms, payroll timing and accuracy drive gross margin directly. Our guide to staffing agency accounting shows how this plays out when payroll runs weekly and client invoices are paid on terms.

Payroll reconciliation also protects you on the tax side. Your CPA works from your books, and payroll numbers that don't match filed returns lead to questions and extra work.

If you're deciding what to hand off and what to keep, our article on outsourced payroll services sorts it out. Even when a provider runs payroll, someone still needs to reconcile it to the books.