---
title: "Debtor days for wholesalers: benchmarks and cost per day"
description: "The standard debtor days formula overstates a UK wholesaler's number by about 20%, because receivables are gross of VAT and revenue is not. The corrected formula, a calculator, and the benchmarks worth measuring against."
url: https://www.paidnice.com/blog/debtor-days-for-wholesalers
---

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

Written by

Denym Bird
Expert verified

Co-founder & CEO of Paidnice

Denym calculated debtor days for wholesalers, including the VAT correction to the standard formula, a calculator, benchmarks, and what a settlement discount and one unpaid invoice cost.

Reviewed by Ashley Schroder

Co-founder of Paidnice

Updated Sep 28, 2026 · 14 min

## 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.

13.60%UK wholesale gross margin proxy, ONS Annual Business Survey 2024
£73,529replacement sales needed after one £10,000 write-off at that margin
~20%overstatement in the textbook formula at a 20% output VAT rate
37 daysaverage days to pay reported by large wholesale and retail businesses, DBT 2025

## 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](https://www.gov.uk/guidance/vat-guide-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.

A number that is wrong twice in opposite directions is not a conservative estimate. It is noise.

Compare it against current [UK wholesale and retail payment times](https://www.paidnice.com/payment-times/uk/wholesale-and-retail) or, for Australian sites, [Australian wholesale trade payment times](https://www.paidnice.com/payment-times/au/wholesale-trade).

## 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](https://www.paidnice.com/blog/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.

💡 Paidnice insight

The most common cause of a debtor days figure nobody trusts is not the formula. It is unallocated cash. A payment banked but never matched against open invoices leaves the ledger showing debt already paid, inflating the number and the ageing together.

## 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.

Debtor days calculator, with the VAT correction

Accounts receivable balance, gross (£)

Credit sales for the period, net of VAT (£)

Days in the period

Your annual cost of money (%)

My receivables include output VAT

Blended output VAT rate (%)

Textbook debtor days: 65.70 days
Corrected for VAT: 54.75 days
Difference: 10.95 days
One day of debtor days costs: £2,465.75 a year
The gap in money: 10.95 days × £2,465.75 = £27,000.00 of funding cost you do not actually carry.

Cost of money is your rate, not a published figure: overdraft, borrowing margin, or the return you would make on the cash. UK statutory interest for 2026 debts runs at 11.75%. A guide, not financial advice.

### The same sum manually

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](https://www.paidnice.com/calculators/days-sales-outstanding).

## 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. For customer payment times across countries, see [average days to pay by country](https://www.paidnice.com/blog/payment-times-by-country).

| Measure | Figure | Published or recommended | Basis |
| --- | --- | --- | --- |
| Median DSO, all US industries | 40.12 days | Published benchmark | [CRF national summary of domestic trade receivables](https://www.crfonline.org/tools/national-summary-of-domestic-trade-receivables-results-summary/), Q1 2026 |
| Best possible DSO | 31.59 days | Published benchmark | CRF, Q1 2026 |
| Average days delinquent | 4.85 days | Published benchmark | CRF, Q1 2026 |
| Collection effectiveness index | 73.48, down from 79.48 | Published benchmark | CRF, Q1 2026 |
| Receivables current | 87.38% | Published benchmark | CRF, Q1 2026 |
| Over 91 days past due | 0.35% | Published benchmark | CRF, Q1 2026 |
| UK large-business average days to pay | 32 days | Published benchmark | [DBT payment practices statistics 2025](https://www.gov.uk/government/statistics/large-businesses-payment-practices-and-performance-statistics-2025/large-businesses-payment-practices-and-performance-statistics-2025-commentary) |
| UK wholesale and retail reporters, days to pay | 37 days, 15% late by number | Published benchmark | DBT, 2025 |
| Australian wholesale trade, average time to be paid | 31.2 days, against 24.2 for all industries | Published benchmark | [Xero Small Business Insights](https://www.paidnice.com/accounts-receivable-statistics/australia), September 2026, small business ledgers |
| UK small business average wait | 29.0 days, 8.2 days late | Published benchmark | [Xero Small Business Insights](https://www.xero.com/uk/resources/small-business-insights/latest-united-kingdom/), March quarter 2026 |
| Builders merchant receivable days | 50.4 days | Published benchmark, derived from filed accounts | 630.7 ÷ 4,564.6 × 365, [Travis Perkins FY2025](https://www.investegate.co.uk/announcement/rns/travis-perkins--tpk/travis-perkins-plc-2025-results-announcement/9476999) |
| Builders merchant bad debt | 0.359% of revenue | Published benchmark, derived from filed accounts | 16.4 ÷ 4,564.6, Travis Perkins FY2025 |
| Countback DSO within 5 days of your effective credit term | 50.5 days on 30-day EOM terms | **Recommended target** | Mine, from the EOM arithmetic and the Travis Perkins anchor |
| Average days delinquent | 5 days or fewer | **Recommended target** | Mine, set at the CRF published median |
| Collection effectiveness index | 85% or higher | **Recommended target** | Mine, above the CRF published median |
| Bad debt | 0.35% of revenue or lower | **Recommended target** | Mine, anchored on the Travis Perkins actual |
| Statements agreed by working day 5 | 90% or higher | **Recommended target** | Mine, the highest-yield contact in a statement-traded cadence |

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](https://www.paidnice.com/blog/credit-control-for-wholesalers) works through.

**Shorter terms cut debtor days.** The same customer pays a 14-day invoice about 9 days sooner than a 30-day invoice, and no more invoices go unpaid.
Original dataSource: our analysis of invoice data from over 1,000 Paidnice customers. See our payment terms data.

## 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**.

| Structure | Cost to you, per year | What it buys |
| --- | --- | --- |
| 1/10 net 30 | 18.4% | 20 days |
| **2/10 net 30** | **37.2%** | 20 days |
| **2.5/10 net 30** | **46.8%** | 20 days |
| **2.5/10 on 30-day EOM terms** | **26.4%** | 35.5 days against the 45.5-day mean |
| 2/10 net 60 | 14.9% | 50 days |
| 5/7 net 30 | 83.5% | 23 days |

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](https://www.ons.gov.uk/file?uri=/businessindustryandtrade/business/businessservices/datasets/uknonfinancialbusinesseconomyannualbusinesssurveysectionsas/current/abssectionsas.xlsx), 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](https://www.paidnice.com/blog/retention-of-title-and-deductions) covers what your terms must say, and how payment allocation can destroy the claim.

## What mistakes make debtor days wrong, and what do they cost a wholesaler?

Each mistake moves the number by days, and each day has a price. The figures below reuse the examples above.

- **Dividing gross receivables by net sales.** £1,800,000 ÷ £10,000,000 × 365 reads 65.70 days, against 54.75 corrected. At a 9% cost of money, those 10.95 extra days equal £27,000 a year of funding cost that is not real.*Fix: divide receivables by 1 plus your own blended output VAT rate first.*
- **Using total income as credit sales.** Net receivables of £1,500,000 over £10.6m of total income, which includes £600,000 of counter sales, read 51.65 days. That is 3.10 days below the correct 54.75, so the ledger looks faster than it is.*Fix: use invoiced trade sales only, and split counter sales into their own income account.*
- **Offering a settlement discount without pricing it.** A 2% discount for payment in 10 days on 30-day terms costs 37.2% a year. UK statutory interest on late debts is 11.75%, so the discount costs more than three times as much.*Fix: annualise the discount with the formula above before you offer it.*

## 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 of [debtor management](https://www.paidnice.com/debtor-management-software) 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](https://www.paidnice.com/blog/charging-interest-on-overdue-invoices)
- Escalation workflows and a customer payment portal, so the chase and the payment sit in one place

Customers see half as many late invoices in the first 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](https://www.paidnice.com/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](https://www.paidnice.com/blog/best-credit-control-software-for-wholesalers).

💡 Paidnice insight

The fastest debtor days improvement we see is rarely a new chase template. It is moving statement day forward and getting the balance agreed early in the month, because a customer who has agreed it cannot hold the payment run.

## Common questions

What is the debtor days formula?

Trade receivables divided by credit sales for the period, multiplied by the number of days in that period. For a UK VAT-registered business, divide the receivables balance by one plus your blended output VAT rate first, so both sides of the sum are net of VAT.

Example: £1,500,000 of net receivables over £10,000,000 of annual credit sales is 1,500,000 ÷ 10,000,000 × 365 = 54.75 days.

Should debtor days include VAT?

No, not on one side only. Your aged receivables report is gross of output VAT and your revenue line is net, so leaving VAT in the numerator overstates debtor days by about 20% at the standard rate. Either strip VAT out of receivables, or gross the sales figure up.

What is a good debtor days figure for a wholesaler?

No UK trade body publishes a wholesale benchmark, so judge against your own effective credit term. On 30-day end-of-month-following terms the true mean term is 45.5 days, so a countback figure around 50.5 is defensible.

Travis Perkins ran 50.4 receivable days in FY2025; the CRF cross-industry median DSO was 40.12 days in Q1 2026.

How do I calculate the number of debtor days for a month?

Take the receivables balance at month end, net of VAT, divide by that month's credit sales, and multiply by the days in the month. For August above: 1,600 ÷ 1,100 × 31 = 45.09 days.

Read it with care. One month is a small denominator, so the figure swings with the sales mix, and any answer longer than the month means receivables span more than one month of trading.

The formula is the easy half. The guide to [credit control for wholesalers](https://www.paidnice.com/blog/credit-control-for-wholesalers) sets out the order gate, the cadence and the point supply stops.

## Paidnice features in this article

- [**Customer statements** Sends branded customer statements on your schedule, with one button to pay.](https://www.paidnice.com/automated-customer-statements)

## About the editorial team

Written by Denym Bird Co-founder & CEO of Paidnice

Denym started Paidnice in 2022 after customers paying late left his own business short on payroll. He has led it to $1 billion collected on time across more than 1 million invoices, and writes about credit control, late fees and getting paid on Xero and QuickBooks.

Reviewed by Ashley Schroder Co-founder of Paidnice

Ashley is a co-founder and lead developer of Paidnice and has built accounting software for more than 10 years. He builds the ledger connections that put reminders, late fees and payments into Xero, QuickBooks and ERPs such as NetSuite and Business Central. Before Paidnice he co-founded A2X, ecommerce accounting software for Xero and QuickBooks.

### Try Our Free Accounts Receivable Calculators

Optimize your cash flow with our suite of financial tools designed for AR professionals. Calculate DSO, aging analysis, late fees, and more.

Explore Calculators

## Start getting paid on time with Paidnice

Connect Xero or QuickBooks and Paidnice prepares draft policies for you. Nothing runs until you approve them.

Try it FreeBook a Demo

[Rated 5 stars, 160+ reviews](https://www.paidnice.com/reviews) · [App of the Year](https://www.paidnice.com/blog/winner-xero-global-app-awards-2026)
