To extract a trial balance, balance every ledger account and list each closing balance in the debit or credit column according to the side it falls on. Then add each column. This is the first step of the end-of-period checks in trial balance and error limits.
The skill appears whenever a question gives you ledger accounts, or a list of balances, and asks you to prepare or complete a trial balance.
How does a ledger account become one line in the trial balance?
Each ledger account holds many entries. The trial balance needs only one figure from each, the difference between the two sides. The bigger side decides the column.
Normal positions help you check yourself. Assets, expenses and drawings normally carry debit balances. Capital, liabilities, sales and other income normally carry credit balances.
How to extract a trial balance, step by step
- Total both sides of each ledger account.
- Subtract the smaller total from the larger to find the balance.
- Note the bigger side: bigger debit side means a debit balance.
- Write the account name and the balance in the matching column.
- Add each column and compare the totals.
Worked example
Kenanga Bicycle Repairs has balanced its ledger. Two accounts are shown in full.
| Bank account | Debit (RM) | Credit (RM) |
|---|---|---|
| Receipts from customers | 6,100 | |
| Receipts from customers | 3,700 | |
| Payments to suppliers | 3,400 | |
| Payments for wages | 2,200 | |
| Totals | 9,800 | 5,600 |
Bank: 9,800 − 5,600 = 4,200. The debit side is larger, so the balance is RM 4,200 debit.
| Trade payables account | Debit (RM) | Credit (RM) |
|---|---|---|
| Payments to suppliers | 2,300 | |
| Credit purchases | 5,200 |
Trade payables: 5,200 − 2,300 = 2,900. The credit side is larger, so the balance is RM 2,900 credit.
The other balances come straight from the ledger. The trial balance is:
| Account | Debit (RM) | Credit (RM) |
|---|---|---|
| Premises | 60,000 | |
| Equipment | 12,000 | |
| Inventory | 5,500 | |
| Trade receivables | 3,800 | |
| Bank | 4,200 | |
| Purchases | 18,400 | |
| Wages | 9,600 | |
| Rent paid | 2,400 | |
| Drawings | 6,000 | |
| Capital | 70,000 | |
| Loan | 20,000 | |
| Trade payables | 2,900 | |
| Sales | 29,000 | |
| Totals | 121,900 | 121,900 |
Check the debit column: 60,000 + 12,000 + 5,500 + 3,800 + 4,200 + 18,400 + 9,600 + 2,400 + 6,000 = 121,900. Check the credit column: 70,000 + 20,000 + 2,900 + 29,000 = 121,900. The columns agree.
The mistake to watch for
A frequent slip is to put a balance in the column where the account “sounds” like it belongs, instead of where the ledger balance actually falls.
Mistaken entry: Trade payables RM 2,900 written in the debit column.
The student thought “payables” is a business item, so it joined the other business items on the debit side. The debit column becomes 124,800 and the credit column 119,000.
The difference is 5,800, which is twice the misplaced 2,900. That pattern is a useful clue: a wrong-column balance makes the totals differ by double its value. The correction is to look at which side of the ledger account was larger, every time.
Check yourself
Try these on paper, then open each answer.
1. Prepare a trial balance from these balances and find the totals. Bank RM 1,800 debit, equipment RM 3,500 debit, purchases RM 2,600 debit, rent RM 700 debit, capital RM 5,000 credit, sales RM 3,100 credit, trade payables RM 500 credit.
Show answer
Debit column: 1,800 + 3,500 + 2,600 + 700 = RM 8,600.
Credit column: 5,000 + 3,100 + 500 = RM 8,600. The columns agree.
2. The debit balances in a trial balance total RM 15,300. The credit balances, except trade payables, total RM 12,900. If the trial balance agrees, what is the trade payables balance?
Show answer
The credit column must also reach 15,300. 15,300 − 12,900 = RM 2,400 credit.
3. A ledger account has debit entries of RM 8,400 and credit entries of RM 5,150. State the balance and the column.
Show answer
8,400 − 5,150 = RM 3,250. The debit side is larger, so it goes in the debit column.
Where this leads next
With the list built, the next question is what the totals can tell you. Continue with identifying errors a trial balance can reveal, then test the whole module with the trial balance practice set. The trial-balance and error detective and the double-entry and ledger trainer let you practise on small fictional ledgers.
Some students balance each account well but lose marks at the column stage under time pressure. A teacher in online one-to-one Accounting tuition can watch how you pick each column and fix that step.