Average days from invoice issue to cash applied. Earliest warning of cash-flow trouble.
At a glance
Average days from Billing Document issue to cash applied (FB05 / F-30 customer payment posting). The single most-watched cash-flow KPI in enterprise B2B commerce on S/4HANA Cloud. Rising DSO is the earliest warning of cash-flow trouble.
| What it counts | Standard formula: DSO = (AR Balance ÷ Total Credit Sales) × Number of Days. AR Balance = sum of open customer line items in BSID / BSAD (or the modern ACDOCA items where KOART = D Customer). Credit Sales = Invoiced Revenue minus Cash Sales (BV order type). Card uses 90-day rolling window for the denominator. Aligns with SAP’s standard DSO computation in the Receivables Management Cockpit Fiori app. |
| Tax treatment | Includes tax in both numerator (AR open items are gross of output VAT, sitting in customer reconciliation account) and denominator (Credit Sales). Net result is the same as a tax-exclusive calculation. |
| AR balance | Open customer line items, gross of any unapplied credit memos. |
| Credit sales | Invoiced Revenue from credit billing types (F2 standard, S1 cancellation, G2 credit memo netted in). Cash Sales (BV) excluded; otherwise DSO is artificially low because cash hits same-day at goods issue. |
| Cash Sales / DTC prepaid | Excluded from both numerator and denominator. |
| Currency | Group Currency for consolidated views. Each Company Code’s AR and Credit Sales are translated at TCURR rate type M then summed. |
| Company Code scope | Respects dashboard filter. |
| Time window | 30D vsP (rolling DSO computed on 90-day denominator) |
| Alert trigger | >45 days OR up >5 vsP, sentiment dso |
| Roles | owner, finance |
Calculation
Calculated automatically from your SAP data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US enterprise wholesale distributor on SAP S/4HANA Cloud Public Edition (annual run-rate ~$280M). Snapshot 03 May 26.| Component | Value |
|---|---|
| Open AR (excludes Cash Sales / BV) | $34,820,000 |
| 90-day Credit Sales (Invoiced Revenue, F2 + G2 net) | $58,140,000 |
| Days in window | 90 |
| DSO (this card) | (34.82M ÷ 58.14M) × 90 = 53.9 days |
| This period | Prior 30D | vsP | |
|---|---|---|---|
| DSO | 53.9 | 47.6 | +6.3 days |
- DSO at 53.9 days exceeds the 45-day alert threshold. Net-30 customers are paying ~24 days late on average. The card fires the sentiment alert and Ask Viq surfaces the question “Why has DSO jumped 6.3 days this period?”.
- vsP is +6.3 days, above the 5-day jump threshold. Trend is bad and accelerating. Two compounding alerts: absolute level breach + jump-rate breach. The CFO and Finance Manager get a paired notification.
- The breakdown helps diagnose. Five large customers (Top B2B Accounts) in the 60+ aging bucket are pulling DSO up disproportionately. Resolving 3 of them via the Receivables Management Cockpit (Fiori app
F0729) collections worklist would drop DSO back under 50. - Net-30 textbook DSO is 35-40 days for healthy B2B (terms + 5-10 days slack). 53.9 days means the average is now Net-30 + 24 days late. Compare to last year’s average; if 12 months ago it was 41, the trend is structural and likely traces to either a customer-base shift (more late-paying accounts) or a collections-process degradation.
- Cash Sales correctly excluded. This merchant’s mix includes 12% DTC prepaid orders booked as BV (cash-sale order type) which clear instantly. If included, DSO would compute artificially low because BV orders hit cash same-day. The card excludes them so the number reflects credit-customer behaviour only.
- FBL5N: Customer Line Items (per-customer open-item drill).
- F-30 / FB05: Cash application (Incoming payments).
- Receivables Management Cockpit Fiori app for the collections worklist.
- F.13: Automatic Clearing run (clears matched payments to invoices automatically).
Sibling cards merchants should reference together
| Card | Why pair it with DSO |
|---|---|
| Invoice Aging Summary | The bucket detail behind DSO. |
| A/R Aging Detail | Per-customer detail. |
| Cash Collected | Receipts side. Strong cash-collected days reduce DSO. |
| Overdue Invoice Value | Pressure target. Overdue % of AR drives DSO. |
| Cash Application Rate | Operations efficiency: how fast cash hits open items. |
| Customer Credit Utilisation | Predictive risk view from FSCM-CR. |
| Top B2B Accounts by Revenue | Concentration: who matters. |
| Sales Documents Blocked on Inventory or Credit | Credit-blocked documents reflect the same upstream problem. |
Reconciling against the vendor’s own dashboard
Where to look in S/4HANA Cloud:Receivables Management Cockpit Fiori app (Direct deep-link:F0729) DSO tile Days Sales Outstanding Fiori KPI tile (configurable in Receivables overview page) SAP Analytics Cloud standard Finance content pack: “DSO Trend” story Saved query: build via Embedded Analytics CDS viewI_CustomerARAgingandI_BillingDocumentItem
https://my{tenant}.s4hana.cloud.sap/sap/bc/ui2/flp#ReceivablesMgmt-display
Why our number may legitimately differ from a manual SAP calculation:
| Reason | Direction | Why |
|---|---|---|
| Window selection | Either | Some Finance teams use 90-day rolling, some use trailing 12-month, some use the last calendar quarter. Card defaults to 90-day rolling. |
| Cash Sales (BV) inclusion | Card excludes | Including BV orders artificially deflates DSO because they clear instantly. SAP’s standard tile includes or excludes based on customising; align the field map. |
| Tax inclusion | Either | Some calculations use net-of-tax in both numerator and denominator; others use gross. Card uses gross consistently (AR open items are gross of output VAT in SAP standard). |
| Multi-Company-Code scope | Either | Card defaults to all CCs visible to the connected role. SAC tile may be scoped per CC. |
| EBRR deferred revenue | Card lower | If your tenant uses Event-Based Revenue Recognition, deferred revenue is excluded from Credit Sales (the denominator), keeping DSO from being artificially deflated by un-billed deferred recognition postings. |