Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets
Ledger Format (Excel & PDF) — Running Balance & T-Format
A general ledger account with date, particulars, voucher, debit, credit and a running Dr/Cr balance, and a traditional T-format account on a second sheet.
Opens in your browser. No Excel needed, no signup.
Free for personal and commercial use · No watermark · Updated November 2026
Guide
About this ledger template
A ledger is the book of accounts where every journal entry is posted to its account, such as cash, sales, rent or a customer, so you can see each account's balance. This template has two ledger formats. The first sheet is the modern running-balance format used by accounting software: date, particulars, voucher number, debit and credit, with a balance that updates after every entry and shows Dr or Cr automatically. The second sheet is the traditional T-format taught in school and college accounting, with debit entries ("To …") on the left, credit entries ("By …") on the right, and the balance carried down.
How to post a ledger account
- 1
Click "Edit online", or download the Excel file.
- 2
Enter the account name, code, period and opening balance (a credit balance as a negative number).
- 3
Post each journal entry on its own line as a debit or a credit, with the date and voucher number.
- 4
Read the running balance and the closing balance, which update automatically.
- 5
For a T-account, use the second sheet: debits on the left, credits on the right; the balance c/d works itself out.
Tips for keeping ledgers
One account per sheet
Copy the sheet for each account: cash, bank, sales, purchases, each customer and supplier.
To and By
In the T-format, debit entries start with "To" and credit entries with "By", followed by the other account.
Use the folio
The J.F. (journal folio) or voucher column lets you trace each entry back to the journal.
Balance to the trial balance
Closing balances of all ledgers go into the trial balance; debits and credits must agree.
Frequently Asked Questions
Tools that help
Excel to PDF
Convert Excel spreadsheets to PDF with all sheets preserved
PDF to Excel
Extract tables from PDF into editable Excel spreadsheets
Percentage Calculator
Calculate percentages, increase, decrease, and ratios
GST / Tax Calculator
Calculate GST, VAT, and tax amounts quickly















