Format & free template
Ledger statement format
A ledger statement, or party statement, lists every transaction with one customer or supplier over a period, starting from the opening balance and ending with what is owed today.
Why send ledger statements
Most payment disputes are not about money; they are about records. The party thinks they paid ₹40,000, your books show ₹35,000; a credit note was never received; a bill is missing at their end. A ledger statement sent regularly brings these differences out while they are small. Many businesses send one every month to their credit customers and ask suppliers for one at year end to confirm balances. See customer ledger statement best practices.
Sample ledger statement format
Figures are made up but add up. Download CSV opens in Excel or Google Sheets as a starting template; Print blank template gives the same layout with the amounts left empty.
Statement of account: Gupta Electricals · In the books of Sharma Traders · 1 April 2026 to 31 October 2026 · amounts in ₹
| Date | Particulars | Voucher | Debit | Credit | Balance |
|---|---|---|---|---|---|
| 01-04-2026 | Opening balance | – | 42,300 | 42,300 Dr | |
| 12-07-2026 | Sales | INV/0098 | 48,500 | 90,800 Dr | |
| 20-07-2026 | Receipt — NEFT | RC/0041 | 42,300 | 48,500 Dr | |
| 02-10-2026 | Sales | INV/0131 | 56,640 | 1,05,140 Dr | |
| 08-10-2026 | Credit note — goods returned | CN/0007 | 2,018 | 1,03,122 Dr | |
| 15-10-2026 | Receipt — UPI | RC/0067 | 25,000 | 78,122 Dr | |
| 29-10-2026 | Sales | INV/0136 | 36,816 | 1,14,938 Dr | |
| Total / closing balance | 1,84,256 | 69,318 | 1,14,938 Dr |
What to put on it
- Business name, address and GSTIN
- Party name, address and GSTIN
- Statement period
- Opening balance with Dr/Cr
- Date of each transaction
- Particulars (sales, receipt, credit note, etc.)
- Voucher or bill number
- Debit amount
- Credit amount
- Running balance with Dr/Cr
- Column totals
- Closing balance
- Unpaid bills with age (optional)
- Request to report differences
The layout
| Date | Particulars | Vch no. | Debit ₹ | Credit ₹ | Balance ₹ |
|---|---|---|---|---|---|
| 01-10-2026 | Opening balance | 42,300 Dr | |||
| 04-10-2026 | Sales | S-1288 | 18,880 | 61,180 Dr | |
| 09-10-2026 | Receipt (NEFT) | R-402 | 42,300 | 18,880 Dr | |
| 17-10-2026 | Sales | S-1341 | 27,140 | 46,020 Dr | |
| 22-10-2026 | Credit note (return) | CN-031 | 2,360 | 43,660 Dr | |
| 31-10-2026 | Closing balance | 46,020 | 44,660 | 43,660 Dr |
For a customer, Dr means they owe you. For a supplier's statement in your books, Cr means you owe them. Print Dr/Cr next to every balance; a bare number confuses everyone.
What to include
- Your name, address, GSTIN and contact for queries.
- Party name, address and GSTIN.
- Period, for example 1 October 2026 to 31 October 2026.
- Opening balance carried from the previous period.
- Each transaction: date, type (sales, receipt, credit note, debit note, journal), voucher or bill number, debit, credit, running balance.
- Closing balance, and the total of each column.
- Optionally a bill-wise list of unpaid bills with days overdue, which helps the party pay the right bills.
- A note: "Please report any difference within 15 days."
Ledger statement vs outstanding statement
A ledger statement shows every movement in the period. An outstanding or bill-wise statement shows only unpaid bills and how old each one is. For collections, the bill-wise one is more useful; for reconciling records, the ledger. Sending both together answers most questions in one go. See bill-wise details and the receivables ageing calculator.
Reconciling with the party
- Agree the opening balance first; if it differs, go back to the previous period.
- Tick off matching entries on both statements.
- List what is left: bills not booked by them, payments not received by you, credit notes not passed, TDS deducted but not accounted.
- Pass the missing entries and confirm the agreed balance in writing.
Year-end balance confirmation
At year end, send every party a statement with a short request: "Please confirm the balance of ₹43,660 Dr as on 31 March, or send your statement if it differs." Auditors often ask for these confirmations, and they settle old differences before they grow. Keep the replies with the year's records. Supplier confirmations matter as much as customer ones, because they show whether all purchase bills and credit notes are in your books.
From Tally
TallyPrime's Ledger Vouchers report for a party is the ledger statement; the Bills Receivable or party-wise outstanding report gives the bill-wise view. Both can be printed or exported to PDF. Cashflow OS can share the same party statement from the phone as a PDF on WhatsApp, and in a simple Hindi version, which is described on the party ledger statements page.
Questions people ask
What does Dr and Cr mean on a ledger statement?
In a customer's account in your books, Dr means the customer owes you and Cr means you owe them, for example after an advance. A supplier's account is the other way round.
How often should I send ledger statements?
Monthly to credit customers, and at year end to all parties for balance confirmation.
Why does the party's balance not match mine?
Usually timing (payment in transit), a missing bill or credit note, or TDS deducted. Reconcile entry by entry from an agreed opening balance.
Is a ledger statement a legal document?
It is an extract of your books. A balance confirmed by the party in writing is useful evidence in a dispute.
Can I send a ledger statement on WhatsApp?
Yes, as a PDF. Send it to the person who handles payments at the party's end.
Should TDS deducted by the customer appear on the statement?
Yes. When a customer deducts TDS, the receipt is short by that amount. Enter the TDS as a credit against the party once it shows in your tax credit statement, or the balance will never match.
This page is general information for Indian businesses, not tax or legal advice. GST rules, limits and formats change by notification — check cbic-gst.gov.in or gst.gov.in, or ask your CA.
