Receivables & Payables Days (DSO, DPO) Calculator

Understanding the DSO and DPO calculator — concept and principle

Days sales outstanding (DSO) tells you how many days, on average, customers take to pay you, and days payable outstanding (DPO) tells you how many days you take to pay your suppliers. Finance teams, lenders and business owners track both to manage cash flow: collecting faster and paying on agreed terms frees cash without borrowing. The calculator works with any currency; the example uses US dollars.

How it is calculated

• DSO = average receivables ÷ annual credit sales × 365
• Receivables turnover = annual credit sales ÷ average receivables
• DPO = average payables ÷ annual COGS (or purchases) × 365
• Payables turnover = annual COGS ÷ average payables

Average receivables and payables are usually (opening balance + closing balance) ÷ 2 for the year. Credit sales exclude cash sales, because cash sales never sit in receivables.

The principle

Receivables are sales you have made but not yet collected. If you sell $1.5 million a year on credit, you sell about $4,110 per day; dividing the receivables balance by that daily figure tells you how many days of sales are waiting to be paid. Turnover is the same idea expressed the other way: how many times a year the receivables balance is collected and replaced. DSO = 365 ÷ turnover. DPO applies the same logic to what you owe suppliers, using cost of goods sold or purchases as the base.

Worked example

1. Inputs: credit sales $1,500,000, receivables $200,000, COGS $900,000, payables $110,000.
2. DSO: 200,000 ÷ 1,500,000 × 365 = 48.7 days.
3. Receivables turnover: 1,500,000 ÷ 200,000 = 7.5×.
4. DPO: 110,000 ÷ 900,000 × 365 = 44.6 days.
5. Payables turnover: 900,000 ÷ 110,000 = 8.18×.

How to read the result

Compare DSO with your payment terms. If you offer 30-day terms and DSO is 49 days, customers are paying about 19 days late on average. A rising DSO can signal collection problems or looser credit. A higher DPO keeps cash in the business longer, but stretching it beyond agreed terms can damage supplier relationships and cost you early payment discounts. Here DSO exceeds DPO by about 4 days, meaning you finance your customers slightly longer than your suppliers finance you. Adding days inventory outstanding (DIO) gives the cash conversion cycle: DIO + DSO − DPO.

Common mistakes

• Using total sales, including cash sales, which understates DSO.
• Taking a year-end balance in a seasonal business instead of an average.
• Mixing COGS and purchases between periods when comparing DPO.

Frequently asked questions

Why use 365 days and not 360?

Both conventions exist. The calculator uses 365; using 360 gives slightly lower day counts.

What is a good DSO?

One close to your standard payment terms. Industries with longer terms naturally show higher DSO.

Can I calculate quarterly DSO?

Yes: use quarterly credit sales and multiply by the number of days in the quarter instead of 365.

Sources: CFA Institute, Financial Reporting and Analysis (CFA Program curriculum) · Brealey, R. A., Myers, S. C. & Allen, F., Principles of Corporate Finance, McGraw-Hill