QuickBooks HelpQuickBooksHelpIntuit

Fix "The report you are attempting to create may not display..." in QuickBooks Online

by Intuit•5• Updated 3 weeks ago

Learn how to fix "The report you are attempting to create may not display due to its large size and volume of data" when you run a General Ledger report in QuickBooks Online.

With QuickBooks Online Advanced, you can create your own reports using Custom Report Builder.

General Ledger reports can have errors because the files are large. QuickBooks Online has limitations as an online application. Send your files to Excel so you can see your financial status and manage your money better.

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.
Before proceeding...

Export the General Ledger report to Excel. A simple export usually works with display issues since QuickBooks Online can export more information to a spreadsheet than it can display.

If you still get the error or if the spreadsheet is still not showing the report completely, you need to create a series of reports (by account, period, or any other filter), export them to Excel, then combine them into a single report within Excel.

Tip: If your display is too large, you can try troubleshooting it by minimizing columns or reducing the amount of data shown.

Run your reports to export to Excel.

  1. Go to Reports (Take me there).
  2. In the Find report by name section, type "General Ledger". Select General Ledger.
  3. Select the target date from the Report period ▼dropdown menu.
  4. To export to Excel, select the More actions ▼dropdown menu. Select Export to Excel.
  5. To save your report, select Save as.
  6. Note: You can also make a General Ledger report for your Balance Sheet and Profit and Loss account. Then, you can save it as an Excel file.

After you've exported the reports, merge them into a single Excel file. You can then consolidate data across multiple worksheets in Excel.

QuickBooks LedgerQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.