What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Trial Balance in QuickBooks
QuickBooks reports

What Is a Trial Balance in QuickBooks? Every Account, Two Columns, One Check

A trial balance lists every account in your books with its balance on one date, debit balances in one column and credit balances in the other. The two column totals should be equal. In QuickBooks Online it's a standard report: open Reports, search for Trial Balance, set the date and run it. Accountants ask for it before year-end because it puts the whole ledger on a single page.

Where the report is

QuickBooks Online: search the Reports page for Trial Balance, choose the report period, then Run report.

Reports Search: Trial Balance Run report

QuickBooks Desktop: it's in the Accountant & Taxes group of the Reports menu.

Reports Accountant & Taxes Trial Balance

What to look at first: the TOTAL row at the bottom. The debit and credit totals should be the same figure, to the cent.

A small trial balance, added up on both sides

Each account carries its balance in one column only. Assets and expenses normally sit on the debit side. Liabilities, equity and income normally sit on the credit side.

Example figures, as of December 31
Checking (debit) $18,400
Accounts Receivable (debit) $6,250
Equipment (debit) $12,000
Cost of goods sold (debit) $41,300
Rent expense (debit) $14,400
Total debits $92,350
Accounts Payable (credit) $4,900
Loan payable (credit) $9,000
Owner's equity (credit) $7,450
Sales (credit) $71,000
Total credits $92,350

Matching totals prove the books are even, not that they're right. A sale posted to the wrong income account still balances. That's why accountants read the account lines, not just the bottom row.

Running it for the date your accountant asked for

  1. 1

    Open the report

    Reports Search: Trial Balance

    There's nothing to set up or build. The report reads your chart of accounts and every transaction already posted, each time you run it.

  2. 2

    Set the report period

    A trial balance is a snapshot, so the end date is the one that counts. For a year-end request, use the last day of your fiscal year. Last year's trial balance is simply the same report with last year's date.

    Watch for: Which accounting method it runs on. Cash and accrual give different balances for receivables, payables, income and expenses, so run it on the basis your accountant files on.

  3. 3

    Run it and read the bottom row

    Equal totals mean every transaction in the period was posted with matching debits and credits. In QuickBooks Online that's almost always the case.

  4. 4

    Click into any balance that looks odd

    Click a figure to open the transactions behind it. A balance on the unexpected side, like a credit in Checking or a debit in Sales, deserves a look before anything goes out. If it needs correcting, a journal entry is usually how your accountant will want it done.

  5. 5

    Print it or export it

    Use the printer icon at the top of the report for paper or a PDF, or Export to Excel if your accountant wants to work in it. Sending it before you close the books saves a second round of questions.

Trial balance or balance sheet: same ledger, different readers

Trial balance

Proves the books are even

  • Every account, income and expense accounts included.
  • Raw debit and credit columns, with no subtotals for current assets or long-term debt.
  • Read by you and your accountant, mostly at close and year-end.
Balance sheet

Shows what the business owns and owes

  • Assets, liabilities and equity only. This year's profit appears as one net income line inside equity.
  • Laid out as a financial statement, grouped and subtotaled.
  • Sent to lenders, investors and anyone checking the financial position.

Both come from the same ledger, so a trial balance that ties out means the balance sheet balances too. Creating a balance sheet covers that report.

Printing, adjusting entries and the out-of-balance case

How do I print a trial balance in QuickBooks Online or Desktop?

Run the report, then use the printer icon at the top of it, or export to PDF for a cleaner copy. In Desktop the report window has its own Print button. There's no separate printable version to hunt for.

How do I create or generate a trial balance in QuickBooks myself?

You don't build it by hand. QuickBooks generates it from what's already in your books every time the report runs, so choosing the date is the whole job. If a figure on it is wrong, the fix belongs in the transaction behind it, not on the report.

Is a trial balance the same thing as a balance sheet in QuickBooks?

No. A trial balance lists every account with a debit or credit balance to show the books are even. A balance sheet shows only assets, liabilities and equity, formatted as a statement for people outside the business.

Why would a trial balance not balance in QuickBooks?

QuickBooks Online won't save a journal entry whose debits and credits differ, so a mismatch is rare there. If it only shows up on the cash basis, rerun it on accrual and compare before assuming anything's broken. In Desktop, a damaged company file is the usual suspect: run File > Utilities > Verify Data, then Rebuild Data if Verify finds problems.

What is an adjusted trial balance?

It's the trial balance once the accountant's adjusting entries for the period, such as depreciation or accruals, have gone in. The accountant editions of QuickBooks include an Adjusted Trial Balance report that shows the before, the adjustments and the after. If you're the business owner, the regular report run after those entries post generally shows the adjusted figures.

We run three QuickBooks companies. Can we get one trial balance across them?

Not from the regular QuickBooks Online plans. Each company is its own set of books with its own report, and multi-entity reporting is part of Intuit Enterprise Suite. n-frames builds the pull that reads each company's trial balance through the QuickBooks Online reporting API, maps the account names onto one list and lays the companies side by side with a combined total, so month-end stops being a copy-and-paste job.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.