Accounts Receivable Days (DSO)

What formula does this tool use?

DSO = accounts receivable balance ÷ annual revenue × 365. It divides one balance-sheet figure by a full year’s revenue, so the result is the number of days of revenue sitting in receivables. Daily revenue is annual revenue ÷ 365, and AR turnover is annual revenue ÷ receivables balance. All three use the figures exactly as entered, with no averaging of opening and closing balances.

What do the three assessment labels mean?

They compare DSO with the payment terms you enter. “On target” means DSO is at or below the terms, “Slightly delayed” means it is above the terms but no more than 1.5 times them, and “Collection issues” means it is more than 1.5 times the terms. The 1.5 cut-off is a rule built into this tool, not an accounting standard, and with terms of 30 days it flags anything over 45.0 days.

What happens when annual revenue is zero?

DSO is shown as not available, with a message to enter annual revenue above zero, because dividing by zero has no meaning. Only the payment terms are echoed back. Negative balances or revenue are treated as zero, so a credit balance in receivables will not produce a negative DSO.

What if receivables are zero?

DSO is 0.0 days, the variance reads as the full number of days inside terms, the assessment is “On target”, and AR turnover shows “n/a (no receivables)”, since dividing revenue by zero has no meaning. A zero DSO usually means customers pay at the point of sale or the balance was entered wrongly.

Can payment terms be zero?

Yes: 0 is accepted for immediate-payment terms. Clearing the box counts as 0, so it gives terms of 0 days, not 30. With terms of 0 any positive DSO counts as beyond terms and is labelled “Collection issues”, because 1.5 times zero is still zero; a zero-day policy therefore needs a DSO of exactly zero to read “On target”.

Why can the answer differ from my own DSO figure?

This is the annual-revenue version of the measure. It assumes revenue is spread evenly through the year and uses a single balance. If you sell mostly on credit, use only credit sales as the revenue figure; if sales are seasonal, or you measure DSO over a quarter or month, a version using that period’s revenue and days will give a different number. The tool has no field for that.

What does “days beyond terms” mean?

It is DSO minus the payment terms, shown as “days beyond terms” when positive and “days inside terms” when not. It is a gap between an average and a policy, not a count of invoices that are late, and it says nothing about how overdue any one customer is. Ageing receivables by invoice would be needed for that, and this tool does not do it.