Learn how to create custom reports with the enhanced experience (modern view) in QuickBooks Online.
Some reports have the option to try our New Enhanced Experience, the result of our continuous efforts to improve our product. Advantages of this include:
- Quickly customize with drag and drop fields, filters, and charts to create your own reports.
- Save and share your reports with others in your organization.
- A new data engine that can handle large volumes of data and complex calculations. You can run reports faster and get insights quicker.
If you see this in your report title, you can use the enhanced report experience (modern view).
The enhanced report experience shows all the categories up front so you can select how you want to personalize your report.
Customize reports in QuickBooks Online Advanced
Create a custom report
Generate a customized report through the use of filters. If you haven’t yet, sign in to QuickBooks Online as an administrator.
- Go to Reports (Take me there).
- Select +Create new report, select the report type, then select Create.
- Select the pencil icon , then enter/edit the name of your report.
Customization Options (steps may vary based on report type) | What you can do |
Date range dropdown▼ | Select the date coverage of your generated data. |
Pivot | Select Pivot to summarize and total your report data. Here’s how: 1. Select which fields to categorize in the rows and columns, then select which value field you want to summarize. 2. Select Show totals to add a totals row or column. 3. Once you've selected Rows, Columns, and Values, the report view displays as a pivot table. Switch off Show Pivot Table to return to the original view. |
Group | Select Group to categorize line items by any column. You can select up to 3 columns to group data. Select Edit group calculations ▼ to calculate totals, averages, or percentages for numeric groups. Tip: When a report is grouped, select expand ▼ to view the details inside that group. When you select a column to group by hierarchy, it automatically becomes the first column on the report. You won’t be able to hide this column. When you select a hierarchical group, you can’t use any other groups to customize your report. |
Filter | Select Filter to view only certain entries. Select what you want to filter by, select the operation, then select from the provided values. Tip: You can apply multiple filters on multiple lines using And / Or. Choose from one of several columns from the Columns panel and it will also be available under filters. |
General options | Change things like the accounting method, reporting period, and number format. Select Accounting method to see the difference another accounting method will make in your reporting. You can customize an individual report to use a different accounting method and compare the results. Select Number format to to divide the number by 1,000 or include cents or zero amounts on the report. Modify with fixed periods or custom ranges. Select Aging to categorize outstanding balances by days past due. Based on the current date or the report date. Select Header/Footer to decide what appears in the report header and footer. |
Columns | 1. Select Columns, look for a topic you want to report on, then select it to reveal the available fields. 2. Select any field you want to view in the report. Note: Some fields may not work in a report together. When you select a field, non-compatible fields will be unavailable. If you use custom fields, they appear in this list. 3. To change the order in which selected fields appear, select Reorder, then select and drag the listed fields in the order you want. Note: Select show/hide to hide or unhide a field. |
- Select Save to save your report. You can edit the report at any time.
Tip: Select Export to export the data to a spreadsheet to store and access it in the future.
The customization options on the report title allow you to:
- expand or collapse all groups on the report.
- alter the density of data on the report from compact to normal.
Refresh data on the report by selecting the refresh icon . Report data also updates whenever you customize so you don’t need to Run report.
To get even more space for your reports, select the ∧ icon to collapse the top header.
View your custom reports
If you haven’t yet, sign in to QuickBooks Online as an administrator.
- Go to Reports (Take me there) and select the Custom reports tab.
- Select the report name to open it.
Tip: If you want to view any transaction in your report, select any field in the report row to open the transaction in a new tab.
Visualize your report
Visualize your report with a chart view to create presentation-ready charts of your report data.
- Open your custom report.
- Select Chart View.
- Select the chart type to see how you want to visualize your data.
- Adjust which field displays on the Horizontal (X) axis and the Vertical (Y) axis by selecting an option in the dropdowns.
- Select Save.
Add a chart report to Management reports
You can add chart reports to Management reports to show visualized data:
- While viewing your report in Chart View, go to More actions and select Add to Management reports.
- Select either Create a new management report or Add to an existing management report.
- Either enter the name of the new management report, or select an existing management report.
- Select Add.
Add a chart report to your Performance center
Here is how you can add your customized chart report to your Performance center as a widget:
- While viewing your report in Chart View, go to More actions and select Add to Performance center.
- A push notification shows that your report was successfully added. To view the widget, select "Click here to view" in the notification.
Schedule an emailed report
- In the Custom reports tab, select the report name to open it.
- Select More Actions ▼, then Schedule Report.
- Enter a Workflow name.
- Select a start date, then choose how often you want the report to be sent.
Ex: If you want the report sent every other Monday, enter 2, select Week, then select Mo. - Enter the email address you want to send the report to.
- Fill out a desired Subject and Message.
- Select Save and enable.
You can also schedule custom reports. Go to Custom Reports and select View Schedules on the relevant report.
Note: If you need to turn off the scheduled report or update the frequency, go to Settings , then select Manage workflows. Here’s how you can learn more about how to create and manage workflows.
Customize reports in QuickBooks Online Plus, Essentials, and Simple Start
Select a report with the New Enhanced Experience.
Customization Options (steps may vary based on report type) | What you can do |
Date range dropdown ▼ | Select the date coverage of your generated data. |
Group | Select Group to categorize line items by any column. You can only select one column to group data. Select Edit group calculations ▼ to calculate totals, averages, or percentages for numeric groups. Tip: When a report is grouped, select expand ▼ to view the details inside that group. When you select a column to group by hierarchy, it automatically becomes the first column on the report. You won’t be able to hide this column. When you select a hierarchical group, you can’t use any other groups to customize your report. |
Filter | Select Filter to view only certain entries. Select what you want to filter by, select the operation, then select from the provided values. |
General options | Change things like the accounting method, reporting period, and number format. Select Accounting method to see the difference another accounting method will make in your reporting. You can customize an individual report to use a different accounting method and compare the results. Select Number format to to divide the number by 1,000 or include cents or zero amounts on the report. Modify with fixed periods or custom ranges. Select Aging to categorize outstanding balances by days past due. Based on the current date or the report date. Select Header/Footer to decide what appears in the report header and footer. |
Columns | Select Columns to Drag and drop to rearrange columns. Select show/hide to hide or unhide a field. |
Save your report
You can select Save to save your report and edit the report at any time.
To view your reports, go to Reports (Take me there) and select Custom reports.