Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
sierrairvine
Level 1

payroll reporting

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!

5 Comments 5
Tori B
QuickBooks Team

payroll reporting

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:

 

rates column.PNG

 

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! 

 

 

sierrairvine
Level 1

payroll reporting

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!

sierrairvine
Level 1

payroll reporting

After adding the cost rate filter 

sierrairvine
Level 1

payroll reporting

@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?

ZackE
Moderator

payroll reporting

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:
 

  1. Use the Gear icon.
  2. Go to Feedback.
  3. Enter your comments or product suggestions.
  4. Select Next.

 

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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us