Guide

How to calculate DSO — and what actually brings it down

Days sales outstanding is the one receivables number that tells you whether cash is arriving on the schedule you invoiced. Here is the formula, a worked example, and the levers that move it.

Short answer DSO = (accounts receivable ÷ net credit sales) × the number of days in the period. Take the money owed to you at the end of the period, divide it by the sales that generated it, and multiply by 365 for a year or 30 for a month. The result is the average number of days your cash spends in a customer's bank account instead of yours.

The formula, in full

There are two numbers in the numerator and denominator that people mix up, so it is worth stating them precisely.

DSO = (Accounts receivable ÷ Net credit sales) × Days in period Accounts receivable — the closing balance, not the average, for a snapshot reading. Use the average of opening and closing AR if you want the period's smoothed figure.
Net credit sales — sales made on credit, net of returns and discounts. Cash sales are excluded: they were never receivable.

A worked example

A small accounting firm closes the year with $180,000 in accounts receivable and $1,460,000 in net credit sales.

(180,000 ÷ 1,460,000) × 365 = 0.1233 × 365 = 45 days

The same firm on a monthly basis: $180,000 of AR against $122,000 of sales for the month.

(180,000 ÷ 122,000) × 30 = 44.3 days

Both methods land in the same place — around 45 days — because the annual and monthly figures are consistent. They will diverge if the business is seasonal or growing fast: a month with unusually high billings flatters the monthly DSO, and a month with unusually low billings distorts it the other way. That is why a rolling three-month or twelve-month calculation is the safer number to track.

The quick estimate: terms plus days late

If every customer paid exactly on the due date, DSO would equal your payment terms — nothing more. Every day beyond that is lateness, so:

DSO ≈ Payment terms + average days paid late

A firm invoicing on 30-day terms whose customers pay 15 days late, on average, has a DSO of about 45 days. This is the same arithmetic as the full formula, rearranged around behaviour you can actually observe in an aging report. It is the method the free AR cash-lockup calculator uses: enter monthly sales, terms and average days late, and it returns DSO, the working capital locked in receivables, and the cash released by collecting faster.

What the number is telling you

DSO converts a pile of invoices into a single behaviour: how long customers take to pay. Read it in three ways.

Against your own terms. DSO of 45 on 30-day terms means roughly 15 days of slippage. That gap — not the headline DSO — is the addressable problem.
Against your own trend. A DSO that drifts from 38 to 45 over three months is a process changing, usually quietly: a reminder stopped going out, a client started disputing invoices, or a large account began stretching payment.
Against the cost of carrying it. Every day of DSO is cash you have earned but not received, funded by an overdraft or by your own reserves. On $122,000 of monthly billings, one day of DSO is about $4,000 of working capital. Ten days is $40,000.

These are planning estimates, not accounting advice. Substitute your own cost of capital and your own period length; the arithmetic does not change.

What moves DSO up

Before optimising, it helps to know the usual suspects. In small firms the same five recur:

Terms that are longer than they need to be. 45-day terms on work delivered in a week buy goodwill and cost cash. Terms set per client, rather than by default, usually shorten DSO with no collection effort at all.
Reminders that depend on memory. The single largest cause of drift. A day-7 email that goes out on day 19 because someone was busy is a 12-day DSO increase, repeated across every invoice.
Invoice errors and disputes. A wrong PO number or a missing timesheet detail stops the clock while the client waits for a correction. Every disputed invoice costs a full payment cycle.
Batching by invoice instead of by customer. Five emails about five invoices in one week reads as noise and gets ignored; one email about the total owed gets a payment date.
Concentration. One large client paying late can dominate the average. Segment DSO by customer to see whether the problem is systemic or one account.

How to reduce DSO, in order of effort

Measure it properly first. Pick one method — annual, rolling three-month, or terms-plus-days-late — and compute it on the same day each month. A number you recalculate inconsistently cannot show a trend.
Segment by customer. Split DSO into your top ten accounts and everyone else. Firms routinely find that a handful of clients account for most of the slippage, and those conversations are worth having individually.
Send a pre-due heads-up. A short note three days before the due date, with the invoice attached, prevents more late payment than any reminder sent afterwards. It is also the cheapest rung on the ladder.
Fix the rungs and the days. Decide the sequence once — for example a check-in at day 7, a firm follow-up at day 35, an urgent warning at day 65, a final notice at day 95 — and treat the schedule as policy rather than a decision to be made per invoice.
Batch one email per customer per stage. State the total outstanding across all open invoices, with the PDFs attached, so nothing hides in an old thread.
Remove the friction from paying. A payment link or clear bank details in every reminder removes the "I'll get to it" delay that has nothing to do with willingness to pay.
Review weekly, not annually. DSO is a lagging indicator. The leading indicators are how many reminders went out, how many invoices are in dispute, and how many are past 60 days.

The first four steps cost nothing but discipline. The fifth and sixth are where a fixed schedule beats good intentions: a collection ladder runs the same reminders whether or not anyone remembers, and the five reminder templates are already written for you to adapt.

A realistic target

Do not aim for a DSO below your terms — that is a measurement artefact, not a win. Aim to close the gap between terms and DSO, and expect the first improvements to come from consistency rather than pressure: the day-7 email actually sent on day 7, the pre-due note going out at all, the disputed invoice corrected before the cycle turns. A firm on 30-day terms moving from 45 days to 35 days releases roughly $40,000 of working capital at $122,000 of monthly billings — without writing a single chasing email.

Frequently asked questions

What is the formula for DSO?

DSO = (accounts receivable ÷ net credit sales) × number of days in the period. Use 365 for an annual figure, 90 for a quarter, or 30 for a month. The result is the average number of days it takes to collect an invoice — how long your cash sits in someone else's bank account.

What is a good DSO?

A DSO close to your stated payment terms is the practical benchmark. If you invoice on 30-day terms and DSO is 45, customers are paying about 15 days late on average and that gap is the number worth attacking. There is no universal "good" figure across industries — compare against your own terms and your own trend month to month.

How do you calculate DSO for a month?

Take the accounts receivable at the end of the month, divide by that month's net credit sales, and multiply by 30. Because a single month of sales can be noisy, many firms also run a rolling three-month version: closing AR ÷ average daily sales over 90 days, which smooths one-off billing spikes.

What is the quick estimate of DSO from payment terms?

If every customer paid exactly on time, DSO would equal your payment terms. So DSO ≈ payment terms + average days late. That approximation is what the Settl AR cash-lockup calculator uses: enter your terms and your average delay, and it returns DSO plus the working capital tied up in receivables.

Does reducing DSO damage client relationships?

Not if the pressure is applied through consistency rather than volume. One calm reminder per customer at fixed intervals, sent from the firm's own address, is less intrusive than scattered chasing — and far less intrusive than an abrupt final notice after months of silence. DSO usually falls because reminders stop being forgotten, not because the tone gets harsher.

Shorten DSO without chasing anyone by hand.

Every morning Settl reads the firm's open invoices, groups them by customer, and sends the right reminder at the right rung — with the PDFs attached, from the firm's own mailbox, white-labelled. One email per customer per stage, so the cadence feels calm rather than relentless.

Book a demo See how it works