top of page
Search

How Guest Houses Reconcile Card and Booking Payments

Nov 7
8 min read

Quick Summary

Guest houses reconcile card and booking payments by comparing each day's card terminal batch against that day's reservations, then matching every booking platform payout line by line against gross booking value less commission. Deposits, refunds and direct payments are tracked separately so that payment reconciliation finishes within days rather than at year end.

  • Compare the terminal batch total with the day's reservations each evening, matching each card payment to a guest and booking reference.

  • Track card settlement dates separately, since payments often settle one or two working days after they are taken.

  • Reconcile each booking platform payout within a few days of receipt, using the attached reservation list as primary evidence.

  • Record deposits as separate lines and close them to zero at checkout, so balances never drift.

  • Log every mismatch in an exception log to spot recurring errors by shift, channel or payment route.

Table of Contents

Why Guest House Payment Reconciliation Goes Wrong

Last Updated: 6 November 2026

Most guest house owners know the feeling. The card machine says you took £2,340 last week, the booking platform says it paid out £2,110, and nobody can explain the £230 gap. Payment reconciliation is the process of matching what guests paid against what actually reached your bank account. Done well, it takes minutes a day. Done badly, it quietly drains profit and hides mistakes for months.

Payment reconciliation problems are common among independent hospitality operators. The reasons it goes wrong are usually simple, and they repeat across properties.

  • Card takings are batched and settled on different days from when they were taken

  • Booking platforms deduct commission before paying out, so the amounts never match

  • Deposits, refunds and cancellations are recorded in different places

  • Staff enter the same payment twice, or not at all

  • Nobody checks the numbers until the accountant asks for them at year end

Each of these creates a timing or amount difference. Without a routine, those differences pile up.

Matching Card Payments to Reservations Day by Day

The simplest fix is a daily habit. Each evening, compare the card terminal's end-of-day report against the reservations taken and checked out that day. A card payment should match a named guest and a booking reference.

Flowchart illustrating the daily payment reconciliation process for matching card terminal receipts to guest reservations

Here is a practical way to do it:

  1. Print or export the terminal batch total for the day

  2. List every card payment against its guest name and room

  3. Tick off each payment against your booking system

  4. Note any payment with no matching reservation

A common mistake is treating the terminal total as final. Card payments often settle one or two working days later, so today's batch may not appear in your bank until after the weekend. Track the settlement date separately from the transaction date.

Booking.com Payout Reconciliation Step by Step

Booking.com pays you net of its commission, so the payout will look smaller than the booking value. Your job is to show why each figure is correct, line by line, and to prove that the net received equals the gross booking value less commission and any adjustments.

For each payout, check:

  • The payout reference and date

  • The list of reservations included

  • The gross booking value for each reservation

  • The commission deducted for each reservation

  • Any guest payments already collected by you, which are not paid out again

  • Any refunds, cancellations or no-show adjustments applied to the payout

Keep a simple spreadsheet with columns for booking reference, gross amount, commission, net expected and net received. Any row where the net received differs from the net expected needs investigating. Most differences come from cancellations, no-shows, currency conversions or a guest payment you collected directly that Booking.com has therefore excluded from the payout.

A worked example makes the mechanism clearer. Suppose a guest books two nights at £120 per night, so the gross booking value is £240. Booking.com deducts commission at your agreed rate and pays out the net amount. If the guest paid a £50 deposit directly to you by bank transfer at the time of booking, Booking.com does not collect that £50, so the payout remains £204 and you have already received £50 separately. Your reconciliation line should show gross £240, commission £36, net expected £204, net received £204, plus a note that £50 was collected directly. The reservation is fully accounted for only when the direct deposit and the platform payout are added together and matched to the total booking value.

Watch out: a cancellation after the payout date can produce a negative adjustment on the next payout rather than a reversal on the current one, so a payout that looks short may simply be carrying a prior-period correction. Check the adjustment lines before treating a difference as an error.

Reconcile each payout within a few days of receipt rather than at month-end. The reservation list attached to the payout is your primary evidence, and it is easier to query a discrepancy while the booking is still fresh in the booking system. Keep the payout statement and your completed reconciliation line together so your accountant can trace the net figure back to the gross booking value without asking you to reconstruct it later.

The article's key figures for a Booking.com payout reconcile as follows.

Item

Example value

Note

Nights booked

2 nights at £120

Gross booking value £240

Commission

£36

Deducted by Booking.com

Net expected

£204

Gross less commission

Direct deposit

£50

Collected by you, not in payout

Net received

£204

Matches net expected

Handling Guest House Deposits and Refunds

Deposits create the most confusion because they sit between booking and stay. A deposit taken in March for an August stay must be tracked from the day it arrives until the balance is settled.

Record each deposit as a separate line with the guest name, amount, date taken and expected balance. When the guest checks out, the balance should close that line to zero. Refunds need the same care. Log the original payment reference, the refund amount and the reason. Many guest houses only record refunds in the card terminal, which leaves the booking system showing money still owed.

A Repeatable Payment Reconciliation Checklist

Use this routine so reconciliation does not depend on memory.

Daily

  • Compare terminal batch totals with reservations for the day

  • Record any cash payments and deposits separately

  • Flag any card payment with no matching booking

Weekly

  • Match all booking platform payouts to reservations

  • Check that refunds appear in both the terminal and booking system

  • Clear any open deposits for guests who have checked out

Monthly

  • Reconcile total card settlements to your business bank statement

  • Review all platform commissions and fees against your expected rates

  • Archive reports so they are available for your accountant

Investigating Mismatches and Exceptions

Most reconciliation guidance stops at spotting a difference. The practical work is in resolving it, and that is where a repeatable investigation routine saves the most time. Work through exceptions in a fixed order so nothing is missed and nothing is investigated twice.

Start with the largest difference, because it is usually the most important, then work down. For each exception, establish four things before you change any record: the transaction date, the settlement date, the booking reference and the payment route. Most mismatches fall into a small number of recognisable types, and each has a standard check.

  • Unmatched payout. The amount reached the bank but no reservation matches it. Check the payout statement's reservation list first, then look for a booking made under a different guest name or a duplicate profile in the booking system. A payout covering several reservations will not match any single booking value, so reconcile it line by line against the statement rather than as one figure.

  • Duplicate charge. The guest was charged twice, often because a card was taken at check-in as well as through the booking platform. Check the terminal batch and the platform payout for the same booking reference and the same amount before refunding; refunding the wrong one leaves the duplicate in place.

  • Short payment. The amount received is less than expected. Check commission, currency conversion and any deduction for a guest payment collected directly. If none of these explains it, request the transaction breakdown from the processor before assuming the guest underpaid.

  • Timing difference. The transaction is correct but the settlement falls in a different period, commonly across a weekend or bank holiday. Track the settlement date separately from the transaction date so a timing difference is not mistaken for a loss.

  • Missing booking reference. The payment is real but cannot be tied to a reservation. Search by amount and date across the booking system, then by guest surname. If it remains unmatched, hold it in a suspense line rather than allocating it to the nearest booking, which only creates a second error.

Watch out: a refund processed on the terminal but not recorded in the booking system will show as money you still hold, overstating your takings and often going unnoticed until the next month. Check both records whenever a refund appears in only one place.

Keep a short exception log for every difference: the date found, the amount, the booking reference, the cause and the action taken. Over time the log shows which mistakes keep repeating, a particular staff shift, a booking channel or a payment route, and that tells you where to tighten the process. Review the log weekly so patterns surface while they are still cheap to fix, and keep it with your reconciliation records so the audit trail from bank statement to booking is complete.

Choosing Hospitality Payment Reconciliation Software

Manual spreadsheets work for a few bookings a week. Once volume grows, software that links your booking system, EPOS and card terminal saves time and reduces errors. When comparing options, check whether the system:

  • Imports booking platform payouts automatically

  • Matches card settlements to individual reservations

  • Tracks deposits and balances through to checkout

  • Exports clean reports for your accountant

Integration matters as much as features. A system that cannot talk to your booking platform still leaves you matching by hand. If you want to see how your current setup compares, Switch4Profit offers free advice on payment systems for hospitality businesses, with no service fees and free installation, staff training and ongoing support.

Book Your Free Business Cost Review With Switch4Profit

Reconciliation problems are often a symptom of a wider setup that has grown messy over time. If your payouts rarely match and your month-end takes days, a fresh look can help. Switch4Profit has over 30 years of hospitality industry experience and offers independent reviews of card and booking payments. Get started with a free review to find out where your money is going.

Frequently Asked Questions

How do guest houses reconcile payments?

Guest houses reconcile payments by comparing what was taken against what was booked. Each day, match card terminal settlements, cash counts and bank deposits to individual reservations in the property management system. Flag any guest whose charge, deposit or refund does not line up with their booking record. Reconciling daily rather than monthly keeps errors small and easy to trace, and gives the owner a clear audit trail for accounts and the accountant.

How often should a guest house reconcile payments?

Most guest houses should reconcile card and cash takings daily, ideally at the night audit or end-of-day close. Booking platform payouts usually arrive on a set schedule, so check them weekly against the reservations they cover. A full monthly reconciliation against the bank statement catches anything missed earlier. Daily checks prevent small mismatches from becoming hard-to-trace gaps by month end.

How do you match Booking.com payouts to guest reservations?

Use the payout statement from the booking platform, which lists each reservation, the amount paid out, and any commission deducted. Compare each line against your reservation records and confirm the gross booking value, commission and any guest-paid extras. Note any cancellations or no-shows that changed the payout. The total of matched lines should equal the bank deposit received, once commission and payment fees are accounted for.

What should a guest house do when a payment does not match a booking?

First, check whether the mismatch comes from timing, such as a payout covering several days or a deposit taken before arrival. Next, look for duplicate charges, refunds that were not recorded, or a guest booked under a different name. Record the discrepancy with a note and resolve it with the payment provider or booking platform. Keep a log of exceptions so recurring problems can be fixed at source.

 
 
 

Comments


Switch4Profit logo
  • Instagram
  • Facebook
  • LinkedIn

© 2025 S4P - Switch4Profit.co.uk

S4P is a trading reference of SWITCH4PROFIT Ltd, Registered in England and Wales Number 12465870 and whose Registered Office is: 207 Regent Street, Third Floor, London, W1B 3HH. View our Privacy Policy here.

bottom of page