Free payroll reconciliation template

Payroll reconciliation template for a workers' comp audit

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.

Quick answer

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 reconciliation template: payroll register vs. Form 941 vs. workers' comp payroll

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.

LineWhere the number comes fromExample quarter
A. Payroll register gross wagesPayroll register or payroll summary for the quarter (or for the months inside the policy period)$252,000
B. Form 941 line 5cTaxable 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 BWrite 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 tipsTip reports. Tips are excluded from workers' comp payroll under NCCI rules- $4,000
E. Plus Section 125 deductionsPayroll deduction report. These salary reductions count as workers' comp payroll+ $6,000
F. Less overtime premiumThe extra half of time-and-a-half, only if your payroll shows it separately in dollars- $5,000
G. Officer adjustmentsRaise 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 +/- GWorkers' comp payroll for the quarter, before splitting it by class code$247,000
I. Payroll estimated on the policyDeclarations page or the latest policy change. Policy period total onlyPolicy total: $900,000
J. Change the audit will look at, total H minus IPolicy period total only. More payroll than estimated usually means additional premiumIf four quarters total $990,000: + $90,000
  • The example numbers are made up to show the method. Your payroll system may treat tips and deductions differently, so use the note in line C to say what drives your own difference.
  • Calendar-year policies: the four 941 line 5c amounts added together should equal the W-3 box 5 total (Medicare wages and tips on all W-2s). If they do not, find the difference before the auditor does.
  • Split line H by class code before you estimate the bill. Overtime premium, officers and uninsured subcontractors can also change the result.
  • The CSV version opens in Excel or Google Sheets, with a column for each quarter and the formulas for lines C, H and J already in place.

The main payroll comparison points

These are the comparisons that usually make later questions easier to answer.

ComparisonWhat to checkWhat to note
Payroll reports vs. policy periodWhether the payroll reports cover the right datesAny cutoff or timing issue
Payroll reports vs. 941sQuarter totals and how they map to the policy periodWhy quarter boundaries may not line up exactly
Payroll reports vs. W-2sAnnual wage summaries vs. payroll-period totalsAny period or inclusion difference
1099 / subcontractor contextWhether outside labor support needs separate trackingWhich payments need proof, not just a summary total
Explanation notesWhat still needs clarificationA short narrative for mismatches you already understand

Common reconciliation mistakes

  • Comparing calendar-year totals to a policy period without mapping the dates
  • Assuming a mismatch means an error before documenting the reason
  • Keeping support files in different folders with no crosswalk
  • Ignoring owner/officer or subcontractor support until later
  • Leaving no note for a known difference

How to reconcile payroll in a calmer order

  1. Confirm the policy period first.
  2. Pull payroll reports, 941s, and W-2 summaries into one working folder.
  3. Map quarter and year totals to the policy period before judging the differences.
  4. Document known reasons for mismatches as you find them.
  5. Use a workbook-led process if you need repeatable reconciliation tabs and packet notes.

Keep reading

More on this topic

Reconcile 941 to payroll

Get from quarterly 941 totals to policy-period workers' comp payroll, step by step.

Learn more →

Multi-state payroll

Keep state-by-state payroll notes and support files organized before totals get confusing.

Learn more →

Check your audit bill

Each line of the audit report, what goes wrong on it and the proof that fixes it.

Learn more →

Audit dispute letter

A free letter to copy when the audit bill is wrong, with wording and evidence for each item.

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 →

Frequently asked questions

Does every mismatch mean something is wrong?

No. Many differences come from timing, policy-period boundaries, or the way different records summarize the same information.

What is the best first comparison to make?

Start by making sure the payroll reports are aligned to the correct policy period.

What helps most if I do this every year?

A repeatable workbook structure with dedicated reconciliation tabs and notes.

What should a payroll reconciliation report for an audit show?

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.

Is there a free payroll reconciliation template?

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.

Important scope note

Practical prep guidance only.

This page provides practical reconciliation workflow guidance only. It does not provide accounting, legal, or tax advice.

If the numbers need a clean crosswalk, start with the reconciliation workflow

The Construction Kit includes workbook tabs built specifically for payroll, tax-form, and packet-ready reconciliation work.