Schedule III Financial Statements Excel – FY 2025-26 (Companies, Division I)
The complete audit-season working file: paste your trial balance, tag each ledger once, and the Balance Sheet, Statement of Profit and Loss, all 26 notes, both ageing schedules, the 11-ratio note, EPS, regulatory disclosures and the cash flow statement build themselves – with your letterhead and signature blocks ready for print.
Download the FY 2025-26 workbook (Excel)Why this template is different
Every free Schedule III shell floating around is a static format: blank tables you retype into, usually still in the pre-2022 layout. This workbook is an engine. You paste the trial balance ledger-wise with current and previous year balances, pick one of 37 map codes per row (the built-in Map Guide sheet lists typical ledgers for every code), and everything downstream assembles itself – including the disclosures added by the 2021 amendment that paid tools charge Rs 4,000 to 9,000 a year for and static shells simply omit.
Enter each term loan once – the workbook computes the principal falling due within 12 months per loan (EMI, equal-principal or bullet) and moves it from Long-term borrowings to Short-term borrowings on the face, as the amended Schedule III requires.
Paste receivables and payables line-wise with dates and flags; the 7-bucket receivables and 6-bucket payables tables (disputed, doubtful, MSME, unbilled, not due) compute against your balance sheet date and tie to the face figures.
Each ledger you tag becomes its own line inside the relevant note – consulting charges, ROC fees, business promotion each appear separately under Other expenses with both years.
All eleven Schedule III analytical ratios compute from the statements, compare with the previous year, and flag any variance beyond 25 percent where a written reason is required.
The seventeen additional disclosures – wilful defaulter, struck-off companies, benami, crypto, quarterly returns, layers and the rest – as a Yes/No/NA checklist.
Letterhead with name, CIN and address, auditor and director signature blocks with designations and DIN on separate lines, print areas set to fit each statement on a page. A Checks sheet with 14 ties must read ALL PASS before you print.
What is inside
Nineteen sheets: Cover, Setup (entity, dates, mandatory rounding selector, SMC flag, signatories), Trial Balance with the mapping dropdown, Map Guide, Borrowings loan grid, Ageing detail grids and tables, EPS working, Balance Sheet, Statement of Profit and Loss, editable Accounting Policies (Note 1), Shareholding (Note 2 with share reconciliation, holders above 5 percent and promoter holding with percent change), Notes to the Balance Sheet, Notes to the P and L, Ratios, Regulatory Disclosures, Cash Flow (AS 3 indirect, auto-linked), and Checks.
How to use it
Fill Setup, paste and tag the TB, complete the loan grid and ageing details, answer the questionnaire, and read the Checks sheet. Pair it with the online tools where deeper workings help: the Borrowings Note Generator for full amortisation schedules, the Accounting Policies Builder for an entity-perfect Note 1, the EPS Calculator for bonus/rights restatements, and the Ratio Analysis Calculator for the ratios note with reasons. The full format walkthrough lives on the Schedule III format guide.
Frequently Asked Questions
Which companies can use this template?
Companies preparing Accounting Standards (non-Ind AS) financial statements under Schedule III Division I – the vast majority of private limited companies. It reflects the format as amended with effect from 1 April 2021/2022.
Is it really free?
Yes – fully functional, no watermark, nothing locked behind payment. Enter your email at download and we mail you the refreshed file when the next financial year template is ready.
Are the formulas protected?
Yellow input cells are open; formula cells are locked so a stray keystroke cannot break the engine. Everything you need to type – including company details, signatories, policies text and every grid – is an input.
Does it handle the previous year column?
Yes. The TB takes previous-year balances alongside current-year, and every face, note breakup and ratio shows both years, with the prior-year current maturities entered once from last year’s financials.
Where do the depreciation figures come from?
Build the asset register in the free CalcGuru Depreciation/FAR Excel and carry the closing block totals into the PPE note grid.
Related on CalcGuru
Schedule III Format Guide (hub) | Borrowings Note Generator | Accounting Policies Builder | EPS Calculator (AS 20) | Ratio Analysis Calculator | Depreciation/FAR Excel | MSME Supplier Ageing Excel
The template is a working tool prepared with professional care; verify every figure and disclosure against the audited books before adoption. Not professional advice.