Debtor days for wholesalers: what your number should be, and what each day costs

Summary

Debtor days is trade receivables divided by credit sales for the period, times the days in the period: £1,800,000 of receivables over £10m of annual credit sales gives 65.70 days. For a UK wholesaler that overstates it by about 20% at the standard VAT rate, because receivables include output VAT and revenue does not; corrected, the figure is 54.75 days.

• The formula: Debtor days = (trade receivables ÷ credit sales for the period) × days in the period; use 365 for a year, 30 or 31 for a month, and average opening and closing receivables for a year-on-year comparison.
• The correction: Divide the receivables balance by one plus your blended output VAT rate before dividing, or gross the sales figure up, so both sides of the sum are net of VAT; at 20% VAT the uncorrected number reads 10.95 days worse on a £10m ledger.
• Paidnice: The Paidnice dashboard shows Days Sales Outstanding, Days Sales Overdue and Average Overdue Age straight from the Xero or QuickBooks Online ledger, with aged receivables by contact in 1-30, 31-60, 61-90 and 90+ day buckets.

Contents▾

How do you calculate debtor days?

Debtor days = (trade receivables ÷ credit sales for the period) × days in the period. A wholesaler with £1,800,000 on the aged receivables report and £10,000,000 of annual credit sales has 1,800,000 ÷ 10,000,000 × 365 = 65.70 debtor days. For a year-on-year ratio, average the opening and closing receivables balances first.

In a UK VAT-registered business the two inputs are measured on different bases, so that raw division is wrong before you start. A wholesaler is also more exposed than most, because the cash in an unpaid invoice is mostly not profit: it is money already paid to suppliers for goods that have left the building.

Invoice a trade customer £10,000 of standard-rated goods and they owe you £12,000, because VAT Notice 700 requires the tax to be charged and shown on the invoice as part of the total payable. Your sales ledger carries £12,000. Your profit and loss records £10,000, because the £2,000 is output tax owed to HMRC, not income.

Put the ledger balance over the revenue line and the numerator is 20% larger than the basis of the denominator. The answer comes out 20% high, every month, for every VAT-registered UK business using the standard formula.

The second error is worse, because it is invisible. Every version of the formula in circulation asks for "total credit sales", and no line of that name exists in Xero or QuickBooks Online. So people take total income, which includes counter takings and card sales that never enter receivables.

Those two errors run in opposite directions and there is no reason they cancel. Take the example below. £1,800,000 of receivables over £10.6m of total income, which carries £600,000 of counter sales, gives 62.0 days. Over £10m of net trade sales, 65.70. The right answer is 54.75.

Wholesale carries the stock cost before the invoice falls due. Xero Small Business Insights measures the wait for that sector.

Xero Small Business Insights · June 2026

Average time to be paid: Wholesale Trade against the national average

Market	Wholesale Trade	All industries	Gap	Rank, slowest first
Australia	27.6 days	20.3 days	+7.3 days	5th of 19

The gap against the national average is the cost of the trade account. Compare it against current UK wholesale and retail payment times or, for Australian sites, Australian wholesale trade payment times.

Is days sales outstanding the same as debtor days?

Yes. Days sales outstanding, or DSO, and debtor days are the same calculation: receivables divided by credit sales for the period, times the days in the period. The vocabulary changes with the market, the arithmetic does not.

US and international finance teams say days sales outstanding, or DSO. UK and Australian teams say debtor days, and "AR aging report" is the US name for the aged debtors report.

The VAT problem is UK, Irish and European. There is no US equivalent, because sales tax is not usually invoiced on a B2B wholesale sale carrying a resale certificate. Our guide to the DSO calculation formula covers that version.

Where do the two debtor days inputs live in Xero and QuickBooks?

In Xero the debtor days numerator is the total on the Aged Receivables Summary, which is gross of VAT, and in QuickBooks Online it is the accounts receivable ageing summary. The denominator is invoiced trade sales from the profit and loss, which is net, and counter sales must come out of it first.

The numerator. In Xero it is the total on the Aged Receivables Summary; in QuickBooks Online, the accounts receivable ageing summary. Both are gross, because that is what the customer owes.

Standard guidance says to average the opening and closing receivables balance, and for a year-on-year ratio that is right: it stops one odd month-end distorting the comparison.

For running a wholesale ledger, take the closing total. Averaging two points twelve months apart flattens the seasonal peak you need to see, and the operating question is what is owed now. Countback handles seasonality properly.

The denominator. Take invoiced trade sales, not total income. If counter or cash sales sit in the same revenue account, split them out: a separate income account or a tracking category fixes the number permanently.

The VAT rate. Do not assume 20%. Divide output VAT charged on sales by net sales for the period, roughly box 1 over box 6 on a UK VAT return. A builders merchant lands near 20%; a food wholesaler selling largely zero-rated grocery lands far below, and over-correcting is as wrong as not correcting.

How do you correct debtor days for VAT?

Divide the gross receivables balance by one plus your blended output VAT rate, then run the formula. A UK wholesaler with £1,800,000 on the aged receivables report and £10m of net credit sales shows 65.70 textbook debtor days and 54.75 corrected, a gap of 10.95 days.

The same sum by hand

A wholesaler turning over £10m of credit sales a year, the ONS average for the division, closes the year with £1,800,000 on the aged receivables report at a blended 20% output VAT rate.

• Textbook: 1,800,000 ÷ 10,000,000 × 365 = 0.18 × 365 = 65.70 days
• Strip the VAT: 1,800,000 ÷ 1.20 = £1,500,000 of net receivables
• Corrected: 1,500,000 ÷ 10,000,000 × 365 = 0.15 × 365 = 54.75 days
• Difference: 65.70 − 54.75 = 10.95 days
• Cost of one day: 10,000,000 ÷ 365 = £27,397.26 of sales a day, funded at 9% = £2,465.75 a year
• The gap: 10.95 × 2,465.75 = £27,000 of funding cost that was never real

The correction does not get you paid faster. It stops you targeting a number 11 days pessimistic, and stops a VAT rate change reading as an improvement. A standalone version sits on our days sales outstanding calculator.

What does a good debtor days figure look like for a wholesaler?

A good debtor days figure for a wholesaler sits within five days of the effective credit term, which on 30-day end of month following terms means a countback figure around 50.5 days. No trade body publishes a wholesale-specific benchmark in the UK, the US, Australia or New Zealand, so the rows below separate what somebody else published from what I recommend.

One warning on the target row. On "30 days end of month following" the effective credit period averages 45.5 days and ranges from 31 to 60, set purely by where in the month the customer ordered. A target that does not normalise for that measures order timing, not collections, as the wholesale credit control pillar works through.

What are countback DSO, best possible DSO, average days delinquent and CEI?

Countback DSO consumes the receivables balance backwards through each month's sales, so seasonal trade cannot distort it. Best possible DSO uses only current receivables, average days delinquent is the gap between the two, and the collection effectiveness index measures what share of collectable receivables was collected. Simple debtor days is the number you report; countback is the number you manage by.

Take sales of £900k in June, £1,000k in July and £1,100k in August, with receivables of £1,600k at 31 August, £1,300k of it current. All net of VAT.

• Countback DSO works backwards from the latest month until the balance is used up. August sales of £1,100k are less than the £1,600k balance, so consume August whole: 31 days. £500k remains, and July sales are £1,000k, so the part month is (500 ÷ 1,000) × 31 = 15.5 days. Countback DSO = 46.5 days.
• Simple debtor days, three months. 1,600 ÷ 3,000 × 92 = 49.07 days, overstating by 2.57 days because recent sales are rising. On falling sales the sign flips.
• Best possible DSO is current receivables over sales, times the days: 1,300 ÷ 3,000 × 92 = 39.87 days, what you would post if everyone paid exactly to terms.
• Average days delinquent is simple DSO minus best possible DSO: 49.07 − 39.87 = 9.20 days, the collections number isolated from your terms.
• Collection effectiveness index is (opening receivables + sales − closing receivables) ÷ (opening receivables + sales − closing current receivables) × 100. With opening receivables of £1,500k: (1,500 + 3,000 − 1,600) ÷ (1,500 + 3,000 − 1,300) × 100 = 2,900 ÷ 3,200 = 90.6%.

Report simple debtor days to the board, manage on countback, and use average days delinquent to separate collections from sales mix. In a seasonal ledger the simple method is wrong in whichever direction the season runs.

Creditor days is the mirror image: trade payables ÷ purchases × days. It carries the same VAT error, because payables are gross of input VAT while purchases are net.

Run both. Creditor days minus debtor days is your funding gap, and in wholesale that gap is mostly cash already paid to a supplier. Pay in 30, collect in 45, and you fund fifteen days of cost of sales on every account.

What does a settlement discount cost a wholesaler?

A settlement discount of 2% for payment in 10 days on 30-day terms costs the seller 37.2% a year, more than three times UK statutory interest, and at a 13.60% gross margin it surrenders 14.7% of the margin to move cash 20 days.

The arithmetic. Annualised cost = [d ÷ (1 − d)] × [365 ÷ (N − D)], where d is the discount, N the net term and D the discount period. For 2/10 net 30: 0.02 ÷ 0.98 = 0.020408, and 365 ÷ (30 − 10) = 18.25, so 0.020408 × 18.25 = 0.3724, or 37.2% a year.

Then the margin test. At the ONS 13.60% gross margin proxy, that same 2% surrenders 14.7% of gross margin (2 ÷ 13.6) to move cash 20 days.

Since 1 April 2015, VAT must be accounted for on the amount actually paid, so every discount taken needs a credit note or invoice adjustment: an accounting cost on top of the margin.

The unearned discount is worse here than in per-invoice trading. On one monthly payment covering 200 invoices, a 2% deduction taken without qualifying looks like an unexplained residual and is almost never charged back.

What does one unpaid invoice actually cost a wholesaler?

One unpaid £10,000 invoice costs a UK wholesaler £73,529 of replacement sales at the wholesale gross margin proxy of 13.60%, because that is how much new turnover it takes to earn the lost profit back. A 60% margin service business needs £16,667: 4.4 times less work for the same hole.

The ONS Annual Business Survey, released 26 May 2026, records SIC Division 46 turning over £1,018,705m in 2024 across 101,213 enterprises against purchases of £880,158m: a gross margin proxy of 1 − (880,158 ÷ 1,018,705) = 13.60%.

Treat that as a proxy, not a measured margin, and as the thin end of the range. SIC 46.71 fuels drags it down: 36.9% of divisional turnover at a 6.54% proxy. Strip fuels out and the rest of the division proxies at 17.74%.

• Wholesale, 13.60% proxy. 10,000 ÷ 0.136 = £73,529, or 7.35 further invoices of the same size.
• Service business, 60% margin. 10,000 ÷ 0.60 = £16,667, or 1.7 invoices.
• The ratio. 73,529 ÷ 16,667 = 4.4 times more revenue for the identical write-off.

The reason is what the invoice is made of. At 13.60%, £8,640 of every £10,000 is cash already paid to suppliers for goods now in the customer's warehouse. A cash loss, not a lost opportunity, and it happened at despatch, not at the due date.

So debtor days is a stock and despatch metric with a finance name. Where recovering the goods is still possible, retention of title and deductions covers what your terms must say, and how payment allocation can destroy the claim.

How do you bring debtor days down without hiring?

Debtor days falls for three reasons: invoices go out sooner, the collection cadence is consistent, and late payment carries a cost. The first is operations, the other two are automation, and Paidnice runs them on Xero or QuickBooks Online.

Paidnice takes the repeatable parts off a person, and its dashboard shows Days Sales Outstanding, Days Sales Overdue and Average Overdue Age straight from the ledger, with an aged receivables report by contact in 1-30, 31-60, 61-90 and 90+ day buckets:

• Reminder sequences per customer group, firm for chronic late payers, lighter elsewhere
• Automatic statements including consolidated parent and child, the highest-yield contact on a statement-traded ledger
• Late fees and statutory interest posted onto the invoice, with the UK rate auto-indexed to the Bank of England base rate. What a goods supplier may charge is in charging interest on overdue invoices
• Escalation workflows and a customer payment portal, so the chase and the payment sit in one place

Customers cut their average wait for payment in half, within 30 days. Pricing is by invoice volume, from £49 / US$69 a month for 150 invoices, Pro from £74 / US$99, no per-seat fees. Statements run from automated customer statements.

The limit, and it matters more in wholesale than anywhere: Paidnice sits on the ledger, not the order book, so it does not block an order at entry. For the comparison, see the best credit control software for wholesalers.

Common questions

The formula is the easy half. The guide to credit control for wholesalers sets out the order gate, the cadence and the point supply stops.