A changing sales pattern can distort days sales outstanding

Days sales outstanding compares a receivables balance with a sales flow. A sudden change in billing can move that ratio even when customers keep paying on the same schedule. Before assigning the change to collections performance, check the age and timing of the invoices inside the balance and the sales period used in the denominator.

A common calculation is closing trade receivables divided by credit sales for a period, multiplied by the number of days in that period. Some reports use average receivables instead. Neither choice is self-explanatory. Document the balance definition, sales population, treatment of credits and taxes, and period length so another analyst can reproduce the number.

ACCA's working-capital guidance discusses the assumptions involved in receivables-days measures, including whether period-end balances represent an average and whether sales are on credit. Those assumptions become especially visible during growth, contraction or uneven monthly billing.

Consider an illustrative 30-day month. A company issues $90,000 of invoices evenly through the month and customers pay exactly 15 days after invoicing. At month end, roughly the last 15 days of invoices remain outstanding, giving $45,000 of receivables and a reported DSO of 15 days.

In a second illustrative month, the company invoices the same $90,000 entirely on the final day. All invoices remain outstanding at month end even though every customer will still pay after 15 days. Closing receivables are $90,000 and the same formula reports DSO of 30 days. Collections behavior has not deteriorated; the month-end snapshot contains a much newer invoice population.

This simplified example ignores weekends, taxes, disputed invoices and opening receivables to isolate the timing effect. Real reports should retain those items explicitly. The lesson is to investigate the balance composition before translating a ratio change directly into a statement about customer conduct.

Use the invoice's issue date consistently, including invoices created after the service period ends. Grouping one month's invoices by service date and another's by issue date changes the apparent collection window. For recurring advance billing, keep the contractual due date as an additional field so the review can distinguish normal payment timing from overdue cash.

Group invoices by the month or week they were issued and measure the share collected after a consistent number of days. A cohort view can show, for example, the percentage paid within 15, 30 and 60 days. Compare like-aged cohorts; a cohort created ten days ago cannot yet demonstrate its 30-day collection outcome.

Choose whether the denominator is original billed value or billed value after valid credit notes. Preserve both when credits are material. Otherwise a team can appear to collect faster because invoices were reduced or written off. Track collected cash, credits, write-offs and remaining balances as separate movements that reconcile to the original invoice amount.

For partial payments, calculate the unpaid amount and each payment date. Counting an invoice as fully collected when its first installment arrives overstates recovery. Counting it as wholly unpaid until the final installment understates progress. Dollar-based curves generally make these partial outcomes visible more clearly than a single paid-or-unpaid flag.

Unpaid invoices may be within agreed terms, overdue without dispute, disputed, awaiting a required customer document, or held because a credit has not been applied. These categories call for different actions. Preserve the customer's actual terms and approval requirements rather than treating every open invoice as a collection failure.

Aged receivables should also distinguish invoice date from due date. An invoice issued 45 days ago under 60-day terms has a different status from one issued 45 days ago under 15-day terms. Both may sit in the same invoice-age bucket, which can distort a comparison when the customer mix changes.

Use reason codes supported by evidence, such as a dispute reference or payment promise. Review stale codes because a previously valid hold can survive long after the underlying issue is resolved. The collections meeting should assign the next action to the relevant owner, including billing or delivery teams where the obstacle starts upstream.

A rapidly growing business may end the period with a larger share of newly issued invoices than its trailing sales denominator represents. A shrinking business can show high receivables days because old unpaid invoices remain while recent sales fall. Longer averaging periods may smooth volatility, but they also mix different commercial conditions.

Report the selected DSO consistently and supplement it with sales by week, current versus overdue balances, collection curves and disputed amounts. If you introduce a different denominator or average balance, show the method change separately. Changing a definition until the ratio looks stable prevents meaningful comparisons.

The cash forecast still needs expected receipt dates for the actual open invoices. A ratio explains part of the working-capital position; it does not identify which payment will reach the bank next Tuesday. Large accounts and material disputes should have specific assumptions tied to the current collection record.

A useful monthly note might say that reported DSO increased after a month-end billing concentration, while the share of comparable invoices collected within 30 days remained unchanged. That statement is stronger than declaring collections good or bad from one number. If the cohort curve also worsened, quantify the change and identify the customers or disputes driving it.

Check the receivables total against the ledger, exclude cash sales from a credit-sales denominator, and align currency and tax treatment. Reconcile unapplied cash separately so payments already received do not remain disguised as collection delays. Retain the report cutoff because cash posted after the cutoff changes the apparent result.

Archive the cohort extract and the definitions used. When a customer pays late next month, the earlier report should remain an honest record of what was known at its own cutoff. Updating the collection history is useful; silently replacing the prior management conclusion removes the evidence needed to assess whether the team responded promptly.