Skip to main content
Remember Me Roofing
Remember Me Roofing
January 16, 2020
Solved

I Need to Track Payroll by Job Type

  • January 16, 2020
  • 1 reply
  • 0 views

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.

Best answer by AddieC

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.

1 reply

AddieC
AddieCAnswer
January 16, 2020

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.

    Remember Me Roofing
    Remember Me RoofingAuthor
    January 16, 2020

    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!

     

    AddieC
    AddieC
    January 16, 2020

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

    Terms & ConditionsAccessibility statement