# How to Balance a Trial Balance That Doesn't Balance

> How to balance a trial balance when debits and credits don't agree: what goes on it, six checks in order, the divide-by-9 trick and where AI helps.

Source: https://learn.ynteractive.com/content/blog/how-to-balance-a-trial-balance · Updated 2026-10-21 · Free from Stepthrough (https://learn.ynteractive.com)

Quick answer

To balance a [trial balance](https://learn.ynteractive.com/content/glossary/trial-balance), re-add the debit and credit columns, find the difference, then trace its cause: a one-sided entry, a balance on the wrong side, transposed digits or a missing account. Search for the difference, half of it, and check whether it divides by 9. The free [P&L analysis lesson](https://learn.ynteractive.com/content/chatgpt-analyze-client-pl-export-accounting) practices checking exports.

Last updated October 21, 2026

[Take the free module →](https://learn.ynteractive.com/courses/ai-for-accounting-firms/7)Module 7 of the free [AI for Accounting & Bookkeeping Firms](https://learn.ynteractive.com/courses/ai-for-accounting-firms) course, about 11 minutes. No account needed.

By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 21, 2026 · Updated October 21, 2026 · 5 min read

Accounting · Bookkeeping · ChatGPT

This guide is for bookkeepers, staff accountants and owners who keep their own books. It covers what goes on a trial balance, the checks to run in order, and the errors a balanced trial balance still hides.

## What goes on a trial balance?

Every account in the [general ledger](https://learn.ynteractive.com/content/glossary/general-ledger) with a balance on the report date: assets, liabilities, equity, income and expenses. Each account appears once, with its balance in the debit column or the credit column. Assets and expenses normally carry debit balances. Liabilities, equity and income normally carry credit balances. Total debits should equal total [credits](https://learn.ynteractive.com/content/glossary/ai-credits).

The [trial balance](https://learn.ynteractive.com/content/glossary/trial-balance) glossary entry has a full example for a small studio, and the [chart of accounts](https://learn.ynteractive.com/content/glossary/chart-of-accounts) is the list it follows.

## Why doesn't my trial balance balance?

Because something was recorded on only one side, on the wrong side, or with the wrong number. Accounting software usually won't post an entry whose debits and credits differ, so out-of-balance trial balances mostly show up in spreadsheets, manual books, imported balances or a file that was edited by hand. The usual causes:

| Cause | What it looks like |
| --- | --- |
| One-sided entry | The difference equals the amount of one entry |
| Balance on the wrong side | The difference is twice the amount, so half of it is a balance you can find |
| Transposed digits (54 typed as 45) | The difference divides evenly by 9 |
| Slide error (450 typed as 45) | The difference also divides by 9 |
| Missing account | One account's balance never made it onto the report |
| Addition error | The columns were added wrong, often after a manual edit |

## How do I find the error, step by step?

Work from the cheapest check to the slowest. Stop when the totals agree.

1. **Re-add both columns.** Use a calculator or a fresh sum formula, not the total that is already there.
2. **Write down the difference.** Every later check uses it.
3. **Search for the exact amount.** A one-sided entry often equals the difference. Look in the journal for that number.
4. **Halve it and search again.** If an account sits in the wrong column, the difference is twice its balance.
5. **Divide it by 9.** If it divides evenly, look for transposed digits or a misplaced decimal.
6. **Compare with last period.** List each account next to last month's balance. A new account, a missing one or a balance that flipped sides stands out fast.

If none of these works, check the [journal entries](https://learn.ynteractive.com/content/glossary/journal-entry) posted since the last trial balance that did balance, one by one. The error is somewhere in that list.

## Can ChatGPT help find a trial balance error?

Yes, as a fast second pair of eyes on an export, not as the bookkeeper. Upload the trial balance and last month's version, and ask it to list every account whose balance changed sides, appeared, disappeared or changed by more than a set amount, and to check whether the difference divides by 9.

The habit that makes this safe is the one the [P&L analysis lesson](https://learn.ynteractive.com/content/chatgpt-analyze-client-pl-export-accounting) teaches: make ChatGPT check the file before it adds anything up, decide yourself what to do about odd rows, and add the key totals yourself. AI can add wrong, so its arithmetic is a lead to check, not an answer.

## Try it free, step by step

**Analyze a Client's P&L Export with ChatGPT (Accounting & Bookkeeping Firms)**. Upload a client's Profit and Loss Detail export to ChatGPT, catch duplicate bank-feed entries and uncategorized rows first, then get a monthly P&L summary, a chart and three takeaways for the client… You do every step yourself in a practice copy of ChatGPT, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts.

[Start the free lesson](https://learn.ynteractive.com/modules/accounting-pl-analysis)

[Or read the full step-by-step guide](https://learn.ynteractive.com/content/chatgpt-analyze-client-pl-export-accounting)

## Does a balanced trial balance mean the books are right?

No. It proves debits equal credits, nothing more. These errors leave it in balance:

- An entry left out completely.
- An entry posted to the wrong account on the correct side, such as office supplies booked to rent.
- Two errors of the same size that cancel out.
- A wrong amount entered on both sides of the same entry.

That is why month-end also includes a [bank reconciliation](https://learn.ynteractive.com/content/glossary/bank-reconciliation), which checks the books against an outside record. The free [bank reconciliation lesson](https://learn.ynteractive.com/content/chatgpt-bank-reconciliation-month-end) has ChatGPT match every bank row against the [ledger](https://learn.ynteractive.com/content/glossary/general-ledger) and list the exceptions.

## Key takeaways

- A trial balance lists every general ledger account with its debit or credit balance, and the totals should agree.
- Find the difference first, then search for that amount, half of it, and check whether it divides by 9.
- Compare each account with last period to spot missing, new or flipped balances.
- ChatGPT can flag changes in an export, but add the totals yourself.
- A balanced trial balance can still hide omissions, wrong accounts and offsetting errors.

## Frequently asked questions

**Why does dividing the difference by 9 help?**

Swapping two digits or moving a decimal point always creates a difference that is a multiple of 9. If yours divides evenly by 9, a typing error of that kind is the likely cause.

**What is the difference between an unadjusted and an adjusted trial balance?**

The unadjusted one comes straight from the ledger. The adjusted one is run after month-end entries such as accruals, prepaids and depreciation, and it feeds the financial statements.

**How often should I run a trial balance?**

At least at every month-end close, and before preparing financial statements. Running it after a large batch of manual entries catches errors while they are easy to trace.

**Can I make the trial balance agree with a suspense account?**

Some bookkeepers park an unexplained difference in a temporary suspense account so work can continue, but it has to be cleared before the period is closed. It is a placeholder, not a fix.

## Where can I go next?

For the rest of the month-end routine, see the [closing the books](https://learn.ynteractive.com/content/glossary/closing-the-books) and [reconciling item](https://learn.ynteractive.com/content/glossary/reconciling-item) entries.

## Free lessons in this post

- [Analyze a Client's P&L Export with ChatGPT (Accounting & Bookkeeping Firms)](https://learn.ynteractive.com/content/chatgpt-analyze-client-pl-export-accounting): Upload a client's Profit and Loss Detail export to ChatGPT, catch duplicate bank-feed entries and uncategorized rows first, then get a monthly P&L summary, a chart and…
- [Month-End Bank Reconciliation with ChatGPT: 20 Minutes, Not 3 Hours](https://learn.ynteractive.com/content/chatgpt-bank-reconciliation-month-end): Upload the bank statement and the books, let ChatGPT match every row and list the exceptions, then check the answer and paste a reconciliation summary into the…

## Watch it in a free lesson: Turn a Client Meeting into Action Items and a Follow-Up Email (Accounting Firms)

### A client meeting in, a clear recap out with ChatGPT

Full walkthrough · 3:04 · with captions

Turn the transcript of a client's quarterly review into the decisions, an action items table with owners and due dates, and a follow-up email to the client.

[Watch it with chapters and the full transcript](https://learn.ynteractive.com/content/chatgpt-client-meeting-recap-accounting-firm#watch)

From the free lesson [Turn a Client Meeting into Action Items and a Follow-Up Email (Accounting Firms)](https://learn.ynteractive.com/content/chatgpt-client-meeting-recap-accounting-firm)

## Related terms

Plain-English definitions, each with an example from a free lesson.

[Trial balance](https://learn.ynteractive.com/content/glossary/trial-balance) · [AI credits](https://learn.ynteractive.com/content/glossary/ai-credits) · [General ledger](https://learn.ynteractive.com/content/glossary/general-ledger) · [Bank feed](https://learn.ynteractive.com/content/glossary/bank-feed) · [Bank reconciliation](https://learn.ynteractive.com/content/glossary/bank-reconciliation) · [CSV](https://learn.ynteractive.com/content/glossary/csv) · [Executive summary](https://learn.ynteractive.com/content/glossary/executive-summary) · [Gross margin](https://learn.ynteractive.com/content/glossary/gross-margin)

[The full AI glossary](https://learn.ynteractive.com/content/glossary)

## Related prompts

- [Bank reconciliation exceptions memo prompt](https://learn.ynteractive.com/content/prompts/bank-reconciliation-exceptions-memo-prompt): A copy-ready prompt that turns a reconciliation's exception list into a short memo for the owner: what each row is, the fix, and…
- [Monthly cost share review brief prompt](https://learn.ynteractive.com/content/prompts/monthly-cost-share-review-brief-prompt): A copy-ready prompt that turns a client's monthly P&L totals into a one-page review brief: cost shares, what changed and three…
- [P&L export check before analysis prompt](https://learn.ynteractive.com/content/prompts/pl-export-check-before-analysis-prompt): A copy-ready prompt that makes ChatGPT check a client's P&L detail export for duplicates and blank accounts before it adds up a…
- [Timesheet summary prompt](https://learn.ynteractive.com/content/prompts/timesheet-summary-prompt): A ChatGPT prompt that turns a timesheet export into a summary: hours by person and project, missing days, unusual entries and…

[All free prompt templates](https://learn.ynteractive.com/content/prompts)

## Visual guide

The same ideas as quick visual guides: swipe through the slides, or read each one as text.

- [Bank Reconciliation with ChatGPT in 5 Steps](https://learn.ynteractive.com/content/visual/ladder-bank-reconciliation): A step-ladder guide: upload a bank CSV and a ledger CSV to ChatGPT, list the exceptions, and check the math yourself, in 5 steps.

[All visual guides](https://learn.ynteractive.com/content/visual)

## Keep reading

- [How to Use ChatGPT for Accounting (Step by Step, 2026)](https://learn.ynteractive.com/content/blog/how-to-use-chatgpt-for-accounting): How to use ChatGPT for accounting: 5 tested jobs (bank recs, overdue invoices, P&L reviews, recaps, client emails), what never to paste, how to check it.
- [How to Add AI to Finance Workflows Without Rebuilding](https://learn.ynteractive.com/content/blog/how-to-add-ai-to-finance-workflows): The most effective ways to add AI to existing finance workflows: start with exports, add one AI step to the inbox you have, and keep people on approvals.
- [ChatGPT Bank Reconciliation Mistakes to Avoid](https://learn.ynteractive.com/content/blog/chatgpt-bank-reconciliation-mistakes): Eight mistakes bookkeepers make reconciling a bank statement with ChatGPT, from "reconcile this" with no balances to trusting its math, and fixes.

[All blog posts](https://learn.ynteractive.com/content/blog) · [All free tutorials](https://learn.ynteractive.com/content)
