Skip to content
Bankautomation

Balance sheet reconciliation software where sign-off carries its evidence

Balance sheet reconciliation is a certification control. The number on the page matters less than the assertion behind it: this account has been reconciled, the open items are known and owned, and someone independent has reviewed that claim.

Run the demo

camt.053 · NOSTRO USD · value date 03 sep 2026

Nostro cash break, sample data

Match rate

75.0%

Breaks

4

At risk

$533.9k

Oldest

4d

Date ±1d
Amount

This console matches the first rows a side. It left out statement and ledger , so anything in them is not counted below. To run a full file, .

BRK-001

Aged 0d

$219,105.40

2026-09-03 · both sides

REF//FX/SPOT/7741 · INTERBANK FX DESK

Amount differs by 164.80 USD (0.075%)

Re-price the ledger leg on the correspondent rate source for the value date and post 164.80 USD to FX variance.

FX RATE SOURCE

→ Treasury Ops

BRK-002

Aged 4d

$187,650.00

2026-08-30 · ledger

PAY/90012/R · KESTREL LOGISTICS

Second ledger entry for 187,650.00 USD against REF//PAY/90012

Confirm the original entry REF//PAY/90012 cleared, then reverse this posting under maker-checker and note the reversal on the original item.

DUPLICATE POSTING

→ Finance

BRK-003

Aged 0d

$123,760.00

2026-09-03 · both sides

REF//TRF/554121 · HALCYON TRADING

Statement 61,880.00 vs ledger 123,760.00 (50% short)

Split the ledger posting and match the settled leg; leave the residual 61,880.00 USD open against the same reference.

PARTIAL SETTLEMENT

→ Payments Ops

BRK-004

Aged 0d

$3,410.00

2026-09-03 · statement

REF//CHG/Q3FEES · CORRESPONDENT CHARGES

On the statement, nothing in the ledger

Post 3,410.00 USD to the charges account for the period and add it to the standing accrual so it stops surfacing as a break.

FEE NOT ACCRUED

→ Finance

Everything matched under these tolerances.

Tighten the date or amount tolerance to see the breaks it was absorbing.

Correspondent statement

camt.053 · NOSTRO USD

Value date Reference Amount
2026-09-02 REF//NONREF/2026090301 1,284,500.00
2026-09-02 REF//INV/88231 96,400.00
2026-09-03 REF//TRF/554120 452,180.25
2026-09-03 REF//FX/SPOT/7741 218,940.60
2026-09-01 REF//SEPA/33421 74,220.00
2026-09-03 REF//CHG/Q3FEES 3,410.00
2026-09-03 REF//TRF/554121 61,880.00
2026-09-02 REF//PAY/90012 187,650.00
2026-09-02 REF//INV/88245 242,015.00
2026-09-03 REF//TRF/554133 18,905.50
2026-09-01 REF//PAY/90044 505,300.00
2026-09-03 REF//INV/88260 132,640.75

Internal nostro ledger

Core banking export

Value date Reference Amount
2026-09-02 NONREF/2026090301 1,284,500.00
2026-09-02 INV/88231 96,400.00
2026-09-03 TRF/554120 452,180.25
2026-09-03 FX/SPOT/7741 219,105.40
2026-08-31 SEPA/33421 74,220.00
2026-09-02 PAY/90012 187,650.00
2026-09-03 TRF/554121 123,760.00
2026-08-30 PAY/90012/R 187,650.00
2026-09-02 INV/88245 242,015.00
2026-09-03 TRF/554133 18,905.50
2026-09-01 PAY/90044 505,300.00
2026-09-03 INV/88260 132,640.75
Matched pairs are tinted on both sides. Breaks carry the brass left rule and appear in the worklist.

Sample data only. Matching runs in your browser; classification is written by the model when you press Run. Matching done in your browser. Writing classifications… Classifications written by the model on this run. Decision support, not a compliance determination. The classification model was unavailable, so the built-in rule classifier wrote these. Same matching, same numbers. This console classifies up to 12 runs a minute and this run went over, so the built-in rule classifier wrote these. Same matching, same numbers. Wait a minute for the model, or . The model wrote the first 8 classifications; the rule classifier wrote the remaining .

Open the full resolver

What a certification should contain

  • The reconciled position and the date it applies to.
  • Every open item with a classification, an age and an owner.
  • The tolerance and matching rule versions in force during the period.
  • The preparer, the reviewer, and the timestamps for both.
  • The supporting documents, attached to the items rather than to a folder.

Risk-based cadence, not one size fits all

Account riskReconciliationCertificationReview depth
High: nostro, settlement, suspense Daily Monthly Item level review of anything aged
Medium: fees, accruals, intercompany Weekly or monthly Monthly Sample of open items
Low: dormant or small static accounts Monthly Quarterly Balance and movement review

Swipe the table sideways to read every column.

Cadence is configured per account. What is not configurable is whether the preparer can also be the reviewer.

The quarter-end pack

The reason evidence packs take days is that the evidence was never in one place. When every action was recorded as it happened, the pack is a filter and an export: this scope, this period, everything attached. That is the single largest time saving finance teams describe when the daily control is fixed first.

We describe what the export contains and how the control works. We do not publish a saving figure, because we have not measured yours and any number we invented would be worth nothing to you.

What the signature is asserting, in four parts

A signature on a certification is a statement with several parts, and it is worth writing them out because teams frequently sign for less than they think they are signing for. The assertion is that the account balance is supported by an identified population of items, that every open item is known and has an owner, that the differences are explained rather than merely observed, and that a person independent of the preparer has reviewed all of that. A certification that cannot show the fourth part is a preparer's opinion with a countersignature.

Preparer, reviewer and the independence question

RoleResponsible forMust not also be
Preparer Completing the reconciliation and classifying open items The reviewer for the same account and period
Reviewer Challenging the classifications and approving the certification The person who posted the entries being reconciled
Account owner The population of open items and their resolution Necessarily either of the above, but must be named
Second line Sampling and challenging the process itself Involved in preparing or reviewing individual accounts

Swipe the table sideways to read every column.

Risk-rating the accounts, so effort follows exposure

Certifying every account to the same standard on the same cadence is the most common way a balance sheet reconciliation programme becomes expensive without becoming safer. Accounts differ enormously in what they can hide. A high-volume clearing account with two counterparties and a daily statement carries a different risk from a low-volume account that only moves at quarter end and is reconciled by the person who posts to it.

Rating each account on volume, volatility, whether an external source exists to reconcile against, and whether it has produced open items before, gives a defensible basis for cadence and reviewer seniority. High risk accounts are reconciled daily and reviewed by someone independent. Low risk, low movement accounts are reconciled monthly with a lighter review, and the rating itself is documented so the choice can be defended rather than assumed. The point is not to do less work. It is to stop spending the same effort on an account that cannot move as on one that can.

The second row is the one most often violated in smaller teams, usually with a pragmatic justification about headcount. It is worth recognising as a compensating control question rather than as a detail: if the reviewer also posts to the account, the review is not independent and the mitigation should be documented rather than assumed.

Late certifications, and what the escalation should be

Some accounts will not certify on time. The useful design decision is what happens then, and the wrong answer is that the deadline moves. An account that cannot be certified should be recorded as an exception with a reason, an owner and an expected resolution date, and it should be visible to whoever owns the close. That turns a missed deadline into a managed item rather than into an absence, and it produces the list that a controller actually needs: not which accounts certified, but which did not and why.

Aged items and the write-off conversation

Every certification population eventually contains items that are old, small and unresolved, and the temptation is to write them off in bulk at quarter end to clean the report. That is exactly the action that attracts scrutiny, and it is also usually unnecessary. Items aged past a threshold should be surfaced continuously with an owner rather than gathered periodically, because a small population reviewed weekly is a routine decision and a large population reviewed quarterly is an event.

  1. 01Set an age threshold per account type at which an item requires an explicit decision, not an automatic action.
  2. 02Require a reason code from a short list, so the population can be analysed by cause later.
  3. 03Enforce maker-checker on every write-off regardless of amount, because the pattern matters more than any single item.
  4. 04Report write-offs by reason and by account monthly, so a systematic cause becomes visible before it becomes a finding.

Group reporting, and the consolidation trap

In a banking group the same account can be certified locally and then aggregated centrally, and the two views frequently disagree because they were produced on different dates from different extracts. Holding certification as a state on the account, with a timestamp and the rule versions in force, rather than as a document produced for each audience, removes the disagreement by construction. Group reporting then reads the same records the local team certified, and a question about a specific account resolves to one answer rather than to a reconciliation between two reports.

Underneath certification sits the daily matching described in general ledger reconciliation, and the approval mechanics are the same ones described in compliance workflow automation.

Questions about balance sheet reconciliation software

Can we import our existing certification checklist?

Checklists per account type are configuration, so an existing checklist can be recreated as required evidence on the certification step, which is stronger than a document nobody reads.

What happens if an account cannot be certified on time?

It stays uncertified with a reason and an owner, and it is visible as such. Hiding a late certification is the failure mode this control exists to prevent.

Do you support attestation by a group finance function?

Multi-entity roll up with entity level preparers and a group reviewer is the Institution plan arrangement.

Is the audit trail immutable?

Actions are append only. A correction is a new recorded action with its own actor, timestamp and reason, and the original remains visible.

More banking automation pages

Every process line we cover, in one place.

Account reconciliation software Where the differences start, account by account. Bank reconciliation software Statement against ledger, MT940 and camt.053 native. Automated reconciliation software Match rates, tolerances, and what auto-match must never mean. Payment reconciliation software Instructed, settled and posted, reconciled three ways. Financial reconciliation software The same engine, framed for the finance team. ATM reconciliation software Cash, switch and network settlement, balanced daily. Credit union reconciliation software Corporate, share draft, card, ATM and shared branching. ACH reconciliation software Origination, receipt, returns and FedACH settlement. Federal Reserve account reconciliation Master account, FIRD, Fedwire and FedNow against the GL. Correspondent bank reconciliation Due from, due to and respondent settlement against the GL. AML compliance software Program workflow, evidence and cadence. Not a detection model. KYC automation software Onboarding and periodic refresh, queued and evidenced. AML software for banks What to ask, and what to refuse to buy. Compliance workflow automation Maker-checker, SLAs and evidence as a system property. BSA AML monitoring software Alert triage as a worklist, not a second inbox. RPA for banks Why screen-scraping bots break, and what replaces them. General ledger reconciliation software Sub-ledger to GL, and the suspense account nobody owns. ISO 20022 payment automation Structured data, repair rates and CBPR+ deadlines. Nostro reconciliation automation The most bank-specific reconciliation there is.

Get started

Put your first reconciliation on rails

Create an account, and we will email you how onboarding works and what a first source connection looks like. The Reconciliation Break Resolver is open to try right now, on sample data, without an account.

Run the demo

No card required to create an account. Sample data only in the demo. Bankautomation is operations software, not a regulated service.