Free Accounts Receivable & DSO Calculator

Step 1: Annual Credit Sales, Aging Schedule Buckets & Capital Cost

Accounts Receivable & Aging Schedule Inputs

💰 Annual Credit Sales & Capital Cost

Annual Credit Sales ($)

WACC / Interest %

DSO = (Gross A/R / Annual Credit Sales) × 365. Bad debt provision is calculated from aging loss probability weights (1% Current to 65% Delinquent).

📅 A/R Aging Schedule Buckets ($)

Current 0-30d ($)

Past 31-60d ($)

Past 61-90d ($)

Past 91-120d ($)

Delinquent 120d+ ($)

Days Sales Outstanding

42.0 Days DSO

8.7x annual turnover on $1.15M total receivables

Bad Debt Reserve (Allowance)

$43.0K

3.74% default loss provision across aging buckets

Annual A/R Carrying Cost

$97.8K / yr

Working capital interest at 8.5% WACC

10-Day Cash Acceleration

+$274.0K

Liquidity released by accelerating collections by 10 days

Credit Matrix: Annual Credit Sales ($) vs. DSO Target (Days)

Simulates Outstanding A/R Capital Lockup ($), Annual Working Capital Carrying Cost ($), and Collection Speed.

Annual Sales	30 Days DSO	42 Days DSO	50 Days DSO	60 Days DSO	75 Days DSO

Corporate Credit Principles

Understanding Accounts Receivable & DSO

Key trade credit, working capital, and bad debt management principles:

The Cash Conversion Cycle Drag: High DSO traps cash on customer ledgers, forcing companies to draw down expensive revolving credit lines to meet payroll and supplier payables.
Aging Decay Probability: Invoices past 90 days have a 30% to 65% probability of default, requiring aggressive collection escalation and bad debt reserve write-offs.
CECL (Current Expected Credit Losses): Modern accounting standards require proactive lifetime expected loss modeling rather than waiting for an actual default trigger.
Dynamic Discounting (2/10 Net 30): Offering early-payment discounts can reduce DSO by 15-20 days, providing cheaper liquidity than high-interest mezzanine financing.

Evaluate firm cash velocity in the Cash Conversion Cycle Lab.

Mathematical Formulation

A/R & DSO equations

Gross_AR = AR_0_30 + AR_31_60 + AR_61_90 + AR_91_120 + AR_120_plus

DSO = ( Gross_AR / Annual_Credit_Sales ) × 365

AR_Turnover = Annual_Credit_Sales / Gross_AR

Bad_Debt_Reserve = ∑ ( AR_Bucket_Balance_i × Expected_Loss_%_i )

Net_Realizable_AR = Gross_AR - Bad_Debt_Reserve

Annual_Carrying_Cost = Gross_AR × ( WACC_% / 100 )

Cash_Unlocked_10d = 10 × ( Annual_Credit_Sales / 365 )

Model solvency risk in the Altman Z-Score Lab.

FAQ

Accounts receivable & DSO questions

What is Days Sales Outstanding (DSO)?

Days Sales Outstanding (DSO) measures the average number of days it takes a company to collect cash payments after a credit sale has been completed: DSO = (Accounts Receivable / Total Credit Sales) x 365.

How does an Accounts Receivable Aging Schedule work?

An A/R aging schedule categorizes open customer invoices into time buckets (Current 0-30, Past Due 31-60, 61-90, 91-120, and 120+ days). Older buckets carry exponentially higher probabilities of default.

What is the Allowance for Doubtful Accounts (Bad Debt Reserve)?

It is a contra-asset account on the balance sheet that estimates uncollectible receivables, reducing gross receivables to their Net Realizable Value in accordance with GAAP/IFRS matching principles.

How much cash is unlocked by reducing DSO?

Each day of DSO reduction frees up one day of credit sales in immediate cash liquidity: Cash Unlocked = DSO Days Reduced x (Annual Credit Sales / 365).

Can I export the accounts receivable audit to CSV?

Yes. You can export complete aging schedules, DSO metrics, bad debt loss allowances, carrying costs, and 6x5 sensitivity tables as a UTF-8 CSV spreadsheet with formula defense.

Continue Exploring Financial & Risk Tools

Explore our Risk & Resilience Hub, model working capital in the Cash Conversion Cycle Lab, analyze debt coverage in the DSCR Lab, calculate capital structure in the Debt-to-Equity Lab, or stress-test bankruptcy probability in the Altman Z-Score Lab.