Hotel Bank and Deposit Reconciliation Agent
Matches bank activity, cash drops and card deposits to the hotel ledger and explains differences.
- 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.
- 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..
- 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 Financial Controller with its reasoning before anything goes out.
- 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.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Amount tolerance for a match (USD) | 0.5 | Lines within this amount can match. |
| Date window for a match (days) | 3 | Card settlements and cash drops can land up to this many days after the business date. |
| Cash over or short to explain (USD) | 20 | A 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) | 100 | Bank fees below this are posted directly. |
| Stale after (days) | 30 | Unmatched items older than this are escalated. |
| Unexplained difference allowed (USD) | 0 | The 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.