Publication number: ELQ-43125-1
View all versions & Certificate
DSO Tracker: Days Sales Outstanding Model and Dashboard (Monthly, Quarterly and Annual)
A plain English, industry agnostic Excel template for measuring, tracking and reporting Days Sales Outstanding. Two numbers a month is all it takes.
Further information
* Calculate monthly, quarterly, annual and trailing twelve month DSO from a simple set of monthly inputs.
* Give management a clear view of how quickly accounts receivable is being converted into cash.
* Track DSO against an internal target or benchmark and identify whether collections performance is improving or deteriorating.
* Smooth month-to-month volatility with a three month moving average and use trailing twelve month DSO to assess the longer-term trend.
* Understand how the composition of A/R is changing through optional aging analysis.
* Provide a repeatable, presentation-ready DSO reporting process without requiring a complex BI system or bespoke spreadsheet build.
* Reduce the time and spreadsheet maintenance normally required to prepare a monthly DSO report.
* Give finance teams, consultants and management a common reporting framework that can be updated each month with minimal effort.
This model works best when:
* Your business has a meaningful accounts receivable balance generated from sales made on credit.
* Revenue sold on credit and closing A/R can be obtained reliably from your accounting or ERP system for each month.
* You want to monitor DSO at the overall company level rather than calculate DSO separately for hundreds of individual customers or invoices.
* Your billing and revenue patterns are reasonably consistent from month to month, or you are comfortable using the three month and trailing twelve month views to smooth normal fluctuations.
* Your business has established payment terms and you want to compare actual collection performance against an internal DSO target.
* You need a lightweight reporting solution that sits alongside your existing accounting system rather than a full collections, credit-risk or cash forecasting platform.
* You want monthly management reporting that can be refreshed without rebuilding formulas, charts or reporting periods.
* You operate on a calendar or fiscal year and can define the appropriate fiscal year-end month.
* You need a practical DSO model for management reporting, board packs, lender reporting, investor updates, budgeting discussions or collections reviews.
This model may not be the best fit when:
* Your business has little or no accounts receivable because customers generally pay at the time of sale.
* Your A/R balance includes significant amounts unrelated to normal trade receivables, such as loans, employee advances, tax receivables or other non-trade balances, without being separated before input.
* Revenue sold on credit cannot be reliably identified or separated from cash sales.
* Your business experiences extremely large or irregular one-off billings where a simple month-end DSO calculation would be materially distorted by billing timing.
* Revenue recognition and invoicing occur on substantially different schedules and you need a metric specifically tied to contractual billing or invoice dates rather than recognized credit revenue.
* You need customer-level, invoice-level or collector-level performance analysis as the primary purpose of the model. The optional support tabs demonstrate invoice-to-monthly aggregation but are not intended to replace a dedicated collections or credit management system.
* You need a detailed cash collection forecast, probability-of-payment model, credit-risk assessment, or expected credit loss calculation. DSO is a receivables performance metric, not a complete cash forecasting or credit-risk model.
* Your organization requires highly specialized DSO methodology, such as customer-segment-specific calculations, contractual-term adjustments, weighted payment-term analysis, or industry-specific KPIs that go beyond the standard monthly DSO approach.
* Your accounting data is not reconciled or the monthly revenue and A/R figures are inconsistent in definition from one period to another. The model can calculate the metric accurately from its inputs, but it cannot correct an underlying accounting or data-definition problem.
