Thank you for your response.
However this report doesn't show the info that I need to provide to my work comp carrier. This report that you have stated will show the time spent based on a given job and will show the billable hours that would be sent to the customer.
We are looking for a report that will take the information and data provided in the report that you mentioned, factor in the employees hourly pay and show the amount we as a business spent in payroll. I am looking for a report such as this that can be grouped together by the type of service provided.
For an example:
We are a lawn and landscape company. For workers comp insurance, our carrier charges x amount of dollars per $100 in payroll for basic lawn service (mow trim blow etc) and they charge y amount of dollars per $100 in payroll for landscaping and pressure washing ("y" is a higher rate, more than double "x").
With our tsheets/ QBTime time tracking app, our employees can clock in under these particular service items.
Long story short, this info is synced to our intuit software and you can view the amount of hours an employee had on a given day and what service he provided that day. We also use QB payroll, so the employees' hourly rate is also in our software.
We will use $200,000 in payroll for this example.
Of this $200,000 for the year of 2021, I need a report to show how much of this payroll was paid out for basic lawn service, how much was paid out for landscaping, and how much was paid out in the multiple other services that we offer. This info would then be provided to our insurance agent so the know how to correctly charge us for work comp. Most of our hours are for basic lawn service which is a lower rate. If we can't show them the seperation of hours, then they will charge us the higher rate for all of services which my agent informed me would take our work comp from $5k per year to $12k.
I NEED THIS REPORT TO SAVE ME $7K PER YEAR...SOMEONE HELP!!!!!
