Reconcile 941 to payroll
Get from quarterly 941 totals to policy-period workers' comp payroll, step by step.
Learn more →Free payroll reconciliation template
Line up your payroll register, Form 941s and workers' comp payroll for each quarter of the policy period, and explain every difference before the auditor asks.
A payroll reconciliation for a workers' comp audit means comparing the payroll you report for the policy period with your Form 941s, W-2 summaries, and 1099 summaries where relevant, then writing a short note for every difference. Auditors work from these same records, so doing it first means fewer surprise questions.
The goal is not to force every number to match perfectly. It is to understand where differences come from and document them before follow-up starts.
Payroll higher than your policy estimate? Estimate your audit bill free
Fill in one column per quarter that overlaps your policy period, then add a total column. The example column shows one made-up quarter so you can check the math.
| Line | Where the number comes from | Example quarter |
|---|---|---|
| A. Payroll register gross wages | Payroll register or payroll summary for the quarter (or for the months inside the policy period) | $252,000 |
| B. Form 941 line 5c | Taxable Medicare wages and tips on the 941 for the quarter. Use the 941-X amount if you filed a correction | $250,000 |
| C. Difference, A minus B | Write a one-line reason. Common ones: pre-tax Section 125 deductions are in gross pay but not Medicare wages, and reported tips are in Medicare wages | $2,000: $6,000 Section 125 in gross pay, less $4,000 reported tips |
| D. Less reported tips | Tip reports. Tips are excluded from workers' comp payroll under NCCI rules | - $4,000 |
| E. Plus Section 125 deductions | Payroll deduction report. These salary reductions count as workers' comp payroll | + $6,000 |
| F. Less overtime premium | The extra half of time-and-a-half, only if your payroll shows it separately in dollars | - $5,000 |
| G. Officer adjustments | Raise or lower covered officers' pay to the state minimum or maximum if it falls outside them; remove officers excluded by endorsement | $0 (no officers on payroll) |
| H. Workers' comp payroll, B - D + E - F +/- G | Workers' comp payroll for the quarter, before splitting it by class code | $247,000 |
| I. Payroll estimated on the policy | Declarations page or the latest policy change. Policy period total only | Policy total: $900,000 |
| J. Change the audit will look at, total H minus I | Policy period total only. More payroll than estimated usually means additional premium | If four quarters total $990,000: + $90,000 |
Line J above your estimate? Estimate your audit bill free
These are the comparisons that usually make later questions easier to answer.
| Comparison | What to check | What to note |
|---|---|---|
| Payroll reports vs. policy period | Whether the payroll reports cover the right dates | Any cutoff or timing issue |
| Payroll reports vs. 941s | Quarter totals and how they map to the policy period | Why quarter boundaries may not line up exactly |
| Payroll reports vs. W-2s | Annual wage summaries vs. payroll-period totals | Any period or inclusion difference |
| 1099 / subcontractor context | Whether outside labor support needs separate tracking | Which payments need proof, not just a summary total |
| Explanation notes | What still needs clarification | A short narrative for mismatches you already understand |
Get from quarterly 941 totals to policy-period workers' comp payroll, step by step.
Learn more →Keep state-by-state payroll notes and support files organized before totals get confusing.
Learn more →Each line of the audit report, what goes wrong on it and the proof that fixes it.
Learn more →A free letter to copy when the audit bill is wrong, with wording and evidence for each item.
Learn more →Overtime premium, officers, subcontractors, tips, and per diem under general NCCI rules.
Learn more →Document owner pay, role notes, and supporting records more clearly before review starts.
Learn more →No. Many differences come from timing, policy-period boundaries, or the way different records summarize the same information.
Start by making sure the payroll reports are aligned to the correct policy period.
A repeatable workbook structure with dedicated reconciliation tabs and notes.
For each quarter in the policy period: payroll register gross wages, Form 941 line 5c, the difference with a one-line reason, the adjustments to workers' comp payroll (tips, Section 125 deductions, overtime premium, officers), and the resulting workers' comp payroll. The total is then compared with the payroll estimated on the policy.
Yes. The template on this page is free to copy, and the CSV version opens in Excel or Google Sheets with the formulas filled in. The paid workbook adds a 941, W-2 and 1099 crosswalk, subcontractor and COI tracking, and a packet index.
This page provides practical reconciliation workflow guidance only. It does not provide accounting, legal, or tax advice.
The Construction Kit includes workbook tabs built specifically for payroll, tax-form, and packet-ready reconciliation work.