A trial balance that will not tally means your total debits and total credits are not equal. Something was entered once instead of twice, entered on the wrong side, or typed wrongly. The difference itself usually tells you which.
Nothing else can be finished until it balances. The balance sheet and the profit and loss statement are both built from the trial balance, so an out-of-balance figure stops the whole month.
The good news: most differences are found in a couple of minutes, and you do not need to read every line to find them. Start with the four quick tests below, then work down the eight causes in order.
Why does a trial balance not tally?
A trial balance does not tally when total debits do not equal total credits. The usual causes are a one-sided entry, two digits typed in the wrong order, an entry posted to the wrong side, opening balances brought forward incorrectly, a duplicated transaction, or bank charges that were never recorded.
01. Start with the difference: four quick tests
Before you read a single ledger line, take the difference between your two totals and run it through these. The number itself usually names the error.
| Test | What it means | What to look for |
|---|---|---|
| Difference ÷ 9 is a whole number | Almost always a transposed figure | 5,940 keyed as 5,490. Difference 450 ÷ 9 = 50 |
| Difference ÷ 2 is a whole number | An entry on the wrong side | A RM300 debit keyed as a credit shifts the balance by RM600 |
| Difference is a round figure | A whole entry missing, or a total added wrong | Check the column totals before anything else |
| Difference matches one transaction exactly | That entry was posted once, not twice | Search the ledger for the amount |
Worked example. Debits total RM 84,610. Credits total RM 84,160. The difference is RM 450. It divides by 9 exactly (450 ÷ 9 = 50), so look for two digits in the wrong order — and there it is: a purchase of RM 5,940 keyed as RM 5,490.
02. The 8 causes, most common first
1. One-sided entry
The commonest cause by far. A transaction was posted to one account and never to the matching one. Check: search for the difference as an exact amount. Fix: post the missing side.
2. Transposed digits
Two digits swapped while typing — 1,260 entered as 1,620. Check: the ÷9 test above, then scan for figures with the same digits in a different order. Fix: correct the entry itself, rather than adding an adjustment on top of it.
3. Posted to the wrong side
A debit entered as a credit, or the other way round. The trial balance is then out by twice the amount. Check: halve the difference and look for that figure. Fix: reverse it and post it again on the correct side.
4. Opening balances wrong or missing
Last year's closing figures were never brought forward, or only some of them were. This happens often when a business changes accounting systems part-way through the year. Check: compare every opening balance against last year's signed balance sheet, line by line. Fix: correct the opening entries. Worth doing carefully — see how to record opening stock, the line that most often goes in wrong.
5. A transaction entered twice
Duplicates usually come in through imports, or when two people key the same invoice. Check: sort by amount and look for matching pairs. Fix: delete one of them. Do not cancel it with a reversing entry, or you will have three entries to explain later.
6. Bank items never recorded
Charges, standing instructions and bounced cheques are done by the bank, so your books never see them until someone checks the statement. Check: run a proper bank reconciliation — it catches items nothing else will. Fix: record them in the period they belong to.
7. Depreciation or accruals in the wrong section
Accumulated depreciation is a negative inside assets, not a liability. Accrued expenses are a liability. Put either in the wrong section and the totals disagree by exactly that amount.
8. Rounding and part-payments
Sen dropped across many lines, or a part-payment matched to the wrong invoice. Check: if the difference is small and keeps coming back, this is usually it. Fix: find it rather than writing it off. A rounding difference that appears again next month was never rounding.
03. What “tak tally” means
In Malaysian offices you will hear “tak tally” far more often than “does not balance”. It means the same thing: two figures that should match, don't.
| You'll hear | In Malay | It means |
|---|---|---|
| Tally | Seimbang / sepadan | The two totals match. Nothing to fix. |
| Tak tally / tidak tally | Tidak seimbang | The two totals do not match. Find the difference. |
| Trial balance | Imbangan duga | The working list of every account's debit and credit balance |
| Balance sheet | Kunci kira-kira | The finished statement, built once the trial balance tallies |
If you are looking for the Malay terms rather than the fix, the full list is in our guide to the balance sheet in Malay.
04. Find it faster: the order to check in
Working in this order finds most differences without reading the whole ledger.
- Re-add the two columns. A wrong total is the easiest thing to rule out, and it costs ten seconds.
- Run the four difference tests. Nine times out of ten one of them points straight at the entry.
- Compare against last month. If last month tallied, only this month's entries can be at fault — that alone removes most of the ledger from the search.
- Check the accounts you touched most. Sales, purchases and bank carry the most entries, so they carry the most mistakes.
- Check the opening balances last. Rare, but when it is this, nothing else you check will ever find it.
If last month tallied and this month does not, the error is almost certainly in this month's entries. Do not re-check the whole year. Narrow first, then search.
05. When the trial balance tallies but the balance sheet doesn't
This one confuses people, and it is worth understanding, because it means something different.
A trial balance proves only that total debits equal total credits. It does not prove the entries are in the right accounts. So if your trial balance tallies but the balance sheet still will not balance, the arithmetic is fine and the classification is wrong — something is sitting in the wrong section.
The usual culprits are the same ones from cause 7: accumulated depreciation placed with liabilities instead of as a negative inside assets, or an accrued expense recorded as an asset. Both keep debits equal to credits while putting the figure on the wrong half of the balance sheet.
There is also a class of error a trial balance can never catch at all: a payment posted to the wrong customer, or a purchase booked to the wrong expense account. Debits still equal credits, so it tallies perfectly — and it is still wrong.
06. How to stop it happening every month
Every cause on this page except rounding traces back to something a person keyed by hand. So the fix is less checking, not more.
- Reconcile monthly, not annually. An error inside one month of transactions takes minutes to find. The same error inside a year of transactions takes a weekend.
- Close the month and leave it closed. If someone edits a period that already tallied, it will stop tallying and nobody will know when it changed.
- Enter transactions once, at source. Most duplicates come from keying the same invoice in two places.
- Let the software make both sides of the entry. A one-sided entry — the single commonest cause here — cannot be created if the system posts both sides for you.
That last point is the whole difference between doing this in a spreadsheet and doing it in an accounting system. When your invoices, expenses, payments and stock all record into the same set of books, both sides of every entry are made together. There is no missing side to hunt for, because there is no way to create one.
Niagawan Plus is RM497 a year and includes three Niagawan Accounting User IDs, bank reconciliation, AR/AP aging, digital invoicing, automatic tax and zakat reports, and the financial reports — generated from the transactions you have already entered. Prices exclude SST.
We have been building for Malaysian small businesses since 2016, and more than 40,000 businesses have used Niagawan over that time. Our Google rating is 4.7 stars from 500+ reviews.
Bryant Gan is the Founder of Niagawan — the cloud accounting and POS system used by more than 40,000 businesses in Malaysia since 2016. He has spent over 10 years building software that helps Malaysian SMEs keep their books, stock, and tax records in order.
Frequently asked questions
Why is my trial balance not tallying?
Because total debits do not equal total credits. Start with the difference: if it divides exactly by 9 you have typed two digits in the wrong order; if it divides exactly by 2, an entry is on the wrong side; if it matches one transaction exactly, that entry was posted once instead of twice. Beyond those, check for a one-sided entry, opening balances brought forward wrongly, a duplicated transaction, or bank charges never recorded.
What does tak tally mean?
“Tak tally” is what most Malaysian offices say for “does not balance” — tidak seimbang in Malay. It means two figures that should match, don't: usually the debit and credit totals of the trial balance.
What is the divide by 9 rule in accounting?
If the difference in your trial balance divides exactly by 9, you have almost certainly transposed two digits — typing 5,940 as 5,490, for example. The difference of 450 divides by 9. It is the fastest single check there is.
What if the difference divides by 2?
An entry has been posted on the wrong side. A RM300 debit entered as a credit moves the balance by RM600 — twice the amount — so halve the difference and look for that figure in your ledger.
How do I find a one-sided entry?
Search the ledger for the exact amount of the difference. A one-sided entry moves the totals by precisely its own value, so the difference is the amount you are looking for. It is the most common cause of a trial balance not tallying.
My trial balance tallies but my balance sheet does not. Why?
The arithmetic is right but something is in the wrong section. A trial balance only proves debits equal credits — it does not prove entries are in the right accounts. The usual causes are accumulated depreciation placed with liabilities instead of as a negative inside assets, or an accrued expense recorded as an asset.
Can a trial balance tally and still be wrong?
Yes. If a payment is posted to the wrong customer, or a purchase booked to the wrong expense account, debits still equal credits and the trial balance tallies perfectly. Those errors are real, and only a review of the accounts themselves will find them.
What is trial balance in Malay?
Imbangan duga. It is the working list of every account with its debit and credit balance, prepared before the financial statements. The full list of Malay accounting terms is in our guide to the balance sheet in Malay.
Should I write off a small difference?
No. Find it. A difference small enough to ignore this month tends to reappear next month, and by then it is sitting on top of a second one. A genuine rounding difference does not come back.
How do I stop this happening every month?
Reconcile monthly rather than annually, close each period once it tallies and leave it closed, and enter each transaction once at source. Most of all, let the system post both sides of every entry — a one-sided entry cannot be created if the software makes both halves for you.