A useful working-capital MIS shows how many days are tied up in receivables and inventory, how much supplier credit supports them, and which actions could release cash. The calculation is only reliable when each balance matches its denominator, tax basis and measurement period. A shorter cash-conversion cycle is an analytical signal, not proof of a larger bank balance or better profit.
This is a management financial-analysis guide checked on 23 October 2026, drawing on ICAI’s financial-management materials. Its base model is a trading business with identifiable credit sales, credit purchases and inventory cost. The proposed metrics are a documented MIS policy, not a claim that every entity must use these exact formulas for statutory Schedule III disclosures.
Publish the metric definitions next to the dashboard
ICAI’s Financial Analysis and Planning–Ratio Analysis chapter relates receivable collection periods to average daily credit sales and payable periods to average daily credit purchases. Its Introduction to Working Capital Management explains the operating-cycle components. Use those analytical foundations, then disclose the entity’s actual balance definitions and averaging method.
| Metric | Defined calculation for this MIS | Matching requirement |
|---|---|---|
| DSO: receivable days | Average relevant trade receivables ÷ credit sales × days in period | Exclude cash sales from the credit-sales denominator; match gross/net tax bases |
| DIO: inventory days for this trading model | Average relevant inventory at cost ÷ COGS × days in period | Use cost, not selling value; reconcile write-downs and excluded inventory |
| DPO: supplier-credit days | Average relevant trade payables ÷ credit purchases × days in period | Match the creditor population to purchases; do not substitute all expenses or COGS without justification |
| Cash-conversion cycle | DSO + DIO − DPO | Use consistent periods and definitions; explain differences in business model |
Annual examples below use 365 days as an expressly chosen management convention; the monthly example uses its stipulated thirty-day period. A 360-day policy can also be documented, but changing the day basis between periods creates a comparison problem. Preserve the unrounded calculations and round only the displayed result.
Choose averages that represent the business
Opening-plus-closing divided by two is simple but can miss a seasonal peak. A monthly or daily average can reveal the exposure carried during the period. State whether the dashboard uses average balances or closing balances: switching methods can make a collection improvement appear without any customer paying earlier.
For a manufacturing business, analyse raw-material, work-in-progress and finished-goods stages against appropriate consumption/production/sales cost flows. ICAI’s operating-cycle material treats these as separate components. Do not carry the simplified trader inventory denominator into every manufacturing stage, or add overlapping total-inventory and component cycles together.
Reconcile tax bases, credits and financing movements
A receivable ledger may include GST while revenue excludes it. Either produce a supported net-tax receivable exposure measure or use a consistent gross-invoice basis for the collection metric. Label the choice and reconcile it to books. A uniform-tax illustration is not a shortcut for a mixed-rate, exempt/export or credit-note-heavy portfolio.
Use the matching purchase population for DPO. Inventory movements, manufacturing conversion costs and cash purchases mean COGS and credit purchases can differ materially. Supplier finance, factoring, disputed balances and customer advances also need visible treatment; a reclassification should not silently become an operational improvement.
Translate target days into actions and a dated cash forecast
Estimate each cash-release component on its own supported daily flow: fewer debtor days against credit sales, fewer stock days against cost, and an agreed extension of supplier terms against credit purchases. Add the components after checking overlap. Multiplying the total cycle change by sales per day overvalues the cost-based components.
The ICAI receivables-management material discusses credit-policy decisions, while its payables-management material addresses the benefits and costs of supplier credit. Therefore, evaluate customer relationships, lost discounts, supply continuity and applicable payment obligations before selecting targets. A DPO target is not permission to withhold a payment that is legally or contractually due.
Assign each target an owner, an affected customer/SKU/supplier population and a collection or settlement date. Keep bad-debt write-offs, inventory write-downs and foreign-exchange movements separate from actual cash collections. Reconcile the eventual bank outcome with the forecast: reducing an accounting balance is not always a cash release.
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: Cash sales distort a credit-collection metric
Average relevant receivables are ₹30,00,000. Annual sales are ₹3,65,00,000, including ₹1,46,00,000 cash sales, so credit sales are ₹2,19,00,000. At 365 days, daily credit sales are ₹60,000 and DSO is ₹30,00,000/₹60,000 = 50 days. Using all sales gives 30 days and understates this defined credit-collection metric by twenty days.
Illustrative example 2: Match the GST basis of the numerator and denominator
Assume a uniform, correctly established 18% invoice tax solely for this illustration. Annual pre-tax credit sales are ₹3,65,00,000 and average pre-tax receivable exposure ₹30,00,000: DSO is 30 days. Gross receivables are ₹35,40,000 and corresponding gross annual billings ₹4,30,70,000; using both gross figures also gives 30 days. Dividing gross receivables by pre-tax sales gives a mismatched 35.4 days. An actual mixed-tax portfolio needs a supported reconciliation.
Illustrative example 3: Inventory cost and credit purchases are different flows
A trader has average inventory ₹48,00,000 and annual COGS ₹2,92,00,000. Daily cost is ₹80,000 and DIO is 60 days. Its matching credit purchases are ₹2,19,00,000 and average relevant payables ₹24,00,000: daily purchases ₹60,000 give DPO 40 days. Using COGS for DPO would produce 30 days, understating the defined supplier-credit period by ten days.
Illustrative example 4: Seasonal balances defeat a two-point average
Assume twelve equally weighted month-end receivable balances, in ₹ lakh, of 10, 10, 20, 30, 40, 50, 60, 70, 60, 40, 20 and 10. They total ₹420 lakh and average ₹35 lakh. With annual credit sales ₹365 lakh, this selected average produces DSO 35 days. Opening and closing balances both ₹10 lakh would give a two-point average of ₹10 lakh and DSO ten days. The monthly proxy exposes the peak; daily or time-weighted analysis may be preferable for the actual business.
Illustrative example 5: Match a monthly flow to monthly days
For a stipulated thirty-day reporting month, credit sales are ₹60,00,000 and average relevant receivables ₹12,00,000. DSO is ₹12,00,000/₹60,00,000 × 30 = six days. Applying 365 to the same one-month sales figure gives 73 days, which is a period mismatch. If the monthly flow were annualised consistently first, the same six-day result would be recovered.
Illustrative example 6: A 25-day cycle improvement does not equal 25 sales-days of cash
Baseline DSO/DIO/DPO are 45/60/30 days, giving a 75-day cycle. Targets of 35/50/35 give 50 days, an improvement of 25 days. Assume supported daily credit sales ₹1,00,000, daily inventory cost ₹80,000 and daily credit purchases ₹60,000. Potential release is 10 × ₹1,00,000 + 10 × ₹80,000 + 5 × ₹60,000 = ₹21,00,000. Using 25 × ₹1,00,000 would give ₹25,00,000, overstating the model by ₹4,00,000. Actual timing and legal payment obligations remain separate controls.
Illustrative example 7: A write-off can improve days without generating cash
For a closing-balance diagnostic, receivables of ₹30,00,000 against daily credit sales ₹1,00,000 show thirty days. A ₹3,00,000 bad-debt write-off reduces the balance to ₹27,00,000 and the diagnostic to twenty-seven days. Cash collected from that write-off is ₹0. Report the three-day movement as a non-cash balance reduction rather than customer collection performance; the averaging method must also remain clearly labelled.
Illustrative example 8: A negative cycle does not settle next week’s bills
Assume DSO five days, DIO twenty and DPO forty. The cycle is 5 + 20 − 40 = minus fifteen days. Nevertheless, if ₹10,00,000 of confirmed payments fall due next week, opening available cash is ₹2,00,000 and no collections or other funds arrive before those dates, the dated cash forecast shows an ₹8,00,000 shortfall. A favourable aggregate cycle cannot replace the payment calendar.
Ten-step verification table
| Step | Verification | Evidence to retain |
|---|---|---|
| 1 | Define the business model and dashboard purpose | Trader/manufacturer/service scope and metric policy |
| 2 | Fix the reporting period and day convention | Period dates and consistent 365/360/month-day basis |
| 3 | Reconcile receivable, inventory and payable populations | Ledger-to-MIS mapping and exclusions |
| 4 | Separate credit from cash sales and purchases | Transaction-level credit-flow schedules |
| 5 | Match GST and other tax bases | Gross-to-net bridge and declared metric convention |
| 6 | Choose and disclose the averaging method | Opening/closing, monthly or daily balance source |
| 7 | Recalculate DSO, DIO, DPO and the cycle without premature rounding | Formula workbook and exact calculation output |
| 8 | Separate operating changes from write-offs and reclassifications | Non-cash movement and financing bridge |
| 9 | Value targets using each matching daily flow and payment constraints | Owner-wise cash-release plan and due-date checks |
| 10 | Reconcile targets to dated bank cash outcomes | Collections, payments and rolling cash forecast |
Sixteen practitioner FAQs
1. Is DSO the same as overdue ageing?
No. DSO is a balance-to-flow measure; ageing tracks individual invoices against dates and credit terms. Use both in the collection discussion.
2. Should cash sales be included in this credit-DSO denominator?
Not under the definition adopted here. Match trade credit balances to the credit sales that generate them.
3. Must every dashboard strip GST from receivables?
No universal rule is asserted. Choose a consistent net-tax exposure or gross-invoice metric and reconcile it clearly to books.
4. Can mixed tax rates be removed by dividing every balance by 1.18?
No. The uniform-tax example is deliberately simplified. Actual mixed-rate, exempt and credit-note balances need transaction support.
5. Is DIO based on selling value?
The trader model uses inventory cost against COGS. Selling values introduce margins into a cost-holding measure.
6. Can DPO always use COGS?
No. Match payables to the corresponding credit purchases. COGS can differ because of inventory changes and conversion costs.
7. Does a manufacturer use the trader inventory model unchanged?
Not necessarily. Raw materials, work in progress and finished goods may need separate flow-based analysis.
8. Is opening-plus-closing always a sufficient average?
No. It can miss seasonal peaks or window-dressing. Select and disclose a more representative average where needed.
9. Must the year always be 365 days?
This guide adopts 365 for its annual examples. A different documented convention can be used consistently; the period and denominator must match.
10. Can a month’s sales be multiplied by 365 in the DSO formula?
Not without consistent annualisation. Use the days represented by the flow data or annualise the flow on the same basis.
11. Does a lower cycle guarantee more cash this month?
No. It is an aggregate analytical measure. Actual collections and due payments determine dated liquidity.
12. Can a write-off be reported as collection-led cash release?
No. Separate non-cash reductions and quantify actual bank receipts independently.
13. Is every extra payable day a saving?
No. Evaluate payment obligations, lost discounts, supplier relationships and continuity of supply before adopting a target.
14. Can cycle improvement simply be valued at sales per day?
Not reliably. Receivables, inventory and payables use different economic bases; compute component values and check overlaps.
15. Are these figures automatically the statutory Schedule III ratios?
No. They are expressly defined management metrics. Prepare and reconcile any separate statutory disclosure under its applicable framework.
16. How should a promoter act on the dashboard?
Assign customer, stock and supplier actions to named internal owners with target dates, then reconcile the planned release to actual cash outcomes.
Conclusion
Define and reconcile the data before judging the days. Convert operational targets into separate debtor, stock and supplier actions, then verify their actual cash effect against a dated forecast.