Last updated: 29 October 2026
A ledger is where every account gets its own page: each customer, each supplier, Sales, Purchases, Cash, Bank, Rent, Input GST, Output GST. You record a transaction once, in date order, in the journal or daybook, then post each line to the page of the account it affects. The ledger tells you who owes you, whom you owe and where every account stands.
Where ledgers usually go wrong
- A payment to a supplier always goes on the Debit side of the supplier’s page. Put it on the same side as the bill and the balance grows instead of shrinking. It’s the most common posting error I see.
- Carry every closing balance forward. If March’s closing balance isn’t brought down as April’s opening, every page after it is wrong, and nobody notices until the trial balance refuses to agree.
- Keep Input GST and Output GST as separate accounts, each split into CGST, SGST and IGST. Net them in one “GST” account and there’s no trail to follow the day a return doesn’t match.
- In an Excel running-balance ledger, each row gets a Debit or a Credit, never both, and the opening balance goes in once, not again as a posting row.
- GST-registered? Rule 56(8) says entries must not be erased or overwritten, and electronic records need a log of every edit or deletion. A plain spreadsheet keeps no such log.
Educational information only. This page is general guidance for Indian small businesses, traders, professionals and students. It is not tax, legal or financial advice and it is not a substitute for a chartered accountant or current official sources. Rules and forms change; verify before you file, pay or sign.
Download the ledger format (Excel, Word, PDF)
Excel does the running balance for you; Word is for printing and filling by hand; the PDF is the same packet, fixed. All three carry the Mehra Traders figures used below, so you can practise and check yourself. If you don’t yet have a voucher for each payment, start with our free payment voucher format in Excel, Word and PDF.
Excel: entry and calculations
A running-balance general ledger register, a party (debtor/creditor) ledger sheet, a starter chart of accounts, a filled journal→ledger worked example and a Sources sheet. Download Excel (.xlsx)
Word: editable print layouts
Blank T-account pages, a blank party ledger, worked Sharma Stores / Patel Suppliers examples, running-balance extracts and a review checklist. Word totals are manual. Download Word (.docx)
PDF: printable reference packet
The same packet in a fixed layout for printing or checking the example. It is not an interactive form. Download PDF (.pdf)
To extend the workbook with party-wise totals or a month-end summary, try these ChatGPT prompts for Excel.
Free ScaleSaathi educational templates, not prescribed government forms or a complete accounting system. Mehra Traders, its parties and references are made up. The workbook does not prepare GST returns, does not replace a cash book for counting cash, and is not a multi-user audit trail.
What is a ledger format? (and what it is not)
A ledger (खाता-बही, or general ledger) is the book, on paper or in a spreadsheet, that keeps one account per head. The journal or daybook comes first and records things in the order they happen. The ledger comes second and sorts the same lines by account. That is why textbooks call it the book of final entry.
Whatever the layout, a ledger page must answer three questions on its own:
- What was the opening balance, and was it Debit or Credit?
- What was posted, on which date, and which journal entry, voucher or invoice does each line come from?
- What is the balance now, and on which side (Dr or Cr)?
If a page can’t answer the second question, it isn’t a ledger yet; it is a list of numbers. It is also not a bank statement, a GST return, a stock register or a prescribed government form: Indian law requires certain people to keep books, but publishes no printable “ledger form” for small businesses.
Ledger vs journal vs daybook vs cash book
| Book | Order of entries | Question it answers | Feeds into |
|---|---|---|---|
| Journal | Date order; full double-entry lines (Dr … To Cr …) | What was the complete accounting entry? | Ledger (by posting) |
| Daybook | Date order; book of original entry (sales, purchase or cash daybooks, or one combined daybook) | What happened today, in order? | Ledger (by posting lines or totals) |
| Cash book | Date order; cash and/or bank receipts and payments | How much cash or bank moved, and what is left? | Often both a book of original entry and the cash/bank ledger page. See cash book format |
| Ledger | By account (one page per account or party) | Where does this account or party stand? | Trial balance, then financial statements |
The cash book does not replace party or GST ledgers. If you need to write the journal side first, our journal entry format has blank Excel, Word and PDF layouts with more than 20 Indian examples.
Columns that make a ledger useful
Traditional T-account (Dr / Cr)
The classic “T” puts Debit on the left and Credit on the right. Each side has the same four columns:
| Column | Purpose |
|---|---|
| Date | Order of entries within this account |
| Particulars | The other account in the entry, written as “To Sales” on the debit side or “By Bank” on the credit side |
| J.F. / L.F. | Journal folio or page number, so you can trace the line back to the original entry |
| Amount ₹ | The rupee amount on that side |
At the end of the period you total both sides, write the difference on the smaller side as “balance c/d” (carried down), and bring it back on the opposite side as “balance b/d” (brought down) to open the next period. This is the Date–Particulars–J.F.–Amount form taught in the NCERT Class 11 Accountancy chapter “Recording of Transactions-I”, where journal entries are posted to ledger accounts. Best for learning and printed party statements; clumsy in Excel.
The step people skip is carrying forward. If March’s closing balance is not brought down as April’s opening, every page after it is wrong, and nobody notices until the trial balance refuses to agree.
Excel-style running balance
Most offices now keep one row per posting line and let a formula work out the balance:
| Column | Purpose |
|---|---|
| Date | Posting date |
| Ref / J.F. | Voucher, invoice, UPI or cheque reference |
| Account / Party | Which ledger this row belongs to (so you can filter by account) |
| Particulars | Why the balance moved |
| Debit ₹ | Amount if this account is debited |
| Credit ₹ | Amount if this account is credited |
| Balance ₹ | Running balance after this row, as a positive number |
| Dr/Cr | Which side the balance sits on |
Two rules keep this layout honest. Each row gets a Debit or a Credit, never both. And the opening balance goes into the opening cell once, not again as a posting row. In our Excel “Running Balance” and “Party Ledger” sheets the balance is worked out in green formula cells; don’t type over them.
Journal → ledger: posting walkthrough in ₹
Do it once by hand and posting stops being a mystery. Here is a made-up firm, Mehra Traders, for 1 to 12 September 2026. All sales and purchases are within the same state, so GST at 18% is split as 9% CGST and 9% SGST. The rate is illustrative, not a claim about any HSN code.
Opening balances (1 September)
| Account | Opening | Side |
|---|---|---|
| Cash | ₹15,000 | Dr |
| Bank | ₹40,000 | Dr |
| Sharma Stores (customer / debtor) | ₹8,000 | Dr |
| Patel Suppliers (supplier / creditor) | ₹12,000 | Cr |
Six transactions (journal first)
1 · 2 Sep · Credit sale to Sharma Stores (INV-101)
Taxable ₹20,000 + CGST ₹1,800 + SGST ₹1,800 = ₹23,600
- Dr Sharma Stores ₹23,600
- Cr Sales ₹20,000
- Cr Output CGST ₹1,800
- Cr Output SGST ₹1,800
2 · 4 Sep · Credit purchase from Patel Suppliers (BILL-44)
Taxable ₹10,000 + CGST ₹900 + SGST ₹900 = ₹11,800
- Dr Purchases ₹10,000
- Dr Input CGST ₹900
- Dr Input SGST ₹900
- Cr Patel Suppliers ₹11,800
3 · 6 Sep · Part receipt from Sharma Stores by UPI (RV-01): ₹15,000 into Bank
- Dr Bank ₹15,000
- Cr Sharma Stores ₹15,000
4 · 8 Sep · Part payment to Patel Suppliers by cheque (PV-01 / CHQ-219): ₹8,000 from Bank
- Dr Patel Suppliers ₹8,000
- Cr Bank ₹8,000
5 · 10 Sep · Cash sale (INV-102)
Taxable ₹5,000 + CGST ₹450 + SGST ₹450 = ₹5,900
- Dr Cash ₹5,900
- Cr Sales ₹5,000
- Cr Output CGST ₹450
- Cr Output SGST ₹450
6 · 12 Sep · Shop rent paid in cash: ₹3,000
- Dr Rent ₹3,000
- Cr Cash ₹3,000
Before posting anything, check the journal itself: total Debits = total Credits = ₹67,300. If the journal doesn’t balance, the ledger can’t.
Now post. Here is the Sharma Stores page in running-balance style, which is how you would show it to the customer:
| Date | Ref | Particulars | Debit ₹ | Credit ₹ | Balance ₹ | Dr/Cr |
|---|---|---|---|---|---|---|
| 1 Sep | — | Opening balance | 8,000 | Dr | ||
| 2 Sep | INV-101 | Credit sale | 23,600 | 31,600 | Dr | |
| 6 Sep | RV-01 | UPI receipt (part payment) | 15,000 | 16,600 | Dr |
On the Patel Suppliers page the same logic runs the other way: opening Cr ₹12,000, bill Cr ₹11,800 takes it to Cr ₹23,800, and the cheque goes on the Debit side, bringing it down to Cr ₹15,800. A payment to a supplier always sits on the Debit side of the supplier’s page. That feels backwards to most beginners, and it is the single most common posting error I see: the payment gets put on the same side as the bill, and the supplier balance grows instead of shrinking.
Resulting ledger balances (opening + Dr − Cr)
| Account | Closing | Check |
|---|---|---|
| Sharma Stores | Dr ₹16,600 | 8,000 + 23,600 − 15,000 |
| Patel Suppliers | Cr ₹15,800 | 12,000 + 11,800 − 8,000 |
| Sales | Cr ₹25,000 | 20,000 + 5,000 |
| Bank | Dr ₹47,000 | 40,000 + 15,000 − 8,000 |
| Cash | Dr ₹17,900 | 15,000 + 5,900 − 3,000 |
| Output CGST | Cr ₹2,250 | 1,800 + 450 |
| Output SGST | Cr ₹2,250 | 1,800 + 450 |
| Input CGST | Dr ₹900 | 900 |
| Input SGST | Dr ₹900 | 900 |
| Purchases | Dr ₹10,000 | 10,000 |
| Rent | Dr ₹3,000 | 3,000 |
If you list these balances on their own, debits come to ₹96,300 and credits to ₹45,300. The ₹51,000 gap is not an error. It is the owner’s capital implied by the opening balances (₹63,000 of Dr openings less the ₹12,000 owed to Patel Suppliers). Add Capital Cr ₹51,000 and both sides agree at ₹96,300. When a trial balance won’t agree, a missing opening balance is the first place I look.
Match the bank page to the bank statement every month; our bank reconciliation statement format shows how. Skip that and small differences become a week of digging at year end.
Every line above comes from a document. The sale and purchase lines come from invoices; see GST invoice format. A challan alone is not a sale and never goes into the ledger; see delivery challan format. Purchases often start with a purchase order, and a return that changes a party’s balance usually needs a credit note.
Party ledger (customers / suppliers)
A party ledger is just the ledger page for one customer (debtor) or one supplier (creditor). In most shops this is the khata, and it causes the most arguments.
| Debtor (customer) | Creditor (supplier) | |
|---|---|---|
| Normal balance | Debit (they owe you) | Credit (you owe them) |
| Invoice / bill | Debits the party | Credits the party |
| Money received / paid | Credits the party (receipt) | Debits the party (payment) |
| Statement habit | Send “you owe us ₹…” with invoice and receipt refs | Match supplier bills against your payments |
Useful columns: Date · Doc/Ref · Particulars (invoice number, UPI UTR, cheque number) · Debit ₹ · Credit ₹ · Balance ₹ · Dr/Cr.
Three habits do most of the work. Agree the opening balance with the party before you enter it, once. Put the invoice number against every receipt or payment, even a part payment, so anyone can see which bill is still open. And post a credit note to the party’s page the day you issue it. In the worked example, Sharma Stores closes at Dr ₹16,600 and Patel Suppliers at Cr ₹15,800; both are in the downloads as filled party layouts.
GST input and output ledgers (do not net)
If you are GST-registered, keep separate ledger accounts for the tax you pay on purchases (input) and the tax you charge on sales (output), and split each into CGST, SGST and IGST. The law asks for true and correct accounts, including of input tax credit availed and output tax payable and paid, under section 35 of the CGST Act, with more detail in CGST Rule 56. Neither prescribes ledger columns; separate accounts are simply good practice and make reconciling with GSTR-2B and GSTR-3B possible.
| Account | Normal side | What posts here (example) |
|---|---|---|
| Input CGST / SGST / IGST | Dr | GST on inward supplies (purchases) |
| Output CGST / SGST / IGST | Cr | GST on outward supplies (sales) |
The shortcut I would talk any client out of is a single “GST” account where input and output are netted line by line. The day a return doesn’t match, there is no trail to follow.
In Mehra Traders: Input CGST and SGST are Dr ₹900 each; Output CGST and SGST are Cr ₹2,250 each. See the GST invoice format guide for the invoice details behind these postings.
Daybook format: record today, post to the ledger
A daybook is the book of original entry for the day’s transactions, kept in date order. Larger businesses split it into sales, purchase and cash daybooks. A small shop can keep one combined daybook with date, voucher number, particulars, accounts to debit and credit, taxable value, GST, total and a “Posted” tick.
The routine is: write it in the daybook the same day, post each line (or each day’s total, in bigger set-ups) to the ledger, then tick “Posted”. Without that tick, entries get posted twice or not at all. If an exam question asks for a “daybook format”, this chronological original-entry layout is what it wants, not a bank statement.
Books of account: what Indian law actually says (high level)
This is where most ledger pages overstate things. A template alone makes you compliant with nothing.
Income-tax Act, 2025: section 62 (from tax year 2026-27). Two groups must keep books from which income can be computed. First, anyone in a specified profession: legal, medical, engineering, architectural, accountancy, technical consultancy, interior decoration, information technology or company secretary, plus any the Board notifies. Second, anyone else in business or a profession whose income exceeded ₹1,20,000 or whose sales, turnover or gross receipts exceeded ₹10 lakh in any one of the three preceding tax years (or is likely to, if newly set up). For an individual or HUF those limits are ₹2,50,000 and ₹25 lakh. See the Income Tax Department’s section 62 page or the full Income-tax Act, 2025.
Specified professions: Rule 46 (Income-tax Rules). Rule 46 (sub-rules 2 and 4) lists the books for people in legal, medical, engineering or architectural, accountancy, technical consultancy and interior decoration work, authorised representatives and film artists. They include a cash book, a journal (if on the mercantile system), a ledger and copies of bills and receipts. Sub-rule 3 switches that detailed list off where gross receipts stay at or below ₹1,50,000; read the rule for the exact test. Two conditions in Rule 46 also reach businesses covered by section 62: keep the books for seven tax years from the end of the relevant tax year (sub-rule 9), and if they are electronic, keep them accessible in India with a daily backup on servers in India (sub-rule 8).
Companies: Companies Act, 2013, section 128. Under section 128, every company must keep books of account that give a true and fair view, on the accrual basis and by double entry, and keep them with their vouchers for at least eight financial years. The books may be kept somewhere in India other than the registered office if the Board decides, with notice to the Registrar within seven days.
GST-registered persons: CGST Act section 35 and Rule 56. Registered persons must keep true and correct accounts and records under section 35, with detail in Rule 56. One sub-rule is directly relevant to ledgers: Rule 56(8) says entries must not be erased or overwritten, wrong entries must be scored out under attestation, and where records are electronic, a log of every entry edited or deleted must be kept. A plain spreadsheet keeps no such log.
Check what applies to your entity with a CA.
How to use the Excel ledger without breaking it
- Enter the opening balance once, in the opening cell, with Dr or Cr.
- Add one row per posting line: date, reference, particulars, then Debit or Credit.
- Leave the green formula cells alone (Balance ₹, Dr/Cr, entry checks, closing lookups). Blue cells are for input.
- Use Party Ledger for one party at a time, and Running Balance filtered by account.
- Count physical cash in the cash book, not here.
- At the end of the period, carry each closing balance to the next period’s opening cell, then save a read-only copy and keep a backup.
Mistakes that make a tidy ledger unreliable
- Posting to the wrong side. Usually a supplier payment entered on the Credit side, or a customer receipt on the Debit side. The balance moves the wrong way and still looks neat.
- Posting only one side of the entry. The sale goes to Sales but never to the customer’s page, so the customer seems to owe nothing.
- Opening balance entered twice: once in the opening cell and again as a posting row.
- Forgetting to carry forward. Last year’s closing balance never becomes this year’s opening, and the trial balance stops agreeing.
- Typing over balance formulas with a number that “looked right” that day.
- Netting GST into one account, so input and output disappear into a single figure.
- Mixing personal drawings with business expenses.
- Using the cash book as the only party record, then not knowing who still owes.
- Not reconciling. Bank never matched to the statement, party balances never matched with the party.
- No document references. Without invoice, UPI or cheque numbers, every party statement becomes an argument.
- Treating a shared spreadsheet as an audit trail when several people edit the same file.
- Treating a template as a government form or a substitute for CA review.
When a spreadsheet is enough — and when software helps
A spreadsheet ledger works well when one person posts, the list of parties is modest and every entry has a voucher behind it. Move to software when several people post at once, when you need an edit log, when stock or more than one GSTIN comes in, or when bank feeds and returns start eating your week.
- Accounting software selector
- Accounting software for small business in India
- Free accounting software for small business in India
- Best GST billing software in India
- Free tools hub
Once your ledger balances give a trial balance that agrees, they flow into the year-end statements. Our trial balance format shows how to find a difference. Asset, liability and capital balances go to the balance sheet format, and income and expense accounts feed the profit and loss account format.
Frequently asked questions
What is a ledger format?
It is the layout of the account-wise book of final entry: date, particulars, journal reference, debit, credit and balance, in either T-account or running-balance style. The downloads above give blank layouts and a worked example in rupees.
What is the difference between a journal and a ledger?
The journal (or daybook) records transactions in date order with full Dr/Cr lines. The ledger sorts those same lines into accounts, so each account shows its own balance.
What is a daybook format?
A daybook is the book of original entry for the day’s transactions, kept in date order: sales, purchases, cash, or one combined daybook for a small business. Its lines or daily totals are then posted to the ledger. The suggested columns are in the daybook section above.
Is a ledger the same as a cash book?
No. A cash book tracks cash and/or bank receipts and payments. A ledger holds every account, including parties and GST. Keep both; start with the cash book format for money-in-hand control.
What columns should a party ledger have?
Date, document or reference number, particulars (invoice and payment references), Debit ₹, Credit ₹, Balance ₹ and Dr/Cr. Enter the opening balance once, at the top.
Should GST input and output be in one ledger account?
No. Keep separate Input and Output accounts, usually split into CGST, SGST and IGST. Do not net them in the ledger.
Do I legally need a ledger in India?
It depends on who you are and what you do. Rule 46 of the Income-tax Rules names a ledger among the books for specified professions. Companies must keep double-entry books under section 128 of the Companies Act, 2013. Section 62 of the Income-tax Act, 2025 requires books from specified professions and from other businesses and professions above the thresholds: income over ₹1,20,000 or turnover over ₹10 lakh, or for an individual or HUF, income over ₹2,50,000 or turnover over ₹25 lakh. GST-registered persons must keep accounts and records under section 35 of the CGST Act and Rule 56. Ask a CA what applies to you.
Can I keep a ledger only in Excel?
Yes, for many small proprietors and early-stage books, provided you keep the vouchers, don’t break the formulas, back up the file and accept that Excel has no proper edit log or multi-user control. Companies and growing GST-heavy businesses usually need software.
What is a running balance in a ledger?
It is the balance of the account after each posting line, labelled Dr or Cr. For an account whose normal balance is Debit: opening + Debits − Credits = closing.
Are ScaleSaathi downloads prescribed government forms?
No. They are free educational templates with no sign-up wall. They are not government-prescribed forms, an audit-trail system, or a guarantee of statutory compliance.
Related guides
- Cash book format: daily cash and bank control
- Journal entry format: the entries you post from
- Trial balance format: check that your ledger agrees
- Bank reconciliation statement format: match the bank page to the statement
- Payment voucher format: a document for every payment
Sources and further reading
Legal sources checked on 29 October 2026.
- Income Tax Department: section 62 of the Income-tax Act, 2025 (books of account; thresholds) and the full Income-tax Act, 2025 (as amended by Finance Act, 2026).
- Income-tax Rules: Rule 46 (books for specified professions, including a ledger; ₹1,50,000 gross-receipts limit; seven-tax-year retention; electronic backup in India).
- Companies Act, 2013: section 128 (accrual basis, double entry, eight financial years). Alternate full text: Companies Act, 2013 PDF from PRS India.
- CGST Act: section 35 (accounts and other records).
- CBIC: CGST Rule 56 (maintenance of accounts, including the edit-log requirement in sub-rule 8).
- CBIC: GST invoice rules (invoice details that party ledgers refer to).
- NCERT Class 11 Accountancy, Financial Accounting Part I, chapter 3 “Recording of Transactions-I”: journal to ledger posting, T-account, Date/Particulars/J.F./Amount. Open it from the NCERT textbook page.
- ScaleSaathi: Cash book format (cash and bank recording alongside the ledger).
- ScaleSaathi’s own arithmetic: the Mehra Traders example on this page and in the downloads (journal Dr = Cr = ₹67,300; closing balances as tabled above).
About the author
Written by Vekho P Ringa for ScaleSaathi, which publishes practical guides for Indian small businesses under LendLink Tech Private Limited.