- Industry
- IT Company
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Investigator
- Approver
- Accounting Manager
- Code
- FIN-07
It matches bank statement lines for each operating account to the ledger's cash entries (client receipts, subscription payouts, payroll funding, contractor and cloud vendor payments) and explains every unmatched item and every difference between bank and book. It proposes the entries to clear explained items and escalates anything unexplained. **The problem it solves:** Why bank and book cash do not agree: which items are unmatched, and whether timing, FX, fees, short payment or error explains each.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the accounting system's cash ledger and bank feed: the statement lines and ledger cash entries for the account and period..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to Accounting Manager with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the accounting system's general ledger: it posts the approved clearing entries and records the reconciliation. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The cash reconciliation procedure: accounts and their purposes, matching rules, common causes of differences (FX, fees, timing, short payments), and the posting limits for bank fees.
Reads from
the accounting system's cash ledger and bank feed: the statement lines and ledger cash entries for the account and period.
Acts in
the accounting system's general ledger: it posts the approved clearing entries and records the reconciliation.
Hands back
An object with matched_count, unmatched (a list with side bank or book, date, amount, reference, cause and evidence), proposed_entries (a list), difference and ready_to_sign_off (true or false).
Asks a person when
An unexplained difference remains, a proposed entry is above 100 USD, or a payment looks duplicated.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Amount tolerance (USD) | 0.5 | Differences up to this still match. |
| Date window (days) | 3 | Entries within this many days of each other may match. |
| Post bank fees below (USD) | 100 | Bank and FX fees below this are posted without a person. |
| Stale item (days) | 30 | Unmatched items older than this are escalated. |
| Unexplained difference allowed (USD) | 0 | Any unexplained difference above this blocks sign-off. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Match on amount within 0.5 USD and date within 3 days, using the reference first.
- Explain each unmatched item as timing, FX, bank fee, short payment, duplicate or unknown, with the evidence.
- Post bank and FX fees below 100 USD; larger ones go to the Accounting Manager.
- Escalate items older than 30 days.
- Block sign-off while an unexplained difference above 0 USD remains.
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.