How to reconcile bank transfers at a hotel restaurant

A guest at table 8 pays ₦18,000 by bank transfer, shows the waiter a screenshot, and heads upstairs. An hour later, a bank alert for ₦18,000 arrives. Are the two the same payment? Usually, yes. Sometimes, no. And the difference is where money goes missing.

Reconciliation is the routine of checking. It sounds like accounting, but at a hotel restaurant it is a daily habit that takes about as long as a shift handover once your records are in order. This guide walks through a routine for restaurants and bars that take a mix of cash, POS, and bank transfers.

What reconciliation actually means

To reconcile is to compare two independent records of the same money, and explain every difference between them. In a restaurant, those two records are your sales record (what your team says was sold, and how it was paid) and your statements (what your bank and POS provider say actually arrived).

The word that matters is independent. A waiter’s screenshot and the same waiter’s sales entry come from one person, so they can’t check each other. A bank statement can.

Record the right details at the moment of sale

Matching is only as good as what was written down when the order was taken. For every sale, make sure your team records:

• The order number, table, and the staff member who served it.
• The amount, including any service charge or discount.
• The payment method: cash, POS card, or bank transfer.
• For transfers, the reference or narration the guest used, and roughly what time they paid.

That last line is the one most teams skip. A transfer reference such as “DIN-1042” turns a guess into a match.

The daily routine, in five steps

1. Close the sales for the shift

   Finish or void every open order before you start matching. Open tabs are the first source of confusion, because a payment can arrive for an order that hasn’t been closed yet.

2. Split the day by payment method

   Total cash, POS, and transfers separately. Each one has its own proof: a cash count, a POS settlement report, and bank credits.

3. Match transfers by amount, reference, and time

   Start with an exact amount and reference. Then try amount plus a short time window, since a transfer can land minutes after the sale. If two sales share an amount, use the reference or the table to tell them apart.

4. List what didn’t match

   Keep two lists: sales with no payment, and payments with no sale. Don’t force a match to make the numbers tidy. An honest gap is more useful than a wrong pairing.

5. Decide, then write down the decision

   For each item, choose one: confirmed (found later), follow up (ask the staff member or guest), or written off, with the name of the person who approved it. The note matters as much as the number.

A worked example

Here is one evening’s transfers for a hotel restaurant, matched line by line.

Two of the four lines are settled in a minute each. The last two are the ones that matter, and they are the reason to reconcile every day instead of every month: the server still remembers table 5, and the guest who sent ₦25,000 is probably still in the building.

Why a transfer doesn’t match

When a line won’t match, the cause is usually one of these:

• Timing. The credit lands after the shift closes, or the next morning. Match across a short window rather than a single shift.
• Combined or split payments. One guest pays for two orders in a single transfer, or several guests split one bill.
• A missing or wrong reference. The guest typed their own name instead of the order number.
• The wrong method. The sale was entered as cash, but the guest paid by transfer, or the other way round.
• No money arrived. A screenshot was shown, but nothing reached your account. Only a credit on your statement confirms payment.

Cash and POS need the same habit

The routine above works for every payment method. For cash, count at shift close with a second person, and compare the total with what the record says was paid in cash. For POS, compare the day’s POS total with the provider’s settlement report. Settlements can arrive a day or more later, and often net of the provider’s charges, so expect the bank credit to differ from the sales total by a known amount.

Make it a habit, not a project

Pick a fixed time for reconciliation, such as the start of the morning shift. Give it to one person, and ask a second person to approve any write-off. Once a week, look at the count of unmatched items: it should be shrinking. If the same gap keeps appearing on one shift, one outlet, or one payment method, look at the pattern before you look at the people.

If a bar sits alongside your restaurant, pair this routine with a regular stock count. Sales and stock tell the same story from two sides, and a gap in one often explains a gap in the other.