Reconciliation

Matches the institution's RTGS/EFT transaction records against the bank's settlement statement (mfi.rtgs.reconciliation), surfacing matched, unmatched and suspense items. It automates the bulk of the matching and isolates exceptions that need a human decision. This is where daily settlement is proven complete and balanced.

Workflow

Open Reconciliation under RTGS & EFT.
Import or load the bank settlement statement for the period.
Run auto-matching against the transaction ledger.
Review unmatched items and route them to the suspense queue.
Resolve exceptions and close the reconciliation once balanced.

Fields reference

Every field on this screen, drawn from the live data model.

Field	Type	Required	Description
Provider `provider_id`	Link → mfi.rtgs.provider	Yes	Provider
Statement Date `statement_date`	Date	Yes	Statement Date
State `state`	Choice: Draft, Fetched, Matched, With Differences, Failed	Yes	State
Name `name`	Text	—	Name
Entries Total `entries_total`	Number	—	Entries Total
Matched Total `matched_total`	Number	—	Matched Total
Unmatched Total `unmatched_total`	Number	—	Unmatched Total
Raw Statement `raw_statement`	Long text	—	Raw Statement
Notes `notes`	Long text	—	Notes
Line `line_ids`	List	—	Line

Status lifecycle

Records on this screen move through these statuses:

Draft → Fetched → Matched → With Differences → Failed

Notes & rules

Auto-matches transactions to statement lines by reference and amount.
Unmatched credits land in a suspense queue for investigation.
A reconciliation cannot close while material exceptions remain open.
Provides the audited evidence that settlement balanced for the day.

Technical model: mfi.rtgs.reconciliation · Record: RTGS Daily Reconciliation Run