More Tracking for Workers’ Compensation Costs

Last week we looked at setting up QuickBooks to track Workers’ Compensation costs as we did payroll. The result was a nice report showing the hours and amounts employees had worked. Using the data on this report could help make workers’ compensation reports much easier to prepare.

Let’s look at some more benefits that QuickBooks offers when we track workers’ compensation costs.

If you track projects or jobs at all, additional setup will get the workers’ compensation costs into the expenses associated with the project involved.

The first step in this process is to be sure the preference is selected. The “Job Costing, Class and item tracking for paycheck expenses” option must be checked. Workers’ compensation would be considered a paycheck expense.

Note the selected area in the Earnings section of the paycheck shown above. We have the ability to set the workers’ compensation code. We fill in the Customer:Job selection. And we specify what work the employee was doing, by selecting a service item.

In this case, Michael Wilhite did framing (service item) for Chris Baker’s Family Room (Customer:Job) and the workers comp code for that is 5645.

Let’s see what that does for us on a report tracking the costs of this project.

Above is a portion of the Job Profitability Detail report for this project. There is a cost for the framing portion of the job. This cost is the paycheck we created for Michael Wilhite.

Let’s examine the details of that framing cost.

The detail report of the framing expenses does not specifically label all the individual lines of expense. But they all come from the same paycheck, they are just different components of that transaction.

The $123.23 expense line is the workers’ compensation expense associated with this Chris Baker project so far. It comes from the one paycheck we created earlier.

While the required information to create this kind of expense tracking can be done from the paycheck, as we did, it is more often entered into the weekly time sheet.

You can see from the screenshot that all the same information that appeared in the paycheck appears here in the weekly timesheet. The timesheet is especially helpful if a number of different projects were worked on during the week.

Once saved, the time from the weekly timesheet directly imports into paycheck creation, so it doesn’t need to be entered twice.

Hector Garcia, CPA
Certified Advanced QuickBooks ProAdvisor
12401 Orange Drive #136
Davie, FL 33330
954-414-1524
hector@garciacpa.com

Hector Garcia

Hector Garcia

Hector Garcia is a CPA and QuickBooks Consultant.
Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

Your email address will not be published.



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022