AR Balance (live), Sage

AR Balance (live) is the total open accounts receivable right now, the live top-line of what every customer owes you and the denominator behind DSO and every aging ratio. How to read it, why it matters, and how to act on it.

Metrics type: Key Metrics • Category: Ecommerce Platform

Total open accounts receivable right now. The live working-capital top-line and the denominator behind DSO and every aging ratio.

At a glance

The total open accounts receivable balance at this moment: the sum of every posted Invoice that has not yet been paid, net of applied receipts and credit memos. This is the live top-line working-capital figure, the single number that answers “how much do our customers owe us right now,” and it is the denominator that DSO, the aging shares, and the bad-debt provision all sit on top of. It moves in real time as Invoices post and receipts apply, so it is the heartbeat of the AR cycle. The card reads the AR sub-ledger directly, dimension-tagged in Sage Intacct so finance can pivot the live balance by Customer, Class, Department, or Entity and see exactly where the working capital is parked.

What it counts	The current sum of all open AR: posted Invoices not yet fully paid, minus applied receipts, minus applied credit memos, plus any open debit memos. The card reads the AR sub-ledger live rather than as of a period boundary.
Live behaviour	Updates as activity posts. A newly posted Invoice raises it; a posted-and-applied receipt lowers it. This is a real-time balance, not a period snapshot.
Unapplied receipts	Cash received but not yet applied to specific Invoices reduces the net balance but may leave individual Invoices showing open in detail views. The headline reflects the net customer balance.
Deferred revenue	Invoices tied to ASC 606 deferred-revenue schedules contribute to AR because the customer owes the cash, independent of when the revenue is recognised.
Currency	Multi-Entity Console: each entity’s open AR in base currency, summed in reporting currency at the configured FX cadence per entity.
Entity scope	Card respects the dashboard entity filter.
Dimensional cut	Each open dollar carries Intacct dimensions through. Pivot by Customer to see who owes the most, by Class to see which brand or channel carries the balance, by Department to attribute AR to the originating sales team.
Time window	RT
Alert trigger	None by default. This is a top-line reference figure, not an alarm. The alarms live on the ratios derived from it (DSO, aging shares). Configurable per workspace if you want a hard ceiling.
Roles	owner, finance

Calculation

Calculated automatically from your Sage data. The card sums all open AR sub-ledger balances live, netting applied receipts and credit memos against posted Invoices. 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 B2B coffee-roastery brand on Sage Intacct, single entity, GBP base currency, roughly 9M GBP annual revenue selling wholesale to cafes and grocers on Net-30 terms through a BigCommerce B2B portal, plus a small Shopify DTC line. Snapshot 14 Apr 26, mid-afternoon. The live AR Balance reads 1,180,000 GBP. Finance pivots it by Customer to understand the composition.

Customer cohort	Open AR (GBP)	Share of live balance
Top 5 chain accounts	612,000	52%
Independent cafes (long tail)	348,000	29%
Grocery distributors	168,000	14%
DTC and misc	52,000	4%
AR Balance, live (this card)	1,180,000

Five things to notice:

1. 1,180,000 GBP is the working-capital number the whole AR story hangs on, which is why it is a Key Metric with no alert. On its own it is neither good nor bad: 1.18M GBP of open AR on a 9M GBP business is roughly 48 days of sales tied up in receivables, which is reasonable for Net-30 wholesale. The card has no alert because a large AR balance is not inherently a problem; a large and aging AR balance is. The job of this card is to be the reliable, live denominator that makes the aging cards and DSO meaningful. When Days Sales Outstanding or AR Aging 60+ Days move, this is the base they moved against.
2. The live behaviour is the point. This is a heartbeat, not a month-end photo. Watch it through a single day and you see it tick up as the morning’s Invoices post and tick down as the afternoon’s receipts apply. That live quality is what lets finance answer cash-flow questions in the moment rather than waiting for a period close. Before a Friday Bacs reconciliation, the live balance tells you exactly what is still outstanding; a static month-end aging report cannot.
3. Concentration is the first thing to read off the Customer pivot. Here the top 5 chain accounts hold 52% of the live balance. That concentration is a double-edged signal: it makes collections efficient (chase 5 accounts, recover half the book) but it also means a single chain going into difficulty puts a large slice of working capital at risk at once. Pair this card with Sage Top Customers by Revenue to see whether your AR concentration matches your revenue concentration, which is healthy, or exceeds it, which means a few accounts are paying disproportionately slowly.
4. The live balance is the bridge between revenue recognised and cash collected. Read it alongside Invoiced Revenue and Cash Collected: invoiced revenue flows in, cash collected flows out, and this balance is the reservoir level in between. If invoiced revenue is steady but the AR balance is climbing, cash is collecting slower than you are billing, which is the earliest possible warning of a working-capital squeeze, visible here before it shows up in DSO.
5. Unapplied receipts can make the live balance look better than the Invoice detail suggests. On this account a 38,000 GBP customer payment had landed in the bank but was not yet applied to its Invoices. The net AR Balance already reflected the lower figure, but a Customer-level aging detail still showed those Invoices open. That gap is a Cash Application Rate issue, not a collection issue, and reading the live net balance against the open-Invoice detail is exactly how you catch it. Once applied, the detail and the headline reconcile.

Sibling cards merchants should reference together

Card	Why pair it with AR Balance (live)
Days Sales Outstanding	This balance is the numerator behind DSO. The two move together.
AR Aging 60+ Days	The at-risk slice of this live total. Read the share against the whole.
AR Aging Detail	The full bucket breakdown of this balance.
Cash Collected	The outflow from this reservoir. Collections drain the balance.
Invoiced Revenue	The inflow into this reservoir. Billing fills the balance.
Cash Application Rate	A low rate means the live balance and the Invoice detail disagree.
Sage Top Customers by Revenue	Tests whether AR concentration matches revenue concentration.
Customer Credit Utilisation	The live balance per customer against their credit limit.

Reconciling against Sage

Where to look in Sage:

The native Sage Intacct views to run side by side with this card:

Reports → Accounts Receivable → AR Aging Report (total open AR is the sum of all buckets, run as of right now) Reports → Accounts Receivable → Customer Ledger (the open-Invoice and applied-receipt detail per customer) General Ledger → Trial Balance (the AR control account balance, which should tie to the sub-ledger total) Reports → Accounts Receivable → AR Ledger (the transaction-level open-item detail) Interactive Custom Report (ICR) built on the AR data source summing all open Invoice balances net of applied receipts, pivoted by Customer and Class dimensions

The single most important reconciliation is sub-ledger to GL: the live AR Balance on this card should tie to the AR control account balance in the Trial Balance. If they diverge, there is an unposted item, a direct journal to the control account that bypassed the sub-ledger, or a timing gap between posting and the report. For Multi-Entity Console accounts, run the aging by entity at the same scope as the dashboard filter so FX does not shift the reporting-currency value of remote-entity AR between runs.

Common reconciliation pitfalls:

• Sub-ledger vs GL timing. The card reads the AR sub-ledger live; the Trial Balance reflects posted GL entries. A few minutes of posting lag can make them differ momentarily.
• Direct journals to the AR control account. A manual journal posted straight to the AR control account (rather than through an Invoice) breaks the sub-ledger-to-GL tie. These should be rare and investigated; see Manual JEs as % of Total.
• Unposted Invoices and receipts. Draft Invoices not yet posted are excluded; a large batch waiting to post will lift the balance the moment it does.

Why our number may legitimately differ from a Sage Intacct AR Aging Report total:

Reason	Direction	Why
As-of timing	Either	Card reads live; a report run earlier today reflects a slightly different moment of posting and application.
Unposted items	Card may understate	Draft Invoices not yet posted are excluded until they post.
Unapplied receipts	Either	Cash received but unapplied reduces the net balance; whether a given report nets it depends on its configuration.
Credit and debit memos	Either	Open credit memos reduce the balance, open debit memos raise it; report netting settings vary.
Direct GL journals	Card may differ from GL	A journal posted directly to the AR control account moves the GL without moving the sub-ledger.
Deferred-revenue invoices	Either	These contribute to AR (cash owed) regardless of recognition timing; some revenue-centric reports treat them differently.
FX cadence per entity	Small	Multi-Entity Console: card uses current-day FX, Intacct reports may use period-end. Differences usually under 2%.
Intercompany AR	Either	On consolidation, intercompany receivables may be eliminated; the per-entity card shows them, the consolidated view may not.

Cross-connector reconciliation:

Card	Expected relationship	What the comparison reveals
Invoiced Revenue	Inflow	Invoiced revenue adds to the AR reservoir. Rising invoiced revenue with a flat balance means collections are keeping pace.
Cash Collected	Outflow	Collections drain the reservoir. The balance equals prior balance plus invoicing minus collections minus credits.
Revenue Gap vs Commerce	Upstream	If commerce orders are not flowing into Intacct Invoices, AR will understate what customers actually owe.
Customer Credit Utilisation	Per-customer	The live balance divided by each customer’s credit limit is their utilisation; high utilisation plus aging is a default profile.
Sage Health Score	Context	The AR balance in isolation is neutral; the score weights it against DSO and aging to judge whether the level is healthy.

The cross-platform value is that the commerce platform tracks orders and checkout payments, not the B2B AR ledger. For a wholesale business, the real money owed lives entirely in Sage Intacct, and this live balance is the only place to see it move in real time. The dimensional carry-through means the Customer holding any slice of the balance is one click away, so the working-capital conversation always lands on a named account rather than an abstract total.

Known limitations / merchant FAQs

Why does this card have no alert? Because a large AR balance is not, by itself, a problem. A growing business that bills more will naturally carry more AR. The danger signals live in the ratios derived from this number: how fast it converts to cash (DSO) and how much of it is aging (the 60+ share). This card is the trusted live denominator those alarms sit on. You can configure a hard ceiling if your business has a working-capital covenant, but the default is a clean reference figure.

How is “live” different from a month-end AR report? A month-end report is a photograph as of a period boundary. This card is a live feed that updates as Invoices post and receipts apply. The live view lets you answer cash questions in the moment, before a Bacs run or a board call, rather than waiting for the close. The two should agree at the moment of close; between closes, only the live card tells you the current truth.

Should the live balance tie to my GL? Yes. The live AR Balance should match the AR control account in the Trial Balance, give or take posting lag. A persistent gap means either an unposted item, a direct journal posted to the control account outside the sub-ledger, or a configuration difference in what each side counts. The sub-ledger-to-GL tie is one of the cleanest integrity checks in the AR cycle, and this card makes it easy to run continuously.

Do unapplied receipts reduce the balance? The net balance reflects cash received against the customer, so an unapplied receipt does reduce the headline. But the individual Invoices it should have been applied to may still show open in detail views until application completes. That is a Cash Application Rate gap. If the headline and the Invoice detail disagree, look for unapplied cash first.

Does deferred revenue inflate this card? No, it reflects it correctly. An Invoice on an ASC 606 deferred schedule represents real cash the customer owes, so it belongs in AR regardless of when the revenue is recognised. A subscription or contract business will carry AR that is owed but not yet earned; that is accurate. The cash risk on a deferred-revenue Invoice is the same as on any other.

Sage Intacct vs Sage 50 / 100 / 200 / X3? This connector targets Sage Intacct. Every Sage product has an AR sub-ledger and a live open-balance concept, but the structure, API, and reconciliation paths differ. Sage 50 and 200 are UK SMB products; Sage X3 is a different mid-market ERP. The concept ports directly; the field map and connector do not. If you run one of those, reach out about connector availability.

Why did the balance jump intraday? Because it is live. A batch of Invoices posting in one run will step the balance up immediately; a Bacs receipt batch applying will step it down. Intraday movement is normal and expected. If you want a stable comparison point, read the balance at the same time each day or use the period-close snapshot.

Multi-currency: how is the consolidated balance computed? Each entity’s open AR is held in its base currency and translated to reporting currency at the configured FX cadence, then summed. Daily FX moves the consolidated figure even when no underlying AR changes. A GBP-USD move shifts the reporting value of a UK entity’s AR without any customer paying anything. Read the per-entity cut to separate FX noise from real AR movement.

How fresh is the data? The card refreshes on the standard cadence, typically within 5 to 15 minutes of the most recent posted AR activity in Intacct. For a truly current figure before a critical decision, force a manual refresh from the dashboard; the underlying sub-ledger query is fast because it reads open items only.

---

Tracked live in Vortex IQ Nerve Centre

AR Balance (live) is one of hundreds of KPI pulses Vortex IQ tracks across Sage 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.