How many days is your cash tied up?
Five numbers from your books give you DSO (how long customers take to pay), DPO (how long you take to pay suppliers), DIO (how long stock sits) and the cash conversion cycle that joins them. Nothing you type leaves this page.
The numbers already in the boxes are an example. Type over them.
Want the names behind the DSO?
The free aging report takes your invoice export and shows which customers are late, by how much, and who to call first.
Want these numbers every morning, without the spreadsheet?
I connect your books read-only, check the figures against your own totals, and send one page before you start work: who paid, who is late, and how the cash cycle moved. A free 30-minute look shows what your systems could answer today.
The formulas
DSO = customers owe you ÷ sales × days
DPO = you owe suppliers ÷ cost of goods sold × days
DIO = stock ÷ cost of goods sold × days
cash conversion cycle = DSO + DIO − DPO
The cycle is the number of days between paying for something and being paid for it. In the example, stock sits for 45 days and customers take 45 more to pay, while suppliers are paid after 30. Cash is tied up for 60 days.
How to read them
Compare DSO with the terms you give customers and DPO with the terms suppliers give you. A DSO well above your terms means customers pay late. A DPO well below your suppliers' terms means you pay earlier than you need to.
A shorter cycle means less cash is needed to run the same sales. The three ways to shorten it are to collect sooner, hold less stock, and pay on the due date and not before.
Questions
Where do I find these numbers?
Sales and cost of goods sold are on the profit and loss report for the period. What customers owe, what you owe suppliers and stock are on the balance sheet as of today.
We do not hold stock. Does this still work?
Yes. Leave stock empty and the cycle is DSO minus DPO.
Should DPO use purchases or cost of goods sold?
Both are used. Cost of goods sold is the common choice because every business has it on the profit and loss report, and it is what this calculator uses.
Is anything I type sent anywhere?
No. The arithmetic runs in your browser.
Who made this?
Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools.