Show only active rows and columns on reports in QuickBooks Online

To keep things less cluttered when you're looking at your reports, you can hide rows and columns with no activity or a total amount of zero. This ability is only available for some reports.

Note: This does not apply to payroll reports.

Some of your reports will look different depending on whether they're in the classic view or new enhanced experience. Learn more about the new enhanced experience.

To show only active rows and columns:

• In case of Modern view:
  1. In a report, select General options.
  2. If available for your report, under Show non-zero or active , select Active or Non-zero under Show rows or columns, as per your requirement.
  3. Under Number format , tick Don't show zero amounts.
     Note: The report refreshes when a different option is selected. You can also select the refresh report icon .
• In case of Classic view:
  1. If available for your report, select the Show non-zero or active only ▼ dropdown.
  2. Under Show rows or columns, select Active or Non-zero as per your requirement.
  3. Select Customise, then select ▼ General to expand it.
  4. Under Number format, tick Except zero amount.
  5. Select Run report.

Notes:

• Active: Hides empty rows or columns.
• All: Shows all rows or columns.
• Non-zero: Hides rows or columns with a total of zero.