A Trial Balance that doesn't balance is one of the most alarming things you can find in QuickBooks Online. Your debits and credits should always be equal — that's the foundation of double-entry bookkeeping. When they're not, something is fundamentally wrong with your books.
The good news: this issue is almost always fixable. The bad news: finding the cause takes some digging. Here's how to understand what's happening and what to do about it.
A Trial Balance is a report that lists every account in your Chart of Accounts along with its current balance, split into two columns: debits and credits. The total of all debits should always equal the total of all credits — to the penny.
This is the mathematical foundation of accounting. Every transaction entered in double-entry bookkeeping has matching debits and credits, so when you add them all up, the totals must be equal. If your Trial Balance shows debits ≠ credits, one or more transactions were entered in a way that broke that balance.
A Trial Balance that doesn't balance means:
Your financial statements are unreliable. Your Profit & Loss, Balance Sheet, and every report you run is built on this underlying data. If the foundation is broken, everything on top of it is wrong.
Tax filings may be inaccurate. Your accountant can't prepare accurate taxes from unbalanced books — and if they don't catch it, the numbers on your return may be wrong.
You can't trust any of your numbers. Cash balances, net income, equity — all of it becomes questionable when the Trial Balance doesn't balance.
It often signals a data integrity problem. QBO is designed to enforce double-entry automatically. A genuine imbalance usually means something unusual happened to your data — an import error, a third-party integration pushing bad data, or a sync bug.
This is a fair question. QBO is supposed to prevent unbalanced entries — when you record a normal transaction through the interface, it should always be balanced.
But a Trial Balance imbalance can still happen through:
Third-party app integrations that push data directly into QBO via API without following double-entry rules. E-commerce sync tools, POS systems, and payroll apps are common culprits.
Data imports — CSV or other file imports that brought in transactions where debits and credits didn't match.
Data corruption or sync errors. Rare, but it happens. Sometimes a QBO update or a sync failure leaves a transaction in a broken state.
Manual journal entries where someone typed mismatched debit/credit amounts and QBO let it through.
If you connected a new third-party app or ran a large import recently, start there.
Look at the Total row at the bottom. The Debit total and Credit total must match exactly. If they don't, note the dollar amount of the difference and the date range — these are your starting clues.
Run the Trial Balance for different periods — this month, last month, last quarter, this year — to narrow down when the imbalance first appeared. If the books were balanced at year-end last year but aren't now, the culprit is somewhere in the current year.
Go to Settings (gear icon) → Audit Log. This shows a record of every change made to your QBO file, including imports, deletions, and API activity.
Look for:
Go to Reports → Journal and look through manually entered journal entries. Check each one: do the debit and credit columns add up to the same number? An incorrectly entered journal entry — where debits and credits don't match — is one of the most common causes.
If you connected a new app to QBO around the time the imbalance appeared, that app is a prime suspect. Common offenders include e-commerce platforms, POS systems, payroll apps, and inventory management tools. Contact the app's support and ask whether there are known data sync issues with QBO.
If you can't find the source after the steps above, contact QBO Support directly. They have backend tools that can identify corrupted data or broken transactions that aren't visible from the standard interface. Request that they review the data integrity of your file.
Sometimes. If you can trace the imbalance to a specific manual journal entry where the debits and credits don't match, you can simply correct the entry.
If the source is a third-party app import, you may be able to delete the problematic batch and re-import it correctly.
However, if the imbalance is large, old, or can't be traced to a specific transaction, don't try to fix it with a balancing journal entry. That approach hides the problem rather than solving it — and can create compounding errors that are much harder to unravel later.
In that case, bring in a bookkeeper or accountant who can trace the imbalance to its source before making any corrections.
Vet third-party apps before connecting them. Before linking any app to your QBO account, check user reviews specifically for data sync issues or accounting errors. This is the most common cause of genuine Trial Balance imbalances.
Run a Trial Balance before and after large imports. If you're importing a significant batch of transactions, take a snapshot of your Trial Balance totals first so you can confirm nothing changed afterward.
Reconcile monthly. Regular bank reconciliation catches data errors before they multiply. An imbalanced Trial Balance usually surfaces during reconciliation long before it becomes a serious problem.
Check your Trial Balance quarterly. Make it a standing item on your month-end or quarter-end checklist. It takes 30 seconds to run and confirm the totals match.
A Trial Balance imbalance is often connected to recording errors in QuickBooks Online — things like incorrectly entered journal entries, data pushed by third-party apps without proper double-entry, or import errors that created unbalanced transactions. BooksCheckup checks for common recording problems like these and gives you a free Health Score in seconds.
Check your books at BooksCheckup.com →
If recording errors show up in your Health Score, the Fix Guide ($49) explains each one and walks through suggested corrections in priority order.
This article is for educational purposes and does not constitute accounting, tax, or legal advice. For guidance on your specific situation, consult a qualified bookkeeper, CPA, or tax professional.
Upload your QuickBooks Online reports and find out in seconds — free.
Check My Books Free →