AR Balance (live, by Legal Entity), Microsoft Dynamics 365

AR Balance (live, by Legal Entity) is the total open Accounts Receivable per legal entity right now. How to read it, why it matters, and how to act on it.

Metrics type: Key Metrics • Category: Ecommerce Platform

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 Key Metric, 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

Four things to notice:

1. 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.
2. 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.
3. 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.
4. 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.

This balance is the ERP-side counterpart to commerce-platform “amount due” figures, but the two rarely tie one to one: commerce platforms track checkout payment, while AR tracks invoiced terms. The gap is largest on B2B Net-30 accounts, where the commerce order is paid (or approved) long before the invoice settles.

Known limitations / merchant FAQs

Is this a balance or a period total? A balance. It is the money owed to you at the instant the snapshot is taken. It does not sum invoices over a window the way revenue cards do. If you want “how much did we bill this month”, use Invoiced Revenue instead.

Why does the number move during the day even when no new sales happen? Two reasons. Payment applications lower the balance as cash is applied, and FX moves the reporting-currency total when you have non-base-currency entities. The per-entity local-currency rows isolate the real economic change from the FX noise.

Does it include invoices on credit hold? Yes. An open invoice is open whether or not the customer account is flagged on credit hold. Credit hold blocks new sales orders from posting; it does not remove already-posted open invoices from AR. To see the held accounts specifically, pair with Customers on Credit Hold.

How does the per-legal-entity breakdown work on a single-entity tenant? Single-entity tenants show one row, in local currency, with no FX translation step. The consolidation and elimination logic simply does not apply.

Does it net credit memos against open invoices? Yes. An open credit memo carries a negative remaining amount and reduces the customer’s net open balance, exactly as the AR sub-ledger does. A customer in net credit shows as a negative contribution to the total.

Why might the GL receivables control account not match the sub-ledger total? If they diverge, it usually means a manual journal posted directly to the control account without a matching customer ledger entry, or a sub-ledger reconciliation is overdue. This is itself a finding worth investigating; a healthy environment keeps the two in lockstep.

What is the freshness on this card? Vortex IQ reads the AR sub-ledger via the OData v2.0 / Dataverse layer with a short cache, typically under 15 minutes. That is materially fresher than a once- or twice-daily Power BI refresh, which is why the card is suitable as a live working-capital pulse.

Can I trust it for a cash-flow forecast? It tells you what is owed, not when it will arrive. For timing, combine this card with A/R Aging Buckets and Days Sales Outstanding to weight the balance by expected collection date.

---

Tracked live in Vortex IQ Nerve Centre

AR Balance (live, by Legal Entity) is one of hundreds of KPI pulses Vortex IQ tracks across Microsoft Dynamics 365 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.