Answer in brief
A profitable order can consume cash before it releases cash. This guide calculates DIO, DSO and DPO, then extends the model for processor settlement, returns and supplier payment milestones.
Profit and cash answer different questions
An online store can book an attractive gross profit on an order while cash is still trapped in stock, settlement timing, returns or supplier payments. The cash conversion cycle is a working-capital lens that asks how long operating cash is tied up between paying for inputs and collecting from customers. In its common form, CCC equals days inventory outstanding plus days sales outstanding minus days payables outstanding: DIO + DSO − DPO. A shorter cycle generally means operating cash returns sooner, although the economically “best” cycle still depends on stock availability, supplier relationships and service levels.
IAS 7 requires entities in its scope to present cash flows by operating, investing and financing activities and explains why profit and cash movement need separate visibility. A small store may not report under IFRS, but the distinction is universal: accounting profit does not ensure liquidity at the moment bills are due. The CCC is a managerial metric rather than a replacement for a cash-flow statement. It simplifies timing and should sit beside a weekly or monthly cash forecast that includes taxes, payroll, advertising, debt service, capital spending and other items the standard cycle does not capture.
Inventory days usually create the first cash gap
Days inventory outstanding estimates how long inventory remains on hand before sale. A common formula uses average inventory divided by cost of goods sold, multiplied by the number of days in the period. For seasonal ecommerce, annual averages can hide peaks, so monthly or rolling measurements may be more useful. Inventory includes more than products visible on the storefront: goods in transit, safety stock and slow-moving variants can absorb cash depending on accounting and operational treatment. The store should reconcile the managerial inventory view with its actual books rather than invent a convenient denominator.
The operational drivers are order size, lead time, minimum quantities, forecast error, assortment breadth and replenishment reliability. Buying six months of stock may secure a discount yet lengthen the cash cycle and increase markdown risk. Buying too little can shorten inventory days but create stockouts and lost demand. The objective is not to minimize DIO at any cost. Segment stock by velocity and consequence, then ask how many days each category needs to support a chosen service level. Slow stock should be visible as a cash decision rather than buried inside a blended inventory average.
Receivable days in ecommerce can mean settlement, not invoices
Many consumer online stores collect card authorization at checkout, so classic trade receivables are much smaller than in invoice-based businesses. Cash may still arrive later because the payment provider settles on a schedule, with timing varying by provider, country, method, risk controls and banking days. For a managerial ecommerce model, DSO can capture the average time between recognized sale and cash becoming available in the operating bank account. If the store also sells wholesale on invoice, calculate that receivable stream separately because its collection behavior may be radically different.
Do not confuse authorization, capture and settlement. A payment can be authorized but not yet captured; captured funds can still be awaiting payout; a payout can then take time to reach the bank. The exact sequence depends on the payment stack. Reconcile processor balances to bank receipts and orders so “sales today” is not treated as “cash today.” Where platforms hold rolling reserves or otherwise delay access under their terms, model that separately if material rather than forcing every balance into one DSO figure. The purpose is to make cash availability visible, not to preserve a textbook label.
Supplier terms subtract financing days
Days payables outstanding estimates how long the business takes to pay suppliers, commonly using average accounts payable divided by cost of goods sold and multiplied by period days. Longer terms can reduce the cash cycle because suppliers are financing more of the operating period. But extending DPO by simply paying late is not a strategy. Late payment can damage supply reliability, lose discounts, breach contract terms or weaken negotiating position. Use agreed terms and actual payment behavior, then examine whether better terms can be negotiated based on order history, forecast quality or purchase commitments.
Supplier terms should be compared with lead time and sell-through. A 30-day payment term offers little working-capital benefit if goods must be paid before production and spend 45 days in manufacturing and transit. Conversely, partial deposits with final payment after shipment create a different cash pattern from a single due date. For meaningful planning, model the real milestones: deposit, balance, freight, customs where applicable, warehouse receipt and sale. The standard DPO remains useful as a summary, while the cash calendar explains why two suppliers with the same headline price can have very different liquidity effects.
Worked example: a profitable store with a 33-day cycle
Take an illustrative store with annualized cost of goods sold of $360,000, average inventory of $60,000, annualized sales of $720,000, average receivables or unsettled processor balances of $6,000, and average supplier payables of $30,000. DIO is about 60.8 days: $60,000 ÷ $360,000 × 365. DSO is about 3.0 days: $6,000 ÷ $720,000 × 365. DPO is about 30.4 days: $30,000 ÷ $360,000 × 365. The resulting illustrative CCC is roughly 33.4 days.
At average daily COGS of about $986, multiplying by 33.4 days suggests roughly $32,900 of operating cost tied up across the cycle as a rough planning intuition. It is not a balance-sheet identity and it ignores several cash items, but it makes the timing burden tangible. If sales double while DIO and DPO remain unchanged, the absolute working-capital requirement can rise sharply even if margins are stable. This is why a “profitable growth” month can drain the bank account: the store buys more inventory now while the cash generated by those goods returns later.
Returns create a second loop after the sale
Returns make ecommerce cash timing more complex than the classic formula suggests. A refund may occur after the original payout, creating a new cash outflow. Returned goods may spend days in transit and inspection before they can be resold, and some cannot return to full-price inventory at all. Payment disputes and chargebacks can create additional timing and fee effects according to provider and card-network rules. Rather than forcing every event into DIO or DSO, maintain an ecommerce cash bridge that starts with the standard CCC and then adds material return, refund, reserve and dispute timing.
Use the store’s own cohorts. For each order month, track gross sales, cancellations before fulfillment, returns by timing, refund date, recoverable inventory value and write-offs. A 10% return assumption can be useful in an illustrative stress test, but it should never be presented as a market norm without evidence. More important is whether the store knows its actual pattern by category. Apparel sizing, fragile goods and customized products can behave very differently. A blended return rate can hide the SKU family that absorbs cash for weeks after apparently successful sales.
Growth requires a working-capital forecast
Build a rolling cash forecast that starts with unit demand and translates it into purchase orders, deposits, supplier balances, freight, payment-provider settlement, refunds and operating expenses. Stress lead times and conversion rather than forecasting only revenue. The World Bank’s SME-finance work highlights working capital as a persistent financing need for smaller firms, and the SBA’s lending programs include working-capital uses in certain products. Those sources do not prescribe a store’s target cycle; they reinforce why access to liquidity matters when cash leaves before customer receipts fully return.
The most useful scenario is often the upside case. If demand jumps 50%, how much inventory must be ordered before the additional sales occur? Do supplier terms scale with the order, or does the deposit become larger? Can the processor payout schedule change under higher volume or risk review? What percentage of returns arrives after the next reorder? A company can survive a slow month and still be surprised by the cash needs of a fast one. Growth planning should therefore identify the maximum cash trough, not merely the projected month-end profit.
Reduce the cycle without damaging the business
Attack each component separately. For inventory, improve forecasting, reduce obsolete variants, negotiate smaller or more frequent replenishment, and distinguish safety stock from accidental overstock. For receivables and settlement, reconcile payment flows, reduce avoidable capture delays and understand payout timing by method and market. For payables, negotiate legitimate terms and align payment milestones with the inventory journey. For returns, improve product information, sizing or quality where data shows preventable causes, and accelerate inspection and restocking. Each intervention should have an owner and a measured cash effect.
Review CCC monthly and by meaningful segment, but pair it with gross margin, stockout rate, return losses and supplier performance. A shorter cycle achieved by cutting every slow-selling SKU could damage assortment economics; a longer cycle may be rational before a predictable seasonal peak. The question behind cash conversion cycle ecommerce analysis is not “how low can the number go?” It is “how much cash does this operating model require, when is the trough, and what controllable choices change it?” Once the store can answer those three questions, profitable orders stop being mistaken for immediately available cash. The discipline is especially valuable before seasonal buys, major promotions or international expansion, when timing assumptions can move faster than historical averages.
Practical checklist
- Calculate DIO, DSO and DPO from consistent accounting periods.
- Reconcile authorization, capture, processor balance, payout and bank receipt timing.
- Map actual supplier deposits, balances and freight milestones.
- Track returns by cohort, refund date and recovered inventory value.
- Build base, growth and delay scenarios for the next purchase cycle.
- Pair CCC improvements with margin, stockout and supplier-performance measures.
Questions and answers
What is the cash conversion cycle formula for an online store?
The common formula is days inventory outstanding plus days sales outstanding minus days payables outstanding: DIO + DSO − DPO. It estimates how long operating cash is tied up in inventory and receivables after accounting for supplier financing. In a card-first online store, receivable days may mainly represent payment capture and settlement timing rather than invoice collection. Returns, reserves, disputes and deposits can make the real cash path more complex, so use the standard metric alongside a detailed cash forecast.
Can an ecommerce store have good margins and still run out of cash?
Yes. Margin measures the economic spread between revenue and costs under the accounting definitions used; liquidity depends on when cash actually leaves and arrives. A fast-growing store may pay deposits for larger inventory orders weeks before the goods sell, while payment settlements and returns occur later. Payroll, tax and advertising can create additional timing needs. This is why management should forecast the cash trough under growth as well as report gross margin and profit. Financing needs can increase even when unit economics improve.
Should a store always try to minimize its cash conversion cycle?
No. A shorter cycle usually releases working capital sooner, but extreme optimization can create stockouts, weaker supplier relationships or an assortment that is too narrow. Extra safety stock may be rational before a reliable seasonal peak, and paying a supplier earlier can be worthwhile for a meaningful discount or supply priority. The goal is to understand the cash cost of each choice and compare it with the operational benefit. Track CCC beside margin, availability, return losses and supplier performance rather than treating it as a standalone target.