Payroll reconciliation template
A free template that lines up the payroll register, Form 941s, and workers' comp payroll by quarter.
Learn more →Form 941 reconciliation
How to reconcile Form 941 to payroll for a workers' comp audit
Your 941s are quarterly federal tax returns, not workers' comp payroll reports. Here is how to get from one to the other and explain the gap.
Quick answer
To reconcile Form 941 to payroll for a workers' comp audit, pull the 941s for every quarter that overlaps your policy period, compare them with your payroll register for the same dates, and write down why each total differs. Carriers commonly ask for quarterly payroll tax reports next to payroll records, so this is a comparison the auditor is likely to make too.
Start from line 5c (taxable Medicare wages and tips). Unlike line 5a, it has no wage cap, and unlike line 2, it includes employees' pre-tax 401(k) deferrals. From there, the usual adjustments are tips, Section 125 cafeteria-plan deductions, the overtime premium, and officer payroll.
941 wages higher than your policy estimate? Estimate your audit bill free
Step by step: from Form 941 to workers' comp payroll
Do this once per quarter that overlaps the policy period, then add the quarters up.
| Step | What to do | Why it matters |
|---|---|---|
| 1. Match quarters to the policy period | List each 941 quarter that overlaps the policy period. For a quarter that is only partly inside it, use monthly totals from the payroll register for the months inside the period. | 941s follow calendar quarters (Jan to Mar, Apr to Jun, Jul to Sep, Oct to Dec). Your policy period may not. |
| 2. Start from line 5c | Add up line 5c (taxable Medicare wages and tips) for the quarters or months in the period. | Line 5c has no wage cap and includes pre-tax 401(k) deferrals, which workers' comp payroll generally includes too. |
| 3. Subtract tips | Take out the tips employees reported to you, which are included in line 5c. | Under NCCI rules, tips and other gratuities received by employees are excluded from payroll. Service charges and automatic gratuities are not tips and stay in. |
| 4. Add back Section 125 deductions | Add employee salary reductions for cafeteria-plan benefits, such as pre-tax health premiums. | Cafeteria-plan benefits can be left out of Medicare wages, but NCCI rules include these salary reductions in payroll. |
| 5. Subtract the overtime premium | If your payroll records show overtime premium dollars separately, subtract the extra part (the half in time-and-a-half). | The premium part of overtime can be excluded when it is shown separately in your records. The straight-time part stays in payroll. |
| 6. Adjust officers and owners | Note each officer's pay and whether the policy covers them or excludes them by endorsement. | Covered officers' payroll is counted within state minimum and maximum amounts. Excluded officers come out. Limits vary by state and policy date. |
| 7. Explain what is left | Compare the adjusted total with the payroll register and write a one-line note for each remaining difference. | Leftover gaps can come from check dates versus pay periods, voided checks, or a 941 that was later corrected on Form 941-X. |
Common 941 reconciliation mistakes
- Comparing a full calendar year of 941s to a policy period that starts mid-year
- Starting from line 5a and missing wages above the social security wage base ($184,500 for 2026)
- Starting from line 2 and missing pre-tax 401(k) deferrals
- Leaving reported tips in the workers' comp payroll total
- Expecting the overtime premium to be excluded when payroll records do not show the premium dollars separately
- Forgetting a 941-X correction filed after the original return
Before you start
- Write down the exact policy period from your policy.
- Pull every 941 that overlaps it, plus any 941-X corrections.
- Export a payroll register by month with gross wages, overtime premium, tips, and pre-tax deductions in separate columns.
- Build the adjustment from line 5c to workers' comp payroll for each quarter.
- Keep the worksheet and notes with the 941s so the auditor can follow the trail.
Keep reading
Multi-state payroll
Keep state-by-state payroll notes and support files organized before totals get confusing.
Learn more →What payroll is included
Overtime premium, officers, subcontractors, tips, and per diem under general NCCI rules.
Learn more →Owner / officer payroll
Document owner pay, role notes, and supporting records more clearly before review starts.
Learn more →California audit rules
The WCIRB's rules, officer limits, dual wage classes and disputes.
Learn more →Florida audit rules
Construction exemptions, subcontractor proof and disputes.
Learn more →Frequently asked questions
Which Form 941 line should I compare to workers' comp payroll?
Line 5c (taxable Medicare wages and tips) is usually the cleanest starting point because it has no wage cap and includes pre-tax 401(k) deferrals. You still need to adjust it for tips, Section 125 deductions, the overtime premium, and officers.
Can you show a simple example?
Say a quarter's line 5c is $250,000. Employees reported $4,000 in tips, had $6,000 in Section 125 health-premium deductions, and earned $5,000 in overtime premium that payroll shows separately. Workers' comp payroll for that quarter is $250,000 minus $4,000, plus $6,000, minus $5,000, or $247,000, before any officer adjustments. These numbers are made up to show the method.
What if a 941 was corrected later?
Use the corrected numbers. Form 941-X is how employers correct a Form 941 they already filed, so keep any 941-X with the original return in your audit file.
Why not just compare W-2 totals?
W-2s cover a calendar year, so they only line up with a policy period that runs January to December. The 941s let you work quarter by quarter, which is easier to map to a policy period that starts mid-year.
Do these rules apply in every state?
No. The adjustments here follow general NCCI rules, which many states use, but states can have exceptions and some use their own rating bureau or state fund. Check with your carrier or agent.
Important scope note
Practical prep guidance only.
This page explains a practical reconciliation workflow based on general NCCI payroll rules and the IRS Form 941 instructions. It is not accounting, tax, legal, or insurance advice, and your state or carrier may apply different rules.
Want the 941 crosswalk already set up?
The Construction Kit workbook includes a Payroll Reconciliation tab and a 941 - W-2 - 1099 Crosswalk tab, plus a completed example.