AWRA OpsHub Search

DSO Calculator

Measure how long customers take to pay — and what that delay costs in cash.

DSO is the distance between the sale and the cash. It is the one working-capital number that customers control and you only influence — which is exactly why it needs measuring monthly rather than admiring annually. Every day of DSO above your terms is an interest-free loan you did not agree to make.

Your numbers

value
value

Exclude cash sales — they never enter receivables.

days

Days sales outstanding

Average days between invoicing a customer and banking their payment.

Average daily credit sales
Receivables turnover

Updates as you type · nothing leaves your browser

The formula

DSO = (Accounts receivable ÷ Revenue) × Days in period

Compare the answer against your stated payment terms — the gap is your collections problem.

What it means

Accounts Receivable — full definition

Read in the glossary

How to use it

  1. 1

    Use credit revenue only. Including cash sales inflates the denominator and understates the real collection period.

  2. 2

    Match the receivables balance to the same period, ideally as an average of opening and closing rather than a single snapshot.

  3. 3

    Compare the result to your standard terms. Terms of 30 days with a DSO of 42 means 12 days of unplanned financing.

Where it goes wrong

  • DSO is an average, so a few very large late accounts can hide behind a mass of prompt small ones. Read it next to an aged receivables report, never instead of one.

  • A sharp fall in DSO right after a sales slump is arithmetic, not improvement — the denominator moved.

Worked example

Twelve days beyond terms

Receivables of 480,000 against 3.6m of annual credit revenue gives daily sales of 9,863 and a DSO of 48.7 days. On 30-day terms, that is nearly 19 days of drift — about 185,000 of cash sitting in other people's bank accounts, financed by yours.

Common questions

What is a good DSO?

Terms plus five days is a realistic target for most B2B operations. The absolute number matters far less than the gap between DSO and your own stated terms.

Should overdue invoices be excluded?

No — they are precisely what you are measuring. Excluding them produces a number that says nothing about collections.

How do I reduce DSO quickly?

Invoice on the day of delivery, chase before the due date rather than after, and put credit limits behind order release. Most DSO drift starts with late invoicing, not with unwilling customers.

Let AWRA do this on your live data

This calculator works on one set of numbers. AWRA OpsHub keeps dso calculator results current across every item, supplier and location — automatically.