Payroll Report per JOB

Hi, Jena11.

I'm here to guide you get the information you need.

To run payroll reports for specific jobs is currently unavailable in QuickBooks Desktop. However, you can run a separate report for your payroll and job. Then, compare them by exporting the report to excel.

Here's how to run a report for a job:

1. Go to the Reports menu.
2. Select Jobs, Time & Mileage.
3. Choose the Job Profitability Detail for one job and Job Profitability Summary for multiple jobs.
4. Enter then reporting date.

Once done, you can export those reports to excel and compare them.

For your reference, feel free to check the guides here for the detailed steps:

• Create a total hour worked by employee report

• Customize payroll and employee reports.

Add a comment if you have further questions about payroll reports. I'll be around to help you.

@Jena11 

RE: Why can't I just run a report to show how much was paid in payroll for a specific job during a specific time frame?

You can. You can start with existing reports and filter them or create your own summary or detail report.

Start with the Payroll Transaction Detail report:

- Filter it by the Name field, where the name is a Customer or Customer:Job

- Optionally, add the Name field (compared to the Source Name field) so you can see the Job on the report as well as the employees.

Start with the Job Profitability Summary report:

- Filter it for Paycheck type transactions and the desired Name, a Customer or Customer:Job.

Start with the Job Profitability Detail report:

If you use time for payroll, and you enter service items on the time or the paychecks, this report will show you that breakdown, by item.

- When it runs, you're prompted to select 1 job.

- Filter the report for Paycheck type transactions.

Start with a custom Summary Report (Reports | Custom Reports | Summary)

- Filter it for Paycheck type transactions and the desired Name, a Customer or Customer:Job.

- Choose the row and column axis to see the numbers you care about. For example, the Rows might be totaled by Income Statement, Payroll Item Detail, Item Detail, or similar. For the columns axis if you pick Job then the report will call out the job it's filtered for, removing and confusion about the data your seeing.

@Giovann_G 

RE: To run payroll reports for specific jobs is currently unavailable in QuickBooks Desktop.

I've been running such reports in QuickBooks for many years. What makes you think they're not available?

How do i set up a custom report to show hours per employee per job?

Hi @Home Effects,

Thank you for reaching out to us here in the Community. I can help you run a report to show the hours worked per employee per job in QuickBooks Desktop.

I recommend running the Time by Name report to pull up the data you need for the employees. You can choose the Time by Name by Job by Item option from the customization screen.

It allows you to view the hours of each employee in the system. Here's how:

1. Click the Reports tab at the top menu bar.
2. Hover your cursor to Jobs, Time & Mileage and select Time by Name.
3. Choose Customize Report at the top.
4. Enter the date range.
5. Select Time by Name by Job by Item next to Display time grouped by. 
6. Go to the Filters tab.
7. Add the Name filter.
8. Choose All employees.
9. Hit OK. 
10. View the report. 

For additional reference, I've attached a link you can use to learn more about personalizing reports, like how to change the report Header/Footer information: Customize reports in QuickBooks Desktop.

Fill me in if you have additional questions about running reports in QuickBooks. I'm always here to help. Take care always. 

I ran a profit and loss report by JOB to get this information. Under Reports, Company & Financial, and then P&L by job. You have to customize the report at the top right, and once you click that go into 'filters' find the 'Name' filter and then select the customer/job you're looking for hours by job on.

I need to run a report for a particular job showing the employees name, pay per hour, and total hours worked on the job?

Hi there, @Olivia M.

You can run the Summarize Payroll Data in an Excel report. This will give you all the data that you need such as employee's name, rate, job, and total hour worked. Here's how:

1. Go to Reports and select Employees & Payroll.
2. Click Summarize Payroll Data in an Excel report.
3. This will open the report in an Excel file.
4. Select the Excel tabs at the bottom part to view the data that you need.

That should do it. Let me know if you have any further questions or concerns. I'll be here to help. Have a good one.

Thanks so much for responding so quickly.  I need this information for a particular job though.  The report gave me information for all employees pay.  We are a contract company so we have multiple jobs going on at one time.  What I need is only the employees that worked on a particular single job.  Any information would be greatly appreciated.

Good morning, Olivia M.

Thanks for following up on this thread. I'd be glad to provide some additional info about the report you need in your QuickBooks Desktop account.

The report option that I recommend to view the data you're looking for would be the Time by Job Detail report. This specific report breaks down your information by Date, Name, Billing Status, and Duration. You can then customize the data even further by filtering for an individual employee. Here's how:

1. Select the Reports tab and choose Reports Center.

2. Click Jobs, Time & Mileage on the left and then scroll down to the Time section.

3. Locate the Time by Job Detail report and click the green arrow button to run the report.

4. Select Customize Report in the top left corner.

5. Choose the Filter tab, and scroll down to pick the Name filter.

6. You can then scroll through the drop-down menu to select a single employee name. 

7. Click OK when you're finished.

That will do it. This report will allow you to view the data you're looking for. Please don't hesitate to reach back out if you have any other questions. I'll be here to help in any way that I can.

I have tried every single report suggestion out there and I can not get the payroll expenses to show on any of the P&L, or financial reports. I wonder if it's a payroll setting, i checked and hours are marked billable. It's impossible to give my boss a true P&L per job without payroll expenses showing on it. Can someone help me out? 

Thanks! 

Jo

Hi there, @JoMelo2021. It's our priority to ensure all your income and expenses are reported properly.

Let's ensure that you have the correct expense accounts associated with your payroll items. You can run the Payroll Item Listing report to see detailed info on each one.

1. Go to the Reports menu.
2. Choose Employees & Payroll and select Payroll Item Listing.
3. Verify the accounts under the Expense Account column.
4. To edit a payroll item, double-click it from the list.
5. Click Next.
6. Make any necessary changes to the expense account associated with the item.
7. Select Next until you can select Finish.

For more details, check out this article: Change an expense or liability account associated with a payroll item.

There are also various reports that help you keep track of your payroll details and history, especially on year ends. Check out this link: Customize payroll and employee reports.

Thanks for coming to the Community. I look forward to being able to help you again should you have further concerns about running reports. Have a great day.

I had to change the name of a job after I ran payroll.

I edited the name of the job in the paycheck detail and now the profit and loss does not show the wages and salaries, giving me the incorrect amount on the profit amount. This needs to reflect the correct amounts.

How can this be fixed?

This report does not tell you the payroll costs. It seems like a simple request for a Contractor Edition of software. The hours and labor costs for a particular job broken down by employee

I am having this issue now, did you ever find a solution?

Hello there, @greavesallison.

Let me share some details on how to run job reports if you need to see the payroll wages, taxes, deductions, and contributions by the job. 

Here's what you'll need to do:

1. Go to the Reports menu at the top.
2. Click Jobs, Time, & Mileage.
3. Choose Job Profitability Summary.
4. Double-click the job amount to see the wages, taxes, deductions, and contributions on each job.

To also guide you with the set up to ensure you can track your payroll expenses by job properly, I suggest checking this article for detailed steps: Set up and track payroll expenses by job in QuickBooks Desktop Payroll.

I'm also adding this link here if you need help managing reports. It has our general report topics with articles. Just choose the one that suits your concern: Create and manage reports.

Please get back to me if you have additional questions about running payroll job report in QuickBooks Desktop. I'd be happy to answer them for you.

Took me a long time - but here's what worked for me - easier than any other recommendation I saw here:

Go to Reports: Employees & Payroll: Payroll Item Detail

Customize Report: Enter Time Frame to Display: One Column to the right select Total By Customer

This gives you the payroll sorted by customer.  Export that to Excel and edit the full report to include whatever customer you are looking for the data.

Good luck! This worked for me.

- Susan  

Hi there, Shets.

I'm happy that you're able to find a solution that worked for you, and appreciate sharing them here in the Community. I'm sure this will help others who encounter the same issue.

Let us know if you have other concerns in the comments below. We're always here to assist.

I need to be able to show the payroll cost by month by employee vs the revenue earned for that work for monthly production bonuses. Any suggestions? 

Thank you for joining this thread, SrAcct1. Let me assist you in running a report about the payroll cost by month and the revenue earned for monthly production bonuses.

You can generate a Project Profitability Summary report and customize the date filter to display the specific information you need. Alternatively, you can also create two separate reports. These are Total Payroll Cost and Profit & Loss. Afterward, you can export it to Excel and combine them.

Here's how to run the Project Profitability Summary report:

1. Go to Reports.
2. Look for the Project Profitability Summary.
3. Filter the date.
4. Select Run report.

I'll also be including this helpful resource on exporting and printing your reports for future reference: Export reports, lists, and other data from QuickBooks Online.

If you have any additional concerns besides reports in QuickBooks Online, please post them here in the community.