Trial balance template

Every ledger account's closing balance on one page, debits in one column and credits in the other, totals equal. The bridge from the ledger to the statements.

Excel, Word and PDF, free, in Arabic and English.

Preview with sample figures

The preview is the file as it downloads in this language; the figures are samples to replace with your own.

Trial Balance

Company name
Al Noor Trading Est.
As at
2026-10-31
CodeAccount nameDebitCredit
1110Bank3,080.00
1200Accounts receivable42,000.00
1500Equipment120,000.00
1590Accumulated depreciation30,000.00
2100Accounts payable18,500.00
2300VAT payable6,580.00
3100Capital100,000.00
4100Sales revenue86,000.00
5100Cost of sales41,000.00
5300Salaries32,500.00
5400Depreciation2,500.00
Total241,080.00241,080.00
Total debits
241,080.00 SAR
Total credits
241,080.00 SAR

The closing balance of every ledger account, debits in one column and credits in the other; the two totals must be equal.

Every account's balance on one page

The trial balance (ميزان المراجعة) lists every ledger account with its closing balance, debit balances in one column and credit balances in the other. Because every journal entry debited and credited equal amounts, the two columns must total the same; if they do not, something was posted one-sided. It is the bridge between the ledger and the financial statements: the income statement is built from its income and expense lines, the balance sheet from the rest.

  • The company name and the date ("as at").
  • Per line: account code, account name, debit balance or credit balance.
  • The two totals, equal.

The sample, and what it does not catch

Eleven accounts, totalling 241,080.00 on each side. Equal totals prove the arithmetic, not the accounting: an entry posted to the wrong account, a transaction missed entirely, or two errors that cancel out all leave the trial balance in balance. Review each balance against what you know (does the bank agree to the statement, do receivables agree to the customer list, is VAT payable the figure on the return) before closing.

Assets (1xxx)Debit 165,080.00; credit 30,000.00 accumulated depreciation
Liabilities and capital (2xxx, 3xxx)Credit 125,080.00
Income (4xxx)Credit 86,000.00
Expenses (5xxx)Debit 76,000.00
Totals241,080.00 = 241,080.00

Questions

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

The unadjusted one is pulled before month-end entries; the adjusted one after depreciation, accruals, prepayments and provisions are posted. The statements are prepared from the adjusted one.

What if the totals do not agree?

Find the difference. If it is divisible by nine, two digits were probably transposed. If it equals one entry's amount, that entry was posted one-sided. If it is half an amount, a debit was posted as a credit. Accounting software makes an unbalanced entry impossible, which is the point of using one.

Is the trial balance a financial statement?

No. It is an internal working paper. The income statement and balance sheet are the statements; the trial balance is where they come from and what an auditor asks for first.

How often should I prepare one?

Monthly, after the month-end entries, and before every VAT return so the VAT payable account is reconciled to what is filed. Quarterly at the least.

Your first compliant invoice is minutes away

Start now for free No credit card needed — invoice in minutes