Start with a reconciliation, then explain the cash shortfall
Positive EBITDA is not evidence of positive cash flow. A useful monthly MIS must explain how the approved profit figure, operating-balance movements, tax payments, asset transactions and financing movements reconcile to actual closing cash. The unexplained difference should be zero; a large receivable or inventory movement is an explanation to investigate, not a plug to insert.
This guide is an internal management-reporting method for an Indian non-financial business. It does not prescribe a statutory monthly MIS format, closing deadline, universal liquidity target or bank covenant. The worked bridge uses an AS 3-style classification; an Ind AS reporter must apply its own applicable cash-flow policy when reconciling to statutory reporting.
Use AS 3 as a reconciliation discipline
ICAI Accounting Standard (AS) 3, paragraphs 18–20 explains the indirect method: adjust profit for non-cash items, accrual timing and income/expenses belonging to investing or financing activities. Paragraphs 15 and 17 distinguish investing and financing cash flows; paragraphs 30–31 address interest. For a non-financial enterprise applying AS 3, interest paid is financing, while interest and dividends received are investing. A management subtotal may differ, but label the difference and reconcile it.
Use one cash perimeter throughout: identify the accounts, cash equivalents and currency balances included, reconcile them to books and bank reconciliations, and display restricted balances separately when assessing spendable liquidity. Undrawn borrowing capacity is not bank cash. A sanctioned limit may exceed the amount currently drawable.
Build the working paper from movements, not closing balances
| Bridge layer | How to prepare it | Control |
|---|---|---|
| Profit starting point | Use approved PBT or PAT; identify which one. | Do not add tax expense to PBT. |
| Non-cash and reclassification items | Add back relevant depreciation/provisions and remove investing gains. | Match each adjustment to the related balance movement. |
| Operating working capital | Analyse movements in receivables, inventory, operating payables and other operating balances. | Exclude capex creditors, loans, acquisitions and non-cash movements. |
| Tax and other cash items | Use actual payments and the chosen classification. | Avoid deducting both tax expense and the same tax payment. |
| Investing and financing | Use cash paid/received, with separate non-cash schedules. | Asset additions and borrowing increases are not necessarily cash flows. |
| Closing cash and liquidity | Opening cash plus reconciled movement equals closing cash. | Then distinguish restricted cash and usable facility headroom. |
Use the sign of the change: an operating asset increase generally absorbs cash; an operating liability increase generally releases cash. This rule works only after removing acquisitions, foreign-exchange effects, write-offs, reclassifications and other non-cash movements. Gross-versus-net receivables and provision treatment must be internally consistent.
Turn the bridge into decisions
For each large movement, report amount, owner, reason, expected reversal date and cash action. Separate a supported explanation from an assumption: new credit sales, delayed collections, inventory build, capex on credit and tax settlement require different responses. Compare the latest forecast with actual collections and payments, rather than attributing every working-capital increase to poor collection discipline.
Use three reconciliations before issue: profit agrees to the approved management P&L; balance movements agree to reconciled ledgers; closing cash agrees to the stated bank/cash perimeter. Unreconciled items should remain visible with an owner and resolution date, rather than being absorbed into miscellaneous cash flow.
Worked illustrations
These illustrations use fictional facts and expressly stated assumptions. Amounts are Indian rupees unless a different currency or unit is specified. They are independent examples, not findings about any actual client.
Illustrative example 1: A profitable month with only a small cash increase
Amounts in ₹ lakh. PBT 8.00 + depreciation 2.00 + finance cost 0.80 − asset-disposal gain 0.30 = 10.50 before working capital. Deduct receivables increase 5.00, inventory increase 2.50 and prepaid-expense increase 0.50; add operating-payables increase 1.80 and accrued-operating-expense increase 0.40. Cash generated is 4.70. Less income tax paid 1.20 gives operating cash 3.50. Investing cash is capex paid −4.00 + disposal proceeds 1.00 = −3.00. Financing cash is loan draw 5.00 − principal repayment 2.00 − interest paid 0.80 − dividend paid 1.50 = 0.70. Net increase is 1.20; opening cash 3.00 becomes closing cash 4.20. All balance changes here are cash-related and contain no revaluations, non-cash additions or consolidation changes.
Illustrative example 2: Do not count an expected-credit-loss charge twice
Opening gross receivables ₹30 lakh, credit invoices ₹59 lakh and collections ₹50 lakh give closing gross receivables ₹39 lakh. A new allowance of ₹2 lakh gives net receivables ₹37 lakh. In this isolated illustration, profit from these transactions is ₹57 lakh: revenue 59 minus allowance expense 2. A gross-balance bridge gives 57 + non-cash allowance 2 − gross receivable increase 9 = collections 50. A consistent net-balance bridge gives 57 − net receivable increase 7 = 50, without another allowance add-back. Mixing the net increase with the add-back incorrectly gives 52.
Illustrative example 3: Separate operating suppliers from capex creditors
Total payables increase from ₹14 lakh to ₹23 lakh, a ₹9 lakh increase. The ledger identifies ₹6 lakh operating-supplier increase and ₹3 lakh unpaid machinery. Only ₹6 lakh belongs in this operating-payables bridge. Machinery additions of ₹12 lakh, with nil opening capex creditors and ₹3 lakh closing capex creditors, mean ₹9 lakh capex paid, assuming no other movements. Adding all ₹9 lakh to operating cash while also using ₹9 lakh capex paid overstates total cash by ₹3 lakh.
Illustrative example 4: A fixed-asset addition need not use cash
Recognised asset additions are ₹20 lakh: ₹12 lakh acquired through a new non-cash lease, ₹3 lakh remaining unpaid to a supplier and ₹5 lakh paid. Cash capex in this simplified schedule is ₹5 lakh. Record the lease and creditor movements in the supporting non-cash reconciliation; do not report a fictional ₹12 lakh loan draw and ₹12 lakh cash purchase. Subsequent lease payments require their own classification under the applicable accounting framework.
Illustrative example 5: Reconcile GST on a gross-cash basis
Assume net credit sales ₹50 lakh, output GST ₹9 lakh, all ₹59 lakh collected, nil input GST and no other operating items. Opening output-GST liability ₹2 lakh + current GST ₹9 lakh − actual payment ₹7.50 lakh = closing liability ₹3.50 lakh. Net revenue 50 + liability increase 1.50 = operating cash 51.50, equal to collections 59 − GST paid 7.50. A bridge using net revenue but gross customer receipts must account for the GST movement once.
Illustrative example 6: Cash, restrictions and drawable headroom
Bank cash is ₹2 lakh, including ₹0.75 lakh restricted and unavailable for operations: spendable cash is ₹1.25 lakh. A CC sanction is ₹10 lakh and utilisation ₹7 lakh, but current drawing power is only ₹8 lakh; assume no other restriction. Usable undrawn headroom is min(10, 8) − 7 = ₹1 lakh. Available operating liquidity is therefore ₹2.25 lakh, while recorded bank cash remains ₹2 lakh. Do not add the full ₹3 lakh sanction headroom.
Illustrative example 7: Translate collection risk into a funding action
Take the ₹4.20 lakh closing-cash forecast from the first illustration. A scenario delays ₹6 lakh of collections, while ₹2 lakh of supplier payments can lawfully and contractually move to a later period. Scenario closing cash is 4.20 − 6 + 2 = ₹0.20 lakh. Against management’s assumed ₹1 lakh minimum buffer, additional funding or cash actions of ₹0.80 lakh are required. The buffer is a management assumption, and the supplier deferral is not permission to breach statutory or contractual payment obligations.
Ten-step verification table
| Step | Verification | Evidence to retain |
|---|---|---|
| 1 | Define entity, month, cash perimeter and accounting framework. | Approved scope and cash-account mapping. |
| 2 | Agree the starting profit to the latest closed P&L. | Versioned trial balance and management adjustments. |
| 3 | Reconcile every cash/bank account and restricted amount. | Bank reconciliations and restriction documents. |
| 4 | List non-cash and investing/financing profit adjustments. | Depreciation, provision and disposal schedules. |
| 5 | Reconcile gross/net receivables consistently. | Debtor and allowance roll-forwards. |
| 6 | Analyse inventory and operating-liability movements. | Inventory bridge and operating supplier schedules. |
| 7 | Remove capex creditors and non-cash asset additions. | Fixed-asset, lease and capital-creditor reconciliation. |
| 8 | Tie tax, GST, interest and debt payments to evidence. | Challans, bank entries and debt roll-forward. |
| 9 | Reconcile opening cash plus movement to closing cash. | Zero-difference bridge and exception list. |
| 10 | Assign cash actions and refresh the forecast. | Owner, action date, approved assumptions and scenario log. |
Sixteen practitioner FAQs
1. Should the bridge begin with EBITDA, PBT or PAT?
Any clearly defined starting point can work. PBT is used here; an EBITDA or PAT bridge needs different tax, interest and non-cash adjustments. Keep a reconciliation to the approved P&L.
2. Is a monthly MIS cash bridge compulsory under AS 3?
This monthly internal format is not prescribed by AS 3. Statutory cash-flow requirements and exemptions depend on the entity and reporting framework.
3. Why can EBITDA increase while cash falls?
Cash may be absorbed by collections, inventory, advance payments, tax, capex or debt service. Reconcile the movements before identifying the cause.
4. Should receivables include GST?
Use the actual ledger basis. If receivables are gross but sales are net, separately reconcile GST and relevant tax balances so receipts are counted correctly.
5. Can all provisions be added back?
Only with an appropriate movement analysis. Payments against opening provisions, reversals and balances included in working capital can otherwise be counted twice.
6. Is every creditor increase an operating cash benefit?
No. Capital creditors, financing balances and non-cash movements need separate treatment; even an operating increase may represent overdue payment risk.
7. How are assets bought on credit shown?
Reconcile asset additions to cash payments through opening/closing capital creditors and non-cash acquisitions. Use actual cash paid in the cash bridge.
8. Are loan proceeds revenue?
No. Cash borrowing proceeds are financing inflows and do not improve operating profit or operating cash generation.
9. Does an unrealised forex gain create cash?
No. Analyse its non-cash impact and separately reconcile exchange effects on foreign-currency cash balances where relevant.
10. Where should interest paid appear?
The examples follow AS 3 for a non-financial enterprise, where interest paid is financing. Reconcile to the policy required by the entity’s applicable framework.
11. Can cash equivalents be assumed to be freely available?
No. Review instrument eligibility, restrictions, liens and availability. Spendable liquidity may differ from the reported cash-and-equivalent perimeter.
12. Can undrawn CC be added to closing bank cash?
Show it separately as funding capacity, limited by drawing power and other actual restrictions. It is not cash until drawn.
13. Does a negative operating cash figure prove distress?
Not by itself. Planned growth, seasonal purchases or temporary settlements may explain it; assess persistence, funding and forecast reliability.
14. How should late accounting corrections be handled?
Issue a controlled revised bridge tied to the corrected P&L and balance sheet, and explain material changes. Do not leave the cash bridge on an obsolete version.
15. What should the promoter see first?
Opening and closing spendable cash, operating cash generation, the largest cash absorptions, usable funding and dated actions. Keep the detailed reconciliations available.
16. How is this different from a 13-week forecast?
The bridge explains actual historical cash movement. A forecast estimates future receipts/payments; actual bridge findings should improve its assumptions.
Conclusion
Issue the MIS only when profit, operating-balance movements and closing cash agree. Then convert the largest supported cash movements into dated collection, procurement, capex and funding actions.