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 |
- 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.
- 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.
- 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.
- 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.
- 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 transactionDirect link template:FBL5Nrun per Company Code with open-item status Trial Balance Fiori app for the customer reconciliation account balance per Company Code Embedded Analytics: query CDS viewI_CustomerARAgingor the open-item line-item view, summed per Company Code
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.
| 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. |