DSO calculator: how much of your DSO is actually fixable?

Why the gap is the number that matters

A DSO of 34 days means nothing on its own. If you sell on NET-30 it is close to excellent. If you sell on NET-7 it is a serious problem. The figure conflates two completely different things: the credit you deliberately extend, and the credit your customers take without asking.

Best Possible DSO separates them. It recalculates your DSO using only receivables that are still within terms, which gives you the DSO you would have if every customer paid exactly on time. The measure comes from The Hackett Group, and the useful part is not the number itself but the subtraction: actual DSO minus Best Possible DSO is the portion of your cycle that your payment terms do not account for.

That distinction matters commercially because the two halves have different remedies. The terms half can only be changed by renegotiating with customers, which is a sales conversation with a real competitive cost. The gap half needs no customer agreement at all. It exists because invoices were chased late, chased inconsistently, chased to the wrong contact, or paid and never applied.

A useful sanity check

You may notice the cash locked up equals your overdue balance exactly, that is, total receivables less current receivables. That is not a coincidence and it is not a trick. It is the same quantity expressed two ways: the gap in days is what you benchmark and report, the balance in money is what you actually finance. If the two did not reconcile, one of them would be wrong.

How DSO is calculated

Use credit sales rather than total sales. Including cash sales inflates the denominator and understates DSO, because those sales never became receivables.

How Best Possible DSO is calculated

Current receivables means invoices not yet past their due date. Everything overdue is excluded, which is precisely what makes the comparison meaningful.

Worked example

Before you act on the number

Check your unapplied cash first. DSO is computed from the ledger, not the bank, so a payment that arrived but was never matched to its invoice leaves that invoice open and still aging. If your cash application is behind, part of the gap this tool just showed you is fictional: the money is already in the bank and only the paperwork is late. Disputed invoices and unissued credit notes distort it the same way, and all three need a different response from genuine lateness.

For scale, The Hackett Group’s 2025 US working capital research attributed a large share of the excess working capital held by big companies to exactly this kind of gap, finding an 18 day spread in DSO between top-quartile and median performers. The difference between good and average collections is measured in weeks of cash.

What actually closes the gap

Nothing about the gap requires a harder conversation with customers. It closes through consistency: contact before the due date rather than after, escalation that changes channel instead of only tone, disputes routed out of the chase sequence to whoever can actually resolve them, and payments applied the day they arrive so invoices stop aging once they are paid.

Every one of those is a scheduling and follow-through problem rather than a judgement problem, which is why it degrades so reliably as invoice volume grows and why it is the part of receivables that software genuinely moves. Finero runs that cycle autonomously, on your existing payment provider and posting back to your existing ERP. If you want the manual version first, the guide to reducing DSO without hiring covers the same ground with no product in it.

DSO calculator: common questions