Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowDoes anyone know how to customize a report that will show payroll costs filtered by customer, labor service, month, and wage rate? Running a labor costing spreadsheet and need labor costs by service monthly, filtered by customer showing different categories of ay for prevailing wage and OT rates. HELP!
Thanks for taking the time to reach out to the QuickBooks Community, @sierrairvine.
How are you doing today? I hope all is well.
Have you tried using the Time Activities by Employee Detail report? This report will show you the customer's name, product/service, the description of the job, rates, duration, and amount. You also have the option to customize the report to suit your needs.
Here's an example of the report from my test account:
To open the report:
That should do the trick. If this isn't what you're looking for, please don't hesitate to let me know. Have a great day ahead!
Good morning @Tori B ! We are doing well over here at CR Concepts, just needing to figure out this report so I can job cost some bigger project we have going on.
So - looking at your screen shot, we do not have the gear icon with those options. How we filter is by columns and groups pictured below. Using those options, it does not allow for rates. How do we get this updated reporting option?
Under columns I am able to add cost rate - however this isn't reporting actual pay rates that our employees were paid per their paystub. Its reflecting what their base pay amount is but on their weekly timesheet they were paid prevailing wage amounts and those are not reflected when selecting this. I have attached screen shots below!
@Tori B after further investigating it looks like the cost rate attached their base pay amount but when working on prevailing wage projects, we select a different pay type than their base pay. So is there an option to customize sorting by pay type instead of cost rate?
Thanks for getting back with the Community, sierrairvine.
I can certainly understand how an ability to sort your Time Activities by Employee Detail report by pay types could be useful and have submitted a suggestion about it as of today.
You can also submit your own feature requests while signed in.
Here's how:
Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing our Product Updates page.
As a workaround, you can use Class Tracking to sort by pay types. There's also the option of including the pay type in your Description or Memo fields when creating time activities.
Please feel welcome to send a reply if there's any additional questions. Have a wonderful Friday!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here