QuickBooks Modern Report View: What Changed and How to Use It

QuickBooks Online’s modern report view has reshaped how users build, filter, and export custom reports — and the change is more than cosmetic. The updated interface moves customization into a dedicated workspace, replaces the old small-box scroll with full-page navigation, and preserves Excel formulas on export. For users who build complex reports regularly, the workflow is noticeably different from the classic layout.

Building a Custom Report from Scratch

The entry point is under Reports, then Custom reports. From there, selecting Create new report opens a creation wizard that lets you search for a specific report type. Once you choose a type and select Create, you land in the customization workspace.

The first thing you will notice is that column management is front and center. You can manually add or remove data columns, and — a long-requested improvement — drag columns to reorder them without navigating through nested menus. To rename the report itself, you select the report name field twice to edit it inline.

Customization: All Changes at Once

The most meaningful workflow shift in the modern view is that you can now make all your changes — filters, columns, groupings — in a single pass before running the report. Previously, users often found themselves toggling between settings and re-running reports after each adjustment. The modern view is built around batching those decisions and running once.

The Customize panel consolidates the key controls:

• Cash vs. Accrual appears as a toggle, letting you switch accounting methods without digging into preferences.
• Display columns by and Compare to — two of the most-used header controls — are now accessible directly in the report header rather than buried in submenus.
• Filters are managed through a dropdown where you choose a data type, select an operation, and then pick from provided values. You can stack multiple filters and conditions as needed.

Grouping, Pivoting, and Calculations

For users who need more than a flat table, the modern view expands grouping and pivoting options. Under the Groups dropdown, you can group by up to three columns simultaneously. An Edit group calculations dropdown lets you compute totals, averages, or percentages for numeric groups — useful for summary-level analysis without exporting to a spreadsheet.

The Pivot dropdown is new territory for QuickBooks reporting. With a single selection, you can pivot data into rows and columns, then designate values to summarize. A Show totals option displays both row and column totals within the pivot layout.

Column Reordering and Banded Rows

Inside any open report, selecting Columns reveals two tabs. The Reorder tab supports drag-and-drop repositioning. The More Columns tab presents a checklist of available data fields that you can toggle on or off. Under General options, you can also enable Banded rows, which alternates row colors to improve readability on wide reports — a small touch that makes a real difference when scanning dozens of columns.

Formatting and Display Controls

The modern view groups formatting controls into dropdown menus in the customization panel:

• Number format — display figures in thousands or cents, show or hide currency symbols, control zero-amount display, and set decimal precision up to three places or round to whole numbers.
• Header or Footer — toggle elements on or off in the report header and footer.
• Column configurations — switch on Show entity names in columns, relevant for multi-entity reporting.
• Row and Column settings — choose banded row colors or highlight selected columns with a distinct color.
• Gridlines — apply vertical, horizontal, or combined borders to the report grid.
• View options — adjust view style, including text size and spacing.

Export, Drilldown, and Persistence

Two functional improvements stand out for day-to-day use. First, when you export a customized report to Excel, calculated rows and columns now retain their formulas rather than converting to static values. That means totals, subtotals, and other computed cells remain editable in the spreadsheet — a significant time-saver for anyone who refines exported data.

Second, the modern view introduces persistent settings. When you drill down into a transaction from a report and then navigate back, your customizations and scroll position are preserved. Combined with the auto-refresh feature — which ensures you are viewing current data — and a manual refresh icon, the reporting workspace is designed to reduce the friction of re-applying settings after every navigation.

A zero balance drilldown on the Balance Sheet lets you click directly into accounts showing a zero balance to see the underlying transaction detail, rather than assuming the account is empty.

Page-Level Scrolling

A practical but easily overlooked change: the modern view replaces the small embedded scroll box with full-page scrolling. You can scroll the entire page, or hover your mouse in the white space to the left or right of the report body to scroll within the report region. For users working with long reports, this eliminates the cramped scrolling behavior that made the classic view frustrating on large monitors.

Saving Your Work

Once a report is configured, selecting Save As followed by Save commits the customization to your custom reports list. The report retains all settings — filters, columns, groupings, formatting — for future use.