UAE · ENBook a demo
HotelFinanceInvestigator

Hotel Bank and Deposit Reconciliation Agent

Matches bank activity, cash drops and card deposits to the hotel ledger and explains differences.

Hotel Bank and Deposit Reconciliation AgentBank Reconciliation Agent · Accounting Operations
Industry
Hotel
Department
Finance
Team
Accounting Operations
Kind
Investigator
Approver
Financial Controller
Code
FIN-07

It matches bank statement lines to the ledger for each property's accounts: front office and outlet cash drops, card settlements, advance deposits, city ledger receipts, OTA payouts and supplier payments, and explains every unmatched item and every difference between the bank and book balances. It proposes the adjusting entries and completes the reconciliation once every difference is explained or approved. **The problem it solves:** Why the bank and book balances differ: each unmatched item, its date and amount, the cash drops and card settlements behind it, and what changed in the period.

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 accounting system's cash ledger and bank feed: the bank statement lines and ledger cash entries for the accounts and period, with the PMS and POS cash drop and card settlement reports..

  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: it posts the approved adjusting entries and marks the reconciliation complete. and records what was done.

What it works with

Your knowledge, your systems, your people.

Knows

The reconciliation procedure: the bank accounts per property, cash drop and safe count procedures, card settlement timing by card type, how advance deposits and OTA payouts land, bank fee schedules and the over-and-short rules for cashiers.

Reads from

the accounting system's cash ledger and bank feed: the bank statement lines and ledger cash entries for the accounts and period, with the PMS and POS cash drop and card settlement reports.

Acts in

the accounting system's cash ledger: it posts the approved adjusting entries and marks the reconciliation complete.

Hands back

A list with one entry per account, each with property, account_name, bank_balance, book_balance, matched_count, unmatched (a list, each with date, amount_usd, side, cause, evidence and how_to_confirm), adjusting_entries (a list), unexplained_difference and complete (true or false).

Asks a person when

An adjusting entry is 100 or more, an item is classed as an error, a duplicate or a cash shortage above 20, the unexplained difference is above 0, or an item is older than 30 days.

ApproverFinancial Controller

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Amount tolerance for a match (USD)0.5Lines within this amount can match.
Date window for a match (days)3Card settlements and cash drops can land up to this many days after the business date.
Cash over or short to explain (USD)20A cashier's drop over or short by more than this is investigated, not written to over-and-short.
Post bank fees without approval below (USD)100Bank fees below this are posted directly.
Stale after (days)30Unmatched items older than this are escalated.
Unexplained difference allowed (USD)0The reconciliation completes only when the unexplained difference is at or below this.

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

Rules it always follows

  • Match bank to book within 0.5 and 3 days of the business date.
  • Explain each unmatched item as timing, a bank fee, a card chargeback, a cash over or short, a misposting, a duplicate or unknown, and say what would confirm it.
  • A cash drop over or short by more than 20 is investigated with the cashier's shift report before it is posted.
  • Post bank fees below 100; any other adjusting entry goes to the Financial Controller.
  • Escalate items older than 30 days.
  • Complete the reconciliation only when the unexplained difference is at or below 0.

See the Hotel Bank and Deposit 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.

Hotel Bank and Deposit Reconciliation Agent · Hotel | Basinwright Industries