Days Sales Outstanding Calculator
Calculate DSO from receivables and credit sales for any period, see what a change in DSO is worth in cash, and compare it with a target. Enter the accounts receivable, the credit sales and the days in the period; add your payment terms to see how late customers pay on average, or switch to the countback method and the trend table.
Receivables and sales
Enter it to use the average of start and end instead of the end balance.
Sales on invoice only. Cash sales are collected on the spot and stay out.
Net 30 is 30. Leave empty to skip the comparison.
To see what collecting that many days faster frees in cash.
Results
Days sales outstanding
22.5 days
$150,000 ÷ $600,000 × 90 days
Credit sales per day
$6,666.67
Against payment terms
7.5 days inside terms, on average
Receivables if DSO matched the terms
$200,000
Credit sales per day × 30 days
Cash freed by the cut
$33,333.33
$6,666.67 a day × 5 days; DSO would be 17.5 days
Countback method
For businesses whose sales swing from month to month. Enter the receivables at the end of the newest month, then each month's credit sales, newest first. Each full month's sales are taken off the receivables and its days counted; the month where the receivables run out counts only in proportion.
Newest month first.
- $
- $
- $
Results
Countback DSO
44.7 days
| Month | Credit sales in the period | Receivables before | Cleared by this month | Days counted |
|---|---|---|---|---|
| July | $50,000 | $82,000 | $50,000 | 31 |
| June | $70,000 | $32,000 | $32,000 | 13.7(part of the month) |
DSO trend
One row per period, oldest first: receivables at the end, credit sales and days. The change column shows the movement from the previous period.
- $$
- $$
- $$
Results
| Period | Accounts receivable at the end of the period | Credit sales in the period | Days | DSO | Change |
|---|---|---|---|---|---|
| January | $150,000 | $200,000 | 31 | 23.3 | – |
| February | $170,000 | $200,000 | 28 | 23.8 | +0.6 |
| March | $140,000 | $200,000 | 31 | 21.7 | -2.1 |
What you type is not sent to ParrotNotes.
What days sales outstanding is, and the DSO formula
Days sales outstanding (DSO) is the average number of days between a sale on invoice and the cash arriving. DSO = accounts receivable ÷ credit sales in the period × days in the period. Receivables are what customers still owe at the end of the period; credit sales are the sales made on invoice during it, cash sales left out.
Example: $150,000 of receivables at the end of a quarter in which you invoiced $600,000. DSO = $150,000 ÷ $600,000 × 90 = 22.5 days: on average, an invoice is paid about three weeks after it is sent.
Some companies use the average of receivables at the start and the end of the period, which smooths out a big invoice sent on the last day. Enter the start balance and the calculator uses the average; whichever you use, keep it the same from period to period so the trend means something.
What a lower DSO is worth in cash
Every day of DSO is one day of credit sales sitting in receivables instead of the bank. Credit sales per day = credit sales ÷ days in the period, and cash freed = credit sales per day × the days you cut. With $2,000,000 of credit sales a year, a day is $5,479; bringing DSO down by 5 days frees $27,397 of cash, once, and keeps it freed as long as the collection pace holds.
That is cash that needs no new sale and no new loan: it comes from invoices already sent. The calculator shows the figure for any cut you enter and the DSO you would land on.
DSO against your payment terms
DSO only means something next to the terms you give. On net 30, a DSO of 30 says customers pay exactly on time on average; a DSO of 40.5 says they pay about 10 days late. Example: $450,000 of receivables on $1,000,000 of quarterly credit sales is a DSO of 40.5 days; against net 30 that is 10.5 days over terms, and collecting on terms would bring receivables down to about $333,333, freeing about $116,667.
A DSO below your terms is normal when many customers pay early or pay a deposit. There is no universal good number: it depends on the terms common in your industry and on the mix of customers, so compare with your own terms and your own trend.
The countback method
The simple formula assumes sales were spread evenly over the period. When sales swing from month to month, a big month at the end inflates receivables and makes DSO look worse than collections are. The countback method fixes that: start with the receivables at the end of the newest month, take off that month's credit sales and count its days, and keep going back a month at a time; in the month where the receivables run out, count only the share you needed.
Example: $82,000 of receivables at the end of July. July's credit sales were $50,000, so all 31 days count and $32,000 is left. June's sales were $70,000 in 30 days: $32,000 ÷ $70,000 × 30 = 13.7 days. Countback DSO = 31 + 13.7 = 44.7 days. The second tab does this for up to 12 months.
Why DSO matters to a sales team
Commission plans that pay on cash collected, and QBRs that track cash as well as bookings, make DSO the rep's problem too: a deal is not done until it is paid. Most late payments trace back to something decided or left vague on the call: the start date, whether a purchase order is needed before delivery, who approves the invoice and where it goes.
Agree the terms on the call, get the PO number before you ship, and name the invoice contact in the CRM. The posts below cover the pipeline and account side; the trend tab here shows whether it is working.
The calculator reports DSO for the whole business. For a single customer or account, use that customer's receivables and credit sales the same way.
The results are built from what you enter. Use credit sales only, keep the period and the receivables definition the same from one period to the next, and read DSO against your own payment terms rather than a general benchmark.
For sales ops and account managers: CRM adoption, sales pipeline management, key account management, distributor sales.
Late payments start as unclear agreements on the call
The start date, the PO, who signs off the invoice: when those are settled out loud but never written down, the invoice waits. Record the call in ParrotNotes and get the summary and action items, so the terms you agreed are in writing before the order goes in. Free for 100 minutes of recording a month.
Get ParrotNotes freeRelated tools
- MRR and ARR CalculatorWork out monthly and annual recurring revenue from your plans and customers, with new, expansion, contraction and churned MRR for the month.Open the tool
- Churn Rate CalculatorWork out customer churn and revenue churn for a month, quarter or year, with net revenue retention and what the rate means for a customer's lifetime.Open the tool
- ROI CalculatorWork out return on investment, annualized ROI and payback period from what you put in and what you get back, for a purchase or a customer's business case.Open the tool
- NPV CalculatorWork out the net present value of an investment from its cash flows and discount rate, with IRR, payback and a year-by-year table.Open the tool