An AR days calculator works out days sales outstanding, the average number of days it takes a business to collect payment after a sale. Enter the accounts receivable balance and the sales for the same period, and the calculator divides the receivables by average daily sales. It also shows the average sales per day and how many times the period's sales cover the receivables balance.
The AR days formula
Average sales per day = sales in the period ÷ days in the period
AR days (DSO) = accounts receivable ÷ average sales per day
OpenStax's Principles of Accounting gives the number of days' sales in receivables as 365 divided by the accounts receivable turnover ratio, where turnover is net credit sales divided by average accounts receivable. This calculator uses the same idea with a single balance: accounts receivable divided by average sales per day. The result is the number of days' worth of average sales that are currently outstanding, and the period can be any useful one: a calendar year, a month or a fiscal period. DSO is often calculated monthly.
How to use the AR days calculator
- Enter accounts receivable, the amount customers owe at the end of the period, from your balance sheet or aged receivables report.
- Enter sales for the period. Credit sales give the truest picture, because cash sales are collected straight away.
- Enter the days in the period, or leave it blank for 365.
- Press Calculate to see AR days, average daily sales and the sales-to-receivables ratio.
Worked example
A wholesaler has $50,000 owed by customers at the year end and made $600,000 of sales during the year. Average sales per day are $600,000 ÷ 365 = $1,643.84, so its AR days are $50,000 ÷ $1,643.84 = 30.4 days. Sales were 12 times the receivables balance. If the business offers 30-day payment terms, customers are paying close to on time.
For a quarter, enter that quarter's sales and 90 days. A company with $50,000 owed and $180,000 of quarterly sales has 50,000 ÷ (180,000 ÷ 90) = 25 days.
What a high or low figure means
OpenStax notes that fewer collection days is better, and that a longer collection period suggests weaker collection procedures and a greater risk of not meeting current obligations on time. A very low figure, which it links to a high turnover, can mean credit terms are too strict, turning away customers who would pay reliably on longer terms. The most useful comparison is with your own payment terms: if you give 30 days and DSO is 45, customers are paying about two weeks late on average. Watching the trend month by month shows whether collections are getting better or worse.
Quick reference
| Receivables | Sales | Days | AR days |
|---|---|---|---|
| $50,000 | $600,000 | 365 | 30.4 |
| $50,000 | $180,000 | 90 | 25 |
| $80,000 | $600,000 | 365 | 48.7 |
| $20,000 | $40,000 | 30 | 15 |
Ways to bring AR days down
- Invoice promptly. The collection clock only starts when the customer receives the invoice.
- Make terms clear on every quote and invoice.
- Follow up early on overdue invoices, with reminders before and after the due date.
- Offer easy ways to pay, such as bank transfer or card.
- Check credit before giving large new customers long terms.
Choosing the sales figure
Using total sales when part of them are cash sales makes DSO look shorter than the time credit customers really take, because cash sales add to the total without adding to receivables. If your accounts separate credit sales, use those. Using a year-end receivables balance against a whole year of sales can also mislead in a seasonal business: a busy December leaves a large balance that the rest of the year's quieter sales do not reflect. In that case, compare the balance with the sales of the last month or quarter instead.
AR days and cash flow
Every day of DSO is a day's sales held by customers instead of in your bank. For the wholesaler above, cutting DSO from 30 to 25 days would free about five days of sales, or around $8,200, without selling anything more. That is why finance teams track DSO alongside the days inventory is held and the days taken to pay suppliers. For related measures, try the break-even calculator and the accounting profit calculator.
Tracking AR days over time
A single figure tells you where collections stand today, but the real value comes from tracking it. Work out AR days at the end of every month using that month's receivables and the sales of the last month or last three months, and keep the results in a simple list. A steady figure that sits close to your payment terms means customers pay as agreed. A figure that creeps upward month after month is an early warning: either customers are taking longer, or a few large invoices have gone unpaid. Because the number moves before cash runs short, catching the trend early gives you time to chase payments, tighten terms for slow payers or arrange extra funding.
Looking behind the average
AR days is an average across all customers, so it can hide problems. A business whose customers mostly pay in 20 days could still have one large account that is 90 days overdue, and the average might look fine. An aged receivables report, which groups what each customer owes by how long it has been outstanding, shows where the money is stuck. Use the calculator for the headline number and the aged report to decide which customers to call first.
Common mistakes
- Mixing periods. Use receivables and sales that match the days you enter.
- Including cash sales when you want to measure credit collection.
- Comparing with the wrong benchmark. Compare DSO with your own terms and history.
- Ignoring bad debts. Very old invoices that will never be paid inflate the balance.
What next
Use this often? Add AR Days to your Home screen.
Frequently asked questions
How does an AR days calculator work?
It divides the period's sales by the days in the period to get average daily sales, then divides accounts receivable by that figure.
What is a good number of AR days?
Compare it with your payment terms. With 30-day terms, AR days close to 30 mean customers pay roughly on time.
Should I use 365 or 360 days?
Use the number of days your sales figure covers. This calculator uses 365 for a year unless you enter another number.
What does a high DSO mean?
OpenStax says a longer collection period suggests weaker collection procedures, and a low turnover can signal bad debts.
Is AR days the same as average collection period?
Yes, both describe the average number of days it takes to collect receivables.
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.