How to use the trial balance checker
- Add a row for each account with its name.
- Enter the account's balance in the debit column or the credit column. A line holds one or the other, not both.
- Add rows until every account in the ledger is listed.
- Read whether debits equal credits and, if not, the difference and the hints about common causes.
Formula
total debits = sum of the debit balances
total credits = sum of the credit balances
difference = total debits - total credits
Amounts are added in whole cents so the totals are exact. A difference of zero means the two sides agree. It does not prove that the books are right.
A small set of books that balances
Cash of $5,200, accounts receivable of $2,400, equipment of $8,000 and rent expense of $1,800 are debits that add up to $17,400.00. Accounts payable of $1,900, owner capital of $9,000 and service revenue of $6,500 are credits that also add up to $17,400.00, so the difference is $0.00 and the trial balance is in balance.
If a $900 debit for supplies is posted as a credit, the debits drop to $5,000 and the credits rise to $6,800, a difference of ($1,800.00). Half of that, $900.00, is the amount on Supplies, and the page points to it as a possible entry on the wrong side.
What a trial balance proves
Double entry bookkeeping records every transaction as equal debits and credits. A trial balance lists the balance of each account at one date and totals the two sides. If the sides differ, at least one entry was recorded wrongly, and the difference is where to start looking.
If they agree, the arithmetic is consistent, and no more. An amount posted to the wrong account, an entry recorded twice on both sides, or a transaction left out completely would not show up, because each of those keeps the sides equal. Treat a balanced trial balance as a first check, followed by your usual reviews.
Finding a difference
Some patterns point to the cause. A difference that divides evenly by 9 often means two digits were swapped or a decimal point slipped. A difference that is exactly twice an amount on the list suggests that entry was posted on the wrong side. A difference that equals an amount on the list suggests the matching entry is missing or an account was left off the trial balance. The page checks for these and names the accounts.
Those are hints, not answers. Compare each account with its ledger page, and check that every account with a balance is listed. The General Ledger Template keeps the account pages, the Chart of Accounts Template lists the accounts, and the Journal Entry Generator writes the correcting entry. To check cash against the bank, use the Bank Reconciliation Template.
Assumptions and limits
- Each line has a debit or a credit, in dollars and cents with no more than two decimals. Negative amounts are not accepted.
- At least two accounts are needed. Blank rows are ignored.
- The hints are patterns, not proof. A balanced result does not show that the accounts are correct.
- Nothing is stored or uploaded. This is a working check, not an accounting record or advice.
Frequently asked questions
What does it mean if the trial balance does not balance?
Total debits and total credits differ, so some entry was recorded wrongly or an account is missing. The difference tells you the size of the error and the hints suggest common causes.
Why is a difference divisible by 9 a clue?
When two digits are swapped, such as 540 posted as 450, the difference is always a multiple of 9. A slipped decimal point has the same effect. It is a hint to check for those errors.
Does a balanced trial balance mean my books are correct?
No. It only shows the debits equal the credits. Amounts in the wrong account, duplicated entries and missing transactions can all leave the totals equal.
How do I handle an account with a negative balance?
Put it on the side that fits its nature: a normal debit balance goes in the debit column, and a balance that is reversed goes in the credit column. The page does not accept negative numbers.