DSO Reporting Checklist
Days sales outstanding (DSO) tells you, on average, how long it takes to collect what you are owed. This checklist helps you calculate it consistently and report it so it actually drives action.
What this checklist covers
- Choose a DSO method and apply it the same way every month
- Gather the right sales and receivables inputs
- Calculate DSO and compare it to terms and prior periods
- Explain movements rather than just reporting the number
- Present DSO so decision-makers can act on it
7 min
Before you start
DSO is only comparable if it is built the same way each month, on clean data. Agree the method and lock your inputs before you calculate anything.
- Confirm the AR balance is reconciled and cash applied, so receivables are accurate.
- Decide the method — simple DSO or a countback — and stick to it for trend comparison.
- Agree whether you report on net sales including or excluding GST, and be consistent.
- Have prior-period DSO and your average customer terms ready as a benchmark.
Step 1 — Gather the inputs
- Take the closing total accounts receivable at the period end from the reconciled ledger.
- Take credit sales for the period (cash-only sales do not belong in DSO).
- Note the number of days in the period being measured.
- Keep the basis consistent — do not switch between gross and net sales month to month.
Step 2 — Calculate DSO
- Apply the standard formula: DSO = (accounts receivable / credit sales) × days in period.
- For a less seasonal view, consider a countback method that subtracts whole months of sales from the AR balance.
- Sense-check the result against your average terms — DSO well above terms signals slow collection.
- Recalculate the prior period on the same basis if you have changed anything, so the comparison holds.
Step 3 — Report and explain
- Show DSO as a trend over several months, not a single number in isolation.
- Explain the movement: a new large slow payer, a billing surge, a dispute, or a genuine collections gain.
- Pair DSO with the aged trial balance so the cause of any rise is visible.
- Recommend a clear action where DSO is drifting away from terms.
If DSO keeps climbing, the lever is faster collection, not a different formula. The getting-paid-faster guide sets out practical moves, and our free tools help you tighten terms and reminders.
Common mistakes
- Changing the method. Switching formula or basis between months makes the trend meaningless.
- Including cash sales. DSO measures credit collection; cash sales deflate it and hide a real problem.
- Reporting the number alone. Without the cause, DSO is trivia — pair it with the aged report.
- Ignoring seasonality. A simple DSO can spike purely on billing timing; a countback view reduces that noise.
Key takeaways
- Pick one DSO method and apply it consistently for the trend to mean anything
- Use credit sales only, and keep the gross-versus-net basis consistent
- Compare DSO to your terms, not just to last month
- Always explain the cause of a movement, paired with the aged report
Frequently asked questions
What is a good DSO?
A DSO close to your average payment terms is healthy. If you sell on 30-day terms, a DSO drifting towards 45 or 50 days signals slow collection. There is no universal target — compare against your own terms and your prior trend rather than a generic figure.
What is the difference between simple DSO and countback DSO?
Simple DSO divides receivables by credit sales and multiplies by days in the period. The countback method subtracts whole months of sales from the AR balance to reflect how recent the unpaid invoices are, which reduces distortion from seasonal or lumpy billing.
Should DSO use sales including GST?
You can use either, as long as you are consistent, because the AR balance and the sales figure should be on the same basis. Mixing a GST-inclusive receivable with GST-exclusive sales will distort the result.
Work the checklist, then get paid
Use the free Invoice Generator, then let Merion recover anything that goes unpaid — commission-only.