Reconciling Form 941 to Your Payroll Ledger: Fixing Discrepancies

Every quarter, payroll tax filings have to tie back to the ledger that produced them. When they do not, the temptation is to force the difference out. Resist it. A discrepancy between Form 941 and your payroll records is a signal that one of the two is wrong, and your job is to find out which before you touch anything.

Where does the discrepancy actually come from?

There are only three possibilities, and it helps to name them before you start:

1. The amounts entered on the Form 941 are wrong, meaning the return does not match what you filed or intended to file.
2. The ledger is wrong, meaning the return is fine but the books behind it contain posting errors.
3. Both are right, but they measure different things, such as timing differences at a quarter boundary.

Most reconciliation workflows flag a difference and stop there. They do not tell you which case you are in. That judgement is yours.

Start with the return, not the books

Check each figure you entered against the filed Forms 941 for the quarter: wages, federal income tax withheld, and both sides of Social Security and Medicare. Transposition errors at entry are the most common cause of a flagged difference, and they are also the cheapest to fix.

If you keyed an amount incorrectly, re-enter it and re-run the reconciliation. The discrepancy should clear. Nothing in the ledger needs to change, because the ledger was never the problem.

If the return was entered correctly, test the ledger

Now the difference is real. Work through the usual payroll suspects:

• Wages posted gross versus net, or posted to the wrong period.
• Employee withholding posted but employer matching not, or vice versa.
• A manual check or adjustment posted outside payroll, hitting the liability accounts directly.
• Prior-quarter corrections posted in the current quarter, so the liability balances but the quarterly wage base does not.

Compare the ledger's quarterly wage and liability totals to the return line by line. The line that differs tells you which class of error you have.

When do you adjust the books versus amend the return?

This is the judgement call. If the ledger is wrong and the return is right, post the correcting entries in the books and carry the difference through your reconciliation working paper. If the return itself is wrong, the books cannot fix it: the return may need to be amended on Form 941-X, and that is a decision for the accountant or the client's tax adviser, not something a bookkeeper should initiate alone.

Say it plainly to the client: an amendment is a filing decision with interest and penalty consequences. Our role is to give them a clean reconciliation that shows exactly what the true quarterly figures were, so they can amend from evidence rather than guesswork.

Keep the evidence with the close

Whatever the outcome, file the reconciliation with the quarter: the return as filed, the ledger totals you compared, the difference identified, and the entry or amendment decision that resolved it. A discrepancy you investigated and documented is worth ten you merely cleared.