The live total of open Accounts Receivable, broken down per legal entity, in reporting currency. The headline working-capital number a controller checks daily.
At a glance
The current outstanding Accounts Receivable balance, summed across all open customer invoices, sliced by legal entity (Company in Business Central, legal entity in Finance & Operations). It is a point-in-time snapshot of money owed to the business, not a period total. Refreshes in near real time so the figure on the card matches what a controller sees when they open the AR sub-ledger.
| What it counts | The sum of remaining (unpaid) amounts on all posted customer invoices that are still open, grouped by legal entity. In Business Central this maps to the open Customer Ledger Entries (Remaining Amount where Open = true); in Finance & Operations it maps to the open customer transactions on the AR sub-ledger. Closed and fully-settled invoices drop out the moment a payment application posts. |
| Currency | Multi-Company / multi-entity setups: consolidated in reporting currency (the parent entity’s local currency, typically GBP, USD, or EUR). Each legal entity’s native AR is FX-translated at the current rate before roll-up. The per-entity rows can be shown in either local or reporting currency depending on the dashboard scope. |
| Time window | RT (real time, point-in-time snapshot, not a period sum) |
| Alert trigger | No fixed threshold. This is a monitoring Hero, not an alert card. Pair it with A/R Aging 60+ Days and Overdue Invoice Value for the alerting layer. |
| Roles | owner, finance |
Calculation
Calculated automatically from your Microsoft Dynamics 365 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 omnichannel homeware group running Business Central with three legal entities in one tenant: UK Homeware Ltd (parent, GBP), US Homeware Inc (USD), and EU Living BV (EUR). Reporting currency is GBP. The snapshot is taken at 09:00 on 14 Jun 26. The controller opens the dashboard before the morning cash-flow call.| Legal entity | Local AR balance | FX rate (current) | GBP equivalent | Open invoices |
|---|---|---|---|---|
| UK Homeware Ltd | £1,840,000 | 1.0000 | £1,840,000 | 412 |
| US Homeware Inc | $1,260,000 | 0.7840 | £987,840 | 388 |
| EU Living BV | €690,000 | 0.8520 | £587,880 | 214 |
| AR Balance (this card) | £3,415,720 | 1,014 |
- This is a live balance, not a period figure. Unlike Invoiced Revenue, which sums what was billed over a window, this card answers “how much is owed to us right now”. A single payment application this afternoon will lower the number by tea time.
- US Homeware Inc carries more open invoices than the UK parent despite a smaller balance. That points to a large volume of small B2C invoices on the US side versus fewer large B2B invoices in the UK. Pair with A/R Aging Buckets to see whether those US invoices are current or aging.
- The GBP equivalent uses the current FX rate, not the rate at posting. When sterling moves, the consolidated number moves even though no customer paid and no invoice posted. The per-entity local-currency rows are the stable view for collections teams.
- Reconciliation against the prior day. Yesterday’s snapshot was £3,498,400. The £82,680 drop is the net of new invoices raised (which push the balance up) minus cash applied (which pulls it down). When the balance climbs day on day while sales are flat, the Days Sales Outstanding card is the next place to look.
Sibling cards merchants should reference together
AR Balance is the headline working-capital figure but it is a single number. Pair it with these to understand the shape and risk inside the balance.| Card | Why pair it with AR Balance |
|---|---|
| A/R Aging 60+ Days | The risky slice of the balance. A large AR Balance is fine if it is all current; it is a problem if a chunk has aged past 60 days. |
| A/R Aging Buckets | Breaks the same balance into current, 30, 60, 90, and 120+ day buckets. The structural view behind the headline. |
| Invoice Aging Summary | Invoice-level aging detail that rolls up into this card’s totals. |
| Days Sales Outstanding | Converts the balance into a velocity measure. Rising DSO with a rising AR Balance is the classic cash-flow warning. |
| Overdue Invoice Value | The past-due subset of this balance. Tells you how much of the AR is genuinely late versus merely outstanding. |
| Unpaid Invoices (count) | The count behind the value. A high balance spread over few invoices is concentration risk; spread over many is administrative load. |
Reconciling against Microsoft Dynamics 365
Where to look in Business Central / Finance & Operations:
Business Central: Reports > Finance > Aged Accounts Receivable (As of Date = today, summed across customers)
Business Central: Customers > Customer Ledger Entries (filter Open = Yes, sum the Remaining Amount column)
Business Central: Chart of Accounts > Receivables control account (the GL control account balance should tie to the sub-ledger)
Finance & Operations: Accounts receivable > Inquiries and reports > Customer aging report (run per legal entity)
Finance & Operations: Accounts receivable > Customer balances list page (current open balances by customer)
For an audit-grade match in Business Central, run the Aged Accounts Receivable report with an As-of date of today and “Aging by = Due Date”, then total the report. It should tie to this card within rounding when both are scoped to the same legal entity and currency. The receivables control account on the Chart of Accounts should also reconcile to the same figure if the sub-ledger and GL are in sync.
Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Local currency vs reporting currency | Either | The card consolidates in reporting currency at the current FX rate; a per-entity report run in local currency will not match the consolidated total until you translate it. Always compare like for like. |
| Snapshot timing | Either | This card is near real time. A native aging report run a few hours earlier, or before a batch of payment applications posted, will show a different balance. |
| Open vs partially-applied invoices | Card lower | The card sums remaining (unpaid) amounts. If a native report lists invoice gross amounts rather than remaining amounts, the report total reads higher. |
| Cross-entity eliminations | Card lower at consolidation | Intercompany AR between two of your own legal entities is eliminated when viewed at the consolidation scope. Per-entity native reports do not eliminate. |
| OData / sync lag | Card up to 15 min behind | Vortex IQ reads via the OData v2.0 / Dataverse layer with a short cache, so a payment applied in the last few minutes may still appear as open on the card. |