A/R Days Calculator

A/R Days Calculator

Estimate how many days of credit sales are tied up in accounts receivable, using either a single receivable balance or an average beginning-and-ending balance.

Method: ending balance Period: 365 days Credit sales: $150,000.00
Excel export is ready for the demonstration values.

Inputs

Ending A/R balance for the period.

Credit sales for the same measurement period; enter a value above zero.

Common choices are 365 for a year or the actual days in a month or quarter.

Average balance calculation

When selected, the calculator uses the mean of beginning and ending receivables instead of the single A/R field.

A/R balance at the start of the period.

A/R balance at the end of the period.

Live result

A/R days
73.00 days

The current receivable balance equals about 73 days of the period's credit sales.

A/R balance used
$30,000.00
Method
Ending balance
Measurement period
365 days
A/R days = (A/R balance used ÷ net credit sales) × number of days in the period
Enter a complete valid set of values to calculate A/R days.
A/R days: 73.00 days.

How to use this A/R days calculator

What this calculator does

This calculator estimates accounts receivable days, commonly called days receivable or days sales outstanding (DSO). It expresses the receivable balance as an equivalent number of days of credit sales for the same period. The U.S. Small Business Administration describes days receivable as accounts receivable divided by annual credit sales and multiplied by 365; this calculator generalizes the same relationship to any positive period length. It is an operating metric, not a prediction of the exact date each invoice will be collected and not a substitute for an aging report, customer-level credit review, or cash-flow forecast.

When to use it

Use A/R days when you want to compare collection speed from one month, quarter, or year with another; review whether receivables are growing faster than credit sales; evaluate whether collection practices are tying up more working capital; or create a consistent DSO assumption for a planning model. Comparisons are most useful when the numerator and denominator cover compatible accounting periods and when you interpret the result alongside your own payment terms, customer mix, seasonality, and industry context.

How to calculate

The calculator opens with a complete demonstration: $30,000.00 of accounts receivable, $150,000.00 of net credit sales, and a 365-day period, producing 73.00 A/R days. The Excel workbook for that demonstration is ready immediately. To run your own calculation:

  1. Replace Accounts receivable with the receivable balance you want to test, then enter Net credit sales for the same period and the Number of days in the period.
  2. If a single ending balance could be distorted by seasonality, open Average balance calculation, select Use average A/R balance, and enter both the beginning and ending receivable balances. The single Accounts receivable field is then excluded from the formula.
  3. Read A/R days in the Live result panel. The accompanying method, A/R balance used, and measurement-period lines show exactly which basis was applied.
  4. Select Download Excel to create a current-state .xlsx workbook. Reset clears the demonstration and all data fields; after Reset, Excel export is disabled until a complete valid state has been entered again.

Input guide

Accounts receivable is a required nonnegative U.S.-dollar balance when the average-balance option is off. Enter digits with an optional decimal point and correctly placed thousands commas; the $ sign is supplied by the control. Example: 30,000.00. A larger receivable balance raises A/R days when sales and period length stay fixed. Do not enter accounts payable, cash sales, or a balance from an unrelated date.
Net credit sales is required, measured in U.S. dollars, and must be greater than zero. Enter digits with an optional decimal point and correctly placed thousands commas; scientific notation and decimal-comma input are rejected. Example: 150,000.00. Higher credit sales reduce A/R days for the same receivable balance because the same A/R represents fewer days of sales. Use credit sales for the selected period rather than total sales when cash sales are material; CFI's DSO formula guide likewise uses net credit sales.
Number of days in the period is required and must be a finite positive number. Enter digits with an optional decimal point and correctly placed thousands commas; scientific notation and decimal-comma input are rejected. Example: 365 for a year or 90 for a 90-day quarter. A longer period increases the calculated day count proportionally if the other inputs are held constant. Match this value to the period represented by Net credit sales; do not mix annual sales with a quarterly day count.
Use average A/R balance is an optional checkbox. Leave it off to use the single Accounts receivable balance. Turn it on when beginning and ending balances better represent the period. The common mistake is comparing an average balance with sales from a different time span; the dates and sales period should align.
Beginning accounts receivable becomes required when average-balance mode is on. It is a nonnegative U.S.-dollar balance entered with digits, an optional decimal point, and correctly placed thousands commas; example: 15,000.00. Increasing it raises the average A/R balance and therefore A/R days, all else equal. Use the actual opening balance for the same period rather than an arbitrary prior-month value.
Ending accounts receivable also becomes required in average-balance mode. It is a nonnegative U.S.-dollar balance entered with digits, an optional decimal point, and correctly placed thousands commas; example: 24,000.00. Together with the beginning balance it forms the simple arithmetic mean. Avoid double-counting the ending balance in the separate Accounts receivable field; that field is ignored while average mode is selected.

Output guide

A/R days is the primary estimate, shown to two decimal places in days. It is driven by the selected A/R balance basis, Net credit sales, and Number of days in the period. Zero means the balance used is zero. A higher value means a larger amount of receivables relative to credit sales; a lower value means the receivable balance represents fewer days of sales. Negative A/R days are not produced because negative receivable balances are rejected. There is no universal “good” number because payment terms and industry practices differ. The summary pills repeat the active Method, Period, and Credit sales so you can verify the calculation context at a glance. In the result panel, A/R balance used identifies the actual numerator, Method tells you whether the ending balance or simple average was used, and Measurement period confirms the day multiplier. These are exact calculation identities from the current inputs rather than independent forecasts.

Worked example

With the startup values, the formula is ($30,000.00 ÷ $150,000.00) × 365. The receivable balance is 20% of the period's net credit sales, and 20% of 365 days is exactly 73 days, so the displayed result is 73.00 days. If you instead select the average-balance option with the demonstration beginning balance of $15,000.00 and ending balance of $24,000.00, the A/R basis becomes $19,500.00 and the result becomes 47.45 days. This average-balance approach can reduce the influence of an unusually high or low closing balance, although a two-point average still cannot describe every seasonal movement within the period.

Learn more

For a federal-business definition of days receivable and related working-capital terms, see the U.S. Small Business Administration's Glossary of Business Financial Terms. It provides a useful reference point for keeping the metric's numerator, credit-sales denominator, and time basis conceptually aligned.

Interpreting receivables in context

Accounts receivable is money owed to a business for products or services already provided on credit. The SBA's business credit terms guide places A/R alongside cash flow and payment terms, which is why DSO is most useful as part of a broader collection and liquidity review. A rising A/R-days trend can come from slower customer payments, more generous credit terms, billing delays, disputes, seasonality, or a change in sales mix. A falling value can reflect faster collections, but it can also coincide with tighter credit policies that affect sales, so the metric should be interpreted rather than optimized in isolation.

Use consistent accounting definitions from period to period. Net credit sales should represent sales made on credit, after relevant returns and allowances where your reporting process supports that distinction. If your business keeps records on an accrual basis, revenue recognition and cash receipt occur at different times; the IRS's cash-basis versus accrual-basis explanation illustrates that timing distinction. For management analysis, compare A/R days with invoice aging, customer terms, bad-debt experience, and prior periods rather than treating a single calculated value as a complete diagnosis.

This calculator is an educational financial-analysis tool. It does not provide accounting, tax, legal, lending, or investment advice.