Skip to content

Tools and templatesFree tool

Debtor Days Calculator

How long do your customers take to pay? Enter what they owe today, your sales on credit for the last 12 months and your payment terms to get debtor days, how far they run beyond your terms, and the cash waiting in your customers' accounts instead of yours. No sign-up, and your figures stay in your browser.

Example figures for an illustrative company. Replace them with yours, from the balance sheet and the last 12 months of sales.

Currency
€1.15m

Trade debtors, from the balance sheet or the aged debtors report

€8.00m

Include VAT here if the debtors figure includes it

Use the terms most of your sales are on, such as 30

Debtor days
52 days
How long customers take to pay, on average
Against your terms
+22 days
Slower than your 30-day terms
Cash waiting beyond terms
€492,466
What would come in if customers paid on terms
Each 10 days faster
€219,178
Brought into the bank once, and kept

Customers pay in 52 days, 22 days slower than your terms

Debtor days against payment terms, days

€1.15m owed against €8.00m of credit sales a year is 52 days of sales waiting to be paid. Collected on 30-day terms, €492,466 more would be in the bank today, without a single extra sale.

A few large accounts usually explain most of the gap: start with the aged debtors report, by customer.

How the calculator works

Debtor days, also called days sales outstanding (DSO), is trade debtors divided by credit sales for the last 12 months, multiplied by 365. It says how many days of sales are waiting to be paid. Set against the terms on your invoices, the gap is how much slower than agreed your customers pay.

  • Debtor days is what customers owe divided by a day's credit sales.
  • Against your terms is debtor days less your payment terms.
  • Cash waiting beyond terms is those extra days times a day's sales: what would be in the bank if every customer paid on time.

In the example, an illustrative company sells €8.00m a year on 30-day terms and is owed €1.15m. Debtor days are 52, so customers pay 22 days late on average, and about €490,000 that should already be in its bank is still in its customers'. Each ten days faster brings in about €219,000, once.

Stratavor connects read-only to Xero, QuickBooks Online, Sage, NetSuite, Deltek Vantagepoint and HubSpot and computes debtor days in code from the ledger every month, with the overdue balance and the customers behind it, so the trend is in front of the board without anyone rebuilding it.

Frequently asked questions

What are debtor days?

The average number of days your customers take to pay. It is trade debtors divided by credit sales, multiplied by 365. Compare it with the terms on your invoices: the gap is how much slower than agreed your customers pay, and each day of it is a day's sales waiting in their bank instead of yours.

How do I calculate debtor days?

Take trade debtors from the balance sheet or the aged debtors report, and credit sales for the last 12 months from the profit and loss. Divide debtors by sales and multiply by 365. If your debtors include VAT, include VAT in sales too, or the result runs about a fifth too high. A business with €8.00m of credit sales and €1.15m owed has debtor days of 52.

Are debtor days the same as DSO?

Yes. Debtor days is the usual name in Ireland and the UK; days sales outstanding (DSO) is the usual name in the US. The formula is the same.

What is a good debtor days figure?

Close to your own payment terms. On 30-day terms, debtor days in the low thirties means customers pay roughly as agreed; 45 or more means a meaningful share pay late. Sector norms differ, so watch your own trend: debtor days rising by five or more over a quarter, with no change in terms or customers, is worth a question at the next board meeting.

Why can debtor days move when nothing has changed?

Seasonality and timing. A large invoice raised on the last day of the month lifts debtors without any change in how customers pay, and a strong month raises the balance before its payments are due. Using 12 months of sales smooths most of this; for a seasonal business, compare the same month a year earlier as well.

How do I bring debtor days down?

Invoice on the day the work is delivered, state the due date on every invoice, chase on a fixed day before and after it, and offer a simple way to pay. Look at the aged debtors report by customer: a few large accounts usually explain most of the gap, and one conversation with each can move the figure more than any process change.

Are my figures stored?

No. The calculation runs in your browser and nothing is sent to Stratavor. A copied link carries the figures, so share it only with people who should see them. With analytics consent, we count that the calculator was used, without your figures.

How does Stratavor help?

Stratavor connects read-only to Xero, QuickBooks Online, Sage, NetSuite, Deltek Vantagepoint and HubSpot and computes debtor days in code from the ledger every month, with the overdue balance and the customers behind it, so the trend is in front of the board without anyone rebuilding it.

The Stratavor digest

One email a month. Worth opening.

Decoded films on real companies' results, short films on how businesses make and lose money, and guides on customers, competitors, risk, cash and the board pack. No sales emails.

By subscribing you agree to receive the monthly Stratavor digest. Unsubscribe at any time from any email. Privacy policy.