Working capital management is the job of keeping as little cash as possible tied up in receivables and stock, and paying suppliers on the agreed date rather than before it. It is measured with the cash conversion cycle: debtor days (DSO) plus inventory days (DIO) minus creditor days (DPO).
The formula is the easy part. A cycle of 75 days does not tell you which customer, which stock line or which vendor payment is holding the cash. This guide covers the measure, then the six places cash usually hides behind it, and a monthly routine for getting it back. It is written for a CFO or finance controller of a mid-size company or group on Tally or SAP.
If you want the working file rather than the explanation, start here:
| Need | Use this |
|---|---|
| DSO, DIO, DPO, the cycle and the cash released by a shorter one | Cash Conversion Cycle Calculator |
| Receivables by age band, to see what is behind the debtor days | Debtors Ageing Analyzer |
| Tests for vendor bills paid twice, and a recovery tracker | Duplicate Payment Test Kit |
| A monthly pack with a working capital page and an exceptions sheet | MIS Report Format Generator |
The cash conversion cycle formula
| Measure | Formula | What it tells you |
|---|---|---|
| DSO — days sales outstanding (debtor days) | Trade receivables ÷ revenue × 365 | How long customers take to pay |
| DIO — days inventory outstanding (inventory days) | Inventory ÷ cost of goods sold × 365 | How long stock sits before it is sold |
| DPO — days payables outstanding (creditor days) | Trade payables ÷ cost of goods sold × 365 | How long suppliers are funding you |
| Cash conversion cycle | DSO + DIO − DPO | The days of trading the business funds itself |
Use annual revenue and cost of goods sold with a 365-day basis, and state the basis. For a month-end review during the year, annualise the month's figures first. Balances can be closing or average, provided the same method is used every period — the trend means nothing if the method changes.
Worked example: an illustrative trading company, FY 2026-27
The figures are illustrative, in ₹ lakh, and are the ones the calculator opens with.
| This year | Last year | |
|---|---|---|
| Revenue | 14,600 | 12,775 |
| Cost of goods sold | 10,950 | 9,490 |
| Trade receivables | 2,400 | 1,925 |
| Inventory | 1,650 | 1,300 |
| Trade payables | 1,200 | 1,092 |
| Measure | Working, this year | This year | Last year | Change |
|---|---|---|---|---|
| DSO | 2,400 ÷ 14,600 × 365 | 60 days | 55 days | +5, worse |
| DIO | 1,650 ÷ 10,950 × 365 | 55 days | 50 days | +5, worse |
| DPO | 1,200 ÷ 10,950 × 365 | 40 days | 42 days | −2, worse |
| Cash conversion cycle | 60 + 55 − 40 | 75 days | 63 days | +12, worse |
Revenue grew by about 14%, and the profit and loss account will look healthy. The cycle says something else: customers are taking five days longer, stock is sitting five days longer, and suppliers are being paid two days sooner. All three moved the wrong way.
In money, the cash tied up in trade working capital is 2,400 + 1,650 − 1,200 = ₹2,850 lakh. Funded by a working-capital limit at 10% a year, that costs about ₹285 lakh in interest annually.
What a shorter cycle is worth. One day of DSO is one day of revenue: 14,600 ÷ 365 = ₹40 lakh. One day of DIO or DPO is one day of cost: 10,950 ÷ 365 = ₹30 lakh.
| Lever | Days | Cash released |
|---|---|---|
| Collect faster — reduce DSO | 10 | ₹400 lakh |
| Hold less stock — reduce DIO | 5 | ₹150 lakh |
| Pay on agreed terms, not early — extend DPO | 5 | ₹150 lakh |
| Total | ₹700 lakh |
The cycle falls from 75 to 55 days. The ₹700 lakh is released once; the interest saving of ₹70 lakh a year at 10% recurs for as long as the shorter cycle holds. This is arithmetic on the numbers entered, not a forecast. Whether ten days is achievable depends on what is behind the average — which is the rest of this guide.
Where the cash hides
The cycle is an average, and averages hide the problem. A DSO of 60 days can be most customers paying in 30 and a handful not paying at all. These are the six places to look.
1. Slow collections and unapplied receipts
Overdue invoices are the obvious part. The less obvious part is money already received and not matched: on-account receipts, unidentified bank credits, and TDS deducted by the customer and not yet booked. They sit as credits in one customer's ledger while invoices stay open, so the ageing overstates what is overdue and the collections team chases invoices that have been paid.
2. Credit notes not raised
Rate differences, short supplies, returns and scheme discounts that the customer has already deducted but for which no credit note has been raised. The receivable is not collectible, yet it stays in the ageing and in debtor days for months. Each one is also a dispute the customer uses as a reason to hold the next payment.
3. Slow and non-moving stock
Stock with no issue or sale for a long period, items bought in bulk for a price break, material for a discontinued product, goods at job workers and third-party warehouses. Inventory days rise slowly, a few items at a time, and nobody is asked about any single one.
4. Early and duplicate vendor payments
Paying a supplier on day 20 against 45-day terms is an interest-free loan from you to them. Paying the same bill twice is worse. Duplicates come from the same invoice entered with a variant number, two vendor codes for one supplier, or an advance followed by the bill paid in full; the duplicate payments guide explains the tests.
5. Advances never adjusted
Advances to suppliers that were not set off when the bill arrived, employee imprests and travel advances, security deposits that should have come back, and debit balances in creditor ledgers. They are cash already paid out, shown as assets, with no one responsible for recovering them.
6. GST credits blocked
Input tax credit that cannot be taken because the supplier's invoice has not appeared in GSTR-2B, credit that has to be reversed because the supplier was not paid within the time the GST law allows, and refunds filed and not followed up. All of it is cash paid to suppliers as tax and not yet recovered. The GSTR-2B reconciliation checker and the 180-day ITC reversal calculator help size it.
Where to look, and who owns it
| Leak | Where to look in Tally | Where to look in SAP | Owner |
|---|---|---|---|
| Overdue and unapplied receipts | Bill-wise outstandings and the ageing for sundry debtors; on-account entries | Customer open items; KNA1/KNB1 for the master | Head of sales for collection; accounts receivable for matching |
| Credit notes not raised | Customer ledger vouchers against the customer's own statement | Billing documents (VBRK/VBRP) against customer open items | Sales commercial |
| Slow and non-moving stock | Stock summary with the last movement of each item | Material documents (MKPF/MSEG, or MATDOC in S/4HANA) | Stores and the business head |
| Early and duplicate payments | Payment register against bill due dates; supplier invoice number on purchase vouchers | Payment runs (REGUH/REGUP) against due dates; invoices in RBKP | Accounts payable |
| Unadjusted advances | Debit balances in sundry creditors; advance ledgers by age | Vendor open items with advances | Purchase and accounts payable |
| Blocked GST credit | Purchase register against GSTR-2B | The same, from the purchase register extract | Tax lead |
Table availability differs between ECC and S/4HANA, and custom fields vary by implementation.
How to reduce debtor days
Reducing debtor days is mostly about removing the customer's reasons not to pay, not about chasing harder.
- Invoice on the day of dispatch, with the purchase order number, the correct GSTIN and the documents the customer's payables team needs. An invoice that is rejected restarts the clock.
- Apply every receipt within the week. Clear on-account balances and book the customer's TDS, so the ageing shows what is actually owed.
- Raise credit notes in the month the deduction is agreed. An open dispute on one invoice holds up payment on ten.
- Keep a dispute log with the invoice, the reason, the person resolving it and a date.
- Set credit limits and act on them. Decide in advance who can release an order for a customer over the limit or with overdue invoices — and record each release.
- Review the ageing by customer, not by total. Start with the largest overdue balances and the oldest band.
- Give collection to a named owner, usually the salesperson for the account, with finance reporting the result.
Debtor days computed from the books run slightly high, because receivables include GST and revenue does not. Keep the method unchanged and read the trend.
A word on creditor days: extending DPO means paying on the agreed date, not later. Payment terms to micro and small enterprise suppliers are limited by the MSMED Act, and delay has interest and tax consequences — see the MSME payment checker. Stretching suppliers is not working capital management.
A monthly review routine
| When | What | Owner | Output |
|---|---|---|---|
| Before month-end | Apply unidentified receipts; list credit notes due; list advances with no bill | Accounts receivable, accounts payable | Clean ledgers on the last day |
| Working days 1–3 | Run the ageing, the slow-moving stock list, the vendor ageing and the advances list | Finance controller | Four lists, each with last month's figure beside it |
| Working days 3–4 | Compute DSO, DIO, DPO and the cycle on the same basis as last month | Finance controller | Working capital page of the MIS |
| Working day 5 | Working capital review: top overdue customers, top slow stock, payments made before due date, open advances, blocked credits | CFO with sales, stores, purchase and tax | Each item gets one owner and one date |
| Through the month | Owners report closure; anything missed its date goes up a level | Item owners | Exceptions sheet updated |
| Quarterly | Duplicate payment tests on the full payment file; credit limits reviewed | Finance controller or internal audit | Recoveries tracked to receipt |
The discipline is the same as on the exceptions sheet of a monthly MIS: a name and a date against every line, carried forward until it is closed.
The natural next step is not to wait for month-end. A receivable crossing its credit period, a bill paid ahead of its due date or a stock item reaching ninety days without movement can each be raised on the day it happens, from every transaction rather than a sample — which is the idea behind CORAA's enterprise intelligence view. The monthly review remains where the decisions are made.
Working capital FAQ
What is working capital management?
Working capital management is controlling the cash tied up in receivables and inventory, and the credit taken from suppliers, so that the business funds as few days of trading as possible. In practice it means collecting on time, holding only the stock that moves, and paying on the agreed date.
What is the cash conversion cycle formula?
Cash conversion cycle = DSO + DIO − DPO. DSO is trade receivables ÷ revenue × 365, DIO is inventory ÷ cost of goods sold × 365, and DPO is trade payables ÷ cost of goods sold × 365. The answer is in days.
How do I reduce debtor days in 2026?
Invoice correctly on the day of dispatch, apply receipts and book customer TDS promptly, raise credit notes in the month a deduction is agreed, keep a dispute log, enforce credit limits, and give each overdue account a named owner. Most delay comes from disputes and paperwork rather than from customers unable to pay.
What is a good cash conversion cycle?
There is no single good figure; it depends on the business. A retailer selling for cash can run a very short or negative cycle, while a manufacturer selling on credit runs a much longer one. Compare the figure with the same business in earlier periods and with its own credit terms.
How much cash does one day of DSO release?
One day of DSO is worth one day of revenue — annual revenue divided by 365. On revenue of ₹14,600 lakh that is ₹40 lakh, so ten days releases ₹400 lakh once and saves the interest on it every year.
Is increasing creditor days a good way to improve working capital?
Only up to the agreed credit period. Paying early gives away cash, so paying on the due date is sound. Paying late costs supplier goodwill and discounts, and for micro and small enterprise suppliers the MSMED Act limits the credit period.
Related CORAA resources
- Cash Conversion Cycle Calculator
- Debtors Ageing Analyzer
- Duplicate Payment Test Kit
- MIS Report Format Generator
- Duplicate payment audit: how duplicates happen and the tests that find them
Sources
- Companies Act, 2013 — Schedule III, Ministry of Corporate Affairs — requires disclosure of the trade receivables, inventory and trade payables turnover ratios; days measures are the same information expressed in days
- Micro, Small and Medium Enterprises Development Act, 2006 — limits the period within which a buyer must pay a micro or small enterprise supplier