Fix General Ledger report errors in QuickBooks 

Create a General Ledger report in QuickBooks Online to prepare it for export.

1. Follow this link to complete the steps in product.
2. Under the For my accountant section, select the General Ledger report.
3. Set the Report period to the dates you need, then select Run report.
4. Select Customise, then open the Filter dropdown.
5. Mark Distribution Account, then choose the accounts you need from the list. For Balance Sheet or Profit and Loss accounts, choose:
   • Assets – All Asset Accounts
   • Liabilities – All Liability Accounts
   • Equity – All Equity Accounts
   • Income – All Income Accounts
   • Expenses – All Expenses Accounts
6. Select Run report to generate your General Ledger.
7. (Optional) Select Save customisation to save the report with a descriptive name for future use.

Exporting allows you to view large reports that QuickBooks Online may not display fully.

1. While on your General Ledger report, select the More actions dropdown.
2. Choose Export to Excel.
3. Save the Excel file to your device.
4. Repeat this process for any other reports you need to combine.

Tip: If the report is too large to export at once, reduce columns or apply filters to limit the data.

If a single report is too large, split it into smaller reports and merge them in Excel.

1. Open each exported report in Excel.
2. Use Excel’s tools to consolidate data from multiple worksheets into a single file.
3. For detailed instructions on combining worksheets, refer to Microsoft Office support.

Tip: Label each worksheet clearly to make merging and reviewing data easier.