QuickBooks Balance Sheet: Build a Tied, Lender-Ready Balance Sheet From QuickBooks

How to run the balance sheet in QuickBooks, and what each setting quietly changes

In QuickBooks Online the path is Reports, then Standard reports, then Balance Sheet. In Desktop it is Reports, then Company & Financial, then Balance Sheet Standard. The report period sets the as-of date, and this is the setting people get wrong most often: a balance sheet is a snapshot at a single instant, so "last month" means the closing date of last month, not a range. Three other controls matter. The accounting method toggle switches between accrual and cash, and it does not just tweak the numbers, it removes open invoices from receivables and open bills from payables, which shrinks total assets and moves equity. Compare columns add the prior period or prior year beside the current one along with a percent change, which is what turns a static page into something a reader can interpret. And Display columns by lets you split the statement by month, class or location, useful for spotting the exact month a balance went strange.

Run the QuickBooks trial balance next, from Reports in QuickBooks Online or Reports, Accountant & Taxes, Trial Balance in Desktop. The trial balance lists every account with its debit and credit balance in one flat list, balance sheet accounts first, then the profit and loss accounts. It is the fastest cross-check you have: if total debits equal total credits on the trial balance but the balance sheet still refuses to tie, the problem is in how transactions link to each other rather than in a single lopsided entry. The balance sheet template QuickBooks ships with is fixed. You can hide subaccounts, change number formatting and save the customization, but you cannot regroup the asset section, add a working capital subtotal or write commentary next to a line. That gap is the whole reason this page exists, and it applies to the P&L and cash flow report too, which is covered on our QuickBooks financial statements page. If you want the mechanics of how an export becomes a finished pack, how it works walks through it.

Why the QuickBooks balance sheet goes out of balance

An out-of-balance balance sheet means assets no longer equal liabilities plus equity, which is arithmetically impossible in a double-entry ledger, so something in the file is broken rather than merely wrong. Start by running the report on both bases. If it is out of balance on accrual, you are usually looking at damaged data in a Desktop company file, and Verify Data followed by Rebuild Data is the first move. If it only breaks on cash basis, the culprit is almost always a transaction whose links do not resolve cleanly: a credit memo applied to nothing, a discount posted on the wrong side of a payment, returned inventory, a multi-currency transaction, or a journal entry that hits Accounts Receivable or Accounts Payable without a customer or vendor name attached. Intuit's own troubleshooting steps have you widen the report dates to All, then narrow year by year, quarter by quarter, and finally day by day until the day the balance first breaks appears.

QuickBooks Online rarely shows a literally unbalanced report, but it produces the same class of problem in a quieter way. A bank feed match that created a duplicate deposit, a journal entry posted straight into a bank account behind a reconciliation, or a transaction dated outside the period you asked for will all give you a balance sheet that balances perfectly and still describes a company that does not exist. That is more dangerous than a visible error, because nothing on the page warns you. The discipline is the same either way: never plug the difference into a suspense or miscellaneous account to make the page close. A plug does not fix the ledger, it hides the fix. Track the break to a date, then to a transaction. Our month-end close checklist sets out the order to work through so this gets caught in close rather than in front of a lender. AIStatements will not plug either: if your source data does not balance, it shows you the difference and the likely cause.

The cleanup checklist before a QuickBooks balance sheet goes to a bank

Six accounts do most of the damage. Opening Balance Equity should be zero once setup is finished; if it still carries a number, that number is the unexplained residue of how the file was created, and a lender reading it knows exactly what it means. Undeposited Funds should only ever hold payments received but not yet taken to the bank; if it holds months of stale entries, payments were almost certainly recorded twice and cash is overstated, and the four causes plus the fix for each are in our walkthrough of undeposited funds in QuickBooks. Uncategorized Asset and Ask My Accountant are parking lots that were never emptied. Retained Earnings in QuickBooks Online is calculated, not posted, which means editing a prior-year transaction silently rewrites a prior-year balance you already gave someone: compare the current retained earnings figure against the statement you filed last year and reconcile the gap deliberately, working through the six causes of an incorrect retained earnings balance in order. Accumulated Depreciation that has not moved in three years means depreciation was never recorded and your fixed assets are overstated. And a bank account showing a credit balance is not an asset at all, it is an overdraft, and it belongs in liabilities.

Then tie the subledgers. The A/R Aging Summary total must equal Accounts Receivable on the balance sheet, the A/P Aging Summary must equal Accounts Payable, the Inventory Valuation Summary must equal the Inventory Asset account, and the Sales Tax Liability report must equal what the balance sheet says you owe. Reconcile every bank and credit card account through the as-of date, not through "whenever we last did it", because an unreconciled month is the first thing a reviewer will find. Check each loan balance against the lender's amortization schedule; the classic error is booking the whole payment to principal, which understates interest expense on the P&L and overstates how fast the loan is being repaid. That link runs both ways, since net income from your QuickBooks profit and loss statement is what rolls into retained earnings. The full sequence, from raw ledger to a statement someone else can rely on, is in our guide on how to prepare financial statements.

What a QuickBooks balance sheet looks like, and the four things it leaves out

The QuickBooks Online balance sheet prints in a fixed shape: ASSETS with Current Assets first (bank accounts, Accounts Receivable, other current assets), then Fixed Assets and Other Assets, then LIABILITIES AND EQUITY with Current Liabilities, Long-Term Liabilities and Equity, and Total Liabilities and Equity at the bottom matching Total Assets. Every account in your chart of accounts appears under the type it was assigned when it was created, with sub-accounts indented under their parents. QuickBooks Desktop produces the same structure through Reports, Company & Financial, Balance Sheet Standard. That structure is honest and it is also the whole problem: it is a list of your accounts, not a statement written for a reader.

Four things are missing when you compare it to a balance sheet a lender or a buyer expects. There is no split between the current portion of long-term debt and the rest, so a loan due in fourteen months and a payment due next month sit in the same place, and the current ratio computed off that report is wrong. There is no ruled subtotal discipline: the report gives you totals, not the grouped presentation with consistent captions that makes two periods comparable at a glance. There are no ratios, so nothing tells you the debt-to-equity figure the loan officer will calculate in the first thirty seconds. And there is no tie-out to anything, so the report will present a receivables figure that disagrees with your aging summary without comment.

The fifth thing worth knowing is what "balance sheet from QuickBooks" means depending on where you start. Running the report gives you QuickBooks' grouping, already decided. Starting from the underlying data instead leaves the grouping open, which is what you want when the destination is outside the business. The summarized route is the trial balance, covered on QuickBooks trial balance to financial statements, and the detailed route is the ledger itself, covered on QuickBooks general ledger to financial statements. Both produce the same balance sheet; the ledger route is the one that can also answer what is inside each number when somebody asks.

What AIStatements adds on top of the QuickBooks report

Being straight about the boundary: QuickBooks is perfectly good at producing the raw report, and we are not trying to replace your ledger. We are the presentation, tie-check and analysis layer that sits after it. Connect QuickBooks or drop in the export, and AIStatements maps every account into current assets, long-term assets, current liabilities, long-term debt and equity, builds ruled subtotals and comparative columns, and verifies that assets equal liabilities plus equity before it shows you anything. The figures stay deterministic because they are computed from your ledger, and the AI writes only the narrative, citing those numbers. A finished pack takes about 60 seconds, with a median generation time of 42 seconds. Then it computes what a loan officer actually reads: the current ratio, debt-to-equity, and asset quality, meaning how much of the asset side is cash and collectible receivables against inventory, prepaids, goodwill and amounts due from the owner. Each one is stated in plain English, with red flags pinned to the exact line that triggered them. Two schedules sit behind the numbers a reviewer will ask for: the accounts receivable aging report, which has to tie to the receivables line, and the statement of retained earnings, which explains how equity got to where it is.

Bookkeepers running several QuickBooks files get the same treatment per client, white-labelled, which is what the for accounting firms plan is built around. If you want to see the generic version of the statement first, the balance sheet generator builds one from a CSV or a sample company, and the cash flow statement generator produces the companion statement a bank usually asks for immediately after the balance sheet. Export to PDF for the lender and XLSX for anyone who wants to trace a figure back to the ledger. Two honest notes. We integrate with QuickBooks; we are not QuickBooks and we are not affiliated with Intuit. And AIStatements is software that formats and analyzes your data. It is not accounting, audit, tax or investment advice, it is not a CPA, and it does not guarantee GAAP or IFRS compliance. Have a licensed professional review anything you file.

Common questions