Average Debtor Days Calculator
Average debtor days tells you how long your money sits in other people’s bank accounts. Sell on credit today, and the sale is not cash until the customer pays; debtor days is the average length of that wait, measured across the whole ledger. It is the same statistic analysts call days sales outstanding (DSO) and the average collection period, and it is the working-capital number lenders look at first.
The Average Debtor Days Calculator below takes average receivables, built automatically from your opening and closing balances if you enter both, divides by credit sales, and scales by the days in the period. The pre-filled example, $50,000 of average receivables on $600,000 of credit sales over 365 days, returns 30.42 days with receivables turnover of 12.00x, so you can see the full result layout before typing your own figures.
Use credit sales only. Cash sales never enter receivables, and including them understates the collection period. If you enter opening and closing balances, the calculator averages them and updates the average field.
Quick Answer
- Quick Answer
- How to calculate debtor days in four steps
- The debtor days formula, and why each part is there
- Worked example: $50,000 of receivables on $600,000 of credit sales
- Reading the bands: what 30, 45, and 60 days really mean
- Every debtor day is cash: pricing a reduction
- Where debtor days sits among the receivables metrics
- What competing calculators miss
- Frequently asked questions
- Add This Calculator to Your Website
- References
How to calculate debtor days in four steps
Debtor days needs two balance figures and one sales figure, all from the same period. Most wrong answers come from mixing periods, not from the division itself.
Average the receivables. Add opening and closing accounts receivable and divide by two: ($40,000 + $60,000) divided by 2 is $50,000. Enter both balances and the calculator does this and fills the average field for you.
Take credit sales for the same period. Credit sales only: strip out cash sales, returns, and discounts. Total revenue is the most common wrong input and it always flatters the result.
Divide and scale by the period. Average receivables divided by credit sales gives the share of a period’s sales sitting unpaid; multiplying by the days in the period turns that share into days.
Read it against your terms. 30.42 days on net 30 terms is a ledger behaving as agreed. The same 30.42 on net 14 terms is a problem. The ratio has no meaning until it is placed next to the terms you actually grant.
The debtor days formula, and why each part is there
The formula is the standard collection-period ratio used across credit management, stated the same way by AccountingTools in its days sales outstanding calculation and every major accounting guide.
The averaging step is doing quiet work. A closing balance is a photograph taken on one day, and collection teams know how to make that day look good: a push in the final week, a big customer paying early for a discount. Averaging opening and closing balances does not remove the gaming, but it halves its effect, and averaging monthly balances removes most of it. The period selector matters just as much. Quarterly credit sales of $150,000 with 90 days and annual sales of $600,000 with 365 describe the same business; entering the annual sales with the 90-day setting would report a collection period a quarter of the true one.
Worked example: $50,000 of receivables on $600,000 of credit sales
A distributor opens the year owing $40,000 from customers, closes it owing $60,000, and sells $600,000 on credit in between. The calculator is pre-filled with this case.
| Figure | Value |
|---|---|
| Opening receivables | $40,000 |
| Closing receivables | $60,000 |
| Average receivables ((40,000 + 60,000) / 2) | $50,000 |
| Credit sales | $600,000 |
| Debtor days ((50,000 / 600,000) x 365) | 30.42 days |
| Receivables turnover (600,000 / 50,000) | 12.00x per period |
| Verdict band | Typical (over 30, up to 45 days) |
Note where the verdict lands. 30.42 days is a hair over the 30-day line, so the band reads Typical rather than Excellent. That is the honest answer for a ledger on net 30 terms: one slow week in December is enough to push a healthy book over the round number. Judge the trend and the terms, not the decimal.
Reading the bands: what 30, 45, and 60 days really mean
The bands in the calculator are calibrated to ordinary B2B credit, where net 30 is the default promise. Industries with structural long terms, construction retentions or public-sector payment cycles, should shift every band up by their normal lag and say so in the report.
| Debtor days | Band | What it usually signals |
|---|---|---|
| Up to 30 | Excellent | Customers pay inside standard terms; credit control is ahead of the ledger |
| Over 30, up to 45 | Typical | Normal commercial behaviour with a slow tail; the worked example sits here |
| Over 45, up to 60 | Watch | Collections are slipping a full half-term behind promises; review who holds the balance |
| Over 60 | Poor | Receivables are functioning as an interest-free loan to customers; tighten terms and escalate |
AccountingTools offers a useful cross-check: a collection period more than about 25 percent above the standard terms granted is an opportunity for improvement. On net 30 terms that line is 37.5 days, which sits inside the Typical band here, a reminder that band edges are guides. A business granting net 45 that reads its 44 days as Typical is fine; a business granting net 14 with the same 44 days is funding six weeks of its customers’ working capital.
Every debtor day is cash: pricing a reduction
The fastest way to make a board care about this ratio is to price one day of it. Daily credit sales are $600,000 divided by 365, which is $1,643.84. Each day shaved off debtor days releases about that much cash, permanently, at unchanged sales. Moving the worked example from 40 days to 30.42 would free roughly $15,750. Moving from 60 to 45 frees about $24,657. No new customers, no price rise, just the same sales collected sooner.
That pricing also exposes the limit of the metric. Debtor days can be improved cosmetically by factoring receivables or by offering early-payment discounts that cost more than the cash is worth. A 2 percent discount for paying 20 days early is an expensive way to buy a prettier ratio. Pair debtor days with the per-invoice view before acting: the average days late calculator shows how late the late payers actually are, and the average days delinquent calculator isolates the delinquent slice of the collection period by comparing actual DSO with the best possible DSO on the same ledger.
Where debtor days sits among the receivables metrics
Debtor days is the headline of a small family. The settlement framing of the same cycle, how long obligations take to settle across the ledger, is covered by the average settlement period calculator, which suits businesses tracking payables and receivables settlement together. The ageing view, which receivables sit in which overdue bucket today, comes from an aging schedule calculator and is the operational list the credit team works from each Monday. Debtor days tells you the period is lengthening; the aging schedule tells you whose invoices did it.
One more construction warning. Some published DSO figures use ending receivables only, some use revenue including cash sales, and a few annualize a single month. Two businesses quoting debtor days may not be quoting the same statistic. When benchmarking against a competitor or an industry survey, match the construction first: average balances, credit sales only, full period. This calculator states its construction in the open so the figure can be defended in a board pack.
What competing calculators miss
WPCalc’s debtors days tool takes a single receivables figure, so a seasonal business gets whichever season its closing date fell in. The guide-led pages, Upflow, Tally, Emagia, teach the formula well but leave the arithmetic to a spreadsheet. Paidnice goes furthest, with four DSO methods and sector benchmarks, but the method picker puts a research decision in front of a first-time user who just needs the standard number.
Winning move 1: the average is built, not assumed. Opening and closing balances go straight in and the average is computed and shown, removing the single-balance skew that simple tools bake in silently.
Winning move 2: turnover travels with the headline. Every result reports receivables turnover next to debtor days, so a reader who thinks in cycles per year and a reader who thinks in days get the same fact without a second tool.
Winning move 3: the number is priced. The cash-per-day framing turns the ratio into a collections target with a dollar value, which none of the simple calculators and few of the guides bother to compute.
Frequently asked questions
Average debtor days, also called days sales outstanding or DSO, is the average number of days a business takes to collect payment for its credit sales. It is calculated as average accounts receivable divided by credit sales, multiplied by the number of days in the period. A figure of 30.42 days means sales spend about a month locked in receivables before becoming cash.
Debtor days equals average receivables divided by credit sales, multiplied by days in the period. With average receivables of $50,000, credit sales of $600,000, and a 365-day year: 50,000 divided by 600,000 is 0.0833, and 0.0833 times 365 is 30.42 days. Use credit sales only, never total revenue, or the result comes out too low.
Average receivables is the better input for any period longer than a month, because a single closing balance can land on an unusually good or bad collection day. This calculator builds the average from your opening and closing balances when you enter both. For seasonal businesses, a monthly average of balances is better still; a two-point average is the minimum honest version.
Read it against your own terms first. On net 30 terms, a figure up to about 30 days is excellent and up to 45 is typical in many B2B sectors. Between 45 and 60 days, collections are slipping and deserve a review. Beyond 60 days on net 30 terms, customers are taking twice the agreed time and cash is financing their operations instead of yours.
One day of debtor days holds roughly one day of credit sales in cash. Divide annual credit sales by 365: at $600,000 of credit sales, each day is about $1,643.84. Cutting debtor days from 40 to 30 at that sales level releases roughly $16,438 of cash without selling anything extra, which is why collections work often beats new-sales work.
Receivables turnover is credit sales divided by average receivables: how many times the receivables balance cycles through in a period. It is the same fact as debtor days read from the other side. Turnover of 12.00 times over 365 days is 365 divided by 12, about 30.42 days. High turnover and low debtor days describe the same healthy ledger.
Debtor days covers every credit sale from invoice to payment, including the invoices paid exactly on time, and it is driven by balance-sheet figures. Average days late looks only at invoices that were late and averages how late each one was. A firm can have debtor days of 30 and average days late of 12 at once: most customers pay inside terms, and the late minority pays very late.
The usual cause is the receivables balance, not behaviour. A large invoice issued just before the period end inflates closing receivables, and a sales slump shrinks the denominator, and both push the ratio up. Check the opening and closing balances and the sales mix before blaming collections, and compare like periods: this quarter against the same quarter last year, not against the seasonal peak.
Add This Calculator to Your Website
References
- AccountingTools, “Days Sales Outstanding Calculation and Usage” – the DSO formula, an example at 60.8 days, and the 25 percent over terms interpretation rule. AccountingTools: Days Sales Outstanding. Accessed October 2026.
- Upflow, “DSO Formula: How to Calculate, Benchmark and Improve” – the simple method walkthrough with a 36.5-day worked example. Upflow: DSO Calculation Formula. Accessed October 2026.
- Paidnice, “DSO Calculator: Days Sales Outstanding, 4 Methods and Benchmarks” – standard, countback and other DSO constructions with sector benchmarks. Paidnice: DSO Calculator. Accessed October 2026.
- WPCalc, “Debtors Days Calculator (DSO / Collection Period)” – the receivables over credit sales construction with a 60.8-day example. WPCalc: Debtors Days Calculator. Accessed October 2026.
- Tally Solutions, “Days Sales Outstanding: Formula and Reduction Strategies” – average receivables from opening and closing balances, with period matching guidance. Tally: Days Sales Outstanding. Accessed October 2026.
- Emagia, “AR Days Calculation Guide for Accurate Accounts Receivable Performance” – AR days formula broken into average receivables, credit sales, and period length. Emagia: AR Days Calculation. Accessed October 2026.
- Investopedia, “Days Sales Outstanding (DSO): Definition and Formula” – the standard definition used by analysts for the collection period. Investopedia: Days Sales Outstanding. Accessed October 2026.
- Corporate Finance Institute, “Days Sales Outstanding (DSO)” – formula, interpretation, and use in working capital analysis. CFI: Days Sales Outstanding. Accessed October 2026.
- NetSuite, “Days Sales Outstanding (DSO): Formula and Guide” – monthly tracking practice and reduction strategies for finance teams. NetSuite: Days Sales Outstanding Guide. Accessed October 2026.
- Paidnice, “DSO Formula: How to Calculate Days Sales Outstanding” – simple and countback methods compared, with the warning that rising trend matters more than level. Paidnice: DSO Formula Guide. Accessed October 2026.