QuickBooks General Ledger: How to Run the General Ledger Report in QuickBooks Online and Export It to Excel

The QuickBooks general ledger report lists every transaction posted during a date range, grouped under the account it hit, with a running balance for each account. In QuickBooks Online it is under Reports, in the For my accountant group. In QuickBooks Desktop it is Reports, then Accountant and Taxes, then General Ledger. It is the most detailed report QuickBooks produces, and the one people run when a balance on the balance sheet looks wrong and they need to see what made it up.

It is also the report most likely to be sixty pages long and unreadable if you run it without setting anything first. Here is how to run it in both products, how to cut it down to the one account you care about, how to get it into Excel intact, and what to do with it once you have it.

What is a general ledger in QuickBooks?

It is the complete record of posted transactions organized by account rather than by date. Every account in your chart of accounts appears as a block: the beginning balance for the period, then one row per transaction with its date, type, number, name, memo, split account, amount and a running balance, ending with the account total. Accounts with no activity in the period still show their balance.

QuickBooks does not really have a general ledger as a separate thing you maintain. Every invoice, bill, check and journal entry you enter posts to the ledger automatically as a balanced pair of debits and credits, and the general ledger report is simply a view of that. This is why the question "does QuickBooks have a general ledger" has a slightly odd answer: yes, and you have never touched it directly, because the forms sit on top of it.

The difference between this and the trial balance confuses people constantly, and it is worth being precise because it changes which report you should be running. The general ledger is transaction level and answers "what made up this balance." The QuickBooks trial balance is account level and answers "what is every account worth right now." If you are producing statements, you want the trial balance. If you are investigating a number on the statements, you want the general ledger. Running a full ledger when you needed a trial balance is a common way to turn a one hour close into an afternoon.

How do I run a general ledger report in QuickBooks Online?

Go to Reports in the left navigation and type "general ledger" into the report search box, or scroll to the For my accountant section where it sits with the trial balance, journal and account list reports. Open it, then set four things before you read anything.

The date range. The default is usually the current month to date. For a close, set it to the period you are closing. The general ledger is genuinely a period report: the beginning balance column reflects everything before your start date, and the rows are only what posted inside it.

The accounting method. Customize, then General, then Accounting method. Cash and accrual produce different ledgers from identical data, because cash basis suppresses unpaid invoices and unpaid bills. If you are chasing a discrepancy between this report and a balance sheet, check that both are on the same basis before you look anywhere else. That single mismatch explains a large share of the reconciling differences people spend an hour hunting.

The columns. Under Customize, then Rows/Columns, then Change columns, you can add explicit Debit and Credit columns rather than a single signed Amount, which is what you want if the report is going to an accountant or into a workpaper file. There is also a Cleared column, which shows the reconciliation status of each transaction and is quietly one of the most useful things on the report when a bank account will not reconcile.

The account filter, covered below, because it is the setting that turns this report from unusable to useful.

How do I run the general ledger report in QuickBooks Desktop?

Reports, then Accountant and Taxes, then General Ledger. Set the dates in the From and To boxes. The accounting basis toggle is in Customize Report, on the Display tab, as a Report Basis radio button for Accrual or Cash.

Desktop gives you two things Online does not. The first is the Advanced button in Customize Report, where the Include setting can be switched from All to In Use, which drops every account with no activity and no balance out of the report. On a chart of accounts that has accumulated 300 accounts over fifteen years, that alone can halve the page count. The second is that Desktop's memorized reports actually hold your filters, so a ledger you have configured once for a particular investigation can be re-run next month without redoing any of it.

Desktop also carries an Adjusted Trial Balance report in the same Accountant and Taxes menu with no direct Online equivalent, showing unadjusted balances, adjusting entries and adjusted balances in separate columns. If your goal is producing statements rather than investigating a transaction, that report is usually the better place to start. It is worth knowing before a migration that the Desktop-only reporting tools do not follow you across: neither QuickBooks Statement Writer nor Advanced Reporting exists in QuickBooks Online, which is covered in QuickBooks Statement Writer alternative.

How do I run a QuickBooks general ledger report for one account?

This is the setting that makes the report worth running. In QuickBooks Online, open Customize, then Filter, then tick Distribution Account and choose the account or accounts you want. Save the customization if you will repeat it. In QuickBooks Desktop, Customize Report, then the Filters tab, then Account, then select the account or a range of accounts.

Filtering to a range rather than a single account is underused. Selecting all accounts from 6000 to 6999 gives you the full detail behind operating expenses and nothing else, which is exactly the report you want when the P&L shows expenses up 30 percent and nobody knows why. Selecting the subaccounts of one parent gives you the detail behind a single balance sheet caption.

One column that trips people up: the Split column names the offsetting account for each transaction, but when a transaction hits more than one offsetting account it shows "Split" instead of a name. A deposit covering four invoices, or a bill coded across three expense accounts, will read that way. To see the breakdown, click the transaction to open it, or run Transaction Detail by Account, which lists each distribution line separately.

How do I export the general ledger from QuickBooks to Excel?

In QuickBooks Online, use the export icon at the top right of the report and choose Export to Excel. In Desktop, the Excel button at the top of the report window, then Create New Worksheet.

Expect to clean it. The export carries QuickBooks' visual grouping into the spreadsheet, which means account names sit in their own header rows rather than in a column beside each transaction, blank spacer rows separate the blocks, and subtotal rows are mixed in with transaction rows. None of that survives a pivot table. The fix is a helper column that carries the account name down the sheet, then filtering out the rows with no date. If you are doing this monthly, it is worth memorizing the report rather than rebuilding the cleanup each time.

The other thing to check before you trust an export is completeness. A ledger only contains what was entered, and the gap is almost always bank activity that never made it into QuickBooks: a card that was never connected to the bank feed, a merchant account whose deposits arrive net of fees, an old account nobody set up. If you are working from paper or PDF statements to close that gap, it is faster to convert the statement into a QuickBooks-ready file than to key several hundred transactions by hand. A ledger with a missing bank account produces statements that balance perfectly and understate both sides.

Running the general ledger by class in QuickBooks

If you use classes, departments or locations, add the tag to the report through Customize, then Rows/Columns, and filter by it under Filter. This turns the ledger into a per-site or per-service record and is the only reliable way to check whether classes have been applied consistently, because unclassified transactions show up as a block with no class rather than being quietly folded into a total.

That check is worth running before anyone builds a segmented P&L, since a class report is only as good as the tagging behind it. The reporting side of that is covered in running a profit and loss by class, and the time dimension in a profit and loss by month.

What to look for on the report

Once the ledger is filtered to something readable, these are the things that repay a scan.

What to check on a QuickBooks general ledger, and what it usually means

What you see	What it usually means	What to do
Journal entries dated the last day of a period, with no memo	Someone forced a balance rather than fixing the cause	Trace to a workpaper; if there is none, reverse and correct properly
Transactions dated inside a closed period	The close was not locked, and last year's issued statements no longer agree to the books	Set a closing date with a password; see why retained earnings is incorrect
A growing Undeposited Funds balance	Payments were recorded twice, once as received and once as a deposit	Clear it before issuing a balance sheet; see clearing undeposited funds
Opening Balance Equity carrying a balance	Setup balances were never reclassified to real equity accounts	Reclassify to retained earnings or paid-in capital, with support
Uncleared transactions months old in the Cleared column	Stale checks or duplicates that will never clear the bank	Void or reissue, dated in the current period
Round-number entries to Ask My Accountant or a suspense account	A plug nobody resolved	Resolve before the statements are produced

Is QuickBooks a general ledger system?

Yes. QuickBooks is a double-entry general ledger system: it holds the chart of accounts, posts every transaction as balanced debits and credits, and maintains account balances continuously. That is the definition. What people usually mean when they ask is whether it is enough for their situation, and that depends on multi-entity consolidation, dimensional reporting, and audit trail requirements rather than on whether the ledger itself is real.

Where QuickBooks genuinely stops is presentation. The reports it produces are internal management reports in Intuit's house format: they carry your raw chart of accounts rather than presentation captions, they will not group five bank accounts into a single cash line, and the cash flow statement it offers is built on assumptions you cannot inspect. For an owner checking the month that is fine. For a lender package, a board pack or a CPA issuing a compilation, it is a starting point rather than a deliverable.

From the general ledger to financial statements

The path is short and the order is fixed. Summarize the ledger to one ending balance per account, which gives you the trial balance. Post adjusting entries for depreciation, accrued payroll, prepaid amortization and inventory. Map each account to a statement caption. Roll net income into retained earnings, or the balance sheet will not balance. Only then are the statements real. The full sequence, including why the cash flow statement cannot be produced from a single period, is on general ledger to financial statements, and the account structure that decides what the captions can contain is on chart of accounts to financial statements. If your ledger is in QuickBooks specifically, the version of that path that starts from this report, including the account type field the export leaves out, is on QuickBooks general ledger to financial statements.

If you are doing this every month for a client roster rather than once a year, the mapping is the part worth saving. Built once per client and carried forward, it turns each period into an import rather than a rebuild, and it flags accounts that appear later with nowhere to go instead of dropping them silently. That mechanism, and the checks that prove nothing fell through it, are covered in trial balance mapping. The multi-client view is on financial statement software for accounting firms.