UAE · ENBook a demo
Procure AIFinanceInvestigator

Bank Reconciliation Agent

Matches bank activity to the ledger.

Bank Reconciliation AgentAccounting Operations
Industry
Procure AI
Department
Finance
Team
Accounting Operations
Kind
Investigator
Approver
Accounting Manager
Code
FIN-07

It matches bank statement lines to ledger cash entries for the company's operating accounts and for the segregated client funding accounts it pays suppliers from, explains every unmatched item and every difference between bank and book balances, and proposes the adjusting entries. It completes each reconciliation in the ERP once every difference is explained or approved. **The problem it solves:** Why the bank and ledger balances differ for each operating or client funding account: the unmatched items, their dates and amounts, which side they sit on and how long each has been open.

How it works

6 steps, and a person signs off before step 6.

  1. 01Looks it up

    Finds the record the request is about in the ERP's purchasing and accounts payable modules: the bank statement lines and ledger cash entries for the accounts and period named, the client funds liability balances and the items left open from earlier reconciliations..

  2. 02Reads the request

    Works out what is being asked and what a complete answer needs.

  3. 03Checks the facts

    Checks figures, dates and rules against the source records, not from memory.

  4. 04Works it through

    Weighs competing explanations against the evidence and shows which one holds up.

  5. 05Asks a person

    Hands the work to Accounting Manager with its reasoning before anything goes out.

  6. 06Acts

    Once approved, it acts in the ERP's purchasing and accounts payable modules: it posts the approved adjusting entries, marks the matched items and completes the reconciliation. and records what was done.

What it works with

Your knowledge, your systems, your people.

Knows

The reconciliation policy: matching rules and tolerances, timing-difference rules, bank fee and interest accounts, the rule that client funding accounts reconcile to the client funds liability to the cent, and the escalation path for unexplained items.

Reads from

the ERP's purchasing and accounts payable modules: the bank statement lines and ledger cash entries for the accounts and period named, the client funds liability balances and the items left open from earlier reconciliations.

Acts in

the ERP's purchasing and accounts payable modules: it posts the approved adjusting entries, marks the matched items and completes the reconciliation.

Hands back

A list with one entry per bank account, each with account_name, kind, client_tenant (or null), bank_balance, ledger_balance, difference, matched_count, open_items (a list, each with date, amount, side, item_class (timing, fee_or_interest, returned_payment, error, duplicate or unknown), evidence and days_open), adjusting_entries (a list, each with account, amount and description) and unexplained_amount.

Asks a person when

An adjusting entry is 100 or more or is on a client funding account, an item is classed as an error, duplicate or returned payment, the unexplained difference is above 0, or an item is older than 30 days.

ApproverAccounting Manager

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Amount tolerance for a match (USD)0.5Operating account lines within this may match; client funding accounts always match exactly.
Date window for a match (days)3A bank line and ledger entry this many days apart or less may match.
Post bank fees and interest without approval below (USD)100Adjusting entries for bank charges or interest under this post straight away on operating accounts.
Escalate an open item after (days)30An unmatched item open longer is escalated with its history.
Most unexplained difference allowed (USD)0A reconciliation completes only when the unexplained difference is at or below this.

Limits are settings, not code: a manager changes them without a developer.

Rules it always follows

  • Match bank and ledger items on amount within 0.5 and date within 3 days, then on reference; client funding accounts match exactly and a one-to-many match must sum exactly.
  • Class every unmatched item as timing, bank fee or interest, returned supplier payment, error, duplicate or unknown, with the evidence for the class.
  • A returned supplier payment on a client funding account is credited back to that client's funds and routed to AP for the supplier's corrected details, never re-sent by this agent.
  • Bank fees on a client funding account are charged as the client contract says, never netted silently against client funds.
  • Propose adjusting entries for fees and interest; those below 100 on operating accounts post without approval.
  • Escalate an item open longer than 30 days; a reconciliation completes only when the unexplained difference is at or below 0, never by forcing the ledger.

See the Bank Reconciliation Agent agent on your own work.

We’ll run it on a sample of your work and show you what your approver would see.

Bank Reconciliation Agent · Procure AI | Basinwright Industries