Payroll reconciliation for small business

Payroll reconciliation for a small business is a monthly check, not a year-end project. Most owners run payroll through a provider such as Gusto, ADP or QuickBooks Payroll, and the provider’s reports always agree with themselves. What nobody checks is whether the books agree with the provider, and the place that shows it is the balance sheet: a Payroll Taxes Payable account carrying thousands of dollars that nobody owes.

The articles that rank for this topic are written for finance teams reconciling time cards and pay rates across hundreds of employees. This one is for an owner with a handful of employees, a payroll provider and QuickBooks Online. It covers the four records that must agree, a worked month and quarter, what a payroll liability balance should look like, and how to find the entries that keep it from clearing. Federal rules are cited to the IRS; Ledgerbrook keeps books and does not run payroll.

The four records that must agree

Record	What it shows	Must agree with
Payroll register (the provider’s payroll journal or summary report)	Gross pay, each withholding, employer taxes and net pay, per pay date	The bank, for net pay and tax debits; the books, for gross wages and employer taxes
Bank statement	The withdrawals: net pay, tax payments, benefit and retirement remittances, the provider’s fee	The register’s totals for the same pay dates
Payroll accounts in the books	Wages and Salaries, Employer Payroll Taxes and the liability accounts	The register for expenses; zero, or a known unpaid amount, for liabilities
Form 941, each quarter	Wages, federal withholding, Social Security and Medicare wages and tax, and deposits	The register for the quarter; together, the four 941s must agree with the W-3

The provider files the 941 from its own register, so in a provider-run payroll the first and fourth rows usually agree. The two rows that drift apart are the bank and the books, because they depend on how each payroll was entered in QuickBooks.

A payroll, from the register to the books

Here is one pay date for a business with four employees, in a state with no income tax. By October every employee has passed the federal and state unemployment wage bases, so there is no FUTA or state unemployment tax on this payroll.

Line on the register	Amount
Gross wages	$10,000.00
Federal income tax withheld	$1,100.00
Employee Social Security, 6.2%	$620.00
Employee Medicare, 1.45%	$145.00
401(k) deferrals	$400.00
Net pay	$7,735.00
Employer Social Security, 6.2%	$620.00
Employer Medicare, 1.45%	$145.00
Federal tax deposit (withholding plus both shares)	$2,630.00

The provider pulls three amounts from the bank: net pay of $7,735, the tax deposit of $2,630, and later the $400 it sends to the 401(k) plan. The entry the books need for this pay date, using the account names from Gusto and QuickBooks Online:

Date	Account	Debit	Credit
Oct 9	Wages and Salaries	10,000.00
Oct 9	Employer Payroll Taxes	765.00
Oct 9	Operating Checking (net pay)		7,735.00
Oct 9	Operating Checking (tax deposit)		2,630.00
Oct 9	401(k) Payable		400.00
Total		10,765.00	10,765.00

When the provider’s integration posts this entry, each bank debit is matched to it in the bank feed rather than added again. When the provider holds the taxes and pays them later, as happens when a business deposits its own taxes, the $2,630 is credited to Payroll Taxes Payable instead, and the later payment debits that account.

The monthly payroll reconciliation

Run it after the bank account is reconciled for the month, so every payroll withdrawal is already accounted for. The business above paid on October 9 and October 23, with the same amounts each time.

Step 1: register to bank

Item	Register, October	Bank, October	Difference
Net pay	$15,470.00	Two net pay debits, $15,470.00	$0
Federal tax deposits	$5,260.00	Two tax debits, $5,260.00	$0
401(k) remittances	$800.00 deferred	$800.00 paid: September 25 deferrals on Oct 2, October 9 deferrals on Oct 13	$0 in total; October 23 deferrals go out Nov 2

The 401(k) line matches in total but not by pay date, which is a timing difference. A timing difference is fine if you can name it. Anything else, such as a net pay total that does not match, usually means a manual check written outside the provider, a voided paycheck the provider reversed but the bank feed did not, or an off-cycle bonus run that was never entered in the books.

Step 2: register to the books

Account	Register, October	Books, October	Should be
Wages and Salaries	$20,000.00 gross	$20,000.00	Equal
Employer Payroll Taxes	$1,530.00	$1,530.00	Equal
Payroll Taxes Payable, Oct 31	$0 owed	$0	Equal
401(k) Payable, Oct 31	$400 not yet remitted	$400.00	Equal

Pull the books side from the Profit and Loss for the month and the Balance Sheet at month end. For a liability account, the Account QuickReport (in Chart of accounts, the Run report action on the account) lists every entry that moved it.

Step 3: roll each liability forward

Each payroll liability should obey one formula for the month:

Ending balance = Beginning balance + Amounts withheld or owed this month − Amounts paid this month

For Payroll Taxes Payable in October, when the taxes pass through that account, it is $0 + $5,260 − $5,260 = $0; when the synced entry credits the bank directly, nothing passes through and it stays at $0. For 401(k) Payable, it is $400 (September’s last deferrals, remitted October 2) + $800 − $800 = $400. If the formula gives a different ending balance than the Balance Sheet, the difference is an entry posted to the wrong account, and the QuickReport shows which one.

Why payroll liabilities do not clear

The most common pattern is a provider that posts its journal entry to the liability, and a tax debit from the bank feed that someone categorized as an expense. Here is October for the same business, set up so the synced entry credits Payroll Taxes Payable, with that error and without it:

	Correct	Tax debits categorized as expense
Synced entries credit Payroll Taxes Payable	$5,260.00	$5,260.00
Tax payments debit Payroll Taxes Payable	$5,260.00	$0
Payroll Taxes Payable, Oct 31	$0	$5,260.00 credit
Employer Payroll Taxes for October	$1,530.00	$6,790.00

The expense is overstated by exactly the liability that never cleared, and a year of it adds up to a large false liability and a payroll tax expense several times what the business owes. The other causes, in the order they usually happen:

1. A payroll recorded twice. The provider’s entry synced, then the net pay debit was also added from the bank feed. Wages are doubled and the bank reconciliation is thrown off by one paycheck run.
2. Net pay only. No provider entry at all, and the net pay debit was coded to Wages and Salaries. Wages are understated by the withholding, employer taxes are missing, and the tax debits land in whatever account the bank feed suggests.
3. A tax payment made outside the provider. A late deposit or a penalty paid directly to the IRS, coded to the liability when the provider had already cleared it, which leaves a debit balance.
4. A voided or reissued check. The provider reversed the paycheck; the books kept the original, so wages and the liability stay overstated.
5. A provider change. The old provider’s accounts were never emptied, and the new one posts to accounts with different names.

A negative (debit) balance in a payroll liability means more was paid than recorded as owed, which points to cause 3 or a tax payment entered twice. A credit balance that only grows points to the expense-coding pattern above, or to cause 4.

The quarterly 941 reconciliation

Each quarter, tie the provider’s Form 941 to the register and to the books. For the business above, the third quarter of 2026 had seven biweekly pay dates of the same size, from early July through September 25:

941 line	Amount	Ties to
Line 2, wages, tips and other compensation	$67,200.00	Gross wages $70,000 minus $2,800 of 401(k) deferrals
Line 3, federal income tax withheld	$7,700.00	Register
Line 5a, taxable Social Security wages	$70,000.00	Register; × 12.4% = $8,680.00
Line 5c, taxable Medicare wages	$70,000.00	Wages and Salaries for the quarter; × 2.9% = $2,030.00
Line 12, total taxes after adjustments	$18,410.00	$7,700 + $8,680 + $2,030
Line 13, total deposits	$18,410.00	Seven tax debits of $2,630 on the bank statement

Employer Payroll Taxes for the quarter should be $5,355, half of the Social Security and Medicare tax, because the unemployment taxes were all paid earlier in the year. A difference of a few cents on line 12 is expected: the 941 has a line for the fractions-of-cents adjustment (IRS Publication 15, 2026).

Line 2 is lower than line 5c because 401(k) deferrals reduce income tax wages but not Social Security and Medicare wages. A business with pre-tax health insurance under a cafeteria plan will see that deduction reduce all three wage lines, so its 941 wages can be lower than the books’ gross wages on every line. Both are expected differences; write them down so next quarter’s check starts from a known gap.

The 941 is due by the last day of the month after the quarter: April 30, July 31, October 31 and January 31 (Publication 15), moved to the next business day when the date falls on a weekend or holiday. Doing this tie-out before the provider files is the cheapest time to find an error, because a correction after filing goes on Form 941-X.

Year-end: the four 941s against the W-3

At year end the same tie-out runs once more, at a larger scale: the four quarters added together must agree with the W-3’s wage and tax boxes, and the IRS compares them. When they do not agree, “the IRS or the SSA may contact you to resolve the discrepancies” (Publication 15). The 941-to-W-3 table, W-2 deadlines and corrections are in the year-end payroll checklist. A business that has reconciled each month and each quarter usually finds the annual check takes minutes.

What it costs when payroll taxes are not paid

Reconciling the liability accounts is how a business notices that a tax deposit was missed. The penalties grow quickly, and the IRS figures them in calendar days from the due date (IRS Publication 15, 2026):

Deposit made	Penalty on the late amount
1 to 5 days late	2%
6 to 15 days late	5%
16 or more days late, or paid directly to the IRS instead of deposited	10%
Still unpaid more than 10 days after the first IRS notice	15%

Withheld income tax and the employees’ share of Social Security and Medicare are trust fund taxes. If they are not deposited and cannot be collected from the business, the trust fund recovery penalty, “100% of the unpaid trust fund tax,” can be assessed personally against anyone responsible for paying them who acted willfully, including owners and officers. A payroll provider that is paying taxes as expected makes this rare; a business that deposits its own taxes, or one whose provider account was suspended, needs the monthly liability check most. What one late quarter adds up to, with the filing and payment penalties and interest on top, is worked through in the Form 941 late filing penalty.

How to reconcile payroll in QuickBooks Online

A bank reconciliation in QuickBooks Online confirms the payroll withdrawals but not the payroll accounts, so the rest of the check is done with reports:

1. Reconcile the bank account for the month first, so the payroll debits are confirmed against the statement. The steps are in how to reconcile in QuickBooks Online.
2. Run the provider’s payroll summary for the same dates and note gross wages, employer taxes, net pay and each deduction.
3. Run the Profit and Loss for the month and compare Wages and Salaries and Employer Payroll Taxes to the summary.
4. Run the Balance Sheet at month end and check each payroll liability against the roll-forward formula.
5. Open the Account QuickReport for any liability that does not agree, and look for a bank feed transaction categorized to an expense or a duplicate payroll entry.

Fix differences in the month they happened if that month is still open. If the month is closed or the year has been filed, the correction is a decision for your preparer, because it changes the payroll expense on a return.

Common questions about payroll reconciliation

How do I reconcile my payroll to the general ledger?

Compare the payroll register’s gross wages and employer taxes with the wage and payroll tax expense accounts for the same period, then check that each payroll liability account equals what is actually still owed. The tables above show the comparison for one month.

How to reconcile 941 with payroll?

Add up the register for the quarter and compare it line by line with the 941: wages on line 2, withholding on line 3, Social Security and Medicare wages on lines 5a and 5c, and total deposits on line 13. Differences should be explainable by pre-tax deductions or fractions of cents.

What is a payroll liability?

An amount the business has withheld from employees or owes on its own account but has not yet paid: withheld income tax, both shares of Social Security and Medicare, unemployment taxes, and deductions such as 401(k) deferrals. It sits on the balance sheet as a current liability until the payment goes out.

Should payroll liabilities be negative on a balance sheet?

No. A negative payroll liability means the books show more paid than owed, which usually means a tax payment was recorded twice, or posted to the liability after the provider’s entry had already cleared it. Find the entry with the account’s QuickReport rather than adjusting the balance to zero.

How often should payroll be reconciled?

Check each payroll against the bank as it posts, reconcile the accounts monthly, and tie out to the 941 each quarter before it is filed. The year-end check against the W-3 is then a confirmation, not a search.

When payroll liabilities have not cleared for months

A liability balance that has rolled forward for more than one quarter is rarely one error. It is usually a pattern repeated on every pay date, and fixing it means rebuilding each payroll entry from the provider’s register, removing the duplicates, and moving tax payments out of expense. That is cleanup work, and it should be finished before the year’s return is prepared.

$99per month of backlog20% off 6+ months

When to hand this off: if a payroll liability account has carried a balance across more than one quarter, or the books’ wages do not tie to the 941s with a named difference, the fix touches reconciled months. A free file review finds where the balance came from and prices the cleanup before any work begins.