- Industry
- Oil & Gas
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Investigator
- Approver
- Accounting Manager
- Code
- FIN-07
It matches bank statement lines to ledger cash entries for each account, including multi-currency accounts in host countries, joint-venture cash-call accounts and cargo receipt accounts, and explains every unmatched item and balance difference. It proposes adjusting entries and completes the reconciliation in the ERP once every difference is explained. **The problem it solves:** Why the bank and book balances differ: each unmatched item, timing items, fees, FX and partner cash calls, and which explanation fits 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 ERP's finance, maintenance and supply modules: the cash ledger and bank feed 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 ERP's finance, maintenance and supply modules: it completes the reconciliation and posts the adjusting entries. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The cash policy: bank accounts by entity and purpose (operating, JV cash call, cargo receipts), matching rules, FX revaluation and the treatment of bank fees.
Reads from
the ERP's finance, maintenance and supply modules: the cash ledger and bank feed for the account and period.
Acts in
the ERP's finance, maintenance and supply modules: it completes the reconciliation and posts the adjusting entries.
Hands back
An object with bank_balance, book_balance, matched, unmatched (with explanation) and adjusting_entries.
Asks a person when
A difference remains unexplained, an item is stale, or a joint-venture or cargo receipt account does not reconcile.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Amount tolerance | 0.5 | In account currency. |
| Date window (days) | 3 | For matching. |
| Post fees itself below | 100 | Bank fees. |
| Stale item (days) | 30 | Unmatched longer is escalated. |
| Unexplained difference allowed | 0 | Nothing is left unexplained. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Match within 0.5 and 3 days.
- Post bank fees below 100 itself.
- Escalate items unmatched for 30 days.
- Explain a cash-call account difference by partner and cash call, and never net one partner's receipt against another's.
- Complete only when the unexplained difference is 0.
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.