cancel
Showing results for 
Search instead for 
Did you mean: 
advance2201
Level 2

View payrate by customer:job

Hi,

 

We need a summarized report to show hours worked and the pay rate by Job for one of our customers

We have a staffing agency and send our graduates out to Customers.

We have two jobs set up to distinguish the department.  There are two payroll items for this customer to distinguish Labor and Forklift driver.  We can't find a report to connect the payrate, hours worked and customer job.

Example:

ABC Company

JobPay Rate (from employee's profile)Hours worked (from timesheet)
Forklift$12160
Laborer$10200

 

Thanks for any suggestions!

 

4 Comments 4
JonpriL
Moderator

View payrate by customer:job

Hello @advance2201,

 

You can pull up and customize one of your reports to determine the pay rate base on hours worked in a job. Let me show you how.

  1. Go to Reports.
  2. Under Jobs, Time & Mileage, select Time by Job Detail.
  3. Select Customize.
  4. On the COLUMNS section, put a check on the Payroll Item selection.
  5. Click Filter.
  6. Below the CHOOSE FILTER section, select Payroll Item.
  7. Select all the payroll items used on your job.
  8. Click OK.

In the same manner, here's an article you can read to learn more about how you can customize a report: Customize reports in QuickBooks Desktop.

 

On top of that, I've also included this reference for a compilation of articles you can use while working with us: Know where you stand financially.

 

If there's anything else that I can help you with, please let me know in the comments below. I'll be here to lend a hand.

advance2201
Level 2

View payrate by customer:job

Thanks for the response.  This is a report we use, but it will not allow us to pull in the pay rate. 

It seems everything we try will get either the hours or the pay but not both into one report.

Rasa-LilaM
QuickBooks Team

View payrate by customer:job

Thanks for adding more information about your concern, advance2201.


In the Time by Job Detail Report, you can add the Payroll Item column to show the pay types used for the jobs. However, it will not show the rate for each type.tjd2.png


You can consider exporting the report in Excel. From there, add the pay rate column and manually enter the amount.


I’ll show the steps on how to do this in QuickBooks.

 

  1. Open the Time by Job Detail Report.
  2. Click the Dates drop-down to set the correct period.
  3. Hit the Refresh button to see the changes.
  4. From there, press the Excel drop-down to select Create New Worksheet.tjd.png
  5. Follow the on-screen instructions to complete the process.tjd1.png

I’m adding an article that will guide you on how to personalize the data on your report and steps to create specific custom statements: Customize customer, job, and sales reports in QuickBooks Desktop.


Please let me know if there's any other way I can be of assistance. As always, I'm just a few clicks away for help. Enjoy the rest of the day.

tifanilei
Level 1

View payrate by customer:job

I was using the attached report and it stopped working when I went to a 64bit system.. It included: date, employee name, customer:job, pay item, hours, pay rate, est. pay

 

How can i create this report again?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us