Top-10 Customer AR Concentration %, SAP

Top-10 Customer AR Concentration %, the share of total accounts receivable held by your ten largest customers in S/4HANA Cloud. How to read it, why it matters, and how to act on it.

Metrics type: Key Metrics • Category: AP/AR Cycle

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)		$14,950,000 /$34,820,000 = 42.9%

Four things to notice:

1. 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?”.
2. **The top two alone are $7.19M, over 20$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.
3. 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.
4. 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.

T-codes / Fiori apps for drilling in:

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

Why our number may differ:

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.

Cross-connector reconciliation:

This card has no commerce-platform counterpart. Commerce platforms collect at order placement and do not carry per-customer receivables balances, so there is no concentration ratio to mirror. This is a B2B credit-ledger metric specific to SAP FI-AR.

Known limitations / merchant FAQs

Why is 40% the alert threshold? Forty percent is a common rule of thumb for “your top ten now represent a material single-point-of-failure risk”. Below it, the loss of any one account is absorbable. Above it, a single bankruptcy or major dispute can swing a quarter’s cash position. The threshold is tunable; businesses with a deliberately small, blue-chip customer base may set it higher, and those wanting an early warning may set it lower.

Is high concentration always bad? No. A distributor with ten large, creditworthy, on-time national accounts has high concentration and low risk. The danger is concentration combined with poor credit quality or rising aging. The card flags the structural exposure; the judgement comes from cross-reading credit utilisation and aging. Treat a high reading as “go check the quality of these accounts”, not “this is automatically a problem”.

Why did concentration jump this period with no new bad accounts? Usually because one large new invoice posted, pushing an account up the ranking and growing the numerator, or because many small accounts paid down, shrinking the denominator. Because the ranking is live and balance-based, membership rotates. Check whether the top-ten total grew or total AR fell.

Does it aggregate a customer across Company Codes? Yes. A customer trading with several Company Codes is rolled up to a single business partner balance before ranking, so the concentration reflects true single-counterparty exposure rather than per-entity slices. This is the correct view for credit risk, because the customer is one legal counterparty regardless of how many of your entities it buys from.

How does this interact with FSCM credit management? SAP’s FSCM-CR sets a credit limit and tracks exposure per customer. The accounts at the top of this card are the ones whose limits matter most. A top-ten account at or near its credit limit while also aging is the highest-priority case for the credit team. Pair this card with Customer Credit Utilisation to see limit consumption.

Multi-currency, does FX change the ranking? Each customer’s balance is translated to Group Currency at rate type M before ranking, so the comparison is like-for-like across currencies. Near the top-ten boundary, an FX move could in principle reorder two adjacent customers, but it does not materially change the headline percentage.

Can I see the eleventh and lower accounts? The card reports the top-ten share. For the full ranked list and per-account aging, drill into A/R Aging Detail or the Manage Customer Line Items Fiori app sorted by open balance.

---

Tracked live in Vortex IQ Nerve Centre

Top-10 Customer AR Concentration % is one of hundreds of KPI pulses Vortex IQ tracks across SAP and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English.

Start for free or book a demo to see this metric running on your own data.