Cash Flow Analysis

Days Sales Outstanding (DSO) / Accounts Receivable Aging Calculator

Measure how fast your business collects payments and optimize your cash flow. Calculate DSO and visualize your receivables aging breakdown.

DSO & AR Aging Calculator
Analyze your accounts receivable efficiency and collection patterns

Aging Receivables Breakdown (Optional)

Enter your metrics and click calculate to see results

What Is Days Sales Outstanding (DSO)?

DSO shows the average number of days it takes your company to collect cash from customers after a sale. Lower DSO = faster cash flow.

๐Ÿงฎ DSO Formula Example

If total credit sales = $120,000 and average receivables = $20,000 over 30 days:

DSO = (20,000 รท 120,000) ร— 30 = 5 days

๐Ÿ’ก Why DSO Matters

Cash Flow Health

Indicates liquidity and working capital efficiency

Late Payment Detection

Helps identify customers with payment issues

Forecasting

Improves cash flow predictions and planning

Credit Terms

Influences supplier relationships and credit limits

๐Ÿ“Š AR Aging Table Example

Age RangeAmount% of Total
0โ€“30 days$60,00060%
31โ€“60 days$25,00025%
61โ€“90 days$10,00010%
90+ days$5,0005%

โš™๏ธ Tips to Reduce DSO

Early Payment Discounts

Offer 2% discount for payments within 10 days

Automated Reminders

Set up automated email reminders for overdue invoices

Late Payment Penalties

Enforce consistent late fees and interest charges

Customer Vetting

Improve credit checks and payment terms screening