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

⚠ Disclaimer: Estimates for planning purposes only. Industry benchmarks drift over time and your specific circumstances may differ materially. Verify against your own data and consult an accountant or business adviser for material decisions.
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