Skip to content
AcademyBy ··6 min read

Days sales outstanding formula with examples

Use the days sales outstanding formula correctly, avoid common distortions and turn DSO into a weekly collections action.

Days sales outstanding formula with calendar and invoice illustration
Photo by Leeloo The First on Pexels

The days sales outstanding formula is (accounts receivable ÷ credit sales in the period) × days in the period. It tells you how long credit revenue is taking to become cash. Use it with a 90-day window and you get a useful signal quickly enough to act, without letting one large invoice throw the month sideways.

Quick answer. days sales outstanding formula is most useful when it produces one decision for this week, not another report to admire.

Calculate DSO in three deliberate steps

Choose a period, total only credit sales, then use the receivables balance at the end of that period. If you have £52,000 open after £120,000 of 90-day credit sales, DSO is 39 days. Write the inputs next to the result. A number without its period, definition and terms is the sort of tidy-looking thing that causes bad decisions.

Compare DSO with your promise

Net 30 does not mean every invoice lands on day 30. Accounts-payable teams batch payments and legitimate disputes pause the clock. But DSO that drifts far beyond terms deserves a closer look. Split the book into current, 1–30, 31–60, 61–90 and 90+ days. The last two bands determine urgency far better than the headline average.

Avoid three misleading shortcuts

Do not divide by total revenue when card-at-checkout sales are included. Do not swap between monthly and quarterly periods as it suits the story. And do not celebrate a falling DSO without checking sales volume: a shrinking sales book can lower the ratio while old invoices remain stubbornly unpaid.

Start with the record, not the assumption

Before acting on days sales outstanding formula, pull the small set of records that would let another person reach the same conclusion: the original agreement or policy, the invoice or transaction history, the current balance, and the dated messages that explain what has happened. Put them in chronological order. This sounds prosaic, but it prevents the common failure mode where a tidy-looking dashboard hides a missing credit note, a changed contact, or a promise already made by someone else. Keep the raw figure alongside the definition used to create it. If a number is based on a period, write down the start and end dates. If a term starts after acceptance rather than on an invoice date, record that too. The point is not to create paperwork for its own sake. It is to make the next action fair, explainable and easy to revisit when a customer, colleague or adviser asks how you got there.

Work through calculate dso in three deliberate steps

Treat the first pass as a controlled check rather than a grand clean-up. Choose a recent, representative slice of work: perhaps ten open invoices, one customer account, or the last ninety days of credit sales. Reconcile the total against the system of record, then inspect the exceptions one by one. A useful note names the owner, the last contact, the stated obstacle and the next date to review it. That level of detail beats a vague label such as “follow up”. It also reveals whether the problem is operational: an invoice sent to the wrong portal, an absent purchase-order number, a query that nobody acknowledged, or a reminder that was drafted but never delivered. Once those facts are visible, use days sales outstanding formula to choose one proportionate next step. Do not change a whole policy because of one awkward case; correct the cause, then see whether the pattern repeats.

Use compare dso with your promise to decide what changes

A practical decision should have an owner and a deadline. For example, if the evidence shows that invoices routinely become stuck before approval, the fix may be a pre-due check asking whether a portal upload, purchase order or supplier form is missing. If the evidence shows a genuine commercial disagreement, pause the disputed part and keep the undisputed amount visible. If the data is sound and there has simply been no response, move to the next documented message in the sequence. Keep the wording calm and specific: invoice number, amount, due date, payment route and a clear reply date. It is tempting to make an exception feel like a negotiation about the relationship. Usually it is better to make the process predictable, then reserve human judgement for the cases that really warrant it. That leaves customers knowing what to expect and gives the team a defensible record of what happened.

A realistic monthly check

Imagine a small services business reviewing its ledger on the first working Monday. One invoice is a few days beyond terms because the buyer’s accounts-payable contact has changed. Another is older, but the customer has made a recorded part payment and agreed a date for the rest. A third is large enough that the founder wants to approve any firmer wording. These are three different jobs, even though all three appear as overdue. The first needs a corrected contact and a short reminder. The second needs a diary entry and a check on the promised date. The third needs a factual handover containing the agreement, delivery evidence and previous messages. This is why an ageing number, template or software feature is only useful when it turns into a visible queue. The queue gives people a way to act without guessing, while still leaving space for an exception that deserves care.

Make avoid three misleading shortcuts repeatable

Set a cadence that is modest enough to keep. A weekly review of new exceptions and a monthly review of the headline measure will usually tell a small team more than a frantic quarter-end scramble. Save a brief note on what changed: a corrected term, a recovered payment, a disputed invoice, a customer who needed a different route, or a rule that created needless noise. Review that note with the person who owns sales or delivery as well as finance. Collections, cash flow and customer experience overlap; handing the issue to a single inbox can make a recurring process failure look like an individual debt. The related guides on payment terms, DSO and escalation are useful cross-checks when you want to test the surrounding process rather than chase one balance harder.

  1. Check the source record. Confirm the amount, dates, terms and contact before a message or calculation is created.
  2. Classify the exception. Separate missing administration, a real dispute, a promised payment and a silent overdue balance.
  3. Choose the smallest sensible step. Make payment or a useful reply easy, and keep consequential escalation with an accountable person.
  4. Record the outcome. Save what changed and when it will next be reviewed, so the next colleague does not need to reconstruct the story.
90-day DSO calculation; illustrative amounts.
MeasureValueCalculation
Open receivables£52,000Period-end balance
Credit sales£120,000Last 90 days
DSO39 days£52,000 ÷ £120,000 × 90

A practical next move

Calculate DSO on the same day each month. When it moves, review the invoices responsible for the 60+ bucket before changing terms or chasing everybody harder.

Questions people ask

What is the DSO formula?

Accounts receivable divided by credit sales, multiplied by the number of days in the selected period.

Should DSO use total sales?

No. Cash sales do not create receivables, so including them can understate collection time.

Can DSO be lower than payment terms?

Yes. It can mean customers pay early or that a proportion of sales are paid before invoicing.

Sources and limits

This guide is general operational information, not tax or legal advice. Check the contract, the governing jurisdiction and your accountant before relying on a debt, fee or tax treatment. Useful primary references: IRS Publication 334, SBA cash-flow guidance, NIST API protection guidance.

Run the formula with your own figures in the browser.

Use the DSO calculator

Stop doing this by hand

Duebay runs the escalation described here on a schedule: import your open invoices, and every overdue one gets chased from friendly nudge to final notice without you writing another email.