Explain the movement behind the numbers

Give finance teams the commercial and operational context behind balances, forecasts and exceptions.

Receivables movement

Follow the £14,000 increase.

Opening balance: £284,000
New invoice · INV 1048: + £36,000
Allocated settlement · SET 0622: − £22,000
Closing balance: £298,000

GBP · May 2026

A balance tells only part of the story

A movement in receivables may reflect billing timing, a customer dispute, settlement allocation or a change in contract terms. Understanding the cause often requires a ledger export, an account conversation and evidence from an order system. Those sources can disagree because they describe different points in the commercial lifecycle.

A financial intelligence workflow connects the posted accounting position to its supporting business events. It keeps the distinction between booked, expected and disputed amounts visible, so a user can investigate the reason for a movement without treating an operational estimate as an accounting fact.

A financial controller investigates an invoice and settlement discrepancy at a reconciliation workstation.

Find the reason for a variance

Start with a variance against an approved baseline. Break it down by business dimension, identify the transactions contributing most to the movement and assemble supporting records. Route unresolved items to the person who can correct the source or explain the commercial reason.

Find the reason for a variance
Evidence	Question it answers
Ledger posting	What was recognized, in which entity and period?
Invoice and settlement	What was billed, paid or left open?
Contract and order	What commercial obligation created the amount?
Investigation record	Who reviewed the exception and what changed?

One invoice. Three different questions.

INV 1048 · GBP

Accounting position

£14,000 open

£36,000 invoiced less £22,000 allocated settlement. The posted position is still open.

Commercial context

£4,000 disputed

A delivery dispute explains part of the open amount. It is included in the £14,000.

Undisputed remainder

£10,000 open

The remainder is separate from the dispute. Neither amount changes until the authorized process acts.

Connect transactions to orders and agreements

Begin with legal entity, account, currency, fiscal period and transaction identifiers. Link journal entries to invoices, purchase orders, contracts and settlement records where the source evidence supports that relationship. Preserve the original identifiers and the transformation that created each derived measure.

Currency conversion, posting dates and intercompany treatment must be explicit. A consolidated view needs an agreed definition of the reporting perimeter. Where a source arrives late, show its effective date and freshness rather than presenting a single total with an implied level of certainty.

May reconciliation: invoice INV 1048 for £36,000 less settlement SET 0622 of £22,000 leaves £14,000 open, including a £4,000 delivery dispute. The accounting position remains subject to authorized review. — The May investigation separates the posted position, settlement allocation and commercial dispute.

Keep finance in control of postings

The accounting system remains responsible for approved postings and close controls. Investigation brings supporting records together, with access appropriate to the entity, payroll or customer information involved.

Source records and calculation versions explain how a figure was produced. Keeping corrections alongside the original records lets reviewers understand both the earlier decision and what changed.