Fix "The report you are attempting to create may not display..." in QuickBooks Online
by Intuit•1• Updated 2 months ago
Learn how to resolve "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.
It is common for you to see errors like this when you run General Ledger reports because of their file size. This is QuickBooks Online’s limitation as an online application.
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. |
Step 1: Run your General Ledger reports
- Go to Reports (Take me there), and then look for the For my accountant section.
- Select General Ledger.
- Set the date for the report period, then select Run report.
- Select Customize, then select the Filter dropdown.
- Mark Distribution Account, then choose All Bank Accounts from the dropdown.
Run a report for a Balance Sheet or Profit and Loss account
To run General Ledger reports for your Balance Sheet and Profit and Loss accounts, just choose the appropriate option:
- Assets - All Asset Accounts
- Liabilities - All Liability Accounts
- Equity - All Equity Accounts
- Income - All Income Accounts
- Expense - All Expenses Accounts
Select Run report. This creates a General Ledger of your bank accounts.
Note: Select Save customization to access the same report easily. Make sure to use a descriptive name.
Where can I find the report?
Go to Reports (Take me there), then the Custom reports tab and select the report.
Step 2: 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 reports you want to combine.
- Use the tools in Excel to combine worksheet information.
For more information on report limitations, see How do I 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
- Fix a report that is too large to displayby QuickBooks•7•Updated 1 week ago
- A paid bill or invoice shows on report or window of open transactionsby QuickBooks•1•Updated June 25, 2024
- Fix negative inventory issues in QuickBooks Desktopby QuickBooks•Updated June 15, 2024
- Accountant tools: Troubleshoot inventoryby QuickBooks•Updated over 1 year ago