Skip to main content
J
Jena11
May 17, 2021
Question

Payroll Report per JOB

  • May 17, 2021
  • 3 replies
  • 0 views

I cannot figure out for the life of me how to get a payroll report for one specific job for a month. Every report I try pulling does not give me what I need, which is just how much we've spent on payroll for a specific job in QB Desktop.

 

I've tried this: https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/hours-worked-report/00/247809

but it does not break this down the way I need it? I even tried customizing the report to reflect only the employees worked at the job and the job itself, but still not accurate. 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?

    3 replies

    G
    Giovann_G
    May 17, 2021

    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:

     

     

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

      BigRedConsulting
      BigRedConsulting
      May 18, 2021

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

      H
      Home Effects
      October 13, 2021

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

      BigRedConsulting
      BigRedConsulting
      May 18, 2021

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

       

      S
      SrAcct1
      March 27, 2024

      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? 

      M
      MelroseV
      March 27, 2024

      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.

      G
      greavesallison
      December 19, 2022

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

      M
      MirriamM
      December 19, 2022

      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.

      Terms & ConditionsAccessibility statement