Top-10 customers’ share of total AR. Above 40% is concentration risk; a single bankruptcy event can dent the quarter.
At a glance
The percentage of total open accounts-receivable value held by your ten largest customer business partners in S/4HANA Cloud FI-AR. The card ranks every customer by open-item balance, sums the top ten, and divides by the total AR balance. A high figure means your cash collection is dependent on a handful of accounts, so a single customer default, dispute, or slow-pay event can swing the quarter. This is the credit-risk-concentration lens on the receivables book.
| What it counts | Open customer line items (FI-AR) aggregated per customer business partner, ranked descending by balance. Built from customer open items in BSID (or the modern ACDOCA items where KOART = D Customer), grouped by the customer business partner number. Cleared items are excluded. |
| How it is calculated | Top-10 Customer AR Concentration % = (sum of open AR for the 10 largest customers) / (total open AR balance). The ranking is by current open balance, so the membership of the top ten can change period to period as accounts pay down or take on new invoices. |
| Numerator vs denominator | Numerator is the combined open AR of the ten customers with the largest balances. Denominator is the full open AR across all customers. A small customer base naturally pushes the figure up, so read it in the context of how many active customers you have. |
| Tax treatment | Gross. Customer open items are gross of output VAT on both sides of the ratio, so tax does not affect the percentage. |
| Currency | Group Currency for consolidated views. Each customer’s balance is translated at TCURR rate type M before ranking and summing, so the top-ten ranking is on a like-for-like basis across Company Codes. Single-Company-Code views use Company Code currency. |
| Company Code scope | Respects the dashboard Company Code filter. By default ranks customers across every Company Code visible to the connected SAP business user / API role. A customer trading with multiple Company Codes is aggregated to a single business partner balance. |
| Time window | RT (real-time live ranking) |
| Alert trigger | >40% |
| 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, Group Currency USD, total open AR of $34,820,000. Live snapshot at 03 May 26.| Rank | Customer business partner | Open AR | Cumulative |
|---|---|---|---|
| 1 | National Retail Group | $4,210,000 | $4,210,000 |
| 2 | Coastal Wholesale Co | $2,980,000 | $7,190,000 |
| 3 | Midwest Supply Partners | $1,640,000 | $8,830,000 |
| 4 to 10 | Seven further accounts | $6,120,000 | $14,950,000 |
| Top-10 total | $14,950,000 | ||
| Total open AR | $34,820,000 | ||
| Top-10 Concentration (this card) | 34,820,000 = 42.9% |
- Concentration is 42.9%, above the 40% alert threshold. Nearly half of all outstanding cash sits with ten accounts. The gauge fires and Ask Viq surfaces the question “Which top accounts are driving AR concentration and what is their aging?”.
- **The top two alone are 4.21M is a single-customer exposure that, if it entered administration, would force a material bad-debt provision in one quarter. This is the scenario the card exists to flag before it happens.
- Concentration and aging together are the real risk. A 43% concentration is tolerable if those ten accounts are blue-chip and paying within terms. It is dangerous if the same accounts also dominate the 60+ aging buckets. Cross-read with AR Aging 60+ Days and A/R Aging Detail.
- The top-ten membership rotates. Because the ranking is by live balance, a customer that pays down a large invoice drops out and the next account moves up. A sudden jump in concentration can mean one big new invoice, not a structural shift. Check whether the numerator grew or the denominator shrank.
- FBL5N: Customer Line Items (per-customer open-item balance).
- Manage Customer Line Items Fiori app: filter and sort customers by open balance.
- BP transaction: customer business-partner master, credit limit, and risk class.
- FSCM credit management: credit exposure and limit per customer.
Sibling cards merchants should reference together
Top-10 Customer AR Concentration is a credit-risk lens. Pair it with the aging and customer cards to see whether the concentrated balances are also slow or risky.| Card | Why pair it with Top-10 Customer AR Concentration |
|---|---|
| AR Aging 60+ Days | Concentration is only dangerous when the concentrated accounts are also aging. Read together. |
| A/R Aging Detail | Names the top accounts and shows their aging bucket by bucket. |
| High-Value Overdue Invoices | The largest single overdue items, which usually belong to the top-ten accounts. |
| Customer Credit Utilisation | FSCM-CR view of how much of each big customer’s credit limit is consumed. |
| AR Balance (live, by CompanyCode) | The denominator behind this ratio. |
| SAP Top Customers by Revenue | Revenue concentration alongside receivables concentration. Big revenue plus big AR is the double exposure. |
| SAP Active Customers | A small active base naturally raises concentration; this gives the denominator context. |
Reconciling against SAP
Where to look in S/4HANA Cloud: The closest native equivalents inside the SAP Fiori launchpad are:
Manage Customer Line Items Fiori app with open items, grouped and sorted by customer, descending by balance
Display Customer Line Items transaction FBL5N with a customer summary layout
Customer Balances Fiori analytical app ranked by open balance
Embedded Analytics: query the customer open-item view aggregated per business partner, sorted descending
Direct link template: https://my{tenant}.s4hana.cloud.sap/sap/bc/ui2/flp#CustomerLineItems-display
To reproduce the card, list open AR per customer, sort descending, take the top ten, sum them, and divide by total open AR. The ten names and the percentage should match the card when run at the same moment and the same Company Code scope.
Common mistakes when comparing against SAP’s own reports:
- Customer vs payer vs sold-to. SAP business partners have multiple roles. A report grouped by sold-to party can differ from one grouped by payer if your customers use separate payer accounts. The card aggregates by the AR-bearing business partner (payer).
- Multi-Company-Code aggregation. A customer trading with three Company Codes appears three times in a per-Company-Code report. The card aggregates them to one business partner, so its ranking can differ from a naive per-CC list.
- Open vs all items. Including cleared items inflates each customer’s balance and changes the ranking. Select open items only.
| Reason | Direction | Why |
|---|---|---|
| Snapshot timing | Either | The ranking is live. A large payment after the snapshot drops an account out of the top ten and changes the percentage. Match the timestamp. |
| Business partner aggregation | Either | The card aggregates a customer across Company Codes to one business partner. A per-CC report that splits the same customer ranks differently. |
| Payer vs sold-to grouping | Either | If your customers use separate payer accounts, the AR-bearing role differs from the ordering role. The card uses the AR-bearing partner. |
| Open vs all items | Either | Including cleared items changes both the per-customer balances and the ranking. The card counts open items only. |
| Company Code currency vs Group Currency | Small | Ranking on local-currency balances can reorder customers near the top-ten boundary versus a Group Currency ranking. |