How to Export the General Ledger to Excel in QuickBooks Online Easily 2026

Log into QuickBooks Online and you'll land on the homepage, greeted by name with shortcuts for Accounting, Expenses & Pay Bills, Sales & Get Paid, and more across the top, plus at-a-glance cards for bank balances, profit and loss, and invoices. The General Ledger export isn't triggered from any of these cards directly — it lives inside a dedicated export tool reachable from the gear icon in the top right, under Tools, where QuickBooks groups data-management features like this one alongside things like the audit log.

Selecting Export Data opens a screen titled "Which reports and lists do you want to export?" with two tabs — Reports and Lists — and a toggle next to each item you can include. On the Reports tab, General ledger sits alongside Profit and loss, Balance sheet, Trial balance, and Journal, all switched off by default, with a date-range dropdown above them defaulting to "All dates." This is the same tool people use for a broader QuickBooks backup, so it's worth remembering it exists next time you need more than just the ledger.

Change the "Pre-selected date ranges" dropdown from All dates to Custom, and two new fields appear for Start date and End date. Narrowing the range matters for anything beyond a full annual review — a General Ledger covering every transaction since the company file was created can run to thousands of rows, which is unwieldy in Excel and slows down anyone trying to reconcile a specific period. Match the range to whatever you're actually working on, whether that's a fiscal quarter, a single month for a bank reconciliation, or a custom window an accountant requested.

Flip the toggle next to General ledger to turn it green and include it in the export. Since you're already in this screen, it costs nothing to also toggle on Profit and loss, Balance sheet, Trial balance, or Journal if you know your accountant or your own review will need them too — each exports as its own tab inside a single Excel workbook rather than separate downloads, which keeps everything for a given period in one file.

With your reports selected and date range set, click the green Export to Excel button in the bottom right corner. QuickBooks compiles the selected reports for the chosen period into a single .xlsx file and downloads it through your browser, the same way any other file download works — check your browser's downloads folder or download bar if it doesn't open automatically.

Open the downloaded workbook and check the General ledger tab specifically: confirm the date range matches what you set, that account names and transaction descriptions look complete, and that the running balances tie out to what you'd expect from the QuickBooks report itself. The export brings over static values rather than live formulas, so any further calculations, subtotals, or pivot tables are something you'll build fresh in Excel rather than something that carries over automatically.