Planning ahead

Cash conversion cycle

How long a euro spent on stock takes to come back as cash.

Formula

Cash conversion cycle = Days inventory outstanding + days sales outstanding − days payables outstanding
The short answer

The cash conversion cycle is the number of days between paying a supplier for stock and getting the money back from customers: days the stock sits, plus days customers take to pay, minus the days the supplier gives you to pay. The longer it is, the more cash a growing store needs.

Days inventory outstanding is how long stock sits before it sells: the average stock at cost divided by the cost of goods sold per day. Days sales outstanding is how long customers take to pay, which for a shop paid by card is the few days until the payout. Days payables outstanding is how long the supplier lets you wait: below zero when you pay on order, because the money leaves before the goods arrive, and thirty when you pay thirty days after delivery.

Worked through on the store the inventory turnover calculator opens with, stock sits about 70 days. With card payouts a few days after each sale and a supplier paid on arrival, the cycle comes to a little over ten weeks: every euro put into stock is away that long before it comes back.

That is the arithmetic behind a familiar complaint, profitable on paper, no cash in the bank. Growth makes it worse, because every reorder is sized for future sales and paid before them, and VAT runs a calendar of its own: the VAT inside this month's sales leaves with the next return, on a date the tax office sets.

The levers are the three terms of the formula: hold less stock for the same sales by ordering smaller batches more often, get paid faster, and pay suppliers later. Supplier terms are usually the cheapest to change: moving from paying on order to paying thirty days after arrival shortens the cycle by the whole lead time plus a month.

The Forecast page in nouz shows the cash side of it on the Stock & cash tab: a cash plan by month, with stock paid on your supplier terms, all on order, 30% on order and 70% on arrival, all on arrival or 30 days after arrival, and the VAT return on its own date. The ecommerce cash flow forecast template lays out the same rows week by week for a spreadsheet.

Where it lives in nouz. The Forecast page, Stock & cash tab: the cash plan by month, with supplier terms and the VAT return.

Questions

Cash conversion cycle, answered.

How do you calculate the cash conversion cycle?
Add days inventory outstanding, how long stock sits, to days sales outstanding, how long customers take to pay, and subtract days payables outstanding, how long your supplier lets you wait.
What is a good cash conversion cycle for an online store?
The shorter the better, and the trend matters more than the level: a cycle that lengthens as the store grows means growth will need more cash every month.
How do supplier terms change it?
Directly. Paying on order instead of thirty days after arrival lengthens the cycle by the lead time plus a month, and every extra day is cash the store has to find before the stock sells.

See this on your own store, every morning.

nouz installs from the Shopify App Store, where the listing is in review. It builds your whole statement from your own orders, refunds and costs, every night, and imports every order your store has ever taken.

Your trialToday
14 days of nouz, every feature€0,00
Card needed to startNone
Access to your storeRead-only
Due today€0,00