AR Balance (live, by CompanyCode), SAP

AR Balance (live, by CompanyCode), the real-time accounts-receivable open-item total from S/4HANA Cloud broken down per Company Code. How to read it, why it matters, and how to act on it.

Metrics type: Key Metrics • Category: Executive Overview

Live total accounts-receivable open-item balance, broken down by Company Code. The cash-locked-in-the-ledger number the CFO checks before any treasury decision.

At a glance

The real-time sum of all open customer line items in S/4HANA Cloud FI-AR, sliced by Company Code. This is the total value of issued invoices that customers have not yet paid, the working capital tied up in receivables right now. Unlike the aging gauges, which express a ratio, this card shows the absolute money outstanding per legal entity, rolled up to a group total in Group Currency.

What it counts	The sum of open customer line items (FI-AR), per Company Code. Built from customer open items in BSID (or the modern ACDOCA items where KOART = D Customer), filtered to status open. Cleared (collected) items are excluded. Matches the open-item total in transaction FBL5N and the Manage Customer Line Items Fiori app when run with the open-items selection.
Currency	Each Company Code’s balance is shown in its own Company Code currency and also rolled up to Group Currency for the consolidated total. Translation uses TCURR rate type M for the roll-up. The Universal Journal stores Company Code currency and Group Currency on every line, so no extra revaluation step is needed for the snapshot.
Company Code scope	The card’s whole purpose is the per-Company-Code breakdown. It lists each Company Code visible to the connected SAP business user / API role with its individual AR balance, plus a consolidated group total. Respects the dashboard Company Code filter if one is applied.
Tax treatment	Gross. Customer open items sit gross of output VAT in the receivables reconciliation account, because the customer owes the tax-inclusive amount. The balance reflects what is actually collectable.
Special G/L items	Standard customer open items by default. Down-payments and security deposits sit in separate special G/L reconciliation accounts and are included only if your field map adds them.
What it excludes	Cleared items (paid), parked-but-unposted documents, and Sales Documents not yet billed. A Sales Document only becomes AR once it is billed into a Billing Document and posted to the customer reconciliation account.
Time window	RT (real-time live balance)
Alert trigger	Informational, no threshold
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 UK enterprise B2B group on SAP S/4HANA Cloud Public Edition, three Company Codes, Group Currency GBP. Live snapshot at 09:00 on 03 May 26.

Company Code	AR balance (local)	FX rate (rate type M)	GBP equivalent
1000 UK Distribution Ltd	£14,210,000	1.0000	£14,210,000
2000 US Distribution Inc	$9,640,000	0.7820	£7,538,480
3000 EU Distribution BV	€4,180,000	0.8540	£3,569,720
AR Balance, group total (this card)			£25,318,200

Four things to notice:

1. The group total is £25.3M of cash sitting in the ledger. This is the headline working-capital number. It is not overdue by itself; most of it is simply invoices issued and within terms. The card is informational, so no alert fires, but treasury reads it daily before deciding what to draw or repay on the revolving facility.
2. CC 1000 holds 56% of group AR. The UK parent carries the largest book. If a single large UK account slips, the group balance moves visibly. Pair with Top-10 Customer AR Concentration to see how concentrated each Company Code is.
3. The number is live, not period-bound. Because the time window is real-time, the balance changes through the day as billing runs post new invoices and cash application clears old ones. A morning read and an afternoon read can differ by the value of the day’s billing-due-list run.
4. This is the denominator behind the aging gauges. AR Aging 60+ Days divides a slice of this balance by this total. When you see the gauge move, this card tells you whether the absolute money moved or just the ratio.

T-codes / Fiori apps for drilling in:

• FBL5N: Customer Line Items (open-item total per Company Code).
• Manage Customer Line Items Fiori app: live open-item view with Company Code filter.
• Trial Balance Fiori app: the customer reconciliation account balance per Company Code.
• BP transaction: customer business-partner master and credit data.

Sibling cards merchants should reference together

AR Balance is the absolute working-capital figure that anchors the receivables cards. Pair it with these to read the balance in context.

Card	Why pair it with AR Balance
Days Sales Outstanding (DSO)	DSO uses this balance as its numerator. The two move together when collections slow.
AR Aging 60+ Days	The aging ratio computed against this balance. Tells you the quality of the receivables, not just the size.
A/R Aging Detail	The per-customer breakdown of this balance.
Top-10 Customer AR Concentration %	How concentrated this balance is in a few accounts.
Cash Collected	The flow that drains this balance. Strong collections shrink it.
Invoiced Revenue	The flow that grows this balance. New billing adds to AR until it is collected.
SAP Intercompany Balance	Intercompany AR sits inside this total per Company Code and eliminates at group level.
Top Findings Across Company Codes	Multi-entity roll-up that flags which Company Code is driving group AR.

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 the open-items selection, grouped by Company Code Display Customer Line Items transaction FBL5N run per Company Code with open-item status Trial Balance Fiori app for the customer reconciliation account balance per Company Code Embedded Analytics: query CDS view I_CustomerARAging or the open-item line-item view, summed per Company Code

Direct link template: https://my{tenant}.s4hana.cloud.sap/sap/bc/ui2/flp#CustomerLineItems-display

To reproduce the card, run the Manage Customer Line Items app with open-item status for each Company Code and sum the open amounts, or read the customer reconciliation account balance on the Trial Balance. The reconciliation account total should match the card per Company Code to within rounding when run at the same moment and the same currency view.

Common mistakes when comparing against SAP’s own reports:

• Reconciliation account vs sub-ledger. The Trial Balance shows the reconciliation account; the line-item report shows the sub-ledger. They should agree, but a posting in transit or an unreconciled special G/L item can create a temporary gap.
• Open vs all items. Running FBL5N with “all items” rather than “open items” includes cleared items and inflates the total. Always select open items only.
• Currency view. A Company Code report in local currency will not match the group total in Group Currency. Pick the matching currency view before comparing.

Why our number may differ:

Reason	Direction	Why
Snapshot timing	Either	The card is live and moves through the day. A report run minutes later, after a billing run or a cash-application run, shows a different balance. Match the timestamp.
Open vs all items selection	Card lower	If the comparison report includes cleared items, it overstates AR. The card counts open items only.
Special G/L inclusion	Either	Customer down-payments and deposits in special G/L accounts may or may not be in the card depending on the field map.
Company Code currency vs Group Currency	Either	A local-currency report will not match the Group Currency roll-up. Match scope and currency view.
Reconciliation account vs line item	Small	A posting in transit can briefly desync the reconciliation account total from the line-item sum. The card reads line items.

Cross-connector reconciliation:

This card has no commerce-platform counterpart. Commerce platforms collect at order placement, so there is no standing receivables balance to mirror. AR balance is a property of the B2B credit ledger that exists only in SAP FI-AR.

Known limitations / merchant FAQs

Why is there no alert threshold on this card? Because the absolute AR balance is not good or bad in itself. A growing business naturally carries a growing receivables book; a shrinking balance can mean either strong collections or falling sales. The card is informational by design. The judgement cards are the aging gauges and DSO, which read the quality and speed of this balance. Watch those for alerts; watch this one for scale and per-entity trend.

How is “live” different from the period-based revenue cards? This card queries open items as they stand right now. It is not bounded to a 30-day window. As billing runs post and cash application clears items through the day, the number moves. The revenue cards aggregate flows over a fixed period; this card is a point-in-time stock figure.

Why does the per-Company-Code split matter? Multi-entity SAP groups consolidate to a single group total, but the working-capital risk lives at the entity level. One Company Code can carry an aging problem that the group total masks. The per-Company-Code breakdown lets treasury see where the cash is actually trapped and which entity’s collections team to escalate to.

Does the balance include intercompany receivables? Yes, per Company Code. An intercompany invoice from CC 1000 to CC 2000 sits as AR in CC 1000’s books. At the consolidated group view, intercompany AR and the matching intercompany AP eliminate via SAP Group Reporting. The SAP Intercompany Balance card isolates this slice.

What about disputed or blocked items? A disputed item is still an open receivable and counts here; the dispute does not remove the cash owed. A payment-blocked item likewise remains open. The card reflects everything outstanding regardless of dispute or block status, because all of it is uncollected cash.

Multi-currency, how is the group total formed? Each Company Code’s open items are translated to Group Currency at rate type M and summed. The card shows both the local-currency entity balances and the consolidated Group Currency total, so you can read either view without a separate revaluation step.

How fresh is the number? The connector polls on its refresh cadence, typically every 15 minutes, and the underlying OData query runs against the live system. For a real-time check against an in-progress cash-application run, the native Manage Customer Line Items Fiori app is always live; this card is at most one refresh cycle behind.

---

Tracked live in Vortex IQ Nerve Centre

AR Balance (live, by CompanyCode) 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.