Hotel payment reconciliation: match POS settlements to the bank

Reception records a successful card payment, yet the bank receives a smaller amount later. That does not automatically mean the guest underpaid. The hotel needs a clear link between what staff recorded, what the payment provider processed and what reached its bank account.

This guide proposes a manual control worksheet for a small hotel. It concerns card settlement after payment, rather than the room’s selling price. Use the net and gross rate guide for commission and markup calculations. The figures below are fictional training amounts, not provider tariffs or financial advice.

Compare three records with different purposes

The PMS record answers which reservation received a payment, its amount and its method. The terminal receipt or provider transaction helps verify the external payment result. The settlement report explains the transfer being paid out; the bank statement confirms the actual credit.

Give each worksheet row a reservation reference, internal payment reference, external transaction reference and settlement identifier where available. Record currency, amount and relevant dates beside them. Matching only by amount is weak evidence: several guests can pay exactly 100 AZN on the same day.

For context, Adyen’s settlement report documentation describes a payout entry containing its reference, batch number and bank account. Check which equivalent fields your own provider supplies.

Start with the payment, then examine the batch

Review whether the recorded card payment has the correct external confirmation. An attempted payment or an unclear receipt needs investigation before anyone treats it as completed. Check the transaction result with the provider rather than asking the guest to pay again merely because the bank credit is absent.

Next, identify the payout containing that transaction. A terminal’s daily total and a provider’s payout can cover different groups of transactions. Write the actual reporting boundaries and time zone on the worksheet; do not assume a matching calendar date proves a matching batch.

Stripe’s payout reconciliation documentation distinguishes the report’s estimated arrival date from the date a bank posts the deposit. Confirm the dates shown by your own provider and bank.

A fictional 1,000 AZN settlement

Assume one identified batch includes completed card sales of 1,000 AZN, a confirmed refund of 100 AZN and a documented processing fee of 20 AZN. All amounts use AZN; there are no other adjustments in this simplified exercise.

Worksheet line	Amount
Gross completed card sales	1,000 AZN
Refund included in this batch	−100 AZN
Fee deducted in this batch	−20 AZN
Expected net bank credit	880 AZN
Actual matching bank credit	880 AZN
Unexplained amount difference	0 AZN

The 120 AZN reduction is explained by the two documented deductions. Do not change guest payments to 880 AZN to match the bank. Keep the original payment and refund references visible. The fee belongs in the settlement explanation; its formal accounting treatment should follow the hotel’s accounting process.

Suppose the provider reports the payout on Monday, but the matching bank credit appears on Tuesday. At Monday’s review, mark 880 AZN as awaiting bank confirmation, with a next check on Tuesday. Close that timing item only after checking Tuesday’s credit reference and amount. These days illustrate the workflow, not a promised settlement schedule.

Use a repeatable exception checklist

1. Select the property, merchant account, currency and review period.
2. Match PMS card entries to external transaction references and results.
3. Link refunds to their original payments and the batch containing them.
4. List every evidenced deduction or adjustment before calculating expected net.
5. Match the payout reference and amount to the actual bank credit.
6. Assign unmatched items an owner, next action and review date.

Keep separate statuses such as awaiting report, awaiting bank credit, entry correction required and resolved. If 870 AZN arrives instead of the expected 880 AZN, the remaining 10 AZN is unresolved until evidence explains it. “Probably a fee” is a hypothesis, not closure.

Prevent a second payment entry

The later bank credit settles money already collected by card. It is not another payment by the guest. Before entering anything, search the reservation’s existing payment references. Follow the supported correction process for a wrong method or duplicate and retain the reason.

The guest folio guide covers account balances. Pass unresolved settlement rows into the night audit handover with a named owner.

Frequently asked questions

Must today’s card total equal today’s bank credit? No. First establish that both records cover the same transactions and explain deductions and timing.

Should reception collect a missing settlement amount from the guest? A delayed payout alone does not prove guest debt. Verify the original payment and investigate the settlement separately.

Does BirOtel automatically reconcile POS and bank data? BirOtel supports internal payment records and reporting; automatic POS or bank integration is not established. Bring this worksheet to a cashier and reporting demonstration to check the available records and plan the external comparison.