Skip to main content
utilitree
Sep 30, 2024 8:57 PM UTC
Solved

Gross hourly and overtime wage report

Can a customizable report reflect gross hourly and overtime wages for all employees for a certain time period?  I've been combing through reports and I'm not seeing what would fit my situation.

IrizAAnswer
Sep 30, 2024 9:52 PM UTC

Yes, utilitree. Let me help you customize your report so you can see the gross hourly and overtime wages of your employees according to your specified period.

 

The customized report will help you see the specific data you want to view in your report. To see the gross hourly and other information, you can pull up the Payroll Summary and adjust it accordingly by following these steps:

 

  1. Go to the Reports, click the Employees & Payroll, then choose Payroll Summary.
  2. Click the Customize Report.
  3. Under the Display tab, you can click the Dates dropdown and choose the date that you want to pull up and populate on your report.
  4. From the Display Columns dropdown, click Employee or according to your preferences.
  5. Navigate to the Filters tab, then enter Payroll Item from the Search Filters.
  6. Click the Payroll Item dropdown, then click the Multiple payroll items.
  7. Tick the Overtime Rate, Regular Pay, and other choices you'd want to include in your report, then click OK.
  8. Click OK once again to exit the Modify Report: Payroll Summary window.
  9. Press Refresh.

 

If you want to export your report out of QuickBooks and analyze or modify it in Microsoft Excel, you can utilize this article: Export reports as Excel workbooks in QuickBooks Desktop.

 

Please let us know if you have further questions regarding your reports in QBDT, utilitree. We'll be around to help you in any way we can.

View in thread

4 replies

FishingForAnswers
FishingForAnswers
Sep 30, 2024 9:02 PM UTC

@utilitree  Does the payroll summary not fit your requirements?

 

It is customizable and, in fact, can even display by week, month, year, class, whichever really, across the time period you choose.

 

That particular feature is handled by way of the 'Show Columns' dropdown menu near the top of the report.

    IrizAAnswer
    Sep 30, 2024 9:52 PM UTC

    Yes, utilitree. Let me help you customize your report so you can see the gross hourly and overtime wages of your employees according to your specified period.

     

    The customized report will help you see the specific data you want to view in your report. To see the gross hourly and other information, you can pull up the Payroll Summary and adjust it accordingly by following these steps:

     

    1. Go to the Reports, click the Employees & Payroll, then choose Payroll Summary.
    2. Click the Customize Report.
    3. Under the Display tab, you can click the Dates dropdown and choose the date that you want to pull up and populate on your report.
    4. From the Display Columns dropdown, click Employee or according to your preferences.
    5. Navigate to the Filters tab, then enter Payroll Item from the Search Filters.
    6. Click the Payroll Item dropdown, then click the Multiple payroll items.
    7. Tick the Overtime Rate, Regular Pay, and other choices you'd want to include in your report, then click OK.
    8. Click OK once again to exit the Modify Report: Payroll Summary window.
    9. Press Refresh.

     

    If you want to export your report out of QuickBooks and analyze or modify it in Microsoft Excel, you can utilize this article: Export reports as Excel workbooks in QuickBooks Desktop.

     

    Please let us know if you have further questions regarding your reports in QBDT, utilitree. We'll be around to help you in any way we can.

      utilitreeAuthor
      Oct 1, 2024 4:36 PM UTC

      I deeply appreciate the step by step instructions to modify the Payroll summary!  I'm not well versed with customizing reports in QB yet.  This help me out a lot and I even printed out the instructions for future use.  Thank you!!!

      JaeAnnC
      JaeAnnC
      Oct 1, 2024 4:44 PM UTC

      I appreciate the update, @utilitree.

       

      We're delighted to hear that the steps provided by my colleague, @IrizA, above have helped you view the gross hourly and overtime wages for all your employees in QuickBooks Desktop (QBDT).

       

      Moreover, you'll want to export your reports to Excel so you'll have the flexibility to customize them according to your business needs.

      If you have other questions about running payroll reports, you can always post on the Community page. We're always here to help. Keep safe, and have a wonderful rest of the day!

      Terms & ConditionsAccessibility statement