QuickBooks Tutorial: Workers Comp Reporting by Code and Employee

QuickBooks Workers Compensation: Reporting by Code and Employee

Workers compensation in QuickBooks relies on correct employee classifications and payroll item setup so premiums are calculated by code and reported accurately. This tutorial walks through the essential steps to configure job codes, assign employees, and run the reports that carriers and auditors expect. The process changes slightly between QuickBooks Online and Desktop, but the core logic remains the same: each employee needs a comp code tied to a rate, and each paycheck must flow through the right payroll items before you generate the summary.

Why Reporting by Code Matters

Carriers price workers comp by class code, which reflects the risk of the work an employee performs. When you enter hours by code in QuickBooks, the system multiplies those hours by the assigned rate and accumulates the premium for each class. If codes are wrong or missing, your audit quote will be off, which can trigger penalties or retroactive premium adjustments. A clean setup also lets you run a workers comp summary that breaks out payroll and estimated premium by class, giving you a defensible record during an audit.

Setting Up Payroll Items for Workers Comp

In QuickBooks Desktop, go to Lists > Payroll Items and create a new item for each compensation type you want to track. Choose Add a new payroll item, then select Custom Setup. Name the item after the class code (for example, "Workers Comp 8810"), select the liability account where premiums accrue, and choose the appropriate tax tracking. In QuickBooks Online, navigate to Payroll Settings > Payroll Items, add a new item, and map it to the correct liability account. The key is to keep one payroll item per class code so the report later can separate them cleanly.

Assigning Employee Class Codes

Open each employee record and set their default payroll and compensation codes. In QuickBooks Desktop, go to Employees > Employee Center, double-click the name, and on the Payroll Info tab assign the comp payroll item you created. If an employee works more than one job, add additional compensation lines and map each to the correct code. In QuickBooks Online, open the employee profile, go to Compensation, and add the payroll item for each role. Always verify the rate you enter matches the class code rate on your insurance certificate, not a generic hourly wage, so the premium calculation reflects the true exposure.

Running the Workers Comp by Code and Employee Report

Once payroll is processed, run a report that shows earnings and hours by class code and by employee. In QuickBooks Desktop, go to Reports > Payroll > Workers Compensation Summary, or build a custom report with Pay Item as the row and Employee as the column. In QuickBooks Online, run the Payroll Summary, then add the Pay Item and Employee breakdowns from the Columns dropdown. Export to Excel if you need to hand the file to your auditor, and double-check that the totals match the paychecks you have already posted.

Common Setup Mistakes to Avoid

The most frequent errors include using a single payroll item for all employees, entering a flat rate instead of the class-specific rate, and forgetting to update the code when an employee changes roles. Another common pitfall is skipping the year-end reconciliation step: before you close the period, run the workers comp report for the full year, compare the accumulated premium to what your carrier billed, and adjust the liability account if the estimate was off. Small differences in setup can compound across multiple payrolls, so catching them early keeps the final audit cleaner.

Keeping the Setup Current

Rates change, codes get updated, and employees move between roles. Review your workers comp payroll items at the start of each policy period and whenever you hire for a new classification. A quarterly check of the Workers Comp by Code and Employee report, even when no audit is pending, helps you spot misclassifications before they grow into a larger adjustment. Pair this review with your payroll closing routine so the habit stays lightweight but consistent.