Industries/Community banks/Reconciliation Agent
Operating and DDA reconciliationcommunity banks.
When a community bank's correspondent file shows WIRE-88213 at $15,382 but GL shows $15,832, the agent cites both amounts and proposes the transposition entry before the CFO signs the cert. Staff export BAI2 from the correspondent bank and VLOOKUP against GL 1010.
Scenarios in community banks
Recon breaks hide in wire and lockbox detail
A single transposed wire or misdated lockbox deposit can stall the CFO's sign-off when spreadsheets are the only trail. The Reconciliation Agent ingests BAI2 and GL, auto-matches references like WIRE-88213, and proposes transposition fixes with both amounts quoted.
Commercial onboarding packs are inconsistent
Treasury or accounting manager approves each proposed journal before post.
Operating and DDA reconciliation
September operating account activity includes outgoing wire WIRE-88213 to Halvorsen Trade Partners GmbH.
What the agent checks
- Exact amount match within penny tolerance
- Reference token match (wire ID, lockbox, check number)
- Transposition heuristic when |bank − ledger| is divisible by 9
- Deposit in transit when ledger precedes bank within N days
- Duplicate payment detection on reference + amount
- Corporate card aggregation vs individual bank debits
How it works
- 1
Ingest bank and ledger
Parse BAI2, MT940, CAMT.053, or CSV bank files alongside GL cash detail. Normalize signs, dates, and references to a common matching key.
- 2
Auto-match within policy
Pair lines by exact amount, by reference token, and by fuzzy description within date windows you configure. One-to-many and many-to-one sets are scored and ranked.
- 3
Classify exceptions
Flag transpositions when differences divide by nine, deposits in transit when bank date follows ledger date, outstanding checks when only GL shows the payment, and duplicate payments when the same reference hits twice.
- 4
Propose journals
Draft adjusting entries with memo text that quotes bank and ledger amounts. Route to approvers by threshold and account sensitivity.
- 5
Close the period
Publish a reconciliation summary with matched balance, open items, and approved adjustments — ready for controller sign-off.
Questions
Does this replace our core banking system?
No. FinanceAI reads exports and APIs you authorize and returns proposed matches and journals for approval in your normal workflow.
Can we start with reconciliation only?
Yes. Many community bank pilots begin with one operating account and BAI2 ingest before expanding to KYC or close.
Does FinanceAI need live API access on day one?
No. Many pilots start with scheduled BAI2/MT940/CAMT.053 files and GL exports over SFTP. Read-only APIs come next once security review passes. The live demo uses the shared Aster Bank synthetic ledger.
What if Stellitron Intelligence is unavailable?
Every decision still runs through deterministic rules: amount matching, transposition checks, UBO percentage math, screening score thresholds, and flux materiality gates. Optional intelligence only improves extraction and narrative.