A trial balance is a quick snapshot of every account in your general ledger—with its balance—at a single point in time. Most companies pull it at month-end or quarter-end. It’s your first check that total debits match total credits before you hand financial statements to investors, banks, or auditors.
Quick Fix Summary (TL;DR)
Run the trial balance report in your accounting software. In QuickBooks Desktop 2026, go to Reports → Accountant & Taxes → Trial Balance. In QuickBooks Online, hit Accounting → Chart of Accounts → Run Trial Balance. If debits don’t equal credits, click the mismatched amount to see the original entry—fix the amount or account, then re-run the report. When the file is corrupted, restore the last good backup and re-enter only the missing month’s transactions.
What’s Happening
Every transaction you post in the general ledger creates equal debits and credits. Over time, tiny errors creep in—rounding mistakes, typos, deleted invoices, or bank-import glitches. The trial balance is your first warning: it lists every account (Cash, Accounts Receivable, Revenue, etc.) and the net debit or credit balance as of the report date. When the two column totals don’t match, you know something’s wrong before it messes up your income statement or balance sheet.
Step-by-Step Solution
QuickBooks Desktop 2026 (R15 or later)
- Open the file and log in with an “Accountant” role.
- Navigate: Reports → Accountant & Taxes → Trial Balance.
- Pick the date—set it to the last day of the period you’re checking (e.g., 2026-03-31).
- Look at the totals at the bottom. If debits ≠ credits, click “Exceptions Report” to see the exact mismatches.
- Dig into the first mismatch; the software opens the underlying journal entry. Edit the amount or account, then save.
- Re-run the trial balance. Repeat until the two columns match exactly.
QuickBooks Online (as of 2026 Q2)
- Head to Accounting → Chart of Accounts.
- Click “Run Trial Balance” in the top right.
- Set the End Date to the last day of the period.
- If the totals don’t match, click the mismatched amount—you’ll see the original transaction. Fix it and re-save.
- Click “Refresh” to regenerate the report. Keep going until debits = credits.
Xero (2026.3 or later)
- Go to Reports → Accounting → Trial Balance.
- Pick the Report Date and click “Update”.
- When totals are off, export the report to Excel (Export → CSV) and sort by the difference column to spot the problem account fast.
- Jump to Accounting → Journal Entries, find the entry that changed the out-of-balance account, correct the figure, save, and re-run the trial balance.
If This Didn’t Work
- Backup & Restore
If the file is corrupted or the error is untraceable, close the file and restore the most recent backup that did balance. Re-enter only the transactions from the month(s) since the backup. Most accounting software keeps a 30-day rolling backup; QuickBooks Desktop users should have an external copy from their last month-end close.
- Account Reconciliation Audit
Mismatches often hide in uncleared bank or credit-card transactions. Run the Reconciliation Discrepancy Report (QuickBooks Desktop: Reports → Banking → Reconciliation Discrepancy; QuickBooks Online: Gear → Reconciliation → History by Account). Watch for transactions marked as cleared but dated after the reconciliation date—those throw off the next period.
- Third-Party Import Fix
If you use bank-fetch or PayPal imports, turn off auto-import, delete the bad entries, and re-import only the cleared items. Many import glitches create phantom “Split” lines that unbalance the ledger.
Prevention Tips
| Task | Frequency | Tool/Technique |
|---|---|---|
| Reconcile every bank and credit-card account | Within 5 business days of statement close | Banking → Reconcile → Match transactions one-by-one; note any uncleared items |
| Lock the prior period | Monthly, after final reconciliations | Edit → Preferences → Accounting → “Close the books” → Enter password → set “Date to close” to month-end |
| Daily backup + offsite copy | End of each business day | File → Backup → Save to local drive + encrypted cloud (e.g., QuickBooks Hosting Dropbox folder or Xero’s automatic daily backup) |
| Review the Uncategorized Income/Expense accounts | Weekly | Reports → Accountant & Taxes → Uncategorized Transactions; clear items to the correct account before month-end |
| Run a preliminary trial balance 2–3 days before month-end close | 25th–28th of each month | Same path as the final report; catch errors early and avoid eleventh-hour scrambles |
Stick to these steps every month and your books stay balanced—no last-minute chaos required.
