Payroll Reconciliation: A Small Business Guide
How to reconcile payroll step by step, how often to do it, a checklist by timing, and why most discrepancies start in your HR data rather than accounting.
Payroll Reconciliation
The step-by-step process, the checklist, and why most discrepancies start somewhere other than accounting
Payroll reconciliation sounds like an accounting chore, and framing it that way is why most small businesses skip it. It is not really an accounting task. It is the fifteen minutes in which you find out whether the money about to leave your bank account is going to the right people in the right amounts, before it goes.
The part worth knowing before you start: at a small company, the discrepancies you find are usually not accounting errors. The software does the arithmetic correctly. What goes wrong is that somebody left and payroll was never told, or a rate change was agreed in a conversation, or a new hire got entered twice. Those are HR events that failed to reach the payroll system, which means reconciling harder does not prevent them. Cleaner records do.
This guide covers what reconciliation actually is, how often to do it and why the intervals differ, the step-by-step process, a worked example with numbers that do not balance, where the errors really originate, a checklist organized by timing, who should do it at each company size, how to tie to Form 941 and W-2, and what getting it wrong costs. To be straightforward about it: FirstHR is an HR and onboarding platform, not a payroll provider, and it does not run payroll or calculate taxes. What it does is keep the employee records, statuses, and documents that payroll depends on accurate. This is general information rather than tax advice.
The Short Answer
Payroll reconciliation is the process of verifying that your payroll records match your timesheets, your pay rates, the money that left your bank account, your general ledger, and your tax filings. You start from the payroll register and compare outward. The goal is to catch discrepancies before payday rather than after.
For a business under twenty-five people it takes fifteen to thirty minutes before each run once the habit exists, and the first time you do it will take longer because you will find something.
What Payroll Reconciliation Is
The word reconciliation puts people off because it sounds like something a controller does with a spreadsheet at midnight. The actual activity is comparison, and the thing being compared is straightforward.
The document at the center of it is the payroll register, the detailed report showing every employee with hours, gross pay, each tax, each deduction, and net pay for the period. Everything else in reconciliation is compared to that register: timesheets and rates on one side, bank and ledger and tax filings on the other.
Which means the single most useful habit in this whole topic is simply looking at the register before you approve the run. A surprising number of small businesses approve payroll without ever reading the detail, and every error described in this article is visible on that one report.
Why It Matters More Than It Sounds
Four reasons, and only one of them is about accounting accuracy.
| Reason | What actually happens without it | Who feels it |
|---|---|---|
| Overpayments are hard to recover | You pay someone who left, or pay twice, and asking for it back is awkward and sometimes legally constrained | You |
| Underpayments damage trust fast | One short paycheck outweighs a year of correct ones, and repeated errors create wage and hour exposure | The employee, then you |
| Tax deposits that do not match trigger notices | The IRS compares your filings to your deposits, and mismatches generate letters and penalties | You, months later |
| Year-end filings that do not tie | Quarterly 941 totals that do not sum to your W-3 produce IRS or Social Security Administration notices | You, in the worst month |
The pattern in that third column is worth noticing. Reconciliation failures are almost always discovered late, by someone else, at a moment you did not choose. The fifteen minutes before a run is the only point in the cycle where you control the timing.
There is a fifth reason that gets less attention: reconciliation is the control that surfaces payroll fraud. A ghost employee on the register, a rate quietly altered before a run, or a payment to an account that does not belong to the person named all show up in a comparison and are invisible without one. That is covered properly in the payroll fraud guide.
How Often to Reconcile
Four intervals, and they are not variations of the same task. Each one catches a different category of problem, which is why doing only the year-end version is the common and expensive mistake.
| When | What you are checking | What it catches | Time |
|---|---|---|---|
| Before each run, a day or two out | Register against people, hours, rates, deductions | Everything, while it is still free to fix | 15 to 30 min |
| After each run | Net pay against bank, tax deposit against liability | Payments that went somewhere unexpected | 5 to 10 min |
| Monthly | Year-to-date totals, benefit deductions against invoices | Slow drift, enrollment mismatches | 30 to 60 min |
| Quarterly | Wages and withholding against Form 941, deposits against liability | Filing errors before they are filed | About an hour |
| Year-end, before W-2s | Four 941s summing to W-3, per-employee totals | The mismatch that generates an agency notice | One to two hours |
If you only adopt one, adopt the pre-run check. It is the only interval where finding a problem costs nothing, because no money has moved and nobody has been paid the wrong amount. Every other interval is damage detection.
How to Reconcile Payroll, Step by Step
Seven steps in order. The first four happen before the run, the last three after.
The order matters. Steps one through four are cheap because nothing has happened yet, so run them before you approve. Steps five through seven verify that what you approved is what occurred, which is a different and less comfortable question.
A Worked Example
Abstract process descriptions are easy to nod at and hard to apply, so here is a reconciliation that does not balance and what finding the cause looks like.
Two things about that example are typical. The difference was small relative to the total, about one percent, which is exactly the size that gets rationalized as a rounding issue and ignored. And the cause was not a payroll error at all. Payroll paid precisely who it was told to pay. The failure happened weeks earlier, in a conversation between an employee and a manager that never reached the system.
Left unfound, that $383 recurs every single run. Six months later it is roughly $4,600 paid to someone who no longer works there, and the conversation about recovering it is considerably worse than the conversation about the first payment would have been.
Where Errors Really Come From
This is the section that changes how you prevent problems rather than just how you find them, and it is the part competing guides mention in passing.
At a company with a payroll department, reconciliation discrepancies are often genuine processing issues. At a company with eight people and no payroll department, they are almost always something else: an employment event that happened in the real world and never reached the payroll system.
The prevention is upstream and it is boring: one place where employee status lives, updated when the event happens rather than when someone remembers, and used by payroll rather than retyped into it. An offboarding checklist that includes payroll deactivation on the last working day eliminates the single most expensive error in this article. What belongs in that record in the first place is covered in the personnel file guide.
The Checklist
Organized by when you do it rather than as one long list, because the timing is what makes it usable.
Print it, or keep it in whatever you actually open on payroll day. The value is in it being present at the moment of the run rather than in a document you intend to consult, and the pre-run group is short enough to become genuinely habitual.
If you are running payroll from a spreadsheet rather than a system that produces a register, the payroll spreadsheet template gives you the same columns to compare against, which makes the checklist above usable rather than theoretical.
Who Should Actually Do It
The question every small business asks and most guides skip, because they assume a payroll administrator exists.
The separation between preparing and reviewing is the part worth protecting even when it feels unnecessary. It is not an accusation of anyone. It is the recognition that a person who prepares payroll, approves payroll, and reviews payroll has no mechanism for catching their own mistake, which is a poor position to put a trusted employee in and an expensive one for the business.
At under ten employees where the owner genuinely does everything, the substitute is to read the bank statement personally and compare the total to the register. It takes two minutes and it is the one check that is very hard to work around.
Reconciling to Form 941 and W-2
The quarterly and annual versions are the same activity aimed at tax filings, and they are the ones where errors produce letters from federal agencies.
Quarterly, run a payroll register covering the full quarter and compare its totals against Form 941: total compensation, federal income tax withheld, taxable Social Security wages, and taxable Medicare wages. Then confirm the deposits you actually made during the quarter match the liability the form reports.
Do this before W-2s go out, not after. Correcting a filed W-2 requires an amended form and correcting a filed 941 requires Form 941-X, and both are considerably more work than catching the difference in December. The broader set of records to retain through all of this is covered in the payroll records guide.
What Getting It Wrong Costs
Worth being concrete, because the cost of skipping reconciliation is usually described vaguely and it does not need to be.
| How late the deposit is | Failure-to-deposit penalty | Applied to |
|---|---|---|
| 1 to 5 calendar days | 2% | The unpaid deposit amount |
| 6 to 15 calendar days | 5% | The unpaid deposit amount |
| More than 15 calendar days | 10% | The unpaid deposit amount |
| More than 10 days after the first IRS notice | 15% | The unpaid deposit amount |
Two details from the IRS guidance on this penalty that are easy to get wrong. The tiers are not cumulative: a deposit more than fifteen days late incurs 10 percent, not 2 plus 5 plus 10. And the count is in calendar days, so a deposit due Friday and made Monday is already late by three.
The penalty applies not only to deposits made late but to deposits made in the wrong amount or by the wrong method, which is precisely the failure mode reconciliation prevents. A deposit that does not match the liability because the register was wrong is a deposit in the wrong amount.
When the Numbers Do Not Match
They will not, eventually. Here is how to find the cause efficiently rather than by rechecking everything.
The first item in the second column is the one that causes lasting damage. A plug entered to make two numbers agree does not remove the underlying difference, it hides it, and the next person to look at those accounts inherits a discrepancy with no explanation attached.
Where Small Businesses Get This Wrong
Six patterns, and the first two account for most of what goes wrong at companies without a payroll function.
The third is the one this article exists to correct. If you look for reconciliation errors in the arithmetic, you will not find the terminated employee still being paid, because the arithmetic on that payment is perfectly correct. Verify the people first, then the numbers.
Frequently Asked Questions
What is payroll reconciliation?
Payroll reconciliation is the process of checking that your payroll records agree with everything they should agree with: the hours actually worked, the pay rates you agreed, the money that left your bank account, the entries posted to your general ledger, and the wages and taxes reported on your tax filings. It is a verification step rather than a calculation step. The payroll system does the math; reconciliation confirms the math was done on the right inputs and that the resulting money went where the records say it went.
How do you reconcile payroll?
Start with the payroll register, which lists every employee's gross pay, deductions, taxes, and net pay for the period. Verify the employee list is correct, then check hours against approved timesheets, pay rates against your records, and deductions against current benefit enrollments. Confirm gross minus deductions equals net for a sample. Then compare total net pay to what actually left your bank account, confirm the tax deposit matches the liability, and check that the payroll entries posted correctly to your general ledger.
How often should you reconcile payroll?
At four intervals, each catching different problems. Before every pay run, ideally a day or two ahead, so errors are corrected before money moves. After each run, to confirm what left the bank matches the register. Monthly, to check year-to-date totals and benefit deduction accuracy against invoices. And quarterly and at year-end, to tie your payroll records to Form 941 and then to Forms W-2 and W-3. The pre-run check is the one that prevents problems; the others find problems that already happened.
What is a payroll register?
A payroll register is the detailed report your payroll system produces for each pay period, listing every employee with their hours, gross pay, each tax withheld, each deduction taken, and net pay, plus employer tax contributions. It is the central document in reconciliation because everything else gets compared to it: timesheets on one side, bank transactions and general ledger entries on the other. If you only look at one payroll report, look at this one, and look at it before the run rather than after.
What causes payroll discrepancies?
Most discrepancies at small companies do not originate in accounting. They come from HR events that never reached the payroll system: an employee who left but was never deactivated, a new hire entered twice or entered late, a pay rate change agreed verbally and never recorded, or a benefit deduction that does not match current enrollment. Timesheet errors, especially missing or incorrect punches, are the other major source. Genuine calculation errors are comparatively rare because the software does the arithmetic.
What happens if you do not reconcile payroll?
Errors compound quietly. An overpayment is difficult to recover and awkward to raise. An underpayment damages trust and can create wage and hour exposure. Tax deposits that do not match liabilities generate IRS notices, and late or incorrect deposits carry failure-to-deposit penalties starting at 2 percent and rising to 15 percent of the unpaid amount depending on timing. At year-end, quarterly filings that do not tie to your W-2 totals trigger notices from the IRS or the Social Security Administration.
How do you reconcile payroll to Form 941?
Run a payroll register covering the full quarter and compare its totals against the corresponding lines on Form 941: total compensation, federal income tax withheld, taxable Social Security wages, and taxable Medicare wages. Then confirm that the deposits you actually made during the quarter match the total tax liability the form reports. At year-end, the four quarterly Forms 941 should sum to the totals shown on Form W-3, and the IRS publishes a year-end reconciliation worksheet mapping each 941 line to the corresponding W-2 and W-3 box.
Who should do payroll reconciliation in a small business?
Whoever processes payroll should do the pre-run checks, and someone else should review the result before money moves. At under ten employees that usually means the owner does everything, with a bookkeeper reviewing quarterly. Between ten and twenty-five, an office manager typically prepares and the owner approves. The separation matters more than the titles: a single person who prepares, approves, and reviews payroll with no second pair of eyes is the condition under which both honest errors and deliberate manipulation persist.
How long does payroll reconciliation take?
For a business under twenty-five employees with reasonably clean records, the pre-run check takes fifteen to thirty minutes once it is a habit, and the post-run bank comparison takes five. Monthly and quarterly reconciliation take longer, perhaps an hour each. The first time will take considerably longer than that because you will find things, which is the point. If it is taking hours every cycle, the problem is usually data quality upstream rather than the reconciliation process itself.
What should you do if payroll does not reconcile?
Work from the largest difference to the smallest rather than checking everything equally. Sort both lists by amount and compare them, which usually isolates the item quickly. Check for the common causes in order: someone on one list and not the other, a duplicate payment, a manual or off-cycle check that was never recorded, and a rate or deduction change nobody documented. Write down what you found and why, because the same cause tends to recur and the note saves you the investigation next time.