Fix a report that is too large to display in QuickBooks Online

When generating a report, you may see a message at the bottom of your screen that says the following: Report too large to display.

This happens when a report exceeds the size limits applied to reports generated within the program.

Size limits when exporting a report to Excel

The following are the size limits for columns, cells, and data:

• Columns: maximum of 1024 columns displayed. (It's unlikely that you'll exceed this limit because it's based on the Excel column limitation.)
• Cells:  maximum of 400K cells with data. (Cells are defined as data that shows up on an individual cell once exported to Excel. Only cells that have data in them count toward the limit.)
• Data: maximum of 10MB worth of data.

Fix a report that's too large to display

There are 4 steps that can help you fix a report that is too large to display.

1. If you're looking at a report displayed on QuickBooks Online, you can double the amount displayed by simply exporting the report to Excel.
2. Since the limit is based on the raw amount of data displayed, you can potentially get more data into a report by eliminating columns you don't need to be displayed. (Note: See how to remove columns below).
3. Select Run report.
4. Segment the report by generating reports with intermediate date ranges. This could work for transaction detail reports that aren't grouped or grouped by some date designation (day, week, month).

Remove columns

To remove columns:

1. Open the report you would like to edit.
2. Select Customize at the top of the report.
3. Select Rows/Columns, then choose Change columns.
4. Put a check mark on your selected columns, uncheck to remove the others.

Learn more about customizing reports in QuickBooks Online.

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.