Financial Statement Spreading in India: Schedule III Line Items Mapped for Lenders
Map every Schedule III caption to a fixed spread line before you compute anything. Decide the Division first, because Division I and Division II use different captions for the same economics. Then rebuild four figures from the notes: current maturities of long-term debt, the finance-cost split, related-party balances and guarantees given. The face of the statement alone cannot support a DSCR.
That mapping is deterministic, which is why it automates. YuSight's Financial Spreading module runs it at 95.2% extraction accuracy, validated against a manual benchmark, with every figure traced back to the document and page it came from.
Key facts
- Schedule III has three Divisions and they are not interchangeable. Division I for companies on previous GAAP, Division II for Ind AS companies, Division III for NBFCs on Ind AS (Schedule III, Companies Act 2013, India Code). Ind AS is mandatory from a ₹500 crore net worth (Phase I, 1 April 2016) and ₹250 crore (Phase II, 1 April 2017), and it drags in holding companies, subsidiaries, associates and JVs (ICAI, *Ind AS Applicability*).
- The MCA notification of 24 March 2021 (effective 1 April 2021) added five disclosures a lender should be reading first: a trade receivables ageing schedule in five buckets (less than 6 months, 6 months–1 year, 1–2 years, 2–3 years, more than 3 years), a trade payables ageing schedule in four, a CWIP ageing schedule, 11 mandatory ratios with a written explanation for any variance above 25%, and a statement of whether quarterly returns filed with banks agree with the books (summary of the amendments, TaxGuru).
- The same amendment moved current maturities of long-term debt out of "Other current liabilities." In pre-amendment Division I sets it sits inside Other current liabilities; post-amendment it belongs inside current borrowings. A spread that reads the caption instead of the note gets it wrong under both regimes.
- Contingent liabilities are never on the face. Schedule III requires them in a note, under three heads — "Claims against the company not acknowledged as debt", "Guarantees", and "Other money for which the company is contingently liable" — plus a separate Commitments block.
- In the worked example below, one mis-mapped caption moves Debt/EBITDA from 2.69x to 2.34x — enough to flip a 2.50x covenant — while leaving the current ratio, the balance-sheet footing and the narrative untouched. That is why it survives review.
Which Division is the borrower reporting under, and how do you tell in ten seconds?
Read the equity captions. They are the fastest discriminator and they never lie.
What you see in the equity block | Division | What else follows from it |
|---|---|---|
"Shareholders' funds" → Share capital, Reserves and surplus | Division I (previous GAAP / AS) | Current/non-current split; "Property, Plant and Equipment" with Tangible and Intangible as sub-items; no financial-asset grouping |
"Equity" → Equity share capital, Other equity | Division II (Ind AS) | Current/non-current split; assets and liabilities grouped into Financial and non-financial; ROU assets and lease liabilities present |
"Equity" → Equity share capital, Other equity, but assets run Financial assets → Non-financial assets in liquidity order | Division III (Ind AS, NBFC) | No current-assets subtotal exists, so a current ratio is undefined |
Balance sheet annexed to an ITR, no Schedule III captions at all | Not a company | Partnership, LLP or proprietorship — spread from the ITR annexure and Form 3CD instead |
For a company borrower, the practical universe is Division I and Division II, and most MSME files are Division I. Division III sets require their own template — that is the subject of financial spreading for NBFCs in India. For the non-company path, see ITR analysis for loan underwriting.
What is the full Schedule III to spread-line mapping?
This is the table. Division I caption on the left, the Division II equivalent beside it, the standardised spread line it rolls into, and the trap.
Balance sheet — equity and liabilities
Division I caption | Division II (Ind AS) caption | Spread line | Watch-out |
|---|---|---|---|
Share capital | Equity share capital | Net worth | Preference shares may be a financial liability under Ind AS — check the note before treating them as equity |
Reserves and surplus | Other equity | Net worth | Revaluation reserve is not cash equity; strip it for a strict TNW |
Money received against share warrants | (within Other equity) | Quasi-equity | Treat as equity only if non-refundable and the note says so |
Share application money pending allotment | (within Other equity or Other financial liabilities) | Quasi-equity | Refundable applications are a liability, not equity |
Long-term borrowings — term loans from banks | Non-current Borrowings | Long-term debt | Read the repayment schedule here, not the P&L |
Long-term borrowings — loans from related parties | Non-current Borrowings (related party) | Quasi-equity if subordinated in writing, else long-term debt | Unsubordinated promoter loans are debt. A letter of subordination changes the ratio, not the risk |
Long-term borrowings — deposits, deferred payment liabilities | Non-current Borrowings / Other financial liabilities | Long-term debt |
|
Long term maturities of finance lease obligations | Non-current Lease liabilities | Long-term debt | Ind AS 116 puts operating leases here too; state which basis the covenant uses |
Deferred tax liabilities (net) | Deferred tax liabilities (net) | Other non-current liabilities | Inside TOL; outside "debt" for Debt/EBITDA |
Other long-term liabilities | Other non-current financial liabilities / Other non-current liabilities | Other non-current liabilities |
|
Long-term provisions | Non-current Provisions | Other non-current liabilities | Gratuity and leave encashment — non-funded, but real |
Short-term borrowings — loans repayable on demand from banks | Current Borrowings | Working-capital debt | Cash credit, WCDL, packing credit |
Short-term borrowings — from related parties | Current Borrowings | Working-capital debt or quasi-equity | Same subordination test as above |
Other current liabilities → current maturities of long-term debt (pre-amendment presentation) | Current Borrowings → current maturities of long-term borrowings (post-amendment) | Current portion of long-term debt | The single commonest India spreading error. See the next section |
Other current liabilities → interest accrued but not due / and due | Other current financial liabilities | Accrued interest | "Interest accrued and due" is an overdue payment — read it as a default signal |
Other current liabilities → statutory dues, income received in advance, advances from customers | Other current liabilities / Contract liabilities | Other current liabilities | Advances from customers are not revenue; under Ind AS 115 they are contract liabilities |
Trade payables — micro and small enterprises | Trade payables — micro and small enterprises | Trade payables (MSME) | Overdue beyond 45 days is both a stress signal and a Section 43B(h) tax exposure |
Trade payables — other creditors | Trade payables — others | Trade payables |
|
Short-term provisions | Current Provisions | Other current liabilities |
|
Balance sheet — assets
Division I caption | Division II (Ind AS) caption | Spread line | Watch-out |
|---|---|---|---|
PPE — Tangible assets | Property, plant and equipment | Net fixed assets |
|
PPE — Intangible assets | Other intangible assets | Intangibles — deducted from net worth |
|
Capital work-in-progress | Capital work-in-progress | Net fixed assets (non-earning) | Read the CWIP ageing note: a "suspended" bucket is a capitalised loss |
Intangible assets under development | Intangible assets under development | Intangibles — deducted |
|
(no equivalent) | Right-of-use assets | Net fixed assets | Only present under Ind AS 116 |
Non-current investments | Non-current Financial assets — Investments | Non-current investments | Investments in group companies get deducted in a strict TNW |
Long-term loans and advances | Non-current Financial assets — Loans | Other non-current assets | Split out advances to directors and related parties — this is where they hide |
Deferred tax assets (net) | Deferred tax assets (net) | Other non-current assets | Not a liquid asset; many lenders deduct from TNW |
Inventories | Inventories | Inventory | Reconcile to the stock statement you sanction drawing power against |
Trade receivables | Current Financial assets — Trade receivables | Receivables | The ageing note reclassifies part of this. See below |
Cash and cash equivalents | Cash and cash equivalents | Cash |
|
(within Cash, or Other current assets) | Bank balances other than cash and cash equivalents | Restricted cash | Margin money against LCs and BGs is not free cash |
Current investments | Current Financial assets — Investments | Marketable securities |
|
Short-term loans and advances | Current Financial assets — Loans / Other current assets | Other current assets | Advances to related parties belong out of current assets in a strict spread |
Other current assets | Other current assets | Other current assets | GST input credit, prepaid expenses, export incentives receivable |
Statement of profit and loss
Division I caption | Division II caption | Spread line | Watch-out |
|---|---|---|---|
Revenue from operations | Revenue from operations | Net sales | Reconcile to GST turnover — see three-way triangulation |
Other income | Other income | Split: recurring vs non-recurring | Profit on sale of assets, forex gains and written-back provisions do not belong in EBITDA |
Cost of materials consumed + Purchases of stock-in-trade + Changes in inventories | Same | COGS | Changes in inventories carries a sign — a decrease in stock is an expense |
Employee benefits expense | Employee benefits expense | Employee cost | Under Ind AS, remeasurements sit in OCI, not here |
Finance costs | Finance costs | Interest | Split in the note into term-loan interest, working-capital interest, lease interest and other borrowing costs |
Depreciation and amortisation expense | Depreciation and amortisation expense | Depreciation | Under Ind AS 116 this includes ROU amortisation that used to be rent |
Other expenses | Other expenses | Other operating expenses | Read the auditor's remuneration and CSR sub-lines for scale sanity |
Exceptional items / Extraordinary items | Exceptional items | Below EBITDA | Never inside EBITDA, always disclosed in the memo |
(no equivalent) | Other comprehensive income | Excluded from PAT for DSCR | OCI is not distributable cash |
Why is "Other current liabilities" the commonest spreading error in India?
Because it is the caption that carries debt without saying "debt", and because the rule changed under most analysts.
Schedule III's general instructions for Division I list what belongs in Other current liabilities: "Current maturities of long-term debt; Current maturities of finance lease obligations; Interest accrued but not due on borrowings; Interest accrued and due on borrowings; Income received in advance; Unpaid dividends; ... Other payables (specify nature)." Two of those ten items are debt. The rest are not.
The MCA amendment of 24 March 2021 moved current maturities of long-term borrowings into current borrowings, so a post-amendment Division I set should show it there. In Division II the amount sits inside current Borrowings and is not separately itemised on the face at all.
Three regimes, one consequence: the figure is never a face-of-the-balance-sheet line you can read off. Whether it is buried in Other current liabilities or buried in current Borrowings alongside cash credit, the only reliable source is the borrowings note.
What the error does to a spread:
- Total debt is understated by the full current portion, so debt-equity, Debt/EBITDA and TOL/TNW all improve.
- The DSCR denominator loses its principal leg, so DSCR either inflates absurdly or gets computed on interest alone.
- The current ratio does not move, because the amount stays inside current liabilities either way. The spread still foots. Nothing looks wrong.
That last point is the reason this survives a four-eye review. Reviewers check that the balance sheet balances and that the ratios look plausible. This error passes both tests.
How do you run the mapping? Seven steps
- Identify the Division and the units. Read the equity captions for the Division and the header string for "₹ in lakh" versus "₹ in crore". Re-read the units on every year presented — they change between sets.
- Map the face lines to your standard chart of accounts using the tables above. Every caption gets a destination; nothing is left as "miscellaneous".
- Open the borrowings note and split current borrowings into working-capital debt and current maturities of long-term debt. Record the facility-wise repayment schedule while you are there.
- Open the finance-costs note and split interest into term-loan interest, working-capital interest, lease interest and other borrowing costs.
- Open the related-party note and pull loans given, loans taken, guarantees, and balances outstanding. Decide the subordination treatment and write the decision into the memo.
- Open the contingent liabilities and ageing notes and pull guarantees given, bills discounted, disputed statutory demands, the receivables ageing buckets and the payables MSME split.
- Compute the ratios in code from the mapped lines, then cross-foot: mapped assets must equal mapped liabilities plus equity, and mapped expenses must equal total expenses on the face.
The sequence matters. Ratios computed before step 3 are computed on the wrong debt. For the general version of this sequence across markets, see the financial spreading process step by step.
Worked example: one Indian balance sheet, mapping visible
Illustrative only. A Division I manufacturing MSME, ₹ in lakh, year ended 31 March 2025. Figures are constructed for this walkthrough.
Face of the balance sheet
Schedule III caption | FY25 |
|---|---|
Share capital | 250.00 |
Reserves and surplus | 1,182.00 |
Total shareholders' funds | 1,432.00 |
Long-term borrowings | 940.00 |
Deferred tax liabilities (net) | 86.00 |
Long-term provisions | 44.00 |
Total non-current liabilities | 1,070.00 |
Short-term borrowings (cash credit) | 1,120.00 |
Trade payables — micro and small enterprises | 96.00 |
Trade payables — other creditors | 812.00 |
Other current liabilities | 486.00 |
Short-term provisions | 62.00 |
Total current liabilities | 2,576.00 |
TOTAL EQUITY AND LIABILITIES | 5,078.00 |
PPE — Tangible assets | 1,486.00 |
PPE — Intangible assets | 38.00 |
Capital work-in-progress | 62.00 |
Non-current investments | 40.00 |
Long-term loans and advances | 96.00 |
Other non-current assets | 24.00 |
Total non-current assets | 1,746.00 |
Inventories | 1,254.00 |
Trade receivables | 1,562.00 |
Cash and cash equivalents | 84.00 |
Short-term loans and advances | 288.00 |
Other current assets | 144.00 |
Total current assets | 3,332.00 |
TOTAL ASSETS | 5,078.00 |
Footing: 1,432.00 + 1,070.00 + 2,576.00 = 5,078.00 ✓ and 1,746.00 + 3,332.00 = 5,078.00 ✓
Profit and loss, FY25
Caption | FY25 |
|---|---|
Revenue from operations | 8,640.00 |
Other income | 62.00 |
Total revenue | 8,702.00 |
Cost of materials consumed | 5,406.00 |
Changes in inventories | (86.00) |
Employee benefits expense | 862.00 |
Finance costs | 268.00 |
Depreciation and amortisation | 214.00 |
Other expenses | 1,606.00 |
Total expenses | 8,270.00 |
Profit before tax | 432.00 |
Tax expense (current 128.00, deferred (10.00)) | 118.00 |
Profit for the year | 314.00 |
Expense check: 5,406.00 − 86.00 + 862.00 + 268.00 + 214.00 + 1,606.00 = 8,270.00 ✓ PBT: 8,702.00 − 8,270.00 = 432.00 ✓
The four figures that are only in the notes
Note | Contents | Spread consequence |
|---|---|---|
Other current liabilities (Note 9) | Current maturities of long-term debt 310.00; statutory dues 74.00; interest accrued but not due 18.00; advances from customers 84.00 | 310.00 moves to current portion of long-term debt |
Finance costs (Note 24) | Interest on term loans 118.00; interest on cash credit 132.00; other borrowing costs 18.00 = 268.00 ✓ | 118.00 is the DSCR numerator and denominator input |
Other income (Note 19) | Profit on sale of land 34.00; interest income 12.00; miscellaneous 16.00 = 62.00 ✓ | 34.00 stripped out of EBITDA |
Loans and advances (Notes 12, 16) | Long-term: security deposits 56.00, advance to a director 40.00. Short-term: advances to related parties 130.00, GST balances 92.00, prepaid 66.00 | 170.00 deducted in the strict TNW |
The mapped spread
Spread line | Built from | Arithmetic | Value |
|---|---|---|---|
Net worth | Share capital + Reserves and surplus | 250.00 + 1,182.00 | 1,432.00 |
Tangible net worth | Net worth − intangibles | 1,432.00 − 38.00 | 1,394.00 |
TNW (strict) | − director advance − related-party advances | 1,394.00 − 40.00 − 130.00 | 1,224.00 |
Total outside liabilities | Non-current + current liabilities | 1,070.00 + 2,576.00 | 3,646.00 |
TOL/TNW | 3,646.00 ÷ 1,394.00 |
| 2.62x |
TOL/TNW (strict) | 3,646.00 ÷ 1,224.00 |
| 2.98x |
Long-term debt | Long-term borrowings |
| 940.00 |
Current portion of LTD | From Note 9, not the face |
| 310.00 |
Working-capital debt | Short-term borrowings |
| 1,120.00 |
Total debt | 940.00 + 310.00 + 1,120.00 |
| 2,370.00 |
EBITDA (reported basis) | PBT + finance costs + depreciation | 432.00 + 268.00 + 214.00 | 914.00 |
EBITDA (adjusted) | − profit on sale of land | 914.00 − 34.00 | 880.00 |
Debt/EBITDA | 2,370.00 ÷ 880.00 |
| 2.69x |
Interest coverage | 880.00 ÷ 268.00 |
| 3.28x |
Current ratio | 3,332.00 ÷ 2,576.00 |
| 1.29x |
Net working capital | 3,332.00 − 2,576.00 |
| 756.00 |
DSCR (term debt) | (314.00 + 214.00 + 118.00) ÷ (118.00 + 310.00) = 646.00 ÷ 428.00 |
| 1.51x |
Receivable days | 1,562.00 ÷ 8,640.00 × 365 |
| 66 days |
Inventory days | 1,254.00 ÷ 5,406.00 × 365 |
| 85 days |
Payable days | 908.00 ÷ 5,406.00 × 365 |
| 61 days |
Cash conversion cycle | 66 + 85 − 61 |
| 90 days |
The same spread with Other current liabilities left unmapped
An analyst who maps the 486.00 wholesale to "other current liabilities" gets:
- Total debt = 940.00 + 1,120.00 = 2,060.00, understated by 310.00 — 13.1% of true total debt (310.00 ÷ 2,370.00)
- Debt/EBITDA = 2,060.00 ÷ 880.00 = 2.34x, against 2.69x correctly mapped
- Debt-equity = 2,060.00 ÷ 1,432.00 = 1.44x, against 2,370.00 ÷ 1,432.00 = 1.66x
- Current ratio = 1.29x — unchanged
- Total assets and total liabilities — unchanged, still footing to 5,078.00
A 2.50x Debt/EBITDA covenant passes on the mis-mapped spread and fails on the correct one. Nothing else in the file differs.
What the ageing and contingent-liability notes add
Trade receivables ageing (illustrative, from the note):
Bucket | Undisputed, considered good |
|---|---|
Less than 6 months | 1,102.00 |
6 months – 1 year | 288.00 |
1–2 years | 96.00 |
2–3 years | 42.00 |
More than 3 years | 34.00 |
Total | 1,562.00 ✓ |
Receivables over one year = 96.00 + 42.00 + 34.00 = 172.00, or 11.0% of the book (172.00 ÷ 1,562.00), carried with nil provision. A lender that haircuts them takes TNW to 1,394.00 − 172.00 = 1,222.00 and TOL/TNW to 3,646.00 ÷ 1,222.00 = 2.98x.
One precision point that costs teams money: the Schedule III bucket boundary is 6 months, and most drawing-power policies allow book debts up to 90 days. The ageing schedule bounds your eligible receivables — it cannot give you the figure. You still need the 90-day ageing from the borrower's own stock-and-book-debt statement, which is the input to the drawing power calculation.
Contingent liabilities note (illustrative): claims not acknowledged as debt — GST demand under appeal 128.00; guarantees — corporate guarantee to a group company's lender 600.00; other money contingently liable — bills discounted with banks 214.00. Commitments: capital contracts remaining to be executed 96.00.
Two adjustments a credit committee will ask for:
- Guarantee-adjusted TOL/TNW = (3,646.00 + 600.00) ÷ 1,394.00 = 4,246.00 ÷ 1,394.00 = 3.05x. A 3.00x covenant breaks on a note item that appears nowhere on the balance sheet.
- Bills discounted with recourse are borrowings. Debt including them = 2,370.00 + 214.00 = 2,584.00, so Debt/EBITDA = 2,584.00 ÷ 880.00 = 2.94x.
Between the mis-mapped 2.34x and the fully adjusted 2.94x sits a 0.60x range, none of which comes from any change in the business. It all comes from mapping. That is the argument in TOL/TNW ratio meaning and in what is financial spreading: fix the definitions in policy, then apply them identically across the book.
Which notes must be read before the spread is signed off?
Note | Pull | Why |
|---|---|---|
Borrowings | Facility-wise split, security, rate, repayment schedule, current maturities | The DSCR denominator and the true debt stack |
Finance costs | Term-loan interest vs working-capital interest vs lease interest | DSCR is computed on term-loan interest, not total finance costs |
Other income | Recurring vs non-recurring split | EBITDA quality |
Related-party disclosures | Loans given and taken, guarantees, sales and purchases, KMP remuneration | Strict TNW, and whether revenue is arm's-length |
Contingent liabilities and commitments | Guarantees, bills discounted, disputed demands, capital commitments | Off-balance-sheet debt |
Trade receivables ageing | Five buckets, disputed vs undisputed | Overstated current assets |
Trade payables ageing | MSME split and buckets | Stress signal plus Section 43B(h) exposure |
CWIP ageing | Projects in progress vs temporarily suspended | Capitalised losses |
Quarterly returns filed with banks | Whether they agree with the books, and the reconciliation | A free audit of every stock statement you sanctioned against |
The 11 mandatory ratios | The ratios and the >25% variance explanations | Management's own written explanation of the deterioration |
Notice how much of that list is post-2021. A spreading template written before April 2021 does not have fields for half of it. For the working-capital assessment that sits downstream, see what is CMA data and MPBF calculation explained.
FAQ
How do you map Schedule III line items to a credit spread?
Caption by caption, with a fixed destination for every line and nothing left as miscellaneous. Then you go into the notes and re-split three captions that carry mixed contents: current borrowings, other current liabilities and finance costs. The face gives you the shape; the notes give you the debt.
What is financial statement spreading in credit analysis?
Taking a borrower's statements as filed and restating them onto one standard template so that every borrower in your portfolio is comparable, then computing ratios from that template rather than from the original captions. Without it, two identical businesses on different accounting frameworks produce different ratios.
Where do lenders find contingent liabilities in Indian accounts?
In a note, never on the face of the balance sheet. Schedule III requires them under "Contingent liabilities and commitments (to the extent not provided for)", split into claims not acknowledged as debt, guarantees, and other money for which the company is contingently liable, with a separate block for commitments.
Why does current maturities of long-term debt cause so many errors?
Because it is not a face line under any Division. Before April 2021 it sat inside Other current liabilities; after the amendment it sits inside current borrowings alongside cash credit. Either way you have to open the note, and either way the balance sheet still foots if you skip it.
Do Division I and Division II need different spreading templates?
They need one template and two maps. The destination lines are the same — net worth, total debt, EBITDA — but "Reserves and surplus" and "Other equity" are different strings, and Ind AS adds right-of-use assets and lease liabilities that Division I never has.
Should promoter loans be treated as debt or equity?
Debt, unless there is a written subordination undertaking on file. Many Indian sanctions treat subordinated promoter loans as quasi-equity for the leverage covenant, and that is defensible — but only where the letter exists, and the memo should say so explicitly.
What does the trade receivables ageing schedule actually give a lender?
The share of the book that is old and unprovided, in five buckets. What it does not give you is your drawing-power figure, because the first bucket boundary is six months and drawing power usually runs on 90 days. Use it to challenge the stock-and-book-debt statement, not to replace it.
Can any of this be automated, or does it need an analyst?
The mapping automates well because it is rule-based and repetitive, and so does the note extraction. What does not automate is the judgement — whether a promoter loan is really subordinated, whether a guarantee to a group entity is likely to be called. Automate the mapping, keep the analyst on the calls.
Conclusion
Three things to carry into the next Indian file:
- Decide the Division before you touch the template. The equity captions tell you in ten seconds, and everything downstream depends on it.
- Three captions always need re-splitting from the notes — current borrowings, other current liabilities and finance costs. Everything else maps mechanically; these three carry mixed contents and hold the debt.
- Read the notes as part of the spread, not after it. Contingent liabilities, receivables ageing, MSME payables and the related-party block moved leverage in the worked example from 2.34x to 2.94x without a rupee of change in the business.
YuSight's Financial Spreading module identifies the Division, maps every Schedule III caption to a standardised spread, pulls the note-level figures the face does not carry, and computes DSCR, leverage, liquidity, profitability and custom ratios in code from those inputs — at 95.2% extraction accuracy against a manual benchmark, with each figure traced to its source document and page, analyst-editable, with full version history.
Watch YuSight spread a real balance sheet — book a live demo.
