Days Outstanding Calculator

Your sales are booked, the invoices are sent, and the bank balance still has not moved. This calculator turns that wait into one number: days sales outstanding (DSO), the average number of days your customers take to pay, checked directly against the payment terms you actually offer.

Enter beginning and ending accounts receivable, credit sales for the period, and your terms if you have them. You get average receivables, DSO to one decimal place, and a plain verdict on whether customers are paying inside your terms or past them.

Quick Answer

How to use this days sales outstanding calculator

Start with the two receivables figures from your balance sheet, at the opening and closing dates of the period you are measuring. Add credit sales for that same period, not total revenue, and set the day count to match: 365 for a year, roughly 90 for a quarter, roughly 30 for a month. Add your payment terms if you want the verdict, then press Calculate DSO.

Two input habits decide whether the answer means anything. First, the receivables and the sales must cover the same window: annual sales against a single month of receivables produces a nonsense figure. Second, if you genuinely have only one receivables balance, enter it in either AR field and leave the other blank. The tool uses that figure directly and the result is still useful as a snapshot, as long as you remember it describes one date rather than the whole period. The closely related settlement-period framing is covered further down on this page, alongside the payables side it is usually paired with; the calculator itself stays with the standard average-balance DSO that finance teams report month to month, and the sections further down explain exactly where the two differ and how to read both sides together.

The DSO formula, step by step

The formula divides what customers owe you by what you sold on credit, then stretches that share across the days in the period.

The Corporate Finance Institute states the same calculation in its guide to days sales outstanding: receivables divided by net credit sales, multiplied by the number of days. AccountingTools gives the equivalent form in its days sales outstanding calculation, and adds the practical rule that a result about 25% above your standard terms marks the point where collection effort deserves a closer look. On Net 30 terms, that tripwire sits near 37 to 38 days, well above the 30.4 days in the worked example.

DSO is also one of three legs of the cash conversion cycle, as the Corporate Finance Institute sets out in its cash conversion cycle guide: days inventory outstanding plus DSO, minus days payable outstanding. That is why this page cross-checks so naturally against the payables side. Your collection speed only tells half the cash story until you set it next to your payment speed.

Worked example: 30.4 days against Net 30 terms

The calculator is pre-filled with this case, and every number below is what it returns when you press Calculate.

Read that result as a pass, not a problem. Half a day of drift across a full year is normal invoice timing, not late payment. The figure that should worry you is the trend: if the same business reports 30.4 days this year, 36 next year, and 44 the year after, customers are quietly stretching you, and the cash effect compounds. At $3,000,000 of annual credit sales, moving from 30.4 to 44 days locks up roughly another $111,800 in receivables (13.6 days at about $8,219 per day), money that has been earned on paper and cannot be spent.

The bars use the worked example and the AccountingTools 25% guideline. They are a reading aid for one set of terms, not a universal scale: a business on Net 60 terms should redraw them around 60 days, and a business selling mostly for cash should question whether DSO deserves much attention at all.

DSO, DPO, and the settlement period: three numbers people mix up

DSO measures money coming in. It says nothing about money going out, and confusing the two sides produces exactly backwards decisions.

Days payable outstanding (DPO) is the mirror image: the average number of days you take to pay your own suppliers, worked out from accounts payable and cost of goods sold. Shortening your DSO frees cash; lengthening your DPO, within agreed terms, also frees cash. If your DSO is drifting up while your DPO is drifting down, you are financing your customers with your own bank balance from both directions. Run your payables figures through the days payable calculator and compare the two results side by side before changing any policy.

Average settlement period sounds like a different metric, and the honest position is that it is a close relative rather than a twin. Both start from receivables and credit sales, but settlement-period presentations often work from a single closing balance and are used in textbook ratio analysis of how long debtors take to settle. This calculator averages the opening and closing balances, which is the convention monthly management reporting follows, because it describes the whole period instead of one date. If you need the single-balance textbook version for coursework or a lender template, enter the closing balance in one AR field and leave the other blank; if you are running a business month to month, the averaged DSO here is the figure your trend line should track. A related aging view is the average debtor days calculator, which frames the same collection wait from the debtor ledger side.

Reading both sides together: the settlement gap

Settlement period is the shared name for the pair: debtor days on the receivables side, which is the DSO this page calculates, and creditor days on the payables side. The payables version mirrors the DSO formula, with payables in place of receivables and credit purchases in place of credit sales: creditor days = (trade payables / credit purchases) x days in period. Some textbooks divide by cost of sales instead of credit purchases, because cost of sales is printed in the accounts while credit purchases often has to be estimated; the logic is the same and the two answers are close when stock levels are stable. This calculator does not compute the payables side: run those figures through the days payable calculator linked above, or work the formula by hand, then set the two results side by side.

A worked comparison shows why the pairing matters. Take one wholesaler with $75,000 owed to suppliers against $300,000 of annual credit purchases, and $50,000 owed by customers against $300,000 of annual credit sales. Its payables settlement period is ($75,000 / $300,000) x 365 = 91.25 days, and its receivables settlement period on the single-balance textbook basis is ($50,000 / $300,000) x 365 = 60.83 days. The difference, 91.25 minus 60.83, is a settlement gap of 30.42 days in the company's favour: it collects about a month faster than it pays. Note the basis difference before comparing with your own figure: the 60.83 days uses one closing balance, while the calculator above averages the opening and closing balances, so the two receivables figures for the same business will not match exactly.

Read the gap, not just the two numbers. A gap in your favour means suppliers are effectively funding your operations, which helps the bank balance today and carries a supplier risk tomorrow: terms can tighten, late-payment interest can apply, and orders can drop in priority when stock is short. A gap the other way round, collecting slower than you pay, is the classic cash stress signal: every sale has to be funded from your own balance until the customer settles, so growth itself eats cash. That is also why a long period means opposite things on the two sides, as the table shows: long is comfortable on the payables side and costly on the receivables side, and short is the reverse.

What a rising DSO is usually telling you

A rising DSO rarely has one cause, and the cause decides the fix. Work through the usual suspects in this order, because the first two are process problems you can solve this month, while the last two are policy problems that need a decision.

Invoice friction. Invoices sent late, sent to the wrong contact, or missing a purchase order number sit unpaid while the clock runs. The customer is not slow; your paperwork is. Collection follow-up slipping. Nobody owns the reminder at day 31, so payment waits for the customer to get around to it. Terms creep. Sales staff quietly offer Net 45 or Net 60 to close deals while the official policy still says Net 30, so DSO rises even though every customer pays on their actual terms. Customer stress. One or two large customers stretching payments because their own cash is tight. That pattern shows up in DSO months before it shows up as a bad debt, which is why lenders and acquirers watch this ratio closely. Pair the DSO trend with your days working capital position to see whether slower collection is lengthening the whole cash cycle or being absorbed elsewhere.

What competing calculators miss

The DSO tools ranking for this term mostly divide one receivables figure by sales and stop. Three gaps kept appearing in that set.

Gap 1: a single snapshot presented as the answer. Most tools ask for one AR balance, usually the closing one, with no prompt to average. A closing balance taken the day after a collection push flatters DSO; taken after a seasonal shipping peak, it punishes it. This tool takes both balances and averages them, and still accepts a single figure when that is all you have.

Gap 2: no verdict against your terms. A bare 41 days means nothing until it sits next to the terms you granted. Here the optional terms field turns the result into a decision: inside terms, or a stated number of days over them, with the gap converted into plain language.

Gap 3: total revenue quietly accepted. Several tools label the denominator as revenue or sales with no warning. Cash sales in that figure push DSO down and hide late payment. This page labels the field credit sales, repeats the warning under the results, and explains the error in the FAQs, because it is the single most common reason a DSO figure looks better than the business feels.

Frequently Asked Questions

Add This Calculator to Your Website

References