Draft reference — content review pending
Accounts Receivable Days
The estimated average number of days between credit sales and collection, using a defined receivables and credit-sales basis.
Business question
How long does it typically take to collect credit sales?
Formula
Accounts receivable days = (average accounts receivable ÷ credit sales for the selected period) × number of days in that period.
Calculation notes
Define whether average receivables use opening and closing balances or more frequent observations. Use credit sales, not total sales, when the denominator is intended to represent receivable-generating sales.
Edge-case guidance
If credit sales are zero or unusually small, do not present a misleading result. Investigate disputed, overdue, written-off, or reclassified balances separately.
Required data
| Input | Type | Status | Available source hints |
|---|---|---|---|
| Average accounts receivableAverage opening/closing balance or agreed period observations. | Currency | Required | Accounting software · Excel |
| Credit salesCredit sales for the same selected period. | Currency | Required | Accounting software · Excel |
| Days in reporting periodThe calendar or business-day basis chosen for the calculation. | Number | Required | Excel · Google Sheets · Manual records |
Interpretation
Use the measure to identify collection timing and cash-conversion pressure. Segment by customer group or invoice policy where useful.
Caution
The measure is sensitive to seasonality, payment terms, large invoices, credit-sales mix, and the chosen period-day basis.
Implementation recommendation
Pair the overall measure with an overdue-invoice view and a clear owner for collection follow-up.
Target guidance
Set the first target from a comparable historical baseline for accounts receivable days, then adjust it for strategy, capacity, seasonality, data quality, and relevant market or regulatory context. Review the direction with the accountable business owner rather than treating any external benchmark as universal.
