Fix a report that is too large to display
by Intuit•2• Updated about 1 hour ago
Learn how to fix a report that is too large to display in QuickBooks Online.
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. |
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
There are 3 steps that you can take to help fix a report that is too large to display in QuickBooks Online.
Step 1: Export your report into Excel
A simple export usually works with display issues since QuickBooks Online can export more information to a spreadsheet than it can display. It is common to see errors like this when you run a General Ledger Report because of the file size.
Learn more about how to export your reports into Excel.
Step 2: Remove columns from your report
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.
To remove columns:
- Open the report you would like to edit.
- Select Customise at the top of the report.
- Select Rows/Columns, then choose Change columns.
- Put a check mark on your selected columns, uncheck to remove the others.
- Select Run report.
Step 3: Combine a series of reports
You can customise a report by account, report period or any other filter available. You may wish to create a series of reports, export them to Excel and combine them into one single report within Excel.
To combine the reports:
- While on the open report, select the Export icon beside Print.
- Select Export to Excel.
- Repeat steps 1 and 2 for all the report segments you want to combine.
- Use the tools in Excel to combine worksheet information.
That's it. You now know how to fix a report that is too large to display.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- How to run and save a monthly expense report by supplierby QuickBooks•Updated June 06, 2024
- Why is the Print icon missing from my preview screen?by QuickBooks•Updated June 04, 2024
- Customise reports in QuickBooks Online using modern viewby QuickBooks•Updated 3 weeks ago
- How do I submit feedback?by QuickBooks•2•Updated 5 days ago