UAE · ENBook a demo
HotelFinanceInvestigator

Card Settlement Reconciliation Agent

Reconciles each card acquirer and payment gateway settlement to the hotel's card payments.

Card Settlement Reconciliation AgentAccounting Operations
Industry
Hotel
Department
Finance
Team
Accounting Operations
Kind
Investigator
Approver
Financial Controller
Code
FIN-17

It reconciles every settlement batch from the card acquirer and payment gateway against the card payments the PMS, point-of-sale system and booking engine recorded for that batch's window: front desk check-outs, deposits, incremental authorisations, OTA virtual cards charged, and restaurant and spa sales. It explains each variance as cut-off timing against the night audit, a processing fee, a refund, a chargeback, a declined or expired authorisation, or a duplicate, proposes the adjusting entries, and completes the batch once every variance is explained or approved. **The problem it solves:** Why a card settlement batch differs from the card payments recorded: the batch and its window, the variances, the fees against schedule, and the refunds, chargebacks and authorisations behind them.

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 payment gateway's settlement reports and the PMS: the settlement batches, fees, refunds and chargebacks, with the card payments recorded in the PMS, point-of-sale system and booking engine for each batch window..

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

  6. 06Acts

    Once approved, it acts in the accounting system's cash ledger and the settlement register: it posts the approved adjustments, records chargeback responses and marks each batch reconciled. and records what was done.

What it works with

Your knowledge, your systems, your people.

Knows

The card processing terms: acquirer fee schedules by card type, batch close times by property and outlet, authorisation and incremental hold rules, virtual card rules for OTA bookings, chargeback reason codes and evidence windows, and PCI DSS handling rules.

Reads from

the payment gateway's settlement reports and the PMS: the settlement batches, fees, refunds and chargebacks, with the card payments recorded in the PMS, point-of-sale system and booking engine for each batch window.

Acts in

the accounting system's cash ledger and the settlement register: it posts the approved adjustments, records chargeback responses and marks each batch reconciled.

Hands back

A list with one entry per batch, each with batch_id, property, source, settled_usd, recorded_usd, variances (a list, each with amount_usd, cause, evidence and how_to_confirm), fees_usd, fee_vs_schedule_bps, chargebacks (a list, each with case_id, respond_by and evidence_ready), adjusting_entries (a list) and complete (true or false).

Asks a person when

A fee is 500 or more or does not match the agreed schedule, a variance is classed as a duplicate, a chargeback or unknown, a chargeback response is due, a batch is missing, or a batch has been unreconciled for more than 48 hours.

ApproverFinancial Controller

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Variance tolerance per batch (USD)2Differences at or below this are rounding.
Fee tolerance against the schedule (basis points)5Fees above the agreed rate by more than this are flagged.
Batch cut-off grace (minutes)30Payments within this of the batch close may fall in the next batch.
Post fees without approval below (USD)500Fees matching the schedule and below this are posted directly.
Days before a chargeback deadline to respond5Chargebacks are prepared with the folio, signed registration card and authorisation evidence at least this many days before the deadline.
Escalate an unreconciled batch after (hours)48A batch open longer than this is escalated.

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

Rules it always follows

  • Reconcile each batch to the card payments recorded in its window, allowing 30 minutes either side of the batch close and the night audit.
  • Explain each variance as timing, a fee, a refund, a chargeback, an expired or declined authorisation, or a duplicate, and say what would confirm it.
  • Flag fees more than 5 basis points above the agreed schedule, and post matching fees below 500.
  • Prepare each chargeback response with the folio, registration card and authorisation evidence at least 5 days before the deadline.
  • Use only the last four digits and the token of any card; never handle full card numbers.
  • Escalate a batch unreconciled for more than 48 hours, and send other adjustments to the Financial Controller.

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 · Hotel | Basinwright Industries