Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
sierrairvine
September 25, 2025
Question

payroll reporting

  • September 25, 2025
  • 1 reply
  • 17 views

Does 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!

1 reply

Tori B
Tori BQuickBooks Team
QuickBooks Team
September 25, 2025

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: 

 

  1. Open the Report menu. 
  2. Search Time Activities and click on Time Activities by Employee Detail. 
  3. Customize as needed. 

 

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! 

 

 

S
sierrairvineAuthor
September 26, 2025

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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement