Download Y: Trial Balance to Schedule III Mapping (.xlsx)
What it does
Maps each trial balance account to a Schedule III (Division II, Ind AS) line and builds the balance sheet and statement of profit and loss, checking that the trial balance balances, every account is mapped and the balance sheet balances after the profit for the period.
Who it is for
Accountants preparing financial statements, and students.
How to use it
- Go to 'TB'. Paste your trial balance: account code, account name, debit and credit. Use the closing trial balance before the profit is transferred to retained earnings.
- In the 'Schedule III line' column, pick the line for each account from the list. Accounts left blank are shown in the checks.
- Go to 'Balance Sheet' and 'Profit and Loss'. Both are ready, in rupees. Change the 'Mapping' tab only if you need extra lines.
- Make sure the Checks box on 'Balance Sheet' reads OK, then copy the figures into your financial statements and notes.
Tabs in the file
| Tab | What it holds |
|---|---|
| Mapping | The Schedule III lines and where each appears. |
| TB | Trial balance with mapping. |
| Balance Sheet | Balance sheet in Schedule III format, with checks. |
| Profit and Loss | Statement of profit and loss. |
Learn the topic
For computation and reconciliation assistance only; not a substitute for formal statutory audit or legal tax advice. All sample data is illustrative and made up. Rates, limits and rules must be checked against current law and your own agreements before use. No tax saving, audit outcome or compliance result is promised.