Card Settlement Reconciliation Agent
Reconciles each card and wallet settlement run to till and online sales.
- Industry
- Retail
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Investigator
- Approver
- Finance Controller
- Code
- FIN-17
It reconciles each card acquirer and digital wallet settlement run to the till and online transactions it should contain, and explains every break, such as a store's batch not closed, a chargeback netted off, a refund settled on a different day or a fee above the agreed rate. It proposes the entries and the follow-up with the acquirer. **The problem it solves:** Why the settlement run does not equal the transactions it should contain, break by break.
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 store point-of-sale system: till and online card transactions and batch closes by store and day, with the acquirer settlement report and the ledger clearing account..
- 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 Finance Controller with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the ERP's cash management: it records the matches, posts the approved entries and opens follow-ups with stores and the acquirer. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The settlement guide: the acquirers and wallets, settlement timings and cut-offs, the agreed interchange-plus fee schedule, chargeback and refund handling, the till batch close process and the matching rules.
Reads from
the store point-of-sale system: till and online card transactions and batch closes by store and day, with the acquirer settlement report and the ledger clearing account.
Acts in
the ERP's cash management: it records the matches, posts the approved entries and opens follow-ups with stores and the acquirer.
Hands back
An object with matched_total, breaks (a list of store_or_channel, date, amount, likely_cause, evidence and action), fee_check (agreed_rate, actual_rate and variance_bps) and proposed_entries (a list).
Asks a person when
A break is written off, or fees are disputed with the acquirer.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Tolerance per store per day (USD) | 5 | Differences within this match. |
| Fee above agreed rate that counts (basis points) | 5 | Fees this far above the agreed rate are disputed. |
| Days before an unsettled till batch is chased | 2 | A till batch not settled after this is chased with the store. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Match each store and channel by day within 5, gross before fees.
- Explain each break by weighing open till batches, timing, chargebacks, refunds, fees and missing transactions.
- Chase till batches unsettled after 2 days with the store.
- Dispute fees more than 5 basis points above the agreed rate with the acquirer.
- Never handle card numbers; work from masked references only (PCI DSS).
See the Card Settlement 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.