Quarter-End Payroll Checklist: Reconcile Records Before Filing

Why quarter-end discrepancies deserve a closer look

Quarter-end is when several parts of payroll need to line up at once. The payroll register, the general ledger, the bank account, and the totals you’re about to report on Form 941 should all show the same activity.

When they don’t, quarter-end is the natural time to catch it. A discrepancy found before you file can usually get fixed as part of your normal review, instead of through a separate correction later.

If a mismatch turns up after you’ve already filed, start by figuring out whether the filed return was actually wrong. Not every discrepancy means it was.

If it was wrong, the IRS provides Form 941-X to correct a previously filed Form 941. This checklist walks through what reconciliation compares, which records support it, how to work through the register, ledger, and bank together, how those numbers connect to what Form 941 asks for, and where mismatches tend to show up during review.

What reconciliation compares and the records you’ll need

The payroll register is the record of what each employee was paid and what was withheld from that pay for a given period. The general ledger is the broader accounting record where that payroll activity gets posted alongside the rest of the business’s financial transactions.

Reconciliation checks that these two records agree with each other, and that both agree with what actually moved through the bank and with what gets reported to the IRS.

Before you start, gather:

• The payroll register for the period, showing hours, pay rates, withholdings, and net pay
• Employee timesheets or time records for the same period
• The general ledger entries where payroll was posted
• Bank statements covering payroll and tax-deposit activity
• Tax-deposit confirmations, such as records from the Electronic Federal Tax Payment System
• The prior quarter’s Form 941, for context on what was previously reported

Check the register before each payday, again at quarter-end alongside Form 941, and once more at year-end when you prepare W-2s. Each time, you’re comparing the same underlying data against a different target.

Matching your register, ledger, and bank records

A practical way to work through reconciliation is to move outward from the register. First, confirm its totals were posted correctly to the general ledger.

Then confirm the ledger agrees with what actually moved through the bank. Some difference between the ledger and the bank on a given day is normal.

A pay date that falls near the edge of the quarter, or a deposit that takes a day or two to clear, can create a timing gap with a simple explanation. Writing down that explanation is part of reconciliation, but it isn’t a substitute for making tax deposits by their actual due date.

A timing difference explains why two records don’t match on paper. It doesn’t push back a deposit deadline.

The same care applies to hours and pay. Check timesheets against the register, including paid time off and holidays, and make sure pay rates are current if anyone got a raise during the quarter.

For hourly employees paid at a consistent rate, you can check regular-hours pay against hours worked. But overtime and any bonuses paid during the period need to be checked separately, since they don’t always follow the same rate.

Deductions deserve the same close attention. Required withholdings include Social Security, Medicare, federal income tax, and state income tax where it applies.

Other deductions, like retirement contributions or health insurance, are usually chosen by the employee. Wage garnishments are different: they aren’t voluntary, and they’re withheld because of a legal or court order.

Reporting each deduction on its own, rather than lumping them together, makes it easier to catch one that changed mid-quarter but wasn’t updated in the register.

Tying your numbers to Form 941

Form 941 reports wages actually paid to employees during the quarter, not just activity tied to a period-end date. Accrued wages, meaning wages an employee has earned but hasn’t been paid yet, don’t belong in this quarter’s totals until they’re actually paid out.

So your reconciliation should reflect what went out the door in that window, not what was accrued around its edges. The return asks for total wages, tips, and other compensation; federal income tax withheld; and taxable Social Security and Medicare wages and tips.

It helps to keep gross wages and taxable wages separate in your mind, since not every dollar of gross pay necessarily counts toward every taxable wage category on the form.

Filing Form 941 itself does not set the timing for your tax deposits. Deposits generally follow a monthly or semiweekly schedule.

Semiweekly here doesn’t mean paying employees every two weeks. It refers to a deposit schedule tied to your paydays, where deposits are due twice a week depending on which days you pay employees.

Which schedule applies to you, monthly or semiweekly, depends on your total tax liability during a lookback period: an earlier period of reported taxes that the IRS uses to set your deposit frequency, not on how often you pay employees. The IRS instructions cover certain exceptions to this rule.

Your total tax liability for the quarter and the deposits you actually made are related numbers, but they aren’t always the same, and a gap between them isn’t automatically a sign of an error. It’s worth understanding why the gap exists before you file, rather than leaving it unexplained.

According to the IRS instructions for Form 941, the return is due by the last day of the month following the end of the quarter. That deadline can stretch to the 10th day of the second month after the quarter ends, but only if you made all of the quarter’s tax deposits on time and in full.

If the due date falls on a Saturday, Sunday, or legal holiday, you can file the return on the next business day instead.

Reviewing likely sources of mismatch

A few areas are worth a close look during your review, without assuming any one is more common than the others. A pay rate or withholding election that changed but wasn’t updated in the register is one example.

A deduction that shifted mid-quarter and didn’t carry through consistently is another. Small adjustments, like a rounding correction, can also get missed if they aren’t recorded in the same place as the rest of the quarter’s activity.

It’s also worth confirming that a tax payment you reported as made was actually sent, and that no required filing was overlooked. Don’t treat any of these as fine just because they’re small.

Each one should be traced to a cause and resolved before you file.

Building reconciliation into every quarter

Treating reconciliation as a habit for every pay period, instead of a task saved for quarter-end, spreads the review work out instead of piling it up right before a filing deadline. If you want support with payroll processing and Form 941 preparation, you can learn more about how Excol works with employers through its payroll services.

Frequently Asked Questions About Quarter-End Payroll Reconciliation

How often should I reconcile payroll, not just at quarter-end?

Check the register before each payday, again at quarter-end alongside Form 941, and once more at year-end when you prepare W-2s. Each checkpoint compares the same records against a different target.

What’s the difference between gross wages and taxable wages on Form 941?

Gross wages are everything you paid an employee. Taxable wages are the portion subject to a specific tax category on the return.

The two are related, but you shouldn’t assume they’re the same number.

Why might my tax liability and my deposits not match exactly?

They can differ for a real, supported reason, such as an overpayment from the prior quarter that got applied to the current return instead of deposited separately. A difference isn’t automatically an error, but you should trace it back to its cause.

What should I do if I find a discrepancy after I’ve already filed Form 941?

First figure out whether the filed return was actually wrong, since not every discrepancy means it was. If it does need correcting, the IRS provides Form 941-X specifically for amending a previously filed Form 941.

Does filing Form 941 each quarter decide when my tax deposits are due?

No. Deposit timing generally follows a monthly or semiweekly schedule based on your tax liability during a lookback period, an earlier period of reported taxes the IRS uses to set that schedule.

The IRS instructions cover exceptions to this. It’s separate from the quarterly filing deadline itself.

When is Form 941 due, and does the deadline ever move?

It’s due by the last day of the month following the quarter, or the 10th day of the second month if you made all of the quarter’s deposits on time and in full. If the due date lands on a weekend or legal holiday, you can file on the next business day.