Easy Tech TutsHow to Export the General Ledger to Excel in QuickBooks Online Easily 2026
By Impran M NLast checked against official docs
Sometimes you need the ledger in a spreadsheet: to hand to an accountant who doesn't have a login, to reconcile a period, or to feed another report. QuickBooks Online gives you two ways to get it into Excel.
The Export data tool under Settings bundles the General Ledger with your other core reports and lists for a date range you pick. The General Ledger report itself exports on its own, and it's the route to use when you need to filter to specific accounts or add separate Debit and Credit columns. This guide walks through the first and explains when to switch to the second.
01Open Export data from the Settings menu
From the QuickBooks Online homepage, click the Settings gear in the top right. In the TOOLS column, select Export data.
None of the homepage cards or shortcuts lead here, which is why people often can't find it. QuickBooks first asks why you're exporting. Choose the reason that fits and click Continue.
02Find General ledger on the Reports tab
The next screen asks "Which reports and lists do you want to export?" and has two tabs, Reports and Lists. On the Reports tab, General ledger sits alongside Profit and loss, Balance sheet, Trial balance and Journal, each with its own switch.
In this recording every switch starts off and the date range reads All dates. The Lists tab holds contact lists such as customers and employees. Leave those off unless you want them in the same download.
03Set the date range
Change the Pre-selected date ranges dropdown from All dates to Custom, and Start date and End date fields appear. Use them.
A ledger covering every transaction since the company file was created can run to thousands of rows. That's unwieldy in Excel and slows down anyone reconciling a specific period. Match the range to the job: a fiscal quarter, one month for a bank reconciliation, or whatever window your accountant asked for.
04Switch on General ledger and export
Turn on the switch next to General ledger. If your accountant will also want the Profit and loss, Balance sheet or Trial balance for the same period, switch those on too, since they come out in the same download. Click Export to Excel in the bottom right, then OK to confirm.
05Unzip the download and check the ledger
The download is a .zip file, not a single spreadsheet. Intuit describes it as your reports and lists as Excel files in one .zip.
Extract it, then open the General Ledger file. If the sheet looks half empty, Excel has probably opened it in Protected View.
Click Enable Editing and the full report appears. Then check that the dates match the range you set and that account names and descriptions look complete. The values arrive as static numbers, so any subtotals or pivot tables have to be built in Excel.
| Compared on | Settings > Export data | General Ledger report |
|---|---|---|
| Where | Settings gear, TOOLS column, Export data | Reports, Standard reports, General Ledger |
| What you download | Excel files for each report and list you switched on, bundled in one .zip | That one report as an Excel file |
| Other reports at the same time | Yes: Profit and loss, Balance sheet, Trial balance, plus lists | No |
| Filter to specific accounts | No, only the date range | Yes: Filter, then Filter by Account |
| Separate Debit and Credit columns | Not configurable on this screen | Yes: Columns, then tick Debit and Credit |
Based on Intuit's QuickBooks Online help articles, checked September 2026.
When it doesn't work
You expected an Excel file but got a .zip
Why: Export data always packages its output as Excel files inside one .zip archive.
Fix: Extract the archive (double-click it on a Mac, or right-click and choose Extract All on Windows) and open the General Ledger file inside.
The exported sheet looks like it's missing data
Why: Excel opened the downloaded file in Protected View.
Fix: Click Enable Editing on the yellow bar at the top of the workbook. Intuit's own export guide gives the same fix.
Your accountant wants debits and credits in separate columns, or only one account
Why: The default General Ledger report doesn't show Debit and Credit columns, and Export data can't filter by account.
Fix: Run the report from Reports > Standard reports > General Ledger. Use Columns to tick Debit and Credit, use Filter to pick the accounts, then choose Export/Print > Export to Excel.
Frequently asked questions
Can I export just one account's ledger?
Not with Export data, which only takes a date range. Open the General Ledger report instead, click Filter, set Filter by to Account, choose the account, and export that report.
Does the General Ledger include separate debit and credit columns?
Not by default. Intuit's documentation says you add them yourself: on the General Ledger report, select Columns and tick Debit and Credit. Do that before exporting from the report.
Why did I get a zip file instead of a spreadsheet?
That's how Export data works. It bundles each report and list you switched on as Excel files inside one .zip. Extract it to get at the ledger.
Which QuickBooks Online plans have Export data?
Intuit lists the article as applying to every current QuickBooks Online plan, from Online Free, Lite and Simple Start through Essentials, Plus and Advanced, plus Solopreneur and QuickBooks Ledger.
Sources and last check
The Export data screens, report list and date-range options come from the original screen recording. The menu path, the reason prompt, the .zip output, the Protected View fix and the Debit/Credit column steps were re-checked against Intuit's QuickBooks Online help articles in September 2026. That check corrected two claims: the export arrives as Excel files in a .zip (not one workbook with a tab per report), and the default General Ledger does not show separate debit and credit columns.
About the author
Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.
