Trial Balance Format — Excel and Word Template with Schedule III Mapping
Trial Balance — Ledger-wise with Schedule III Mapping
Entity: {{entity_name}} | Financial Year: {{fy}} | Trial balance as at: {{as_at_date}} | Source:
1. Purpose
A trial balance lists the closing balance of every ledger account, debit balances in one column and credit balances in the other. If the books have been kept on the double-entry system and posted correctly, the two columns total the same amount. It is the starting point of the audit file: the financial statements are drawn from it, and every figure in them should trace back to a line here.
2. Part A — Ledger Balances (as extracted)
| Ledger code | Name of ledger | Group / sub-group | Opening balance (₹) Dr / Cr | Debits during the year (₹) | Credits during the year (₹) | Closing balance — Debit (₹) | Closing balance — Credit (₹) |
|---|
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |
| Total | | | | | | | |
- Closing debit and closing credit totals must be equal. Record both totals and the difference, even when it is nil.
- Show each balance in the column of its nature. A creditor with a debit balance, or a customer with a credit balance, stays in the column it actually sits in. Do not net it against other parties; it is a reclassification point for the balance sheet.
- Extract the trial balance at ledger level, not group level. A group total hides the ledger that is wrong.
3. Part B — Check Totals
| Check | Amount (₹) | Result |
|---|
| Total of closing debit balances | | |
| Total of closing credit balances | | |
| Difference | | |
| Opening balances agree to last year's audited closing balances | | |
| Profit or loss per trial balance agrees to the draft statement of profit and loss | | |
4. Part C — Adjusting Entries after the First Extract
| JV no. | Date | Ledger debited | Ledger credited | Amount (₹) | Reason | Approved by |
|---|
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
Typical year-end entries: provisions for expenses, prepaid expenses, depreciation, accrued income, deferred tax, closing stock and write-offs. Keep the unadjusted trial balance as extracted and show the adjusted one beside it, so the effect of each entry is visible to the reviewer.
5. Part D — Mapping to Schedule III
| Ledger code | Name of ledger | Schedule III line | Adjusted balance (₹) | Note no. |
|---|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
- Balance sheet lines: share capital, reserves and surplus, borrowings, trade payables, other liabilities, provisions, property plant and equipment, investments, inventories, trade receivables, cash and cash equivalents, loans and advances, other assets.
- Statement of profit and loss lines: revenue from operations, other income, cost of materials consumed, employee benefits expense, finance costs, depreciation and amortisation, other expenses, tax expense.
- Map every ledger to exactly one line. A ledger left unmapped is a balance missing from the financial statements, and the mapped totals should add back to the trial balance totals.
- A ledger sitting opposite to its usual nature, such as a debit balance in a payables ledger, is mapped to the line that matches its actual nature, and noted.
6. Sign-off
Prepared by: {{prepared_by}} | Reviewed by: {{reviewed_by}} | Date: 10 October 2026
