QuickBooks General Ledger to Financial Statements: Turn the General Ledger Report in QuickBooks Online Into a P&L, Balance Sheet and Cash Flow

How to run the general ledger report in QuickBooks Online and QuickBooks Desktop

In QuickBooks Online, or QBO as most bookkeepers write it, open Reports and scroll to the group called For my accountant, where the General Ledger report sits alongside the trial balance, journal and transaction detail reports. You can also type "General Ledger" into the report search box at the top. Older builds of the interface label that group Accountant & Taxes, which is also the exact path in QuickBooks Desktop: Reports, then Accountant & Taxes, then General Ledger. What you get either way is the full detail behind the books: each account as a heading, every transaction posted to it inside the date range listed underneath with date, type, number, name, memo and amount, and a balance that runs down the column.

Three settings decide whether the export is usable, and the defaults are wrong for statement work. Open Customize and set the report period first, because unlike a trial balance the general ledger is a range rather than a snapshot, and a wrong start date quietly changes every opening balance on the report. Still in Customize, the accounting method toggle switches between cash and accrual, and the effect is not cosmetic: on cash basis QuickBooks removes open invoices from Accounts Receivable and open bills from Accounts Payable, so whole transactions disappear from the ledger rather than merely moving. Then open Change columns and tick Debit and Credit. This is the setting people miss. Without it the report shows a single Amount column, and a single signed column is much harder to foot and much easier to misread than an explicit debit and credit pair. Tick Cleared as well if you want reconciliation status to travel with the data.

Export from the export icon at the top of the report, choosing Excel or CSV. If you will run this every month, use Save customization and name it, and the report reappears under My Custom Reports with the same period logic, method and columns already applied. That is worth ninety seconds of setup, because the most common cause of a statement pack that does not tie is not a mapping error at all, it is the second month being exported on a different basis from the first. If you want the summarized version of the same data instead, the report that lists only ending balances is covered on our QuickBooks trial balance to financial statements page, and the step-by-step of reading the ledger itself is in our QuickBooks general ledger walkthrough.

General ledger versus trial balance in QuickBooks: which export should you build statements from

They contain the same money at different resolutions. The general ledger holds every individual transaction posted to every account, so it can run to hundreds of pages on a real file. The trial balance holds one line per account showing where that account ended up, so it is usually two or three pages for the same company and the same period. Foot the ledger by account and you get the trial balance exactly. Nothing is added or lost between them.

For producing a statement pack, the trial balance is the cleaner input and the general ledger is the more useful one, which is why firms end up pulling both. The trial balance gives you the twelve or thirty numbers a balance sheet actually needs, already footed, with no chance of a subtotal error. The general ledger gives you the ability to answer the question that follows every statement pack ever sent to a lender or an owner: what is actually in that number. When somebody asks why professional fees tripled in March, the trial balance says 41,200 and stops. The ledger shows the four invoices. Our general ledger to financial statements page covers the same conversion for ledgers exported from systems other than QuickBooks, and trial balance to financial statements covers the summarized route.

There is one practical trap in the comparison that catches people the first time. The general ledger and the trial balance can present the same account with what looks like an opposite sign, because the ledger is showing signed activity in an Amount column while the trial balance is showing a debit or credit position. They are not in conflict. Adding the Debit and Credit columns to the general ledger, as described above, removes the ambiguity entirely and makes the two reports directly comparable, which is the point of doing it before you export rather than after you have started reconciling in Excel.

The one field the QuickBooks general ledger export leaves out, and why it matters

The QuickBooks Online general ledger export gives you account names. It does not give you account types. That sounds like a small omission until you try to build a balance sheet from it, because the account type is the field that decides which statement a line belongs on and which subtotal it rolls into. "Tools" could be a fixed asset or an operating expense. "Deposits" could be a prepaid asset the business paid out or a customer deposit it owes. "Loan" could be a current liability, long-term debt, or a shareholder receivable. QuickBooks knows which, because the type is set on the account in the chart of accounts. The general ledger report simply does not carry it into the export.

That is why the first hour of every hand-built spreadsheet model goes on rebuilding a mapping that already exists inside QuickBooks. The usual workaround is to export the chart of accounts separately, which does include the type, and join the two files on account name. It works, and it breaks in exactly two places: accounts renamed since the last export, and sub-accounts whose names are only unique underneath their parent. Both failures are silent. The line does not error, it just lands in the wrong subtotal, and a balance sheet that still balances is not evidence that it landed correctly.

AIStatements handles this by reading the account structure rather than guessing from the name, and by remembering the decision. Connect QuickBooks directly and the type comes across with the account. Upload an export and unfamiliar accounts are classified and shown to you before anything is produced, so you approve the mapping once rather than every month. When the chart of accounts gains a new expense account in April, it maps to the same statement line the rest of its family maps to instead of appearing as an unexplained new row. If you would rather start the mapping from the chart of accounts itself, that route is on chart of accounts to financial statements.

From general ledger export to a finished statement pack: what the conversion does

The work is the same every month and it is mechanical, which is the argument for not doing it by hand. Every transaction is summed to an account balance. Every account is assigned a statement and a line. Cash, receivables, inventory and prepaid expenses become current assets. Property, equipment and accumulated depreciation net into fixed assets. Payables, credit cards, accrued liabilities and the current portion of any loan become current liabilities, with the remainder of the loan sitting below in long-term debt. Owner contributions, distributions and retained earnings form equity. Revenue and expense accounts drop into the income statement, and the net income that falls out of it has to arrive back on the balance sheet as the movement in retained earnings.

Two checks catch most of what goes wrong, and almost nobody runs them by hand because both require footing the whole file. First, total debits must equal total credits across the export, which flags a truncated download or a partially pasted range before you lose an afternoon to it. This matters more with the general ledger than with the trial balance, because ledger exports are long enough to be cut off by a row limit without anyone noticing. Second, net income computed from the income statement accounts has to equal the change in retained earnings plus distributions on the balance sheet. When those two disagree, something is on the wrong statement, and the size of the gap usually tells you what. AIStatements runs both and reports the difference and the likely cause rather than plugging it, because a plug hides a ledger problem instead of fixing one.

The cash flow statement is the part that cannot be produced from a single export at all. The indirect method begins at net income and adjusts for non-cash items and for the movement in every working capital account, so it needs the current period and the prior period side by side. Run the general ledger for both periods, or supply the prior close, and the statement falls out of the comparison. That is the loop that gets genuinely painful in Excel and it is why the cash flow statement generator takes both periods at once. For teams happy to work from the finished QuickBooks reports rather than the ledger, QuickBooks financial statements covers that route, and the balance-sheet-specific version is on QuickBooks balance sheet.

Ledger checks worth running before a statement pack leaves the building

The general ledger is the only report that shows you why a balance is what it is, so it is the right place to run the review rather than the balance sheet. Scan Opening Balance Equity first: it should be empty once file setup is finished, and any balance there is unexplained residue from how the file was created. Look at Undeposited Funds and check that everything in it is genuinely in transit at the report date, because a stale balance normally means payments were recorded twice and cash is overstated, which our note on undeposited funds in QuickBooks works through. Uncategorized Asset, Uncategorized Income and Ask My Accountant are parking lots somebody meant to empty. Accumulated Depreciation with no entries all year means depreciation was never booked, so assets and equity are both overstated.

Then tie the subledgers, and tie them to the ledger rather than to the balance sheet, because the ledger is the version with nothing rolled up. The A/R Aging Summary total has to equal Accounts Receivable, the A/P Aging Summary has to equal Accounts Payable, the Inventory Valuation Summary has to equal Inventory Asset, and the Sales Tax Liability report has to equal sales tax payable. Reconcile every bank and credit card account through the as-of date rather than through whenever the last reconciliation happened. Check each loan against the lender amortization schedule, since posting the whole payment to principal understates interest expense and overstates how fast the debt is clearing. The ordered version of this, arranged to catch problems during close rather than in front of a lender, is our general ledger reconciliation process and the month-end close checklist.

Two QuickBooks-specific items deserve a direct look in the ledger every month. Retained Earnings in QuickBooks Online is calculated rather than posted, so editing a prior-year transaction silently rewrites a figure you may already have given someone; the ordered list of causes is in why QuickBooks retained earnings is incorrect. And journal entries posted directly to control accounts such as Accounts Receivable or Inventory Asset will not appear in the matching subledger report, which is the usual reason an aging summary and the ledger disagree by a round number. The general ledger shows those entries plainly, with a JE transaction type, which is exactly why the review belongs here.

Who runs this loop, and what AIStatements adds on top of the QuickBooks report

Three groups do this every month. Bookkeepers closing several QuickBooks files who need each client to receive a consistent, presentable pack rather than three raw QuickBooks printouts. CPA firms on preparation or compilation engagements, where the ledger is the standard supporting artifact and the deliverable has to meet a firm format; that workflow is set out on financial statement compilation software. And controllers at a single company producing a board or lender pack on a deadline, who would rather not own a spreadsheet model that breaks whenever a new account appears in the chart of accounts.

What we add is the layer after the report. Upload the general ledger export, or connect QuickBooks directly, and AIStatements foots every account, maps each one to a statement line, builds the ruled subtotals, produces all three statements, and verifies both that debits equal credits and that net income ties to the movement in equity before it shows you anything. The figures stay deterministic because they are computed from your ledger; the AI writes only the narrative, and it cites the numbers it is describing. A finished pack takes around 60 seconds. Export to PDF for the recipient and XLSX for anyone who wants to trace a figure back to a transaction. Firms that track profitability by department or property will usually be running the ledger with a class or location filter, and the reporting consequences of that are covered in QuickBooks profit and loss by class.

Two honest boundaries. We integrate with QuickBooks, we are not QuickBooks, we are not affiliated with Intuit, and nothing here replaces your ledger. QuickBooks remains the system of record and we are the reporting layer on top of it. And AIStatements is software that formats and analyzes data you already have. It is not accounting, audit or tax advice, it is not a CPA, and it does not certify GAAP compliance, so have a licensed professional review anything you file or send to a lender. To see the output shape before uploading a client file, the balance sheet generator and the profit and loss generator both run from a sample company. Firms doing this across a roster should start at financial reporting software for accounting firms.

Common questions