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.

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.

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.

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.
5. Follow the on-screen instructions to complete the process.

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.

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?