Payroll Reconciliation Template

By Nupur Mittal

Co-Founder, OCTA

This is a free payroll reconciliation template for accounting and bookkeeping firms — the exact fields to tie each payroll run to the general ledger, the payroll tax liabilities, and the cash that left the bank. Copy it into a spreadsheet to confirm every run is recorded correctly before it flows into the close.

The payroll reconciliation template

Header

The reconciliation

1. GROSS-TO-NET (per payroll register)
   Gross wages .......................................  $__________
   Less: employee taxes withheld (FICA, fed, state) .. −$______
   Less: other deductions (benefits, garnishments) ... −$______
   Net pay ...........................................  $__________

2. TIE NET PAY TO BANK
   Net pay per register ..............................  $______
   Direct deposits + checks per bank .................  $______
   Difference ........................................ MUST = $0.00

3. TIE WAGES & TAXES TO THE GL
   Gross wages expense per GL ........................  $______
   Employer payroll tax expense per GL ...............  $______
   Payroll register total ............................  $______
   Difference ........................................ MUST = $0.00

4. RECONCILE TAX LIABILITIES
   Employee + employer taxes per register ............  $______
   Payroll tax liability booked to GL ................  $______
   Taxes remitted / impounded by provider ............  $______
   Liability remaining ............................... SHOULD = expected

5. CLEAR THE PAYROLL CLEARING ACCOUNT
   Opening balance ...................................  $______
   Activity this period .............................. ±$______
   Closing balance ................................... SHOULD → $0.00

Exception log

How to use this template

Reconcile every pay run, not just at month-end — errors compound across runs. Work top to bottom: confirm gross-to-net on the register, tie net pay to the cash that actually left the bank, tie gross wages and employer taxes to the GL expense accounts, then reconcile the tax liabilities against what the provider remitted or impounded. The payroll clearing account should sweep to zero once everything is booked — a nonzero balance is the fastest tell that a run is only partially recorded. Confirm the employer tax match (Social Security and Medicare) equals the employee side.

Common mistakes and tips

• Booking net pay instead of gross. Wages expense is gross; the withholdings are liabilities. Booking only net understates both.
• A payroll clearing account that never zeroes. That balance is unrecorded activity — investigate before closing.
• Forgetting employer-side taxes. The employer matches Social Security and Medicare and owes unemployment; missing them understates expense.
• Not tying to the bank. A run posted to the GL but not matched to actual cash out is a reconciliation waiting to break.

Run this template automatically in OCTA Flow

Payroll reconciliation is multi-source matching — register, GL, tax liabilities, and bank — repeated every pay period. In OCTA Flow, the payroll Skill pulls the register from the payroll provider and the ledger from QuickBooks, Xero, Sage, or Zoho, ties net pay to the bank, wages and employer taxes to the GL, and sweeps the clearing account, flagging any run that doesn't tie as a finding by severity. Flow logs every step for the audit trail; your team reviews and signs off. See payroll reconciliation automation, fold it into the month-end close checklist, or pair it with the sales tax reconciliation template.

Frequently Asked Questions

What should a payroll reconciliation tie together? The payroll register (gross-to-net), the cash that left the bank, the wage and employer-tax expense in the GL, and the payroll tax liabilities against what the provider remitted. The clearing account should net to zero.

Why does my payroll clearing account have a balance? It usually means a run is only partially recorded — net pay posted but taxes or employer expense missing, or a timing difference between the provider's debit and the GL entry. Investigate before closing the period.

Reconcile every payroll run against the GL and bank automatically → start a 30-day OCTA Flow trial.