Cash & Nostro Reconciliation
Bank statements (SWIFT MT940/950) vs GL cash ledgers, multi-currency
Total Lines Compared
7
Matched
4
Breaks
2
Warnings (tolerance)
1
About This Agent
Data on This Page
Three nostro/settlement accounts (GBP Settlement — London at Barclays, USD Nostro — New York at JPMorgan Chase, EUR Nostro — Frankfurt at Deutsche Bank) with live balances, plus 7 statement lines comparing bank-reported amounts against GL ledger amounts by reference, date, status (match / break / warning) and age in days.
What This Agent Does
Ingests SWIFT MT940/950 bank statement feeds and matches each line against the corresponding GL cash-ledger posting, account by account and currency by currency. Exact matches are auto-cleared; small variances are flagged as tolerance warnings; anything else becomes a hard break that ages until resolved with "Match to Bank" — the cash reconciliation layer competing directly with TLM and AutoRek's nostro modules.
Worked Examples
- SEPA-11209: EUR Nostro — Frankfurt shows a bank receipt of €780,450.00 against €0.00 in the GL — flagged as a break (missing GL posting), aged 3 days.
- WIRE-88240: USD Nostro — New York bank amount $45,610.20 vs GL $45,600.00, a $10.20 gap — small enough to fall inside tolerance, so it's a warning rather than a break.
- FT24089156: GBP Settlement — London bank £182,004.50 vs GL £157,624.50, a £24,380.00 gap flagged same-day as a genuine break needing investigation.
Barclays · GBP
GBP Settlement — London
£4,281,904.12
JPMorgan Chase · USD
USD Nostro — New York
$9,102,447.88
Deutsche Bank · EUR
EUR Nostro — Frankfurt
€6,540,220.55
Reconciliation Results
| Status | Account | Reference | Date | Bank Statement | GL Ledger | Age | Action |
|---|---|---|---|---|---|---|---|
| GBP Settlement — London | FT24089123 | 2025-03-20 | £24,380.00 | £24,380.00 | 0d | ||
| GBP Settlement — London | FT24089156 | 2025-03-20 | £182,004.50 | £157,624.50 | 0d | ||
| USD Nostro — New York | WIRE-88213 | 2025-03-19 | $1,204,000.00 | $1,204,000.00 | 1d | ||
| USD Nostro — New York | WIRE-88240 | 2025-03-18 | $45,610.20 | $45,600.00 | 2d | ||
| EUR Nostro — Frankfurt | SEPA-11209 | 2025-03-17 | €780,450.00 | €0.00 | 3d | ||
| EUR Nostro — Frankfurt | SEPA-11288 | 2025-03-20 | €12,050.00 | €12,050.00 | 0d | ||
| GBP Settlement — London | FT24089201 | 2025-03-15 | £3,200.00 | £3,200.00 | 5d |