Fix a report that is too large to display

Note: This article is for customers using QuickBooks Online (Advanced, Essentials, Plus, and Simple Start) and Sole Trader.

Learn how to fix a report that is too large to display in QuickBooks.

While running reports, you may see a message that says your report is too large to display.  This happens when the report exceeds the size limits. Here’s how you can fix this.

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.

Note: The classic view is not available for QuickBooks Sole Trader.

Understand size limits when exporting a report to Excel

• Columns: maximum of 1,024
• Cells: maximum of 400K cells with data
• Data: maximum of 10 MB

Fix a report that is too large to display

Here are ways to fix a report that is too large to display.

1. Open the report you want to fix.
2. Drag the vertical line between the columns to adjust their width.
3. Remove columns to display more data. 
4. Run reports for a specific date range using the Report period ▼ dropdown.

Note: If the report still doesn’t display all your data, you can export your reports to Excel.

Remove columns

1. Open the report you want to view and edit.
2. Select Customise.
3. In the Rows/Columns section, select Change columns.
4. Select columns. Uncheck the box for the column you want to remove.
5. Select Run report.
6. Select Save customisation to save the report under custom reports.

Learn more about customising reports in QuickBooks.