Debtor days estimates how long a business takes to collect payment from credit customers. The common annual formula divides trade receivables by annual credit sales and multiplies the result by 365. It is a ratio derived from account totals, rather than an exact average of the payment time for every invoice.
For a telecoms reseller, the measure is useful alongside payment terms, billing dates and an aged debt report. A change can indicate a collection problem, but it can also reflect a large recent invoice, a change in sales or adjustments to older balances.
Debtor Days Formula
Debtor days = (trade receivables ÷ annual credit sales) × 365
HMRC describes the debtors-to-sales ratio and notes that collection periods vary between trades. Use figures with a consistent basis and document whether the receivables figure is a period-end snapshot or an average balance.
The numerator and denominator should cover comparable activity. Cash sales do not create trade receivables, so including them in credit sales can make the result look lower. VAT treatment also needs consistency: a VAT-inclusive debtor balance compared with VAT-exclusive sales can distort the ratio.
Key Takeaways
- Debtor days is also called days sales outstanding, or DSO.
- Use a consistent sales period and receivables basis for comparisons.
- Compare the result with your payment terms and previous periods.
- Use invoice-level detail to explain changes before deciding what action to take.
A Worked Example
Suppose a business has £120,000 in trade receivables and £900,000 of annual credit sales, measured on a consistent basis:
(£120,000 ÷ £900,000) × 365 = 48.7 debtor days
If its usual terms are 30 days, the result warrants a review of the ledger. It does not establish that each invoice was paid 18.7 days late. The calculation includes outstanding invoices with different ages and does not measure each customer’s actual payment interval.
For a shorter measurement period, use the sales and number of days from that period. For example, a 90-day calculation uses credit sales over those 90 days and multiplies by 90. Do not combine one month’s sales with a 365-day multiplier.
What Is a Good Debtor Days Figure?
A useful benchmark starts with the business’s own payment terms and sales pattern. A reseller collecting mainly by Direct Debit will have a different profile from one supplying customers with agreed longer terms. There is no single threshold that establishes good performance for every business.
Compare the same point in each billing cycle. A measurement immediately after the monthly run can differ from one taken after the main collections have settled. Keeping the timing consistent makes trends easier to interpret.
Then examine the distribution behind the average. Two businesses with similar debtor days can have very different positions: one might have a large current ledger, while the other carries a smaller number of seriously overdue accounts. The aged debt report provides that detail.
Why Debtor Days Can Change
Several movements can affect the figure without a change in how promptly customers pay:
| Change | Possible effect on the ratio |
|---|---|
| A large invoice raised near the reporting date | Increases the receivables snapshot before payment is due |
| Sales growing or falling | Changes the relationship between the sales period and the closing ledger |
| An old balance credited or written off | Reduces receivables without generating cash |
| Receipts awaiting allocation | Can leave invoice-level balances appearing outstanding |
| A different mix of payment terms | Changes the expected collection profile |
A zero sales denominator makes the ratio undefined. Negative or unusually small balances also need investigation before the result is treated as a performance measure. Document the reporting method and apply it consistently.
How to Reduce Debtor Days
Use the ledger to identify the source of avoidable delay. The appropriate improvement depends on what is holding payment up:
- Invoice accuracy: correct service dates, prices, purchase orders and billing contacts before the invoice is issued.
- Delivery: identify failed emails or missing documents and confirm the customer’s submission requirements.
- Follow-up: assign the next action and review date rather than relying on an occasional export.
- Disputes: identify the amount under review and give the query a responsible owner.
- Collection methods: monitor agreed automatic payments for failures, cancellations and returns.
- Older balances: review evidence and recovery options, separating cash receipts from accounting adjustments.
Changing terms can be part of a commercial review, but it needs agreement and consistent implementation. Shorter terms alone do not resolve incorrect invoices or an unresolved service issue. Our credit control process guide covers the broader routine.
Debtor Days and Cash Flow
The ratio is an indicator of cash tied up in customer receivables. It is not a cash forecast: the formula does not tell you the date a particular customer will pay, whether a collection will succeed or which balance is disputed.
For near-term planning, review expected payments and collection status alongside the overdue ledger. An expected receipt remains uncertain until the payment is recorded. Report promises, scheduled collections and actual cash separately so the forecast does not imply more certainty than the evidence supports.
Payment collection can support that process. For suitable services and agreed customer arrangements, pre-pay top-up can reduce credit exposure, while failed collections and other invoices still need attention.
Late-Payment Remedies
Where qualifying commercial invoices remain unpaid, review the contractual and statutory remedies available. GOV.UK explains statutory interest, and our late payment interest calculator supports an invoice-specific calculation.
Keep the charge decision separate from measurement of collection performance. An additional charge can increase the receivable; it does not itself improve cash collection. The product guide to late-payment charges and automated chasing explains how SAFE records that workflow.
Frequently Asked Questions
What is the difference between debtor days and DSO?
Days sales outstanding, or DSO, is another name for this collection-period measure. Check the calculation used by a particular report: period-end and average receivables, differing sales periods and different VAT treatment can produce different results under either label.
Are lower debtor days always better?
A lower figure can reflect faster collection, but it can also result from credits, write-offs or a changed customer mix. Explain the movement using receipts and invoice-level data before attributing it to better credit control.
Can I calculate debtor days monthly?
Yes. Use a clearly defined method, such as a month-end receivables balance against a rolling annual sales figure, or a matching shorter-period calculation. Compare periods using the same method and consider the effect of billing dates and seasonal sales.
SAFE CRM gives the team access to the invoices, payment history and follow-up work behind these measures. Contact us to discuss the reporting and Credit Control workflow for your accounts.