Payroll Reconciliation
The process of verifying that payroll records match bank statements, general ledger entries, and tax filings to ensure every dollar paid is accurately accounted for.
- What Is Payroll Reconciliation?
- Payroll Reconciliation Workflow
- Common Payroll Reconciliation Discrepancies
- Quarterly and Annual Reconciliation
- Tools and Technology for Payroll Reconciliation
- Payroll Reconciliation as Fraud Prevention
- Best Practices for Payroll Reconciliation
- Payroll Reconciliation Performance Metrics
- Frequently Asked Questions About Payroll Reconciliation
What Is Payroll Reconciliation?
Key Takeaways
- ✓Payroll reconciliation is the process of comparing payroll output (what was calculated) against payroll execution (what was actually paid) and accounting records (what was booked) to identify and resolve discrepancies.
- ✓The American Payroll Association found that 33% of employers experience payroll discrepancies at least once per quarter, making reconciliation a non-negotiable control process.
- ✓Reconciliation happens at three levels: per-pay-period (operational), monthly (accounting), and quarterly/annual (tax and audit compliance).
- ✓Without regular reconciliation, small errors accumulate undetected. A $200 per-period discrepancy across 26 pay periods equals $5,200 in unexplained variance by year-end.
- ✓Payroll reconciliation also serves as the primary defense against payroll fraud, which the Association of Certified Fraud Examiners reports costs organizations a median of $100,000 per scheme.
Payroll reconciliation is the process of verifying that three things match: what the payroll system calculated, what the bank account shows was disbursed, and what the general ledger recorded. When all three agree, the payroll is "reconciled." When they don't, you have a discrepancy that needs investigation. Think of it as balancing a checkbook, but with far more variables. A single payroll run involves gross wages, federal tax withholding, state tax withholding, local tax withholding, Social Security, Medicare, benefit deductions, retirement contributions, garnishments, and employer-side taxes. Each of those amounts flows to different bank accounts, tax agencies, and GL accounts. If any one number is off, the entire payroll is out of balance. Most payroll teams reconcile at three intervals. Per-period reconciliation catches obvious errors immediately: the total direct deposit file doesn't match the payroll register, or a tax deposit amount looks wrong. Monthly reconciliation ties payroll to the general ledger and bank statements for the accounting close. Quarterly and annual reconciliation verifies that cumulative payroll data matches what's being reported on Form 941 and W-2s.
Payroll Reconciliation Workflow
A systematic reconciliation process ensures nothing gets missed. This workflow applies to each pay period and scales to monthly and quarterly reviews.
Step 1: Compare payroll register to prior period
Before looking at bank statements or GL entries, compare the current payroll register to the previous one. Look for unusual variances: a significant jump in total gross pay, a department's payroll increasing or decreasing by more than 5%, individual employees with large pay changes, or missing employees. This comparative analysis catches data entry errors, duplicate payments, and unauthorized changes before they hit the bank.
Step 2: Reconcile net pay to bank disbursements
Match the total net pay on the payroll register to the total amount withdrawn from the payroll bank account. This includes direct deposit files (ACH totals), printed checks, and any manual payments. The two numbers must match exactly. If they don't, common causes include outstanding checks from prior periods, voided checks not properly reversed, manual off-cycle payments, or bank processing errors.
Step 3: Reconcile tax withholdings to tax deposits
Verify that the federal, state, and local tax amounts calculated by the payroll system match the actual deposits made to each tax agency. Compare the payroll register's tax totals to your payment confirmations from EFTPS (federal) and state electronic filing systems. Timing differences are normal (the tax is calculated today but deposited next week), so track the timing and confirm deposit execution.
Step 4: Reconcile benefit deductions to carrier invoices
Total the employee and employer benefit deductions from the payroll register and compare them to the invoices from your health insurance, dental, vision, life, and other benefit carriers. Discrepancies often arise from enrollment changes that weren't reflected in payroll, COBRA participants, or employees on unpaid leave whose premiums need manual processing.
Step 5: Post to general ledger and verify journal entries
Confirm that the payroll journal entry posted to the GL matches the payroll register totals for each category: wages expense, tax expense, benefits expense, and all liability accounts. Verify that the GL accounts used are correct (salary expense shouldn't include contractor payments, for example). The GL balances for payroll liabilities should clear to zero after tax deposits and benefit payments are made.
Common Payroll Reconciliation Discrepancies
Knowing the most frequent discrepancy types helps payroll teams investigate faster and build preventive controls.
| Discrepancy Type | Typical Cause | Detection Method | Resolution |
|---|---|---|---|
| Net pay doesn't match bank withdrawal | Outstanding or voided checks, manual payments | Compare ACH file total + checks issued to bank debit | Account for all outstanding items; void stale checks |
| Tax deposit variance | Rate table not updated, employee moved to new jurisdiction | Compare register tax totals to EFTPS/state confirmations | Correct the rate, file amended deposit if needed |
| GL payroll expense variance | Incorrect account mapping, posting to wrong period | Compare register categories to GL journal entry | Reclassify the journal entry, update mapping table |
| Benefit deduction mismatch | Enrollment change not reflected in payroll | Compare payroll deduction totals to carrier invoices | Update payroll deductions, reconcile with carrier |
| Headcount difference | Terminated employee still on payroll, new hire missed | Compare active employee list to payroll register | Process termination or add employee to next cycle |
| Gross-to-net variance | Incorrect deduction amount, garnishment error | Recalculate gross-to-net for flagged employees | Correct the deduction, issue adjustment in next period |
Quarterly and Annual Reconciliation
Per-period reconciliation catches immediate errors. Quarterly and annual reconciliation ensures cumulative data integrity and tax reporting accuracy.
Quarterly Form 941 reconciliation
Before filing Form 941, reconcile the following: total wages reported on the quarterly 941 must equal total wages on all payroll registers for the quarter. Total federal income tax withheld must match the sum of tax deposits made during the quarter. Total Social Security and Medicare taxes (employee and employer shares) must reconcile to deposits. Any discrepancies must be resolved before filing. Amending a 941 after filing (Form 941-X) creates additional IRS scrutiny.
Annual W-2 reconciliation
The most critical annual reconciliation. Total W-2 wages (Box 1) across all employees must equal total wages reported on the four quarterly 941 filings. Social Security wages (Box 3), Medicare wages (Box 5), and withheld taxes must also match. State W-2 totals must reconcile to state quarterly filings. Start this reconciliation in November, not January, to allow time for corrections before the January 31 filing deadline.
Year-over-year analysis
Compare annual payroll totals to the prior year. Total wages should track with headcount changes and compensation adjustments. Benefit costs should align with enrollment and rate changes. Tax withholding totals should reflect rate and regulation changes. Large unexplained variances warrant investigation, even if per-period reconciliation was clean, because systemic errors can hide within normal period-to-period variation.
Tools and Technology for Payroll Reconciliation
Manual reconciliation using spreadsheets works for very small companies, but it doesn't scale and introduces human error risk as payroll volume grows.
Built-in payroll system reports
Most payroll platforms (ADP, Paychex, Gusto, Paylocity) include pre-built reconciliation reports: payroll register summaries, tax liability reports, benefit deduction summaries, and GL interface files. These reports are your starting point. Configure them to match your chart of accounts and tax deposit schedule so comparisons are straightforward.
Automated reconciliation software
Dedicated reconciliation tools like BlackLine, Trintech, or FloQast automate the matching process between payroll, bank, and GL data. They flag exceptions automatically, maintain audit trails, and track resolution status. For companies processing payroll for 500+ employees or across multiple entities, automation reduces reconciliation time by 60 to 70% and catches discrepancies that manual review misses.
Spreadsheet-based reconciliation
For companies with fewer than 100 employees, a well-structured Excel template can handle the job. Create tabs for each reconciliation area (net pay to bank, taxes, benefits, GL). Use VLOOKUP or INDEX-MATCH to match records between data sources. Protect formulas from accidental edits. The key risk with spreadsheets is version control and the lack of an audit trail. Save timestamped copies and document who performed each reconciliation.
Payroll Reconciliation as Fraud Prevention
Payroll fraud is one of the most common forms of occupational fraud, and reconciliation is the primary control for detecting it.
Ghost employees
Ghost employee schemes involve creating fictitious employees on the payroll and directing their pay to the fraudster's account. Reconciliation detects this by comparing the active employee roster (from HR) to the payroll register. Any employee on the payroll who doesn't appear in the HRIS, doesn't have a manager, or doesn't show time and attendance records is a red flag.
Unauthorized pay changes
Payroll staff with system access can inflate their own pay or create unauthorized raises. Period-over-period comparison reports flag unusual pay increases. Segregation of duties (the person who processes payroll shouldn't approve pay changes) combined with reconciliation review by someone outside the payroll team provides the strongest control.
Timesheet manipulation
Employees or managers inflating hours worked is the most common form of payroll fraud. Reconciling time and attendance data against payroll output, badge access records, and production logs helps identify patterns. Look for employees consistently at exactly 40 hours (avoiding overtime scrutiny), sudden increases in overtime, or timesheets approved by the same manager without variation.
Best Practices for Payroll Reconciliation
These practices turn reconciliation from a tedious checkbox exercise into a valuable financial control.
- Reconcile every pay period, not just monthly. Catching errors after one pay cycle is far cheaper than catching them after six.
- Assign reconciliation to someone who doesn't process payroll. Segregation of duties is a fundamental internal control.
- Set a reconciliation completion deadline: 3 business days after pay date for per-period, 5 business days after month-end for monthly.
- Document every discrepancy and its resolution, even small ones. Patterns in small discrepancies often reveal systemic issues.
- Reconcile tax liabilities quarterly before filing Form 941, not after. Finding errors pre-filing avoids amended returns.
- Keep a running log of recurring discrepancy types and address root causes rather than repeatedly fixing symptoms.
- Include payroll reconciliation in your annual internal audit scope. External auditors will test it, so be proactive.
Payroll Reconciliation Performance Metrics
These benchmarks help payroll managers assess the health of their reconciliation process and identify areas needing attention.
Frequently Asked Questions
How often should payroll be reconciled?
What's the difference between payroll reconciliation and payroll audit?
Who should perform payroll reconciliation?
What do I do when I find a discrepancy during reconciliation?
Can payroll reconciliation be fully automated?
How does payroll reconciliation fit into SOX compliance?
Written by Adithyan RK