DSO (Days Sales Outstanding) Calculator

Share:

Compute Days Sales Outstanding (DSO) = Accounts Receivable ÷ Revenue × period. Measures how long customers take to pay invoices. Standard B2B finance KPI.

RT-FIN-213 · Finance & Money

DSO Calculator

Days Sales Outstanding
vs Stated Terms
Cash Locked in Over-Terms AR
Enter accounts receivable and revenue to compute DSO
Advertisement
After results · AD-W1Responsive · Post-tool — peak engagement

How to use the DSO Calculator

Pick the period

For annual analysis: 365 days. For quarterly: 90. For monthly: 30. The period MUST match your revenue period — use annual revenue with 365, quarterly revenue with 90. Mixing produces nonsense. Public companies disclose quarterly; private companies typically run monthly DSO for operational visibility.

Enter revenue + accounts receivable

Revenue = top-line sales for the period. AR = end-of-period accounts receivable balance (net of bad-debt allowance). Use the same period for both. For trend analysis, run the calc monthly and watch DSO over time — direction matters more than absolute level. A rising DSO is a leading indicator of collection problems building.

Enter your stated payment terms

The standard terms on your invoices — usually net 30 for B2B SMEs, net 15 for cash-tight businesses, net 60-90 for industries with long collection cycles. This sets the "expected" benchmark; the tool computes how many days over (or under) terms your actual collections are running. Best-practice DSO = stated terms. Real-world DSO is typically 5-15 days over.

Read the verdict + locked-cash figure

The verdict classifies your DSO vs stated terms (Excellent / Healthy / Elevated / Problematic / Critical). The locked-cash figure shows how much working capital is sitting in over-terms AR — money you could deploy if customers paid on time. For a $10M business at 60-day DSO vs 30-day terms, locked cash is ~$800K — a meaningful CFO conversation.

Advertisement
After how-to · AD-W2Responsive

DSO — the credit + collections KPI that every B2B CFO watches

Days Sales Outstanding measures how long it takes to collect from customers after a sale. It's the single most-watched B2B credit + collections KPI. Public companies disclose it; banks include it in covenants; credit rating agencies use it as a deterioration signal. A DSO of 45 days on $10M revenue means ~$1.23M is locked up in accounts receivable at any time. Cut DSO by 5 days and you free ~$137K of working capital — without raising capital, taking on debt, or growing sales. That's why operational excellence in collections is one of the highest-ROI activities in finance.

Reading DSO in context — terms matter

Raw DSO is meaningless without comparing to stated payment terms. A DSO of 60 days is excellent if your terms are net 60; a disaster if your terms are net 15. The right framing is DSO MINUS stated terms — "best practice DSO" or "BPDSO". BPDSO 0-5 days over terms: excellent collections; rare. 5-15 days over: normal B2B slippage. 15-30 days over: aging customers cluster — usually 1-3 accounts driving the average. 30+ days over: systemic collection failure or large customer imposing unfavourable terms. Industry norms vary wildly: retail/consumer can run DSO 5-15 (card payments); SaaS 30-45; industrial B2B 50-90; government/healthcare 90-150. Always benchmark against direct competitors.

Cut DSO by 5 days on a $10M revenue business and you free ~$137K of working capital. No capital raise. No new sales. Pure operational improvement.

How to actually reduce DSO

The DSO reduction playbook is well-established and works in any industry. (1) Invoice on delivery day: every day you delay invoicing is one day added to DSO. Automate where possible. (2) Offer 2/10 net 30: 2% discount for payment in 10 days, full amount in 30. The 2% discount is effectively 36% APR — most customers take it; you trade margin for cash. (3) Automated dunning: reminders at days 7, 21, 35 past due. Tone escalates; final reminder mentions credit hold or legal. (4) Credit hold at 45-60 days past due: stop new shipments until current balance is cleared. Sales hates this; CFO needs it. (5) Factor receivables: sell AR to a bank or factor for 95-97% face value; immediate cash. Common in long-cycle B2B and export industries. (6) Card-on-file for small customers: auto-charge on net date eliminates collection entirely for sub-$5K customers. (7) Customer credit review annually: tighten terms for slow-paying accounts; cancel credit for chronic late-payers. The combination usually reduces DSO 10-30% within 6 months.

The ASEAN DSO reality — wildly different by market

DSO benchmarks vary dramatically across ASEAN markets, reflecting payment culture, banking infrastructure, and B2B contract enforcement. Singapore: net 30 strictly enforced; typical B2B DSO 35-45 days. IRAS guidance discourages late-payment culture. Bank financing for AR-backed lending readily available. Malaysia: net 30 nominal, but DSO 60-90 common because GLCs (Petronas, TNB, government agencies) impose 90-120 day payment terms — SMEs serving GLCs run DSO 100-130 routinely. Indonesia: payment culture slower; net 60-90 common; DSO 70-110 typical. Philippines: similar to Indonesia; POGO exit + tourism recovery made many AR balances dicey 2020-2023. Vietnam: manufacturers exporting to Western customers typically run DSO 60-90 due to LC processing + ocean freight + customs cycles. Thailand: B2B more disciplined than Indonesia/Philippines; DSO 45-70 typical. For SMEs operating across the region, AR factoring (DBS, OCBC, CIMB, Maybank, BCA all offer programmes) is increasingly the working-capital backbone — it converts the long DSO into immediate cash for a small discount.

10 Things to Know About DSO

01

DSO = (AR ÷ Revenue) × Period. Days customers take to pay invoices. Standard B2B finance KPI.

02

Best-Practice DSO = stated terms. Most B2B businesses run 5-15 days over. Anything 30+ days over terms = collection problem.

03

Cut DSO by 5 days on $10M revenue = ~$137K working capital freed. Highest-ROI finance activity.

04

Singapore B2B DSO ~35-45 days (net 30 enforced); Malaysia GLC sales 100-130 days (90-120 day payment terms imposed).

05

2/10 net 30 = 2% off if paid in 10 days. Effective 36% APR — most customers take it. Trade margin for cash.

06

Rising DSO is a leading indicator of collection problems; usually precedes bad-debt writeoffs by 1-2 quarters.

07

SaaS DSO is artificially low due to annual prepayment. Annual contracts collected upfront skew the metric.

08

Factoring: sell AR to bank/factor for 95-97% face value. Immediate cash; 3-5% discount is the cost.

09

Dunning = reminder/collection sequence. Best practice: automated reminders at days 7, 21, 35 past due.

10

1-3 customers typically drive the average. Aging analysis (0-30 / 31-60 / 61-90 / 90+) reveals which.

Frequently Asked Questions

  • Industry-dependent: Retail/e-commerce 5-20 days; SaaS 30-45 (artificially low due to annual prepay); B2B services 35-55; industrial/manufacturing 50-90; construction 70-110; government/healthcare 90-150. The right benchmark is direct competitors, not industry averages. Pull 10-K data for 3-5 competitors and compare.

  • Three common causes: (1) Customer behaviour: B2B customers routinely pay 5-15 days late; treat your net 30 as net 35-45 in budgeting. (2) Invoicing delay: every day you delay invoicing after delivery adds 1 day to DSO. Automate. (3) Large customer concentration: 1-2 major accounts paying slowly can drag the average way up. Pull an aging report (0-30, 31-60, 61-90, 90+) to identify the cluster. Usually 1-3 customers explain the bulk of the over-terms DSO.

  • Usually yes. 2/10 net 30 = 2% off if paid in 10 days, full at 30. The discount is effectively 36% APR (2% for 20 days of acceleration). Most customers take it — borrowing at 36% to delay payment is irrational. Trade-off: you give up 2% of revenue for cash 20 days earlier. Math works if your weighted-average cost of capital (WACC) is below 36% — which it is for virtually all businesses. Discounts also reduce administrative collection burden, an underrated benefit.

  • When the cost of factoring (~3-5% of face value) is less than the cost of alternative working-capital funding (bank line, equity dilution, supplier finance) AND you can't reduce DSO faster. Common scenarios: fast-growing exporters waiting on LC settlement; SMEs serving GLCs with 90-120 day payment terms; seasonal businesses needing cash before peak revenue collects. Factoring also outsources collection — the factor chases the debtor. Singapore: DBS Factoring + OCBC; Malaysia: CIMB Factoring + Maybank; regional: ESG-linked invoice financing available through HSBC + Standard Chartered.

  • New customers added during growth haven't been "trained" on your terms yet. They\'re also testing how strict you are. Fix: tighten new-customer onboarding — credit application, terms acknowledgment in writing, automated payment reminder from day 1. Don\'t let new-customer payment behaviour drift; once it does, retraining is very hard.

  • Together they form the Cash Conversion Cycle: CCC = DIO + DSO − DPO. Lowering DSO reduces CCC directly. If you can also raise DPO (longer to pay suppliers), the CCC improvement compounds. Practical implication: don't optimise DSO in isolation — look at CCC + DPO together. Sometimes lowering DSO by 5 days while DPO drops by 8 days actually worsens CCC. Use the Cash Conversion Cycle calculator (RT-FIN-211) for the full picture.

  • Government + GLC customers in ASEAN typically pay 90-120 days regardless of stated terms. Singapore: government procurement aims for 30-day payment but actually runs 45-60. Malaysia: GLCs like Petronas + TNB officially 90-120 day terms; some SMEs see 150+. Indonesia + Philippines: government 120-180 days common. Survival strategies: factor receivables; charge a premium for GLC business (price in the working capital cost); negotiate progress payments (30% upfront, 30% mid, 40% completion) rather than back-loaded; have a non-GLC customer mix to balance cash flow. Don\'t treat 30-day DSO as realistic for GLC-heavy businesses — set expectations correctly.

  • They're synonyms. Some textbooks call it "receivables collection period" or "average collection period." All compute the same way: (AR ÷ Revenue) × period. "DSO" is the most common term in practice; CFOs + analysts use it interchangeably with the others.

  • No. All calculations run in your browser via JavaScript. Open DevTools → Network and confirm zero outbound requests with your data. Revenue, AR, and terms all stay on your device. Safe for confidential CFO reviews.

  • US: SEC EDGAR (10-K + 10-Q); CSC Working Capital Survey (annual industry benchmarks); REL/PwC Working Capital Survey (annual ranking). Singapore: SGX disclosures; CFO Institute Singapore + Deloitte ASEAN CFO Survey. Region: APQC working capital benchmarks (membership); S&P Capital IQ peer comparison (paid). For direct competitor analysis, just compute DSO from their disclosed balance sheet + income statement — public companies make this transparent.

Related News

You may be interested in these recent stories from our newsroom.

View all news →
Advertisement
Pre-footer · AD-W3 728 × 90

75 more free tools

Calculators, converters, security tools — no signup.