Planning ahead

Cash conversion cycle

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

Updated

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.

In nouz the stock half of the cycle is on Insights, Inventory: Inventory turnover, which turns into days in stock when 365 is divided by it, and Cash in overstock, the money in stock beyond what the coming months will sell. The Forecast page gives the profit side of a cash flow plan, every month ahead with its EBITDA, its cost of goods and the VAT in its sales on their own lines. Supplier terms and payout days stay with you, and the ecommerce cash flow forecast template lays out the whole cycle week by week for a spreadsheet.

Where it lives in nouz. Not a figure of its own. Insights, the Inventory tab gives the stock half as Inventory turnover; the Forecast page gives each month's profit, cost of goods and VAT, where a cash flow plan starts.

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.

Install nouz in minutes from the Shopify App Store. 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