Cash-to-Cash Cycle for Distributors: DIO, DSO and DPO

The distributor's revenue grew 18% last year and the bank line is still maxed out every month-end. The warehouse turns look fine on the operations dashboard, the sales team says customers pay on time, and purchasing says suppliers are paid on terms. Nobody is wrong about their own number, but nobody has put the three together, so the cash the business needs to fund its growth is a surprise every quarter.

The cash-to-cash cycle joins those three numbers into one: days of inventory plus days of receivables, minus days of payables. Built from ledger balances with consistent tax treatment and period days, it tells a distributor how many days of cost it is financing and what each day is worth in dollars or rupees, which turns a vague working-capital worry into a target that warehouse, credit and purchasing can each move.

• What this guide covers: the definition and its Ind AS 1 context, where each input comes from, averaging and period choices, and the edge cases that distort each component.
• What it adds: a worked distributor dataset in USD and INR, the GST effect on DSO and DPO, supply chain finance and MSME payment limits, a month-end trace and a review checklist.

What the cash-to-cash cycle measures, and how Ind AS 1 frames it

The cash-to-cash cycle is the number of days between paying suppliers for stock and collecting cash from customers for it: DIO plus DSO minus DPO. For a distributor, which adds little conversion between buying and selling, it is the clearest single measure of how much working capital the trading model consumes.

Indian accounting already uses the underlying idea. Ind AS 1, paragraph 68, defines an entity's operating cycle as the time between the acquisition of assets for processing and their realisation in cash or cash equivalents, and assumes twelve months when the normal cycle is not clearly identifiable. Paragraph 70 notes that trade payables and some operating accruals are part of the working capital used in that cycle, so they stay current even if settled after twelve months.

Distributor finance teams compute the cash-to-cash cycle as DIO plus DSO minus DPO, using the inventory subledger, the receivables ledger and the payables ledger. Ind AS 1 paragraph 68 defines the related operating cycle and assumes twelve months where it is unclear; in the worked US example, each of 45 DSO days is worth $230,137.

The cash-to-cash cycle is the operating cycle shortened by the supplier credit the business receives. Ind AS 1 uses the operating cycle to classify balances as current or non-current; it does not require any company to report a cash-to-cash figure. The metric is a management measure, and the US has the same position: current-asset classification under US GAAP uses the operating-cycle concept, while the day counts are an internal analysis.

Where each input lives: subledgers, aging reports and the GL

Every component must come from a ledger balance that reconciles to the general ledger at month-end, not from an operations dashboard. Inventory value comes from the stock valuation report, receivables and payables from the subledger aging, and revenue and cost of goods sold from the period's income statement.

The last row is the one most often missing. If invoices have been sold to a bank or suppliers are being paid through a bank programme, the ledger balances alone do not show the business's true funding position. Treasury needs to report those balances alongside the cycle, for reasons covered further down.

Average balances, period days and the countback alternative

Use average balances over the measurement period and the actual number of days in it, and keep the same tax basis in numerator and denominator. Mixing a closing balance with an annual flow, or a tax-inclusive balance with a tax-exclusive flow, can move the result by a week without any change in the business.

Cash-to-cash cycle for a distributor (period of N days)

  DIO = Avg_Inventory_at_cost        / COGS_period        x N
  DSO = Avg_Trade_Receivables_net    / Revenue_net_period x N
  DPO = Avg_Trade_Payables_goods_net / COGS_period        x N
  C2C = DIO + DSO - DPO

  Avg_X        = mean of opening and month-end balances in the period
                 (or monthly balances, for a 12-month view)
  *_net        = balance excluding recoverable indirect tax
                 (India: GST charged on invoices; US: sales tax collected)
  Revenue_net  = revenue excluding GST or sales tax, after returns
  N            = calendar days in the period (365, 366, 91, 30 or 31)

  Value of one day:
  Day_DSO = Revenue_net_period / N
  Day_DIO = Day_DPO = COGS_period / N

Tolerance: recompute when any average moves more than 2% after
late closing entries; report C2C to one decimal place.

Some credit teams prefer countback DSO, which walks back through monthly sales until the receivables balance is used up and counts the days covered. It reacts faster to a recent sales spike than the average method and suits distributors with sharp seasonal peaks. Pick one method for each component, write it into the metric definition, and do not switch methods between months.

The two-per-cent recompute rule in the block is an internal choice, not a standard. Its purpose is to stop a metric being reported from a soft close and then quietly restated. Inventory-specific choices such as which cost measure to use for each warehouse are covered in our guide to inventory turnover and days on hand by warehouse; this article stays at the level of the whole distribution business.

A worked distributor in dollars and rupees, line by line

A US distributor with $84 million of sales runs a 69-day cycle, and an Indian distributor with ₹240 crore of sales reports 69.4 days that falls to 66.5 once GST is removed from receivables and payables. All figures are illustrative, including the blended 18% GST used to strip tax from the Indian balances.

Both businesses sell industrial consumables from stock. The US company's customers are mostly resellers buying on resale certificates, so its receivables carry little sales tax. The Indian company invoices with GST on every sale and receives GST-charged supplier invoices, so its ledger balances include tax that never appears in revenue or cost of goods sold.

The tax effect does not cancel. Removing GST cut DSO by 9.0 days but DPO by only 6.1 days, because receivables are larger than payables. Reported on the raw ledger, the Indian cycle looked about three days worse than it was, and a target set on that basis would have chased a tax artefact. The value-per-day lines are what turn the metric into a budget conversation.

GST, rebates and consignment stock that bend the ratios

Each component has a handful of predictable distortions, and most come from balances that sit in the right ledger account but do not behave like trade working capital. Clean them out, or at least disclose them, before comparing months or setting targets.

• Tax inside balances: GST in India and sales tax in the US sit in receivables and payables but not in revenue or cost; strip them from balances or gross up the flows, as the worked table shows.
• Unissued rebate credit notes: volume rebates owed to customers but not yet credited overstate receivables, so post the rebate accrual against receivables or adjust DSO for it.
• Supplier rebates receivable: amounts due from suppliers are not trade receivables from customers; keep them out of DSO and consider netting against payables only where the right of set-off exists.
• Consignment stock: goods held on a supplier's consignment are not the distributor's inventory, while the distributor's own stock at customer sites is, and both often sit in the same warehouse system.
• Goods in transit: purchases already owned but not yet received belong in DIO, and missing them at month-end flatters the cycle; our goods-in-transit cutoff guide covers the title tests.
• Freight and service payables: transport, warehousing rent and utilities payables are not goods payables; including them inflates DPO against a cost-of-goods denominator.

Reverse factoring and bill discounting: a shorter cycle on paper

Supplier finance programmes lengthen DPO and receivables discounting shortens DSO, and both can improve the cycle without changing how long the business actually takes to turn stock into cash. Report the cycle both with and without these facilities so the board sees which part of the improvement is financing.

US GAAP now requires buyers using supplier finance programmes to disclose them. ASU 2022-04 added Subtopic 405-50, requiring disclosure of the key programme terms and the confirmed amount outstanding for fiscal years beginning after 15 December 2022, with a rollforward of that amount from fiscal years beginning after 15 December 2023. The ASU changed disclosure only, not how the liability is recognised or measured.

Distributors that use reverse factoring should report DPO twice: once from the trade payables ledger and once excluding invoices already paid by the finance provider. ASU 2022-04 (ASC 405-50) requires buyers to disclose the confirmed outstanding amount, so a 10-day DPO gain from a programme should be visible to lenders.

Under IFRS, the IASB issued amendments to IAS 7 and IFRS 7 in May 2023 that add supplier finance disclosure requirements; Indian preparers should check that the Ind AS 7 and Ind AS 107 text currently notified by the Ministry of Corporate Affairs carries the same requirements. Separately, the IFRS Interpretations Committee's December 2020 agenda decision on reverse factoring discusses when such liabilities should be presented as trade payables or within borrowings, which Indian preparers often consult because Ind AS follows IFRS closely.

Receivables discounting works the other way round. Where invoices are sold without recourse and derecognised, DSO falls; when the facility lapses or is drawn on with recourse, the receivables return to the balance sheet and DSO jumps. The month-end trace below is that situation, combined with a rebate posting failure.

MSME payment law sets a ceiling on DPO in India

An Indian distributor cannot stretch payables to micro and small suppliers beyond 45 days from acceptance without consequences, so DPO targets must be set separately for those suppliers. The limit comes from the MSMED Act, 2006, which also charges interest on late payment and denies a tax deduction for that interest.

• Payment deadline: Section 15 of the MSMED Act requires payment on the agreed date, which in no case may exceed 45 days from the day of acceptance or deemed acceptance; without a written agreement, payment is due before the appointed day, the day after 15 days from acceptance.
• Interest on delay: Section 16 makes the buyer liable for compound interest with monthly rests at three times the bank rate notified by the Reserve Bank, overriding any contrary agreement.
• Interest never deductible: Section 23 of the MSMED Act disallows the interest payable under the Act as a deduction for income-tax purposes.
• Disclosure in accounts: Section 22 requires buyers whose accounts are audited to disclose principal and interest unpaid to such suppliers at year-end and interest paid during the year.

The protection applies to suppliers that meet the Act's definition, which requires the enterprise to have filed the registration memorandum the Act refers to, now done through Udyam registration. Tag those suppliers in the vendor master, compute their DPO separately, and hold their payment run to the 45-day limit. US federal law sets no general cap on payment terms between private businesses, so the comparable US control is usually contractual.

Nine days of DSO that appeared on one closing date

A sudden jump in DSO is usually an accounting event rather than a collections failure, and the review should check postings and facilities before calling customers. The trace below shows an illustrative quarter-end at the Indian distributor from the worked example.

1. 15 September, 18:00, facility lapse: the non-recourse bill discounting line used for two large dealer accounts expires pending renewal; ₹2.70 crore of new invoices raised after this date stay in trade receivables instead of being derecognised.
2. 30 September, 22:40, batch failure: the ERP job that converts approved quarterly volume rebates into credit notes stops on a tax-code error, leaving ₹3.20 crore of customer credits unposted.
3. 1 October, 09:30, flash report: receivables close ₹5.90 crore above plan; at ₹65.75 lakh per day of sales, DSO reads about nine days higher than the prior quarter.
4. 1 October, 15:10, review: the credit controller's aging shows no deterioration in overdue buckets; treasury confirms the lapsed facility, and the rebate batch error is found in the job log.
5. 3 October, 12:00, correction: credit notes post with the corrected tax code, the restated DSO is reported with the facility effect shown separately, and the facility renewal date is added to the month-end checklist.

Nothing in that trace involved a late-paying customer, which is why the first question at review should be whether any non-trade event moved the ledger. Ageing buckets are the quickest test: if overdue balances did not grow, the jump came from postings or financing, not from collections.

Cycle checks the ERP computes and where an analyst decides

The arithmetic, the tax stripping, the reconciliation to control accounts and the MSME payment clock should all be fixed calculations in the ERP or reporting layer. Interpreting a movement, deciding which balances are non-trade, and setting targets need a finance analyst working with operations.

Indian distributors should hold the MSMED Act Section 15 limit of 45 days from acceptance as a fixed due-date rule in the payables ledger, computed from the goods receipt date. Payments beyond it attract Section 16 compound interest at three times the RBI bank rate, and Section 23 bars deducting that interest for income tax.

A monthly cash-to-cash review that finance and operations sign

Report the cycle monthly with a rolling twelve-month view, show each component's owner and value per day, and separate financing effects from operating ones. The checklist below sets up that review so the number is trusted before targets are attached to it.

Start with the reconciliation and tax steps before any target is set, because a cycle that moves three days when the tax basis changes cannot support a bonus. Once the figure holds steady for three closes, attach value-per-day targets to each owner. More logistics finance and inventory guides are on our Logistics and Supply Chain hub.

If you are selecting an ERP, WMS or reporting platform and want these calculations and controls built in from the start, our RFP builder turns the checklist into requirements vendors must answer.