Skip to main content
R
razwheat
January 13, 2025
Question

Simple need for a payroll report that I cannot find

  • January 13, 2025
  • 1 reply
  • 0 views

I need to provide data for a work comp premium audit. I have a brewpub where employees earn tips, which are a pay type, but not applicable for worker comp premiums. I need a report that lists 2025 payroll with tips (pay types) broken out for current and terminated employees. I also need the work comp class displayed to isolate owner pay form the audit as well. I can manually deduct the one owner's comp if necessary.

 

The "PayrollAggregatedReport" would work great, but there's no setting to include terminated employees. Other reports I found do not break out pay types, or present the data in a way that can be easily pivoted or summed for the year. 

 

Please, please, please provide me a solution so I don't have to waste an hour with QBO's useless support. 

1 reply

G
GlinetteC
January 13, 2025

Hello, razwheat.

 

Thank you for reaching out with your request for specific payroll data from QuickBooks Online (QBO) for your work comp premium audit. QuickBooks Online indeed offers a variety of payroll reports, however, I understand your need for a report that includes both current and terminated employees with tips broken out for the year 2025.

 

For the data you require regarding tips given to employees, I recommend running the Payroll Detail report. You can customize this report to All employees to ensure both active and inactive employees are included. To do this, follow these steps:

 

  1. Go to the Reports menu.
  2. Search for the Payroll Detail report.
  3. Customize the report to show only the data needed like, Gross pay, Other pay, etc.
  4. Click Run report.

 

You can consider exporting the report into Excel. This way, you can easily consolidate and analyze it alongside your other relevant data sets. This process will help you streamline your analysis and ensure a comprehensive understanding of all the information.

 

Check this article to learn more about personalizing your report: Customize reports in QuickBooks Online.

 

Moreover, I've included this resource for you to refer to later when wrapping up your year-end tasks: Year-end checklist for QuickBooks Online Payroll.

 

If you have any other specific requirements or need further assistance in customizing the reports, feel free to contact us, razwheat. We're always ready to help.

Terms & ConditionsAccessibility statement