BFSI: reconciliation and finance exceptions

Configure a read-only reconciliation assistant for synthetic bank and ledger data, review discrepancies, and hand approved corrections to finance.

Scenario and boundary

Example Bank's finance team wants a daily exception pack comparing a reviewed ledger export with bank/settlement statements. AgenticOrg assists with evidence extraction, comparison, break classification and a reviewable summary. Posting entries, releasing money and certifying balances remain the finance team's authorized process.

This is a configurable reference workflow, not a universally pre-integrated bank reconciliation product. The actual ledger/bank connector contract, matching logic and accounting policy must be implemented/reviewed for the institution.

Prepare the sources

Use synthetic CSV/XLSX statements with transaction reference, date, amount, currency and relevant account mapping. Define timezone, date boundaries, sign conventions, duplicates and tolerances. Avoid real account numbers in training examples.

Upload the reconciliation procedure to Knowledge Base and verify search. Configure read-only exports/connectors with the correct company binding. Make sure the agent's selected tools actually read the required data; a finance template alone does not do so.

Configure and run

For a small reproducible exercise, prepare these two synthetic datasets using the schema expected by your reviewed read tool. Do not infer that uploading CSV to Knowledge Base automatically connects the reconciliation agent to it.

source,reference,date,amount,currency
bank,DEMO-001,2026-09-28,1000.00,INR
bank,DEMO-002,2026-09-28,2500.00,INR
bank,DEMO-003,2026-09-28,750.00,INR

source,reference,date,amount,currency
ledger,DEMO-001,2026-09-28,1000.00,INR
ledger,DEMO-002,2026-09-28,2400.00,INR
ledger,DEMO-004,2026-09-28,500.00,INR

The reviewed expected result is one exact match (DEMO-001), an INR 100 amount difference (DEMO-002), one bank-only entry (DEMO-003) and one ledger-only entry (DEMO-004). Bank total is INR 4,250; ledger total is INR 3,900. These figures are teaching assertions, not reconciled customer balances. Require source-row references and validated calculations in the exception pack.

Review the available reconciliation agent or create a bounded finance candidate.
Specify output: matched items, unmatched items, reason, evidence reference and proposed follow-up.
For exact financial totals, require deterministic calculations/validated tool results; do not ask an LLM to invent or approximate amounts.
Build a manual workflow: read sources, validate schema, compare, prepare exception pack, human review.
Run a synthetic day with known expected matches and deliberate breaks.
Inspect source freshness, totals, duplicate handling and every exception.
Hand approved corrections to the accounting system through a separately authorized process.

1Read-only data
Collect the reviewed statement and ledger for the same business period.
2Validate and compare
Apply reviewed mappings, currencies, totals and matching rules.
3Exception pack
List breaks with evidence and missing information.
4Finance review
Resolve ambiguity and approve any proposed correction.
5Authoritative posting
The institution's controlled finance path performs and confirms updates.

Sample acceptance cases

Input	Expected evidence
Same reference and amount	A documented matched pair
Missing ledger item	Unmatched source entry, not a guessed posting
Same amount in different currencies	No unsupported cross-currency match
Duplicate reference	Explicit duplicate exception
Corrupt/partial source	Failed validation or incomplete evidence, not balanced totals

Scheduling and operations

Schedule only after a manual run is reproducible. Confirm timezone, statement arrival, worker availability, rate limits and retry/idempotency. A late source must not be represented as a complete daily reconciliation.

Measure correctly identified breaks, false matches, review effort, source delays and reopened corrections. Compare against an independently reviewed ledger sample. Retest mappings after upstream changes.

Next: Connectors, Workflows, Audit and monitoring.

View this page on AgenticOrg