DSO & AR Aging Optimizer
Measure collections efficiency and identify trapped cash in AR. Enter values for instant results with step-by-step formulas.
Formula
DSO = (AccountsReceivable / TotalCreditSales) × DaysInPeriod
DSO measures the average number of days it takes to collect payment after a sale is made. A lower number means faster cash conversion. We calculate 'Trapped Cash' by comparing your current DSO to a standard benchmark (e.g., 45 days).
Worked Examples
Example 1: Slow Collections
Problem:$150k AR, $1.2M Sales. DSO = 45.6 days.
Solution:If target is 30 days, you have ~$50k trapped in AR.
Result:46 Days
Example 2: Fast Collections
Problem:$50k AR, $1.2M Sales. DSO = 15 days.
Solution:Excellent liquidity. Cash is in the bank, not the books.
Result:15 Days
Frequently Asked Questions
What is DSO?
Days Sales Outstanding. It represents the average time it takes for a company to convert its credit sales into cash.
Is high DSO bad?
Usually, yes. It implies you are acting as a bank for your customers. However, in some industries with long payment terms (Construction), high DSO is normal.
What is AR Aging?
A report that categorizes receivables by how long they have been outstanding (0-30 days, 31-60 days, 90+ days). Old debt becomes bad debt.
How can I lower DSO?
Invoice immediately, offer early payment discounts (2/10 Net 30), accept credit cards, and automate follow-up emails.
Does Cash Sales count?
No. DSO only applies to Credit Sales (Sales made on account). Cash sales are collected instantly (DSO=0).
Why does DSO fluctuate?
Seasonality. If you have a huge sales month in December, your AR will spike in January, temporarily inflating DSO.
What is 'Best Possible DSO'?
The DSO you would achieve if every single customer paid exactly on the due date. Comparing Actual DSO to Best Possible DSO reveals collection inefficiency.
Is negative DSO possible?
Yes, for subscription businesses that collect upfront (Deferred Revenue). This is called 'Negative Working Capital' and it's amazing for growth.
Background & Theory
The Cash Conversion Cycle
DSO is part of the CCC (Cash Conversion Cycle). DSO + DIO (Inventory Days) - DPO (Payables Days) = CCC. The goal is to minimize CCC.
Impact of Payment Terms
- Net 30: Standard.
- Net 60/90: Enterprise standard. Hard on small vendors.
- 2/10 Net 30: 2% discount if paid in 10 days. Encourages lower DSO.
Practical Tips
- Clean Invoices: Disputes cause delays. Ensure PO numbers are correct.
- Credit Checks: Don't extend credit to risky clients.
- Collections Process: Have a defined escalation path (Email -> Call -> Letter -> Hold Service).
History
The Merchant's Ledger
Since ancient Mesopotamia, credit has existed. Merchants tracked "tabs" in ledgers. DSO wasn't calculated, but "Old Debts" were known to be dangerous.
Industrial Accounting
In the 20th century, Standard Costing and Ratio Analysis formalized DSO. Banks used it to assess creditworthiness. A company with high DSO was seen as risky because their "Profit" might never actually arrive as "Cash."
The Automation Era
Today, ERPs (NetSuite, SAP) and AR Automation tools (Bill.com, HighRadius) track DSO in real-time. Automated dunning emails have replaced the "Collections Call." However, the core dynamic remains: leverage vs liquidity. Extending credit wins deals; collecting cash keeps the lights on.
Common Misconceptions
- Myth: Sales are all that matters. Reality: A sale is not a sale until the money is in the bank. Bankruptcies often happen to profitable companies who ran out of cash.
- Myth: Low DSO is always best. Reality: If you are too strict on credit (Net 0), you might lose customers to competitors offering Net 60.