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.
QuickBooks Online: search the Reports page for Trial Balance, choose the report period, then Run report.
Reports › Search: Trial Balance › Run reportQuickBooks Desktop: it's in the Accountant & Taxes group of the Reports menu.
Reports › Accountant & Taxes › Trial BalanceWhat 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.
| 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
Open the report
Reports › Search: Trial BalanceThere'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
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
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
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
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
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.
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.