The Three Invoice Numbers That Tell You Cash Flow Is About to Break
Most small businesses discover a collections problem the same way: the bank balance is lower than the spreadsheet said it would be, and nobody can explain the gap without opening four tabs. Revenue looked fine. The pipeline looked fine. The money simply was not there.
Cash flow rarely breaks in a single dramatic event. It erodes — one invoice that slipped thirty days, one client who always pays "after the next funding round", one disputed line item nobody chased. By the time it is visible in the bank account, the problem is months old.
Three numbers catch that erosion early, and all three can be calculated from invoices you already have. No dashboard subscription, no accountant, no benchmarking data you cannot verify.
Why revenue is the wrong number to watch
Revenue measures work you have done. Cash measures work you have been paid for. A business can double revenue and still run out of money, because every new client adds a payment cycle you have to fund.
Profit and loss statements also smooth everything into a monthly figure. They cannot tell you that one client represents a third of your receivables, or that your average payment time has drifted from 21 days to 38 over two quarters. Those are the details that decide whether you make payroll in February.
Metric 1: Days sales outstanding
DSO answers one question: on average, how many days does it take to turn an invoice into cash?
The standard formula, for a period:
DSO = (average accounts receivable ÷ total credit sales) × number of days in the period
Average receivables means the opening balance plus the closing balance, divided by two. Use credit sales only — anything paid at the counter is not sitting in receivables.
A worked example. Over 90 days you invoice $160,000. Receivables were $40,000 at the start and $56,000 at the end, so average receivables are $48,000.
(48,000 ÷ 160,000) × 90 = 27 days
Now compare that to your stated terms. If you invoice on net 14 and DSO is 27, your real terms are twice what your paperwork says, and every forecast built on "net 14" is wrong by thirteen days of working capital.
DSO is a lagging average, which is its weakness. It moves slowly, so it will not warn you about the invoice that went bad last week. It is still the right number for tracking direction quarter over quarter.
Metric 2: Overdue rate — and the number hiding inside it
DSO tells you the average. Overdue rate tells you how much of the outstanding balance is already late.
Overdue rate = value of invoices past due ÷ total outstanding receivables
Two businesses can both sit at 30% and be in completely different situations. In one, the late money is five invoices at four days overdue. In the other, it is one invoice at ninety days and two at sixty. The second business has a collection problem; the first has a timing blip.
So calculate a second figure alongside it:
Weighted average days overdue = Σ (invoice value × days overdue) ÷ Σ invoice value
That single number resists the most common self-deception in receivables: a healthy-looking overdue rate held up by a large volume of small, slightly-late invoices, while the three invoices that actually matter quietly age out.
Metric 3: Aging concentration
Sort every unpaid invoice into buckets — current, 1–30 days late, 31–60, 61–90, 90+. Then look at two ratios:
- Share of receivables in the 60+ bucket. This is the money most likely to become a write-off. A small share is normal; a growing share is a trend.
- Share of receivables held by your largest client. If one customer is more than roughly a quarter of your outstanding balance, their payment behaviour is your cash flow, and you have no diversification.
Neither ratio needs a benchmark to be useful. Your own trend over three months is the comparison that matters, because collection norms differ wildly by industry, contract size and whether your customers are consumers or procurement departments.
What the numbers cannot tell you
Three limits worth knowing before you build a ritual around them:
They do not distinguish a dispute from forgetfulness. A disputed invoice needs a conversation about the work. A forgotten one needs a reminder. Same bucket, opposite fixes, which is why you should tag disputed invoices separately rather than letting them inflate your overdue rate.
They will not fix weak terms. If your invoices have no due date, DSO is measuring your own ambiguity. No metric repairs a document that never told the client when to pay.
Averages hide the tail. One invoice at 120 days can be invisible in a 24-day DSO and still be the thing that hurts. Always read the aging report next to the average.
The 15-minute weekly review
Metrics only work if the underlying data is current, and payment status is the field people stop updating first. Once a week, same day, same time:
- Mark every invoice paid, unpaid or partially paid. Partials matter — an invoice half-paid is not paid.
- List what is overdue, sorted by days late, not by value.
- Circle the three oldest. Those get an action today, not a note.
- Move disputed invoices to their own list with one line on what is disputed.
- Note anything that changed since last week: a new large invoice, a client who suddenly went quiet.
Fifteen minutes, five checks, one page. Do it for a quarter and you will know your real payment cycle better than most accountants who see your books twice a year.
Where the numbers come from
The arithmetic is trivial; the discipline is keeping status accurate. That is easier when the payment record lives beside the document rather than in a separate spreadsheet that drifts out of sync.
One example of that pattern: Invoice Maker, a free-to-download iOS and Android app from Caractiv Tech, records paid, unpaid and partially paid status against each invoice, reuses saved clients and line items, and supports 34 currencies — which matters for reporting, because a receivables total mixing currencies is not a number, it is a guess. Manual invoicing works offline; the AI drafting, which turns a typed description or voice note into an editable draft you review and confirm, needs a connection. Premium templates and branding sit behind a subscription.
Start with one number
Pick DSO. Calculate it for the last quarter, then for the quarter before. If it moved by more than a few days in the wrong direction, you do not have a cash problem yet — you have a warning. That is the entire point of measuring: to get the warning while it is still cheap to act on.
Disclosure: I work with the team behind the app mentioned above. This article is general business information, not accounting, tax or legal advice; how you recognise revenue and report receivables depends on your jurisdiction and entity type, so confirm specifics with a qualified professional.
Get Invoice Maker
- Official website: https://invoicemaker.caractiv.com/?utm_source=content&utm_medium=article&utm_campaign=invoice_maker_202611
- App Store (iPhone/iPad): https://apps.apple.com/app/id6756495015
- Google Play (Android): https://play.google.com/store/apps/details?id=com.caractiv.invoicemaker
Appendix: distribution assets (not part of the article body)
Social summaries
X: Revenue is the number everyone watches. It is also the one that tells you least about whether you can make payroll. DSO, overdue rate, and aging concentration — three formulas, one 15-minute weekly review.
LinkedIn: A healthy-looking overdue rate can hide a dying business. If 30% of your receivables are late, that number means something very different when it is five invoices at four days versus one invoice at ninety. The fix is to read three numbers together: DSO for direction, weighted days overdue for severity, aging concentration for risk. All three come from invoices you already have.
dev.to: Wrote up the three receivables metrics I actually use, with the formulas and a worked example. The interesting part was not the math — it was realising DSO had drifted from 21 to 38 days across two quarters and nobody noticed because the monthly P&L looked fine.
Image suggestion
Concept: A simple three-panel dashboard sketch on paper beside a phone showing a list of invoices with mixed paid/unpaid status chips; one panel labelled DSO with an arrow drifting upward, hand-drawn aging buckets current → 90+.
Alt text: Hand-drawn receivables dashboard showing DSO, overdue rate and aging buckets beside a phone invoice list.
Notes: 1200×800 blog header, 1080×1080 for LinkedIn. If a screen is shown, use fictional data ("Sample Client", "INV-0042") and no real bank details.
Top comments (0)