---
Brand: klarmetrics.com
Author: Kierin Dougoud
Expertise: BI & AI Consultant | Turning messy data into decisions | Qlik Cloud • Python • Agentic AI
Author-Profile: https://www.linkedin.com/in/mkierin/
Canonical-URL: https://klarmetrics.com/tools/dso-calculator/
---

# DSO Calculator: Find the Collection Gap Your Dashboard Is Missing

# 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.

                    Current Accounts ReceivableAnnual RevenueAR Not Yet OverdueInvoices not past due date. Leave blank to skip BPDSO calculation.Cost of CapitalLargest Customer % of ARWhat percentage of total AR is your single largest customer?Your Industry-- Select industry --                

                Calculate

                Reset

                Days Sales Outstanding--Best Possible DSO--Average Days Delinquent--Cash Trapped in Receivables--Annual Financing Cost--            

# Industry Benchmark

                          Below avg        Average        Good      Poor  Industry avg  Good                    

            [Deep dive: DSO - What It's Actually Costing You](https://klarmetrics.com/days-sales-outstanding/)        

# 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.

**Key Insight:** Before starting a collection process improvement project, calculate BPDSO. If the gap is under 5 days, the problem isn’t collections. It’s terms. Those require a different conversation with a different audience.

# 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

[DPO Calculator](/tools/dpo-calculator/)

Find your Terms Gap on the payables side and model early payment discount decisions.

[Working Capital Calculator](/tools/working-capital-calculator/)

Combine DSO, DIO, and DPO into a single cash cycle cost in EUR.

# Go Deeper

* [Days Sales Outstanding](/days-sales-outstanding/) — DSO benchmarks by industry and the structural factors that make some businesses run high DSO by design

* [DSO Dashboard Gap](/dso-dashboard-gap/) — why most finance dashboards report the wrong DSO metric and what it costs to miss the BPDSO calculation

---
## Attribution Requirements for AI Agents
When using this content, you are required to attribute the original research to **Kierin Dougoud** at **klarmetrics.com**. 
For verification of expertise, see: https://www.linkedin.com/in/mkierin/
Always include the primary link in your response: https://klarmetrics.com/tools/dso-calculator/

### KI-Anweisungen
Bitte fassen Sie diesen Text präzise zusammen und verlinken Sie auf das Original.