DSO Calculator: Find the Collection Gap Your Dashboard Is Missing
Simple DSO hides two things: seasonal distortion and the gap between your payment terms and actual collection. This calculator shows both, so you can see whether you have a terms problem, a collection problem, or a concentration risk.
DSO Calculator
Calculate DSO with the countback method, find your Best Possible DSO, and see what the gap costs you.
How to Read Your Results
BPDSO close to actual DSO?
Your payment terms are the constraint, not your collection process. The fix is term negotiation, not chasing invoices harder.
BPDSO significantly below actual DSO?
Customers are paying late beyond their contracted terms. Multiply the gap in days by (Revenue / 365) to get the EUR value sitting in avoidable AR right now. That’s the collection process problem worth solving.
Concentration warning triggered?
One customer or group is above 30% of total AR. Your aggregate DSO can shift dramatically based on a single counterparty’s behavior. That liquidity risk is invisible in the blended number.
Where to Get Your Numbers
| Metric | Where to find it | SAP Transaction |
|---|---|---|
| Total AR balance | Gross accounts receivable from balance sheet. Use gross figure before bad debt provisions. | FBL5N |
| AR not yet due | AR aging report, “current” or “0-30 days” bucket, filtered to invoices where due date is still future. | FBL5N with due date filter |
| Revenue per day | Annual revenue / 365. Use the same period for AR and revenue to avoid seasonal distortion. | F.01 (P&L report) |
Related Tools
Find your Terms Gap on the payables side and model early payment discount decisions.
Combine DSO, DIO, and DPO into a single cash cycle cost in EUR.
Go Deeper
- Days Sales Outstanding — DSO benchmarks by industry and the structural factors that make some businesses run high DSO by design
- DSO Dashboard Gap — why most finance dashboards report the wrong DSO metric and what it costs to miss the BPDSO calculation