Trial Balance Not Balancing? 7 Common Causes and How to Find the Difference With the ÷2 and ÷9 Tests

You total the debit column of your trial balance and get 84,360, the credit column gives 83,820, and a 540 riyal difference refuses to go away no matter how often you add it up again. A trial balance fails to balance because an error changed one column without changing the other by the same amount: an entry posted on one side only, an amount posted to the wrong side, transposed digits, a balance left off the list, an addition mistake, a double posting or a wrong opening balance. The difference itself is your first clue: divide it by 2, then by 9, before you open a single ledger.

That is exactly where Rami found himself. He runs a small bakery and prepares his monthly trial balance in Excel before sending it to his accountant. Amounts in the examples are in Saudi riyals, and the seven causes below each come with a way to detect them, followed by a search order that can save you hours.

What does a balanced trial balance prove?

A trial balance lists every ledger account that has a balance: debit balances in one column, credit balances in the other. Because every correct entry has equal debits and credits, the two columns must total the same. If you are not sure about the entries themselves, start with how to write a journal entry using four questions.

Balance proves one thing: what was posted to the debit side equals what was posted to the credit side. It does not prove that every transaction was recorded, or that every amount sits in the right account. OpenStax's chapter on preparing a trial balance confirms that a trial balance can be mathematically in balance and still contain errors, and it describes both the divide-by-2 and divide-by-9 tests.

Seven common causes and how to detect each one

1. An entry posted on one side only

The debit was posted and the credit forgotten, or the other way around. For example, a 1,200 flour invoice bought on credit was posted to inventory but never to the supplier's account, so the difference is the full 1,200. Look for an entry whose amount equals the difference and check that both sides reached the ledger.

2. An amount posted to the wrong side

When a credit amount is posted as a debit, one column goes up by that amount and the other goes down by the same amount, so the difference is double the amount. That is why you divide the difference by 2 and look for the result. In Rami's trial balance, 540 ÷ 2 = 270, and the debit column is the larger one, so he needs an amount of 270 that appears as a debit but belongs on the credit side.

3. Transposed digits

Did you write 4,830 as 4,380? The difference is 450, and 450 ÷ 9 = 50, a whole number. Swapping two digits always produces a difference divisible by 9, and so does adding or dropping a zero, such as writing 270 as 2,700. When the swapped digits sit next to each other, the result of 50 tells you more: the hundreds and tens places, with digits 5 apart, in this case 8 and 3.

But the test points to a possibility, not a verdict. Rami's own difference is divisible by 9 as well, because 540 ÷ 9 = 60, so do not stop at the first test that works; check the candidate amounts from both tests.

4. A balance left off the list

A whole account was skipped when balances were copied into the trial balance, so the difference equals that account's balance. If the difference is 3,150, for example, look in the ledger for an account with that balance that is missing from the trial balance. Comparing the number of accounts in the trial balance with the number in the ledger catches this quickly.

5. An addition error

The balances may all be correct while the column total is wrong, or an account balance inside the ledger was miscalculated. Round differences such as 10, 100 or 1,000 often point to an addition or carrying error. Re-add the columns using a different method from the first time, and in Excel check that the SUM range covers every row.

6. An entry posted twice on one side

The debit side of an entry was posted twice and the credit side once. The difference equals the amount, as with a one-sided entry, but the clue is different: the same amount appears twice in one account with the same date and description. Duplicates are common in customer payments too, as covered in how to spot a payment recorded twice.

7. A wrong opening balance

If a balance was carried over incorrectly from the previous period, the difference shows up in every trial balance after it, however clean the month's entries are. The telltale sign is that the same difference has been there since the first trial balance of the period. Compare each opening balance with the previous period's closing trial balance, and see the opening balance and partial payments example for how a starting balance carries into everything after it.

Errors a balanced trial balance will not catch

These errors either affect both sides by the same amount or affect neither side, so the trial balance stays in balance:

With the reversed entry, cash and the amount owed to the supplier are both 4,000 higher than they should be. Only counting and reconciling will catch errors like these: counting the cash, matching the supplier's statement and checking each customer's balance with them, as in the step-by-step customer account reconciliation guide.

A step-by-step search order

Start with the quick checks, move on to the detailed ones, and do not change any figure until you know why it is wrong:

1. Re-add both columns and make sure the totals include every account.
2. Work out the difference, divide it by 2 and then by 9, and note both results.
3. Look for an amount equal to the difference, half of it on the wrong side, or a figure with swapped digits.
4. Compare the accounts in the trial balance with those in the ledger, and the opening balances with the previous period's trial balance.
5. Recalculate the balance of every ledger account.
6. Check the posting of each journal entry one by one, starting with the largest amounts.

For Rami, step three settled it: a 270 payment from a customer had been posted to the debit side of the customer's account, as if it were a new sale. After moving it to the credit side, debits became 84,360 − 270 = 84,090 and credits 83,820 + 270 = 84,090, so the trial balance balanced and the customer's balance dropped by 540.

Clean daily balances mean fewer differences

Zawid Accounts does not produce a trial balance or post double-entry journals, but it keeps the records that many differences come from: customer and supplier debts and payments, expenses, and the cash in each treasury account kept separately. When those balances are clear, you or your accountant can match them against the trial balance more easily.

Before closing the month, open the statement of any customer or supplier whose balance you doubt and compare it with their figure in the trial balance, as shown in the guide to reviewing and sharing a PDF statement. Had the payments of Rami's customer been recorded in the app, the 270 would have appeared on the statement as a dated payment, and the comparison would have exposed the difference in that account quickly.