Excel template · Finance

Schedule III Balance Sheet and Profit & Loss Format in Excel

Paste your trial balance, map each ledger to a Schedule III code once, and the balance sheet and statement of profit and loss build themselves in the Division I format, with previous-year columns and a tally check.

For: Accountants and CA firms finalising accounts of companies that follow Indian GAAP (Division I).

Free download · no sign-up · no macros · Excel 2010+, Google Sheets, LibreOffice

Preview of the Schedule III Balance Sheet & P&L Excel template with sample data
Main sheet with sample data

At a glance

What it is
Schedule III Balance Sheet & P&L — an Excel workbook for Indian businesses and accountants
Free edition
5 sheets (Guide, Mapping, Trial Balance, Balance Sheet, Profit & Loss) — free download, no sign-up
Pro edition
7 sheets, adds Notes and Ratios (Sch III) — ₹19 one-time (regular ₹99)
Works in
Microsoft Excel 2010 or later, Google Sheets, LibreOffice Calc — no macros
Checked
Recalculated with zero formula errors; sample data and a Guide sheet included
Made by
Prakash Bagchi, finance professional, PB Lab (Raipur, India)

Free vs Pro: what you get

SheetFreePro
Guide
What it does, how to use it, assumptions and a live status check
Mapping
Schedule III codes and heads, with room for your own note lines
Trial Balance
Ledgers with debit/credit for both years, a mapping-code drop-down and checks
Balance Sheet
Division I balance sheet with the tally check
Profit & Loss
Statement of profit and loss with earnings per share
Notes
Note-wise break-up generated from the mapped ledgers
—
Ratios (Sch III)
The 11 ratios required since the 2021 amendment, with the >25% change flag
—

Pro edition

Get Schedule III Balance Sheet & P&L – Pro

₹19₹9981% OFF

Everything in the free edition, plus:

  • Notes — Note-wise break-up generated from the mapped ledgers
  • Ratios (Sch III) — The 11 ratios required since the 2021 amendment, with the >25% change flag
  • One-time payment, instant .xlsx download, free updates
+91

Secure payment by Razorpay · UPI, cards, netbanking & wallets

We use your details only to deliver the file and support your purchase. See our privacy policy and terms.

Need more than one? The Finance & Accounts Kit has all 14 finance Pro templates, including this one, for ₹208.

How to use it

  1. 1Download the free file and read the Guide sheet.
  2. 2Fill in company name, year-end dates, units and share counts at the top of the Trial Balance sheet.
  3. 3Paste ledger names and debit/credit balances for both years, then pick a Schedule III code for each ledger from the drop-down — you only do this once per client.
  4. 4Check that the trial balance totals and the 'unmapped ledgers' count are both zero.
  5. 5Open Balance Sheet and Profit & Loss — the tally check should show ✔.

What Schedule III is

Schedule III to the Companies Act, 2013 prescribes the format of a company's balance sheet and statement of profit and loss. Division I applies to companies that follow the Companies (Accounting Standards) Rules — the old Indian GAAP. Division II applies to companies that follow Ind AS, and Division III to NBFCs that follow Ind AS. This template uses Division I, which covers most small and medium private companies.

The balance sheet is in vertical form: Equity and Liabilities first (shareholders' funds, non-current liabilities, current liabilities), then Assets (non-current and current). The statement of profit and loss lists revenue from operations, other income, expenses by nature, exceptional items, tax and earnings per share.

Current or non-current?

Every asset and liability must be classified as current or non-current. An item is current if it is expected to be realised or settled within twelve months after the reporting date, or within the company's normal operating cycle, or is held mainly for trading. Long-term borrowings that fall due within twelve months move to 'current maturities' under short-term borrowings. Each Schedule III code in the Mapping sheet already sits under the right head, so you decide once per ledger, not once per year.

What changed with the 2021 amendment

The amendment notified in March 2021, effective from 1 April 2021, added several disclosures to Division I. These include shareholding of promoters, ageing schedules for trade receivables, trade payables and capital work-in-progress, title deeds of immovable property not held in the company's name, details of benami property and wilful-defaulter status, transactions with struck-off companies, and crypto-asset dealings.

It also requires 11 ratios — current ratio, debt-equity, debt service coverage, return on equity, inventory turnover, trade receivables turnover, trade payables turnover, net capital turnover, net profit ratio, return on capital employed and return on investment — with an explanation for any ratio that changed by more than 25% compared with the previous year. The Pro edition calculates all 11 and flags the ones that need a comment.

Rounding off

Schedule III sets rounding rules by turnover. A company with turnover below ₹100 crore may round to the nearest hundreds, thousands, lakhs or millions, or decimals of these. Companies with turnover of ₹100 crore or more may round to lakhs, millions or crores, or decimals of these. Whatever unit you choose, use it consistently across the financial statements.

How the mapping approach saves time

Instead of building SUMIF formulas every year, you map each ledger once. Next year you paste the new trial balance, the existing ledgers pick up their mapping and only new ledgers need attention — the 'unmapped' counter tells you how many. Because previous-year figures come from the same mapping, comparatives stay consistent.

Written by Prakash Bagchi, finance professional and founder of PB Lab. Last reviewed .

Frequently asked questions

Which Division of Schedule III does this template follow?

Division I, for companies that follow the Companies (Accounting Standards) Rules. Ind AS companies follow Division II, which has a different layout including other comprehensive income.

Does it include the 11 ratios required from FY 2021-22?

The Pro edition calculates all 11 ratios required by the 2021 amendment and flags any ratio that moved by more than 25% so you can add the explanation.

Can I use it for an LLP or partnership firm?

Schedule III is not mandatory for them, but many firms use the same layout. You can map ledgers to the same lines; ignore the share capital lines and use partners' capital instead.

What if my trial balance doesn't tally?

The template shows the difference on the Trial Balance sheet and the Guide status stays red until it is zero. Fix the trial balance in your accounting software first.

Can I use it every year for the same client?

Yes. Paste next year's trial balance; existing ledgers keep their mapping and the template tells you how many new ledgers need a line.

Does it work with Tally exports?

Yes. Export the trial balance from Tally (or any software) to Excel and paste the ledger name and closing balances into the Trial Balance sheet.

How much does the Pro edition cost and how do I get it?

The Pro edition is ₹19 (regular price ₹99), a one-time payment through Razorpay by UPI, card, netbanking or wallet. You download the .xlsx file right after paying, and the download page works again later if you bookmark it. Pro adds: Notes, Ratios (Sch III).

Related free calculators

More Excel templates

See all templates →

Disclaimer: This template is a working aid, not legal, tax or accounting advice. Sample data is fictional. Laws, rates and thresholds change — verify them against the current Act, rules and notifications, or with a qualified professional, before relying on the results. PB Lab is not responsible for decisions made using this file.