Year-End Reconciliation: Matching W-2s to Quarterly Returns
6/18/2026
The year-end reconciliation is the single most valuable hour in the payroll calendar. It is the control that catches a March configuration error before it becomes eleven amended returns, and it is also the control most frequently skipped — because the system produces Forms W-2 that look complete, and reconciling them feels like verifying something already done.
The IRS and Social Security Administration reconcile these figures whether you do or not. The only question is whether you find the variance first.
What You Are Tying Together
Three sets of figures must agree:
- The payroll register — your system's record of what was actually paid and withheld
- The four Forms 941 — what you reported and deposited quarterly
- The Forms W-2 and W-3 — what you are about to report annually
Because the Forms 941 have already been filed, a variance discovered now means either the W-2s are wrong (fixable before filing) or the 941s were wrong (requiring amendment). Determining which is the first step in resolution.
Our Payroll Reconciliation And Reporting session covers the method, and Payroll Year End: W-2 And Proper Year End Reconciliation covers the year-end process.
The Tie-Out Worksheet
Build this once and reuse it every year.
|
Item
|
Sum of four 941s
|
Form W-3
|
Variance
|
|
Total wages, tips, other compensation
|
941 line for wages
|
Box 1
|
Should be $0
|
|
Federal income tax withheld
|
941 line for FIT
|
Box 2
|
Should be $0
|
|
Social Security wages
|
941 line for SS wages
|
Box 3
|
Should be $0
|
|
Social Security tax
|
941 SS tax, employee share only
|
Box 4
|
Should be $0
|
|
Social Security tips
|
941 tips line
|
Box 7
|
Should be $0
|
|
Medicare wages and tips
|
941 Medicare wages
|
Box 5
|
Should be $0
|
|
Medicare tax
|
941 Medicare tax, employee share only
|
Box 6
|
Should be $0
|
|
Additional Medicare wages
|
941 Additional Medicare line
|
Included in Box 6
|
Verify
|
The critical mechanical point: Form 941 reports the combined employer and employee share of Social Security and Medicare, while Form W-2 reports only the employee share. You must halve the 941 figure for the base tax before comparing — but the 0.9% Additional Medicare Tax is employee-only and is not halved. Getting this wrong manufactures a variance that does not exist, which is the most common false alarm in the entire exercise.
Differences That Are Expected
Some figures should not match, and knowing which prevents chasing correct numbers.
Box 1 will differ from Box 3 and Box 5. Traditional retirement deferrals reduce income tax wages but not Social Security or Medicare wages. For a plan participant, Box 1 is legitimately lower by the deferral amount. See pre-tax vs. post-tax deductions.
Box 3 will be lower than Box 5 for high earners. Social Security wages cap at the annual taxable maximum — $184,500 for 2026 — while Medicare wages are uncapped.
Box 6 will exceed 1.45% of Box 5 for high earners, because of the additional 0.9% above $200,000.
Box 1 will differ from Box 16 in non-conforming states, which do not follow federal treatment of some pre-tax deductions.
Boxes 3 and 7 combined should not exceed the annual taxable maximum, though either alone may be less.
The Six Causes of Variance
When the tie-out fails, the cause is almost always one of these. Work through them in order of likelihood.
1. A Deduction or Earnings Code With Wrong Tax Mapping
The most common cause. A code added mid-year — a new benefit, a new bonus type — was created by copying an existing code and inherited the wrong tax-base flags.
How to find it: identify the quarter where the variance begins. Then list codes created or first used in that quarter and check each against all four wage bases.
The classic instance: traditional 401(k) deferrals flagged as pre-tax for FICA as well as income tax. This produces a variance in Boxes 3 and 5 for every participant, and it under-withheld FICA all year.
2. Imputed Income Posted to the Ledger but Not to Wages
Group-term life coverage over $50,000, personal vehicle use, gift cards, domestic partner coverage. The expense appears in the general ledger; the taxable value never reached the wage boxes.
How to find it: compare general ledger benefit and expense accounts against total imputed income reported on the Forms W-2. A material gap is the answer. See fringe benefits tax guide.
3. Manual or Off-Cycle Checks Issued Outside the System
A bonus, a settlement, or a correction paid through accounts payable. It appears in the ledger and in the bank, but never in payroll — so it is missing from both the Forms 941 and the Forms W-2.
How to find it: reconcile total payroll disbursements from the bank and ledger against total payroll per the register. Any difference is an off-system payment.
This is the variance most likely to be discovered by someone other than payroll, and the most embarrassing.
4. Third-Party Sick Pay Misallocated
Both parties reported it, or neither did, or the responsibility split was misunderstood. Third-party sick pay has specific rules on which party reports the wages and the withholding, with Form 8922 existing to reconcile the pieces.
How to find it: obtain the third party's reporting statement and compare it to what you reported. See third-party sick pay reporting.
5. A Prior-Period Correction Handled in the Current Quarter
An error from Q1 was corrected by adjusting Q3 rather than by filing a Form 941-X for Q1. The annual totals may be right while each quarter is wrong, or the correction may have been applied inconsistently between the register and the return.
How to find it: review any manual adjustment entries and confirm each was handled on the correct form for the correct period.
6. A Wage Base or Threshold Error
Social Security withheld above the annual taxable maximum, or Additional Medicare not started at $200,000.
How to find it: run a report of Box 3 amounts and confirm none exceeds the maximum. Separately, list employees above $200,000 in Box 5 and verify the additional withholding.
Resolving a Variance
Once you have identified the cause, the resolution path depends on which set of figures is wrong.
The W-2s are wrong, the 941s were right. Correct the W-2 data before filing. This is the cheap outcome and the reason to reconcile before transmitting.
The 941s were wrong, the W-2s are right. File Form 941-X for each affected quarter. Underreported amounts should be corrected and paid promptly to limit interest and support reasonable-cause relief; overreported amounts follow either a refund claim or an adjustment process, with the employee-share FICA requiring repayment or reimbursement to the employee, or their written consent, first.
Both are wrong. Correct the W-2 data before filing and file 941-X for the affected quarters.
Already filed the W-2s. Form W-2c plus Form W-3c, and 941-X where the returns were also wrong. See how to file W-2 corrections.
Our How To Properly Complete The 941 Form session covers the return and its corrections.
Do This Quarterly Instead
The strongest recommendation in this guide: stop treating reconciliation as a year-end task.
Tie the register to each Form 941 as you file it. The advantages compound:
- An error found in April affects one quarter, not four
- The cause is identifiable while the changes are recent and the people who made them remember
- Corrections happen through a single 941-X rather than three plus a W-2c population
- The annual tie-out becomes a formality taking minutes
- FICA under-withholding can still be recovered from the employee within the year, which becomes difficult or impossible after year end
That last point has real financial consequence. Employee FICA that was never withheld and cannot be recovered is generally absorbed by the employer. Catching it in Q2 means adjusting future withholding; catching it in January means writing it off.
The Other Reconciliations Worth Doing
The 941-to-W-2 tie-out is the essential one. Four others catch errors it cannot.
Bank to register. Total payroll disbursements per the bank statements and the general ledger, compared to total net pay plus tax deposits plus third-party remittances per the register. A difference means money moved outside payroll — a manual check, an off-system settlement, or a wire that never entered the system. This is the only reconciliation that finds off-system payments, and it is the one most rarely performed.
General ledger to imputed income. Benefit and perquisite expense accounts in the ledger, compared to total imputed income reported on the Forms W-2. A material gap means a taxable benefit was paid but never imputed. This is exactly the comparison an examiner makes, so making it first is strictly better.
Recordkeeper to register. Total retirement plan deferrals per payroll, compared to what the recordkeeper received. Catches transmission gaps, missed enrollments, compensation-definition errors, and catch-up basis mismatches. Quarterly is far better than annually, because a plan correction is cheaper the earlier it is found.
State returns to state wages. Each state's periodic deposits and quarterly filings, compared to the state wage and withholding figures going on the Forms W-2 and the state reconciliation return. Non-conforming states produce legitimately different wage figures, so this must tie to state amounts rather than to Box 1. See state W-2 filing requirements.
A practical sequencing note: do the bank-to-register comparison first. If an off-system payment exists, it affects every subsequent reconciliation, and discovering it after you have investigated a Box 3 variance for an hour is wasted effort.
The Reconciliation Checklist
- [ ] Sum all four Forms 941 for each line item
- [ ] Halve the 941 Social Security and Medicare tax figures for the employee share — but not Additional Medicare
- [ ] Compare each line to the corresponding Form W-3 box
- [ ] Confirm expected differences: Box 1 vs. Box 3/5, Box 3 cap, Box 6 excess
- [ ] Confirm no employee's Box 3 exceeds the annual taxable maximum
- [ ] Confirm Box 4 equals Box 3 × 6.2% and Box 6 equals Box 5 × 1.45% plus the additional 0.9% where applicable
- [ ] Compare general ledger benefit expense to imputed income reported
- [ ] Reconcile bank disbursements to the payroll register to find off-system payments
- [ ] Confirm third-party sick pay reported once, by the correct party
- [ ] Review all manual adjustments for correct period and form
- [ ] Document the variance found, its cause, and its resolution
- [ ] Only then file
Frequently Asked Questions
How do you reconcile W-2s to 941s?
Sum the four quarterly Forms 941 for each line item — total wages, federal income tax withheld, Social Security wages and tax, Medicare wages and tax — and compare to the corresponding Form W-3 boxes. The critical adjustment is that Form 941 reports the combined employer and employee share of Social Security and Medicare while Form W-2 reports only the employee share, so the 941 figure must be halved for the base taxes. The Additional Medicare Tax is employee-only and is not halved.
Why don't W-2 Box 1 and Box 3 match?
Because they measure different bases. Box 1 is federal income tax wages, reduced by traditional retirement deferrals as well as Section 125 contributions. Box 3 is Social Security wages, reduced by Section 125 but not by retirement deferrals, and capped at the annual taxable maximum. For a retirement plan participant, Box 1 should be lower than Box 3 by the deferral amount — this is expected, not a variance to investigate.
What causes a W-2 to 941 variance?
Six causes account for nearly all of them: a deduction or earnings code with wrong tax-base mapping, usually added mid-year; imputed income posted to the general ledger but never to taxable wages; manual or off-cycle checks issued outside the payroll system; third-party sick pay reported by the wrong party or twice; a prior-quarter error corrected in the current quarter rather than on a 941-X; and a wage base or threshold error.
Should you reconcile before or after filing W-2s?
Before, always. If the W-2 data is wrong and the Forms 941 were right, correcting before filing costs nothing. Filing first turns the same error into Forms W-2c plus Form W-3c, and potentially amended Forms 941 as well — several times the work for the same underlying mistake.
How often should payroll be reconciled?
Quarterly, as each Form 941 is filed. An error found in April affects one quarter instead of four, its cause is identifiable while the changes are recent, and — importantly — under-withheld employee FICA can still be recovered from the employee within the same year. After year end, unrecovered employee FICA is generally absorbed by the employer.
What is Form 941-X used for?
Correcting a previously filed Form 941. File a separate 941-X for each quarter being corrected rather than adjusting a later quarter's return. Underreported amounts should be corrected and paid promptly to limit interest and support reasonable-cause relief on penalties. Overreported amounts follow either a refund claim or an adjustment process, and recovering the employee share of FICA requires repaying or reimbursing the employee, or obtaining their written consent, first.
Going Deeper
Wage bases and thresholds change annually and form line references are revised. Confirm current figures and work from the current-year forms and instructions when building the tie-out.
{
"@context": "https://schema.org",
"@graph": [
{
"@type": "Organization",
"@id": "https://www.payrolltrainingcenter.com/#organization",
"name": "Payroll Training Center",
"url": "https://www.payrolltrainingcenter.com/"
},
{
"@type": "WebSite",
"@id": "https://www.payrolltrainingcenter.com/#website",
"name": "Payroll Training Center",
"url": "https://www.payrolltrainingcenter.com/",
"publisher": {
"@id": "https://www.payrolltrainingcenter.com/#organization"
}
},
{
"@type": "WebPage",
"@id": "https://www.payrolltrainingcenter.com/blog/year-end-reconciliation#webpage",
"url": "https://www.payrolltrainingcenter.com/blog/year-end-reconciliation",
"name": "Payroll Year-End Reconciliation: W-2 to 941 Tie-Out",
"description": "How to reconcile W-2s to quarterly 941s — the tie-out worksheet, expected differences, the six causes of variance, and how to resolve each before filing.",
"isPartOf": {
"@id": "https://www.payrolltrainingcenter.com/#website"
},
"breadcrumb": {
"@id": "https://www.payrolltrainingcenter.com/blog/year-end-reconciliation#breadcrumb"
}
},
{
"@type": "HowTo",
"@id": "https://www.payrolltrainingcenter.com/blog/year-end-reconciliation#article",
"headline": "\"Year-End Reconciliation: Matching W-2s to Quarterly Returns\"",
"name": "\"Year-End Reconciliation: Matching W-2s to Quarterly Returns\"",
"description": "How to reconcile W-2s to quarterly 941s — the tie-out worksheet, expected differences, the six causes of variance, and how to resolve each before filing.",
"url": "https://www.payrolltrainingcenter.com/blog/year-end-reconciliation",
"inLanguage": "en-US",
"isPartOf": {
"@id": "https://www.payrolltrainingcenter.com/#website"
},
"mainEntityOfPage": {
"@id": "https://www.payrolltrainingcenter.com/blog/year-end-reconciliation#webpage"
},
"author": {
"@type": "Organization",
"name": "Payroll Training Center",
"url": "https://www.payrolltrainingcenter.com/"
},
"publisher": {
"@id": "https://www.payrolltrainingcenter.com/#organization"
},
"keywords": "payroll year end reconciliation",
"articleSection": "How-To"
},
{
"@type": "BreadcrumbList",
"@id": "https://www.payrolltrainingcenter.com/blog/year-end-reconciliation#breadcrumb",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"name": "Home",
"item": "https://www.payrolltrainingcenter.com/"
},
{
"@type": "ListItem",
"position": 2,
"name": "Blog",
"item": "https://www.payrolltrainingcenter.com/blog"
},
{
"@type": "ListItem",
"position": 3,
"name": "\"Year-End Reconciliation: Matching W-2s to Quarterly Returns\""
}
]
},
{
"@type": "FAQPage",
"@id": "https://www.payrolltrainingcenter.com/blog/year-end-reconciliation#faq",
"mainEntity": [
{
"@type": "Question",
"name": "How do you reconcile W-2s to 941s?",
"acceptedAnswer": {
"@type": "Answer",
"text": "Sum the four quarterly Forms 941 for each line item — total wages, federal income tax withheld, Social Security wages and tax, Medicare wages and tax — and compare to the corresponding Form W-3 boxes. The critical adjustment is that Form 941 reports the combined employer and employee share of Social Security and Medicare while Form W-2 reports only the employee share, so the 941 figure must be halved for the base taxes. The Additional Medicare Tax is employee-only and is not halved."
}
},
{
"@type": "Question",
"name": "Why don't W-2 Box 1 and Box 3 match?",
"acceptedAnswer": {
"@type": "Answer",
"text": "Because they measure different bases. Box 1 is federal income tax wages, reduced by traditional retirement deferrals as well as Section 125 contributions. Box 3 is Social Security wages, reduced by Section 125 but not by retirement deferrals, and capped at the annual taxable maximum. For a retirement plan participant, Box 1 should be lower than Box 3 by the deferral amount — this is expected, not a variance to investigate."
}
},
{
"@type": "Question",
"name": "What causes a W-2 to 941 variance?",
"acceptedAnswer": {
"@type": "Answer",
"text": "Six causes account for nearly all of them: a deduction or earnings code with wrong tax-base mapping, usually added mid-year; imputed income posted to the general ledger but never to taxable wages; manual or off-cycle checks issued outside the payroll system; third-party sick pay reported by the wrong party or twice; a prior-quarter error corrected in the current quarter rather than on a 941-X; and a wage base or threshold error."
}
},
{
"@type": "Question",
"name": "Should you reconcile before or after filing W-2s?",
"acceptedAnswer": {
"@type": "Answer",
"text": "Before, always. If the W-2 data is wrong and the Forms 941 were right, correcting before filing costs nothing. Filing first turns the same error into Forms W-2c plus Form W-3c, and potentially amended Forms 941 as well — several times the work for the same underlying mistake."
}
},
{
"@type": "Question",
"name": "How often should payroll be reconciled?",
"acceptedAnswer": {
"@type": "Answer",
"text": "Quarterly, as each Form 941 is filed. An error found in April affects one quarter instead of four, its cause is identifiable while the changes are recent, and — importantly — under-withheld employee FICA can still be recovered from the employee within the same year. After year end, unrecovered employee FICA is generally absorbed by the employer."
}
},
{
"@type": "Question",
"name": "What is Form 941-X used for?",
"acceptedAnswer": {
"@type": "Answer",
"text": "Correcting a previously filed Form 941. File a separate 941-X for each quarter being corrected rather than adjusting a later quarter's return. Underreported amounts should be corrected and paid promptly to limit interest and support reasonable-cause relief on penalties. Overreported amounts follow either a refund claim or an adjustment process, and recovering the employee share of FICA requires repaying or reimbursing the employee, or obtaining their written consent, first."
}
}
]
}
]
}
