Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
E
EthanDale
June 27, 2022
Solved

How do you create custom reports?

  • June 27, 2022
  • 2 replies
  • 5 views

We don't currently do payroll through QuickBooks Online, so none of the payroll reports have any data. I can sort of create my own in Excel, manually entering in the figures from the reports for Wages, 941, SWT, etc., but this isn't very optimal. I'd like to create my own custom report that's sort of like a payroll summary. I don't see a button to create a custom report, which is what the documentation says to do.

Best answer by ChristieAnn 11

Welcome back to the QuickBooks Community, EthanDale. I'll be providing details on how Custom reports work in QuickBooks. Then, to ensure you can create your own custom report that is sort like a payroll summary.

 

You can make a custom report in QBO by clicking the Save customization button after you've customized the specific data within the program. Please know that a custom Payroll Summary report is currently unavailable in the QuickBooks Online Essential and Plus versions.

 

However, you can use or upgrade your subscription to QuickBooks Online Advanced version. You can build your own custom report and allow you to access and organize your company’s financial data from there.

 

Here's how:

 

  1. Sign in to QuickBooks Online as an administrator. Then, go to the  Business overview and select Reports.
  2. Click the Create new report button. Then, enter the name of your report. 
  3. Choose a date range from the dropdown and click Customize.
  4. Select Columns and look for a topic you want to report on. Then, select it to reveal the available fields. 
  5. Select any fields you want to view on the report. 
  6. To change the order in which selected fields appear, select Layout. Then, select and drag the listed fields in the order you want.
  7. Use Pivot table to summarize and total your report data.
  8. Use Filter to view only certain entries.
  9. Select Save to save your report. Then, you can edit the report at any time. 
  10. Click Export to export the data to a spreadsheet. 

 

Once done, you can now view your custom reports. Please follow the steps below on how to perform the process:

 

  1. Sign in to QuickBooks Online as an administrator. 
  2. Go to Business overview and select Reports.
  3. Select Custom reports and choose the report name to open it.

 

Lastly, you may refer to this article to see several payroll reports you can use to view useful information about your business and employees in QBO: Run payroll reports in QuickBooks Online Payroll.

 

Feel free to leave a comment below if you still have concerns about custom reports in QuickBooks. I'll get back to you as soon as I can, EthanDale. Have a good day!

2 replies

C
ChristieAnn 11Answer
Level 9
June 27, 2022

Welcome back to the QuickBooks Community, EthanDale. I'll be providing details on how Custom reports work in QuickBooks. Then, to ensure you can create your own custom report that is sort like a payroll summary.

 

You can make a custom report in QBO by clicking the Save customization button after you've customized the specific data within the program. Please know that a custom Payroll Summary report is currently unavailable in the QuickBooks Online Essential and Plus versions.

 

However, you can use or upgrade your subscription to QuickBooks Online Advanced version. You can build your own custom report and allow you to access and organize your company’s financial data from there.

 

Here's how:

 

  1. Sign in to QuickBooks Online as an administrator. Then, go to the  Business overview and select Reports.
  2. Click the Create new report button. Then, enter the name of your report. 
  3. Choose a date range from the dropdown and click Customize.
  4. Select Columns and look for a topic you want to report on. Then, select it to reveal the available fields. 
  5. Select any fields you want to view on the report. 
  6. To change the order in which selected fields appear, select Layout. Then, select and drag the listed fields in the order you want.
  7. Use Pivot table to summarize and total your report data.
  8. Use Filter to view only certain entries.
  9. Select Save to save your report. Then, you can edit the report at any time. 
  10. Click Export to export the data to a spreadsheet. 

 

Once done, you can now view your custom reports. Please follow the steps below on how to perform the process:

 

  1. Sign in to QuickBooks Online as an administrator. 
  2. Go to Business overview and select Reports.
  3. Select Custom reports and choose the report name to open it.

 

Lastly, you may refer to this article to see several payroll reports you can use to view useful information about your business and employees in QBO: Run payroll reports in QuickBooks Online Payroll.

 

Feel free to leave a comment below if you still have concerns about custom reports in QuickBooks. I'll get back to you as soon as I can, EthanDale. Have a good day!

E
EthanDaleAuthor
June 29, 2022

I found out that you cannot make custom reports unless you pay an additional fee.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement