Your payroll software reports one set of numbers. Your general ledger shows something different. Your quarterly 941 filings reflect a third version of the same period. In most businesses, nobody is systematically comparing these three sources – and the discrepancies between them build up silently over months and years.
Payroll reconciliation is the process of comparing these data sources against each other, identifying discrepancies, and tracing them to their source. It is not a luxury for large businesses with complex payroll. It is a fundamental control that any business running payroll needs to perform regularly – and that most businesses do not.
What Payroll Reconciliation Actually Involves
Payroll reconciliation is not a single task. It is a suite of comparisons across multiple areas of payroll data. Each comparison serves a different purpose and catches different types of errors.
Gross wages reconciliation
The starting point: total gross wages per payroll records should equal total wages per the general ledger payroll expense account for the same period. When these do not match, the discrepancy may be due to timing differences, recording errors, or payroll data that was entered into the accounting system incorrectly.
Tax deposit reconciliation
Payroll tax deposits made to the IRS and state agencies should reconcile to the payroll tax liabilities recorded in the accounting system. If the liability account shows $18,000 owed and only $16,000 was deposited, there is either an underpayment – which the IRS will eventually notice – or an accounting entry error. Either way, the discrepancy must be traced and resolved.
941 to general ledger reconciliation
The quarterly Form 941 reports total wages and total tax deposits for the quarter. These figures should match the payroll expense and tax liability accounts in the general ledger for the same period. When they do not – which is common – the business has either filed an incorrect 941 or its accounting records do not accurately reflect payroll activity.
Benefits and deduction reconciliation
Amounts withheld from employee paychecks for health insurance, retirement plan contributions, and other benefits should match the amounts paid to the relevant providers. If the business is withholding $12,000 per month in health insurance premiums but paying the insurance company $11,000, there is a $1,000 per month discrepancy that is either going somewhere it should not or represents an accounting error.
Year-end W-2 reconciliation
Before W-2s are filed, total wages and withholding reported across all W-2s should reconcile to the total wages and withholding reported across all four quarterly 941 filings. This is a required step before submitting the W-3 transmittal to the Social Security Administration. Discrepancies here generate IRS notices and require amended filings.
The Three Areas Most Businesses Never Reconcile
The three most neglected payroll reconciliation areas
The three most neglected payroll reconciliation areas
1. 941 filings vs general ledger – most businesses file the 941 without reconciling it to the books
2. Employer vs employee tax split in accounting entries – the two portions are often recorded incorrectly as a single amount
3. Benefits withheld vs benefits paid – overpayments to providers sit undetected for months or years
The 941 reconciliation is the most consequential and the most frequently skipped. Many businesses calculate the 941 directly from payroll software data without ever comparing those figures to the accounting records. The result is that the 941 and the books diverge gradually – and the divergence only becomes apparent at year-end when W-2s cannot be reconciled, or during an IRS audit.
The employer-employee tax split is an accounting entry issue. When payroll taxes are remitted to the IRS, a single payment covers both the employer and employee portions of FICA. Many businesses record this entire payment as payroll tax expense. The correct treatment is to record the employer portion as an expense and the employee portion as a reduction of the payroll liability that was created when wages were recorded. Recording the full deposit as an expense overstates payroll tax expense and fails to properly clear the liability account.
Benefits reconciliation is particularly important for businesses that offer health insurance. Insurance premiums are typically billed and paid monthly, but employees are charged their share every payroll cycle. The cumulative employee deductions must equal the employee portion of the premium bill. When they do not – due to mid-year enrollment changes, terminations, or billing errors – the overpayment or underpayment accumulates until someone specifically looks for it.
How Often Should You Reconcile Payroll?
The answer depends on the size and complexity of the payroll, but a practical minimum is:
- Gross wages and tax deposits: every payroll cycle
- 941 to general ledger: every quarter, before filing the 941
- Benefits and deductions: monthly
- Year-end W-2 reconciliation: before W-2 distribution in January
For businesses with complex payroll – multiple states, variable compensation, significant benefits programs – more frequent reconciliation at each level provides earlier error detection and simpler corrections.
What Good Payroll Reconciliation Looks Like in Practice
A structured payroll reconciliation process produces a documented comparison of each data source at each reconciliation point. The documentation shows what was compared, whether it agreed, and if not, how the discrepancy was resolved. This documentation serves two purposes: it confirms accuracy at the time of reconciliation, and it creates an audit trail that demonstrates the quality of the payroll process.
Payroll reconciliation is also one of the most effective tools for detecting payroll fraud, which – according to the Association of Certified Fraud Examiners – affects approximately 27 percent of businesses and causes median losses of $90,000 per case. A business that reconciles payroll thoroughly and regularly is significantly less vulnerable to ghost employees, inflated timesheets, and unauthorized pay rate changes.