UAE · ENBook a demo
RetailFinanceInvestigator

Card Settlement Reconciliation Agent

Reconciles each card and wallet settlement run to till and online sales.

Card Settlement Reconciliation AgentAccounting Operations
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.

  1. 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..

  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 Finance Controller with its reasoning before anything goes out.

  6. 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.

ApproverFinance Controller

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Tolerance per store per day (USD)5Differences within this match.
Fee above agreed rate that counts (basis points)5Fees this far above the agreed rate are disputed.
Days before an unsettled till batch is chased2A 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.

Card Settlement Reconciliation Agent · Retail | Basinwright Industries