Thred

DSO: how to calculate days sales outstanding, the count-back method, and how to reduce it

Manoj Tutika · Published 17 November 2026 · Last checked 17 November 2026

Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.

Book a demo

What is DSO?

Days sales outstanding, or DSO, is the average number of days it takes customers to pay you. It turns the debtors balance into a time measure, which makes it comparable from month to month even as sales grow. UK finance teams often call the same idea debtor days; the definitions are in our glossary entry on days sales outstanding.

A rising DSO means cash is staying with customers for longer. Every extra day is a day of sales you have earned but cannot spend.

The DSO formula

The standard calculation is:

DSO = trade debtors ÷ credit sales for the period × number of days in the period

Three choices decide whether the number means anything.

  • Credit sales only. Leave out cash and card sales paid at the time of sale. They never create a debtor, so including them makes DSO look better than it is.
  • Match VAT on both sides. Your debtors balance includes VAT, because customers owe you the full invoice. Your sales figure in the Profit and Loss excludes it. Divide a gross number by a net one and DSO is overstated by the VAT rate. Either gross up sales or strip VAT out of debtors.
  • Pick the period and stick to it. A quarter or 12 months smooths out the noise of a single big invoice. A single month is volatile, and the result moves with the number of days in it.

A worked example: the standard method

A UK wholesaler on 30-day terms wants its DSO for the quarter to 30 September 2026. July to September has 92 days.

Inputs for Q3 2026 (£)
ItemAmount
Trade debtors at 30 September, including VAT180,000
Credit sales July to September, excluding VAT375,000
Credit sales July to September, including 20% VAT450,000
Days in the period92

DSO = 180,000 ÷ 450,000 × 92 = 36.8 days.

Had the team used net sales, the answer would be 180,000 ÷ 375,000 × 92 = 44.2 days. Same business, same customers, 7.4 days worse, purely because of VAT. If some of your customers are outside the scope of UK VAT, gross up only the sales that carry it.

The count-back method

The standard formula assumes sales were even across the period. If they were not, for example because September was much bigger than July, the count-back method gives a truer answer. You start from the debtors balance and count back month by month until it is used up.

Count-back DSO at 30 September 2026 (£, including VAT)
MonthGross credit salesDebtors left to coverDays counted
September160,000180,000 - 160,000 = 20,000 left30 (whole month)
August150,00020,000 ÷ 150,000 of August's 31 days4.1
Total34.1

The debtors balance of £180,000 covers all of September's £160,000 of sales and £20,000 of August's. That is 30 days plus 4.1 days of August, so count-back DSO is 34.1 days.

Count-back gives the lower figure here because sales rose through the quarter. A growing business that uses the standard method can look as if it is collecting more slowly when it is not. Pick one method, write down which, and use it every month.

Best possible DSO and days overdue

DSO mixes two things: your payment terms and how late customers pay. Splitting them tells you where to act.

Best possible DSO uses only debtors that are not yet due. In the example, £140,000 of the £180,000 is not yet due: 140,000 ÷ 450,000 × 92 = 28.6 days. That is roughly what DSO would be if every customer paid exactly on time.

The gap, 36.8 − 28.6 = 8.2 days, is the average days delinquent. That part is down to collection. The 28.6 days is down to your terms and invoicing. A business with a big gap needs better chasing; a business with a high best possible DSO needs shorter terms or faster invoicing.

What is a good DSO?

It depends on your terms. Compare DSO with your standard payment terms: a business on 30-day terms with a DSO of 36.8 days is collecting about a week late on average.

Be careful with published benchmarks. Industry averages mix companies with very different terms and sales patterns, so your own trend, measured the same way every month, is the better guide. For context on the other side of the relationship, GOV.UK's statistics on large businesses' payment practices show they took an average of 32 days to pay suppliers in 2025, with 15% of invoices paid late.

How to reduce DSO

  • Invoice on the day of delivery. Every day between delivery and invoice adds a day to DSO. Monthly batch invoicing on 30-day terms can stretch real collection to 60 days.
  • Get the invoice right first time. Include the PO number, the customer's reference and the right contact. Wrong invoices go into a queue and come back after the due date.
  • Remind before the due date. A pre-due reminder catches invoices stuck in approval while there is still time.
  • Chase on a fixed schedule. Reminders on set days after the due date, with a phone call in the first week, beat chasing when someone has time. The credit control process for small businesses has a day-by-day schedule.
  • Make paying easy. A payment link or direct debit on the invoice removes a step for the customer.
  • Resolve disputes fast. An invoice in dispute will not be paid. Log disputes and close them weekly.
  • Review terms. If best possible DSO is high, shorter terms for new customers or deposits on large orders move the number more than any amount of chasing.
  • Use your statutory rights. Telling customers you will apply Late Payment Act interest and compensation changes who gets paid first. See Late Payment Act interest: how to calculate and claim it.

What a lower DSO is worth

Cash tied up in debtors equals daily credit sales times DSO. In the example, annual gross credit sales run at £1,800,000, or £4,931.51 a day. Cutting DSO from 36.8 to 29.8 days releases 7 × £4,931.51 = £34,520.55 of cash, once, and keeps it released for as long as the lower DSO holds.

Tracking DSO every month

Calculate DSO from the same report each month, on the same basis. In Xero that means the aged receivables report at month end and the sales figure for the period; see the aged receivables report in Xero. Plot it next to best possible DSO so you can see whether terms or collection moved.

Thred's agents calculate DSO and best possible DSO from the live ledger in Xero, Exact Online or Moneybird, on a basis you set once, and the credit control agent works the overdue list behind the gap. The finance lead sees the trend and the invoices driving it in one place.

Frequently asked questions

How do you calculate DSO?

Divide trade debtors at the end of the period by credit sales for the period and multiply by the number of days in the period. For example, £180,000 of debtors and £450,000 of credit sales over 92 days gives a DSO of 36.8 days.

Should DSO use sales including or excluding VAT?

Match the debtors balance. Debtors include VAT, so use VAT-inclusive credit sales, or strip VAT out of debtors. Mixing a gross debtors figure with net sales overstates DSO by the VAT rate.

What is the count-back method for DSO?

You start with the debtors balance and subtract each month’s gross credit sales, working backwards, counting the days covered until the balance is used up. It reflects uneven sales better than the standard formula.

What is a good DSO?

One close to your payment terms. A business on 30-day terms with a DSO of 37 days is collecting about a week late on average. Track your own trend on a consistent basis rather than relying on broad industry averages.

Is DSO the same as debtor days?

Yes, in practice. Both measure the average number of days customers take to pay. You will see both terms used in the UK.

How can I reduce DSO quickly?

Invoice on the day of delivery, send a reminder before the due date, call overdue customers in the first week, resolve disputes promptly and tell customers you will apply statutory late payment interest.

Sources

  1. AccountingTools, Days sales outstanding calculation
  2. GOV.UK, Large businesses’ payment practices and performance statistics 2025: commentary
  3. GOV.UK, VAT rates
  4. GOV.UK, Late commercial payments: charging interest

Read next

Where Thred comes in

Finance Leaders

For finance leaders who want more capacity without more headcount.

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo