Financial Spreading for NBFCs in India: Formats, Schedules and Pitfalls
An NBFC spreading Indian borrower financials is reconciling four incompatible presentations at once: Schedule III Division I (previous GAAP), Division II (Ind AS), Division III (Ind AS for NBFC borrowers), and unaudited provisionals. The captions differ, the comparatives get restated, and the notes carry more credit information than the face of the statement.
That is a mapping problem, not a reading problem — which is why automating it is what lets a credit team run 5x throughput at the same headcount rather than simply typing faster.
Key facts
- Three Schedule III presentations are live simultaneously. Division I for companies on previous GAAP, Division II for Ind AS companies, and Division III for NBFCs on Ind AS, which classifies the balance sheet as financial and non-financial rather than current and non-current (ICAI, *Guidance Note on Division III — Schedule III*, revised January 2022).
- Since the MCA notification dated 24 March 2021, effective 1 April 2021, every Schedule III set carries 11 mandatory ratios — current ratio, debt-equity, DSCR, 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 required for any variance above 25% against the prior year (summary of the amendments; ICAI Guidance Note on Division II).
- The same amendment made your own facility auditable from the borrower's accounts. Companies must state whether "quarterly returns/statements filed with the lender agree with the books of account" for facilities secured against current assets, and reconcile material differences. That disclosure is a free stock-statement audit sitting in the notes.
- For an NBFC borrower, the provisioning number on the face of the P&L is not the regulatory one. RBI's *Implementation of Indian Accounting Standards*, RBI/2019-20/170 dated 13 March 2020 requires that "where impairment allowance under Ind AS 109 is lower than the provisioning required under IRACP (including standard asset provisioning), NBFCs/ARCs shall appropriate the difference from their net profit or loss after tax to a separate 'Impairment Reserve'", and requires a comparison of the two, per the template in the Appendix, in the notes.
- The bottleneck is mapping, and mapping is what automates. Deciding the Division, pulling the four or five figures that live only in the notes, and reconciling three turnover definitions is deterministic, repetitive work — which is why credit desks running it on YuSight get 5x throughput at the same headcount without loosening a check.
- Regulatory expectations now scale with the borrower's size. The Master Direction — RBI (Non-Banking Financial Company – Scale Based Regulation) Directions, 2023, RBI/DoR/2023-24/106 dated 19 October 2023 sets the layered framework that determines what your NBFC borrower is required to disclose in the first place.
What formats does an NBFC actually receive?
Not one. In a working month a mid-size NBFC's credit desk will see all of these, often in the same file.
Format | Who files it | What it looks like | Spreading difficulty |
|---|---|---|---|
Schedule III Division I (previous GAAP / AS) | Companies below the Ind AS thresholds — most SME borrowers | Current/non-current split; "Reserves and surplus"; current maturities of long-term debt in Other current liabilities | Lowest. Captions are stable across firms |
Schedule III Division II (Ind AS) | Listed companies, large unlisted companies, their holding/subsidiary/associate/JV entities | Current/non-current split; "Other equity"; ROU assets and lease liabilities; current maturities sit inside current Borrowings | Moderate. Ind AS 116 and 115 change the shape of EBITDA and revenue |
Schedule III Division III (Ind AS, NBFC) | NBFC borrowers — a growing share of an NBFC's own book, via on-lending and BC/co-lending exposures | Financial/non-financial split, liquidity order; Loans, Investments, Impairment on financial instruments as face lines | Highest. It does not map to a corporate template at all |
Provisional / management accounts | Almost every borrower, for the stub period | A trial balance in a spreadsheet, or a two-page P&L with no notes and no auditor | Deceptively easy to read, impossible to verify |
Tax audit report, Form 3CD | Borrowers above the tax-audit threshold | Clause-wise; turnover, disallowances, related-party payments, loans and deposits | Different definitions of turnover and profit from the statutory set |
CMA data | Prepared by the borrower's CA for the facility | Seven statements, lender-friendly, projections included | Standardised — but prepared for you, so treat as an assertion |
Two consequences for a spreading template.
You need at least two chart-of-accounts maps, not one. A single template that assumes "Reserves and surplus" will silently drop "Other equity". A single template that assumes current maturities sit in Other current liabilities will understate current-portion debt for every Ind AS borrower.
A large share of your borrowers are not on Schedule III at all. Partnerships, LLPs and proprietorships file no Schedule III statement. What you get is a balance sheet and P&L annexed to the ITR, plus Form 3CD. That is a genuinely different spreading path, covered in ITR analysis for loan underwriting and ITR and Form 26AS spreading for MSME lending.
How does Division III differ from Division II, and why does it matter?
Because a Division III set will not fit a corporate template, and forcing it produces nonsense ratios.
Under Division III, per the ICAI guidance note, "the assets and liabilities are classified as financial and non-financial instead of current, non-current classification as required by Division I and Division II". There is no current assets subtotal and no current liabilities subtotal. Current ratio is undefined on the face of a Division III balance sheet. If your template computes one anyway, it is computing a number from whatever happened to land in those rows.
The face lines that replace them:
- Financial assets — Cash and cash equivalents; Bank balances other than cash and cash equivalents; Derivative financial instruments; Receivables (trade and other); Loans; Investments; Other financial assets
- Non-financial assets — Current and deferred tax assets, PPE, CWIP, intangibles, right-of-use assets, other non-financial assets
- Financial liabilities — Derivative financial instruments; Payables; Debt securities; Borrowings (other than debt securities); Deposits; Subordinated liabilities; Other financial liabilities
- P&L revenue from operations — Interest income; Dividend and rental income; Fees and commission income; Net gain on fair value changes; Net gain on derecognition of financial instruments
- P&L expenses — Finance costs; Fees and commission expense; Net loss on fair value changes; Impairment on financial instruments; Employee benefits; Depreciation; Others
For a lending NBFC assessing another NBFC, the credit-relevant lines are: Loans (gross and net of impairment), Impairment on financial instruments, Debt securities plus Borrowings plus Subordinated liabilities (the funding stack and its seniority), and Net gain on fair value changes (which is where non-cash income hides).
Rebuild leverage from the liability lines, not from a "total debt" caption, because Division III has none. And do not compute a working-capital cycle for a Division III borrower; it has no meaning for a lender's balance sheet.
Which schedules and notes carry the credit information?
The face of a Schedule III statement is roughly forty lines. The notes are eighty pages. Almost everything that changes a credit view is in the notes.
Note | What to pull | Why it changes the decision |
|---|---|---|
Borrowings | Facility-wise split, security, interest rate, repayment schedule, current maturities of long-term borrowings | This is your DSCR denominator, and under Division II it is buried inside current Borrowings rather than shown separately |
Trade payables ageing | Split of micro and small enterprises vs others, and the ageing buckets | MSME dues overdue beyond 45 days are a stress signal and a Section 43B(h) tax exposure |
Trade receivables ageing | Buckets, plus disputed vs undisputed | A large >3 years undisputed bucket with no provision is the most common overstated-asset pattern |
Related-party disclosures (Ind AS 24 / AS 18) | Loans and advances given, guarantees, purchases and sales, KMP remuneration, balances outstanding | Deduct related-party receivables from TNW; treat circular sales as non-arm's-length revenue |
Contingent liabilities and commitments | Guarantees given (especially to group entities), disputed statutory demands, LCs | Guarantees to group entities are contingent debt on the borrower you are lending to |
Quarterly returns filed with lenders | The statement of whether returns agree with books, and the reconciliation | Free verification of every stock statement you have been sanctioning drawing power against — see drawing power calculator |
Ratios (the 11 mandatory) | The ratios, and the explanation for any >25% variance | The management's own written explanation for the deterioration, in their own audited words |
Wilful defaulter / struck-off companies / benami / undisclosed income | Any entry at all | Any non-nil entry here is a stop-and-escalate, not a note to read later |
CWIP ageing | Split of projects in progress vs temporarily suspended, by period | A "temporarily suspended" bucket is a capitalised loss waiting to be written off |
Ind AS 109 vs IRACP comparison (Appendix) | Stage-wise gross, ECL, IRACP required, and the Impairment Reserve | For an NBFC borrower, this is the whole asset-quality picture in one table |
Worked spread: one Schedule III Division II balance sheet and P&L
A mid-market manufacturing borrower, Ind AS, ₹ in lakh, year ended 31 March 2025. Face of the statements first, then the mapping.
Balance sheet as at 31 March 2025 (₹ lakh)
Schedule III caption | FY25 |
|---|---|
Non-current assets |
|
Property, plant and equipment | 3,120.40 |
Capital work-in-progress | 186.00 |
Right-of-use assets | 214.60 |
Other intangible assets | 42.30 |
Financial assets — Investments | 95.00 |
Financial assets — Other financial assets | 63.70 |
Other non-current assets | 48.00 |
Total non-current assets | 3,770.00 |
Current assets |
|
Inventories | 1,842.50 |
Financial assets — Trade receivables | 2,106.80 |
Financial assets — Cash and cash equivalents | 128.40 |
Financial assets — Bank balances other than above | 92.60 |
Financial assets — Loans (to a related party) | 175.00 |
Financial assets — Other financial assets | 54.20 |
Other current assets | 230.50 |
Total current assets | 4,630.00 |
TOTAL ASSETS | 8,400.00 |
Equity |
|
Equity share capital | 500.00 |
Other equity | 2,236.00 |
Total equity | 2,736.00 |
Non-current liabilities |
|
Financial liabilities — Borrowings | 1,684.00 |
Financial liabilities — Lease liabilities | 168.90 |
Provisions | 96.10 |
Deferred tax liabilities (net) | 210.00 |
Total non-current liabilities | 2,159.00 |
Current liabilities |
|
Financial liabilities — Borrowings (cash credit 985.00 + current maturities of long-term borrowings 527.00) | 1,512.00 |
Financial liabilities — Lease liabilities | 58.40 |
Financial liabilities — Trade payables: dues of micro and small enterprises | 143.60 |
Financial liabilities — Trade payables: dues of creditors other than micro and small enterprises | 1,486.40 |
Financial liabilities — Other financial liabilities | 121.60 |
Other current liabilities | 138.00 |
Provisions | 22.00 |
Current tax liabilities (net) | 23.00 |
Total current liabilities | 3,505.00 |
TOTAL EQUITY AND LIABILITIES | 8,400.00 |
Balance check: 2,736.00 + 2,159.00 + 3,505.00 = 8,400.00 ✓
Statement of profit and loss, FY25 (₹ lakh)
Schedule III caption | FY25 |
|---|---|
Revenue from operations | 12,480.00 |
Other income | 86.40 |
Total income | 12,566.40 |
Cost of materials consumed | 7,912.30 |
Changes in inventories of finished goods, WIP and stock-in-trade | (168.40) |
Employee benefits expense | 1,142.60 |
Finance costs | 386.20 |
Depreciation and amortisation expense | 428.90 |
Other expenses | 2,214.80 |
Total expenses | 11,916.40 |
Profit before tax | 650.00 |
Current tax | 182.00 |
Deferred tax | (14.00) |
Profit for the year | 482.00 |
Other comprehensive income (remeasurement of defined benefit plans, net of tax) | (6.00) |
Total comprehensive income | 476.00 |
Component check: 7,912.30 − 168.40 + 1,142.60 + 386.20 + 428.90 + 2,214.80 = 11,916.40 ✓ PBT: 12,566.40 − 11,916.40 = 650.00 ✓
Finance costs, from Note 26 (p.34): interest on term loans 214.60 + interest on working capital borrowings 138.20 + interest on lease liabilities 21.40 + other borrowing costs 12.00 = 386.20 ✓
The mapping
Spread line | Built from | Value | Note |
|---|---|---|---|
Net worth | Equity share capital + Other equity | 500.00 + 2,236.00 = 2,736.00 | "Other equity" under Ind AS; "Reserves and surplus" under Division I |
Intangibles deducted | Other intangible assets | 42.30 | Add intangibles under development if present |
Related-party receivable deducted | Financial assets — Loans (current) | 175.00 | Policy-dependent; state which policy applies |
Tangible net worth (standard) | 2,736.00 − 42.30 | 2,693.70 |
|
Tangible net worth (strict) | 2,693.70 − 175.00 | 2,518.70 |
|
Total outside liabilities | Total non-current + total current liabilities | 2,159.00 + 3,505.00 = 5,664.00 | Includes deferred tax and lease liabilities |
TOL/TNW (standard) | 5,664.00 ÷ 2,693.70 | 2.10x |
|
TOL/TNW (strict) | 5,664.00 ÷ 2,518.70 | 2.25x | 0.15x of leverage turns on one policy choice |
Total debt (ex-lease) | Non-current borrowings + current borrowings | 1,684.00 + 1,512.00 = 3,196.00 | Current maturities are already inside current borrowings |
Total debt (incl. lease) | + lease liabilities 168.90 + 58.40 | 3,423.30 |
|
EBITDA | PBT + finance costs + depreciation | 650.00 + 386.20 + 428.90 = 1,465.10 | Ind AS 116 inflates this — see pitfalls |
Debt/EBITDA (ex-lease) | 3,196.00 ÷ 1,465.10 | 2.18x |
|
Debt/EBITDA (incl. lease) | 3,423.30 ÷ 1,465.10 | 2.34x |
|
Current ratio | Total current assets ÷ total current liabilities | 4,630.00 ÷ 3,505.00 = 1.32x |
|
DSCR (term debt) | (PAT + depreciation + term-loan interest) ÷ (term-loan interest + term principal due) | (482.00 + 428.90 + 214.60) ÷ (214.60 + 527.00) = 1,125.50 ÷ 741.60 = 1.52x | Term-loan interest from Note 26, not the P&L face |
Three things this walkthrough demonstrates.
The denominator of DSCR is not on the face of anything. Term-loan interest (214.60) comes from the finance costs note; term principal due within 12 months (527.00) comes from the borrowings note, where it is a sub-component of a current borrowings line that also contains cash credit. Using the P&L's total finance costs of 386.20 instead gives (482.00 + 428.90 + 386.20) ÷ (386.20 + 527.00) = 1,297.10 ÷ 913.20 = 1.42x, not 1.52x — a 0.10x swing from one sourcing decision. See DSCR calculation for term loans in India for which variant Indian lenders use where.
TOL/TNW moves 0.15x on a policy choice, not on any change in the borrower. That is why the definition needs to be fixed in policy and applied identically across the book — the argument in TOL/TNW ratio meaning.
Every one of these figures should carry a page reference. In the spread above there are 14 source figures drawn from 5 different pages. A reviewer who cannot click from 527.00 to Note 14 is re-reading the statement, not reviewing the spread.
ECL and provisioning: what to pull when the borrower is an NBFC
If your borrower is itself an NBFC, the asset-quality picture lives in one table — the Ind AS 109 versus IRACP comparison the RBI circular requires in the Appendix format. Here is a worked illustration (₹ lakh). The standard-asset provisioning rate used below is 0.40%:
Asset classification | Gross carrying amount | ECL (Ind AS 109) | ECL % | IRACP required |
|---|---|---|---|---|
Stage 1 (standard) | 39,180.00 | 195.90 | 0.50% | — |
Stage 2 (standard, SICR) | 2,140.00 | 214.00 | 10.00% | — |
Standard asset provision @ 0.40% on 41,320.00 |
|
|
| 165.28 |
Stage 3 (NPA) | 1,280.00 | 368.00 | 28.75% | 896.00 |
Total | 42,600.00 | 777.90 | 1.83% | 1,061.28 |
What a credit analyst reads off it:
- Gross NPA ratio = 1,280.00 ÷ 42,600.00 = 3.00%
- Net NPA ratio = (1,280.00 − 368.00) ÷ (42,600.00 − 777.90) = 912.00 ÷ 41,822.10 = 2.18%
- Stage 3 provision coverage = 368.00 ÷ 1,280.00 = 28.75% — thin
- Impairment Reserve required = 1,061.28 − 777.90 = 283.38, appropriated from post-tax profit, not charged to the P&L
That last line is the one to internalise. The borrower's reported profit is unaffected by the 283.38, because the RBI circular directs the difference to be appropriated from net profit after tax to the Impairment Reserve. So a borrower with ECL materially below IRACP can show a healthy P&L while transferring a real regulatory shortfall below the line. Read the appropriation, not just the impairment expense. The reserve is also not freely available — withdrawals require RBI approval, and it should not be treated as distributable or as free capital.
Also pull: Stage 2 as a percentage of standard assets (the migration warning), the movement in ECL between years split into transfers and remeasurement, and the write-off line — a falling GNPA with a large write-off is not an improvement. For how these classifications work on your own book, see IRAC norms explained.
What are the pitfalls, and how do you detect each one?
Pitfall | What you see | What it does to the spread | Detection rule |
|---|---|---|---|
Restated comparatives (Ind AS 8) | The FY24 column in the FY25 accounts differs from the FY24 column in the FY24 accounts | Growth rates computed across two document sets are wrong | Hold both signed sets. Compare prior-year closing to current-year opening for every line; flag any non-zero delta and read the restatement note |
Ind AS transition year (Ind AS 101) | A first-time adoption reconciliation note; equity and profit reconciled from previous GAAP | Every year-on-year comparison spans two accounting frameworks | Detect the Ind AS 101 note. Do not compute growth across the transition without adjusting; spread both bases for the overlap year |
Ind AS 116 leases | ROU assets and lease liabilities appear; rent disappears from Other expenses into depreciation and finance cost | EBITDA inflates and debt inflates simultaneously. Debt/EBITDA can look flat while both legs moved | Presence of ROU asset or lease liability. Compute the ratio on both bases (2.18x vs 2.34x above) and state which basis the covenant uses |
Ind AS 115 gross vs net revenue | Revenue jumps with no volume change (agent vs principal, or excise/GST presentation) | Turnover-linked limits and turnover covenants misfire | Reconcile revenue to GST turnover. See three-way triangulation |
Changed accounting policy or estimate | Useful lives revised, inventory valuation method changed, provisioning policy altered | Depreciation, margins and net worth move without any operating change | Read the significant accounting policies note against the prior year, line by line. It is the note analysts skip |
Tax audit vs statutory audit figures | Form 3CD turnover ≠ P&L revenue from operations | Two defensible turnover figures in one file | Expect the difference (GST treatment, other income, discounts). Reconcile once, document the bridge, and state which one the sanction uses |
Consolidated vs standalone | The header says "Consolidated"; there is a non-controlling interests line and goodwill | You have spread group cash flows against a standalone obligor | Check the header string, NCI in equity, goodwill in assets. Lend against the entity that signs; use CFS for group context only |
Provisional / management accounts | Two pages, no notes, no auditor's report, no UDIN | Nothing is verifiable, and no note-level data exists at all | Absence of an audit report or UDIN. Cap the weight in policy, and reconcile the stub period to bank credits and GST |
Units and rounding | "₹ in lakh" in one set, "₹ in million" or "₹ in crore" in the next year's | A 10x or 100x error that foots perfectly | Parse the units string from the header on every statement, and run a magnitude sanity check against the prior year and against bank turnover |
Current maturities under Ind AS | No separate "current maturities" line; the amount sits inside current Borrowings | Current-portion debt understated; DSCR denominator understated | Always open the borrowings note. Never take the current borrowings face value as working-capital debt |
Related-party circularity | Sales to and purchases from group entities, plus loans given | Revenue and receivables inflated by non-arm's-length flows | Read the Ind AS 24 note in full. Deduct related-party loans from TNW; test what turnover looks like net of group sales |
Where automation earns its keep
The reading is the easy part. What consumes an analyst's day on an Indian file is:
- Deciding which Division the statement is drawn under, and picking the right map
- Finding the four or five numbers that are in the notes rather than on the face
- Reconciling three turnover figures — statutory, 3CD and GST
- Comparing this year's comparatives with last year's originals
- Doing it identically across every file so the portfolio is comparable
Every one of those is deterministic, rule-based and repetitive, which is precisely the class of work that scales. That is where 5x throughput at the same headcount comes from — not from typing faster, but from the analyst never re-keying a figure and never hunting for a note. For a like-for-like view against the incumbent Indian tooling, see Perfios vs YuSight for financial spreading and best credit appraisal software in India. For the working-capital assessment that sits downstream of the spread, see what is CMA data.
FAQ
How do Indian NBFCs spread borrower financials?
By mapping whichever Schedule III presentation the borrower filed onto one internal chart of accounts, then pulling the credit-relevant figures out of the notes — borrowings, related parties, contingent liabilities, ageing schedules — and computing ratios from that. The mapping, not the reading, is where the time goes.
How do you spread Schedule III financial statements?
Identify the Division first, because the captions differ. Then map the face lines, then open the notes for the numbers that are not on the face: current maturities of long-term debt, the finance-cost split, related-party balances and guarantees given. A spread built only from the face of the statement is missing the DSCR denominator.
What is financial spreading software?
Software that reads a borrower's statements, standardises them onto one template, and computes ratios from the standardised figures. The useful ones keep every figure traceable to its source page and let an analyst edit any line with the change recorded. See what is financial spreading for the full walkthrough.
What is the difference between Division II and Division III of Schedule III?
Division II is for Ind AS companies generally and splits the balance sheet into current and non-current. Division III is for NBFCs on Ind AS and splits it into financial and non-financial, in liquidity order. There is no current assets subtotal in Division III, so a current ratio computed from it is meaningless.
How do you handle restated comparatives?
Keep both signed statement sets and compare the prior-year closing balances with the current year's opening balances, line by line. Any difference means a restatement, and the restatement note tells you why. Growth computed across two sets without that check is simply wrong.
Does Ind AS 116 change our leverage covenant?
It changes the inputs to it. Right-of-use assets and lease liabilities appear, rent moves out of operating expenses into depreciation and finance cost, so EBITDA rises and debt rises at the same time. Compute the ratio on both bases and be explicit in the sanction about which one the covenant tests.
Why does the tax audit report show a different turnover?
Because Form 3CD and the statutory P&L use different definitions — treatment of GST, other income, discounts and rebates all move the number. The difference is usually explainable in one reconciliation. What matters is that you do it once, write down the bridge, and use the same basis every quarter.
What should I look for in an NBFC borrower's ECL disclosure?
The Appendix table comparing Ind AS 109 impairment with IRACP requirements. Read the Stage 3 coverage percentage, the Stage 2 share of standard assets, and whether an Impairment Reserve was created — because that appropriation comes out of post-tax profit and does not touch the reported P&L.
Can we spread provisional accounts at all?
Yes, but treat them as an assertion rather than evidence. There is no auditor, no notes and usually no UDIN, so nothing in them is independently checkable. Reconcile the stub period against bank credits and GST returns, and cap the weight the policy allows them to carry.
Conclusion
Three things to take away:
- Pick the Division before you pick the template. Division I, II and III use different captions and different classifications, and Division III has no current/non-current split at all. One template applied to all three produces ratios that look fine and mean nothing.
- The notes carry the credit information. Current maturities of long-term borrowings, the finance-cost split, related-party balances, the payables ageing, the quarterly-returns-agree-with-books statement and the 11 mandatory ratios with their 25% variance explanations. A face-only spread misses the DSCR denominator entirely.
- Detect the pitfalls with rules, not vigilance. Restated comparatives, an Ind AS 101 transition note, an ROU asset, a "Consolidated" header, a changed units string — each has a mechanical detection test, and each should fire automatically rather than depending on an analyst noticing at 7pm.
YuSight's Financial Spreading extracts and standardises Indian financials across Schedule III Divisions, computes DSCR, leverage, liquidity, profitability and custom ratios in code from traceable inputs, and keeps every figure traced to its source document and page with spreads analyst-editable and full version history. That is what lets a credit desk run 5x throughput at the same headcount without loosening a single check.
Watch YuSight spread a real balance sheet — book a live demo.
