cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Visit our new QuickBooks News section for news, updates, and opportunities to give feedback.
Highlighted
Level 2

I Need to Track Payroll by Job Type

I work for a construction company. We pay WSIB Premiums every quarter based on the total amount we've paid all of our employees that quarter. 

 

It used to be one rate so it was easy to figure out. Now, it's changed and WSIB wants two different totals - one basic total for all work completed, and one for Siding jobs only. We've never felt the need to track different types of jobs when it comes to payroll. We only track them in terms of income. Customers pay a set cost per job, and we don't charge them extra if a job takes longer than expected. We use a spreadsheet to keep track of the jobs we've completed and what type of work was done, but that's mostly used to give us a general idea so we can plan our season ahead of time.

 

Our workers do use the Time Activity feature in Quickbooks to submit their timesheets, which I look over before running payroll. Here are some options I've come up with, but they all seem like a lot of work:

 

- When submitting a Time Activity, have the workers add "Siding" to the description area. Then I can review all of the time activity for the quarter and add up the hours for these jobs. I think I would need to go employee by employee and figure out their pay separately, which would take a long time.

 

- Add another Work Location for "Siding" and see if I add hours for the regular address, and hours for the Siding address, to one pay check.

 

- Keep track of the number of Siding jobs per month, keep it in a spreadsheet, and use that as a rough guide. If 30% of jobs completed were siding, I would split the total payroll amounts into 70% for the normal rate and 30% for the Siding rate. This will not be accurate.

 

I would greatly appreciate and help or other ideas with how to deal with this. It is pretty time sensitive since every pay period that passes without a solution will skew the numbers.

Solved
Best answer January 16, 2020

Best Answers
Highlighted
QuickBooks Team

I Need to Track Payroll by Job Type

Hi there, 

 

Thank you for providing such a detailed question outlining your goals. QuickBooks Online is here to help with the new WSIB specifications, and I'd be happy to explain how you can specify "siding" jobs on your time activities to easily retrieve the total hours. 

 

You're on the right track with your idea of adding a location for siding. In this case, I recommend using the Class tracking feature instead, which better suits your situation. To set up a class, click the Gear icon > All Lists > Classes > New.

 

Next, when your employees create their time activity, they'll select Siding from the Class drop-down menu. 


The next step will save you tons of time. Rather than manually calculating the total for each employee's "siding" time activity, simply run the Time Activities by Employee Detail report. To find the report, click the Reports tab on the left menu, then search for it in the search bar. Once you open the report, you can customize it to show only siding hours.

 

Here's how: 


1. Click Customize

2. Click Filter.

3. Check off the box for Class

4. Select Siding from the class drop-down menu. 

5. Click Run Report

 

This will total up all the hours worked for siding jobs for each employee. 

 

I hope this helps you reach your goals. If you have any other questions, please reach out to our tech support team


Cheers.

View solution in original post

3 Comments
Highlighted
QuickBooks Team

I Need to Track Payroll by Job Type

Hi there, 

 

Thank you for providing such a detailed question outlining your goals. QuickBooks Online is here to help with the new WSIB specifications, and I'd be happy to explain how you can specify "siding" jobs on your time activities to easily retrieve the total hours. 

 

You're on the right track with your idea of adding a location for siding. In this case, I recommend using the Class tracking feature instead, which better suits your situation. To set up a class, click the Gear icon > All Lists > Classes > New.

 

Next, when your employees create their time activity, they'll select Siding from the Class drop-down menu. 


The next step will save you tons of time. Rather than manually calculating the total for each employee's "siding" time activity, simply run the Time Activities by Employee Detail report. To find the report, click the Reports tab on the left menu, then search for it in the search bar. Once you open the report, you can customize it to show only siding hours.

 

Here's how: 


1. Click Customize

2. Click Filter.

3. Check off the box for Class

4. Select Siding from the class drop-down menu. 

5. Click Run Report

 

This will total up all the hours worked for siding jobs for each employee. 

 

I hope this helps you reach your goals. If you have any other questions, please reach out to our tech support team


Cheers.

View solution in original post

Highlighted
Level 2

I Need to Track Payroll by Job Type

Thanks so much AddieC!

 

This is the perfect solution I was looking for. It's easy to do on my end, and easy for my guys to keep track of on their timesheets. 

 

You Rock!

 

Highlighted
QuickBooks Team

I Need to Track Payroll by Job Type

It's my pleasure. Happy to be of help to you and your guys. :)