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.

Plan my KPIs

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.

(Average accounts receivable / Credit sales) × Period days

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

InputTypeStatusAvailable source hints
Average accounts receivableAverage opening/closing balance or agreed period observations.CurrencyRequiredAccounting software · Excel
Credit salesCredit sales for the same selected period.CurrencyRequiredAccounting software · Excel
Days in reporting periodThe calendar or business-day basis chosen for the calculation.NumberRequiredExcel · 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.

Related metrics