General ledger template

One sheet per account: every posting in date order and the balance after each. The closing balance agrees to the bank statement and the trial balance.

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.

General Ledger

Account
1110 — Bank: Riyad Bank current account
Period
October 2026
Opening balance
25,000.00
DateReferenceDescriptionDebitCreditBalance
2026-10-01RV-0215Receipt — Golden Customer Co.7,665.0032,665.00
2026-10-05PV-0098Payment — Gulf Supplies LLC11,385.0021,280.00
2026-10-28PR-10Payroll — October18,200.003,080.00
Total7,665.0029,585.00

One sheet per account: every posting in date order and the running balance. The closing balance agrees to the trial balance.

One account, every posting, the balance after each

The general ledger (دفتر الأستاذ العام) is the book of accounts: one sheet per account, every entry posted to it in date order, and the running balance. The sample is a bank account for one month: an opening balance, a receipt, a payment, the payroll, and the closing balance that must agree to the bank statement on one side and the trial balance on the other.

  • The account code and name, and the period.
  • The opening balance, which is the previous period's closing balance.
  • Per line: date, reference (the voucher, invoice or journal number), description, debit, credit, balance.
  • Totals of the debits and credits for the period, and the closing balance.

Reading the sample

The bank opens at 25,000.00. A customer's payment of 7,665.00 is a debit (money in). A supplier payment of 11,385.00 and the October payroll of 18,200.00 are credits (money out). The account closes at 3,080.00, which is the bank balance on the trial balance.

Opening balance25,000.00
RV-0215 receipt+7,665.00 → 32,665.00
PV-0098 payment−11,385.00 → 21,280.00
PR-10 payroll−18,200.00 → 3,080.00

Keeping the books

ZATCA requires VAT records, invoices and the books behind them to be kept for at least six years after the end of the tax year, longer for capital assets, in Arabic or with an Arabic translation available, and accessible in the Kingdom. A ledger kept in a spreadsheet meets the letter of this; a ledger kept in an accounting system posts itself from the documents and cannot be edited after the fact, which is what an auditor and a tax inspector look for.

Questions

What is the difference between the journal and the ledger?

The journal records transactions in the order they happen, each as a complete entry with its debits and credits. The ledger reorganises the same entries by account, so each account's balance can be read. Every ledger line came from a journal entry.

How is a debit balance different from a credit balance?

Assets and expenses normally carry debit balances; liabilities, equity and income carry credit balances. A bank account with a credit balance is an overdraft; a customer with a credit balance has overpaid.

Do I need a ledger if I use accounting software?

The software is the ledger. What you need is to be able to print or export any account for any period, with every posting traceable to its document, and to keep that for six years.

Must the books be in Arabic?

The zakat and tax rules require records to be kept in Arabic, or to be translatable on request; ZATCA may ask for an Arabic version. The templates here are produced in Arabic and English for that reason.

Your first compliant invoice is minutes away

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