How should an Irish hotel reconcile Booking.com payouts against commissions and refunds?
A bank credit rarely tells the whole story of a hotel booking. This guide follows three fictional reservations from guest charges through refunds and commission to one euro payout, with a clear trail for your accountant.
Match each Booking.com reservation to the payout breakdown, then reconcile the batch total to the bank credit. Start with gross guest amounts, subtract refunds and only the commission and other charges actually withheld, and include documented adjustments. Check whether the payout is gross or net before deducting commission. Keep stay dates, refund dates and bank dates separate, and carry unresolved differences forward with supporting references.
Start with the payment route and source records
Reliable hotel Booking.com payout reconciliation starts with identifying who collected the money. Booking.com is an online travel agency (OTA); your property management system (PMS) holds the hotel reservation records. Separate Booking.com bank transfers from guest payments collected by the hotel and virtual credit card settlements.
- Gather the reservation-level payout breakdown, commission invoice and credits, refund confirmations, PMS folios and bank statement. Match reservation references, property, currency and payout reference; equal amounts alone are insufficient.
- Check the payout model. Booking.com’s explanation of gross and net payouts distinguishes commission included in a gross payout from commission withheld in a net payout. Do not deduct separately payable commission from the expected gross bank credit.
- Build one row per reservation and payout allocation. Record gross collected, refunds, withheld commission, other deductions, credits, expected payout, actual allocation and difference. Give every bank batch a unique reference to prevent duplicate matching.
Worked example: three bookings to one bank credit
Hypothetical example for a Galway hotel: A and B are October stays; C is cancelled before arrival. All three guest amounts were collected by Booking.com. Assume refunds are completed before settlement, commission is 15% of the remaining guest charge, and all commission adjustments appear in the same net payout. There are no other fees, tax withholdings, currency conversions or opening balances. These are teaching assumptions, not quoted Booking.com terms.
| Booking | Gross collected | Refund | Commission withheld | Net allocation |
|---|---|---|---|---|
| A | €600.00 | €0.00 | €90.00 | €510.00 |
| B | €900.00 | €200.00 | €105.00 | €595.00 |
| C | €400.00 | €400.00 | €0.00 | €0.00 |
| Total | €1,900.00 | €600.00 | €195.00 | €1,105.00 |
Bank check: €1,900.00 − €600.00 − €195.00 = €1,105.00. Match that expected total to the fictional bank credit of €1,105.00, reference GAL-1106. Difference: €0.00. A contributes €510.00, B €595.00 and C €0.00; each reservation is fully explained.
Gross means the guest amount including any applicable VAT, before refunds and commission. The table reconciles cash; it does not calculate VAT or VAT-exclusive revenue. Use the actual commission basis and charges shown in your agreement and statements.
A refund does not prove that commission has also been credited. Here the assumed original commission is €285.00, reduced by a documented €90.00 credit to €195.00. If that credit arrives later, show the €90.00 as an open item until it appears; do not invent a deduction or credit to force a match.
Explain timing differences without changing revenue
For this example, record the October service dates, refund confirmations dated 2 November and bank receipt dated 6 November separately. The November payout settles the balance owed to the hotel; it does not make every underlying sale November revenue. Agree revenue allocation, refund credit-note dates and VAT treatment with your accountant.
- Use an OTA clearing account, agreed with your accountant, to track amounts awaiting settlement. For this example: €0.00 opening + €1,900.00 collected − €600.00 refunds − €195.00 commission − €1,105.00 bank settlement = €0.00 closing.
- If the bank receives €1,095.00 instead, log a €10.00 difference with the payout reference, evidence, owner and review date. Only classify it as a fee when supporting documentation explains it.
- Keep unpaid or partly paid allocations open. Exclude extras collected directly by the hotel from the Booking.com payout calculation. Investigate duplicate refunds, missing credits and rounding separately.
Keep an accountant-ready evidence pack
Revenue requires detailed, current VAT records that allow individual transactions to be verified. Save the reconciliation with invoices, credit notes, refund confirmations, payout statements and bank references. Ask your accountant to confirm VAT treatment of commission and refunds, and the relevant retention periods and conditions for each record type, including unresolved claims or enquiries.
Use RoomRaccoon records in the reconciliation
RoomRaccoon’s integrated hotel payments page describes payment tracking, transaction matching and financial reporting. Its hotel property management system supports reservation and invoice management. Use those records alongside Booking.com statements and bank evidence. Confirm which reports, payment services and accounting connections your package includes; transaction matching alone does not establish that an entire Booking.com bank batch has been reconciled.
Bring a sample payout, a commission adjustment and a refund to a demo, and ask the team to show the available records and any manual reconciliation steps.
Book a demo for your propertyBooking.com reconciliation FAQs
Should the net payout be recorded as room revenue?
Do not use the net bank credit as the room-sales figure. Keep guest charges, refunds, commission costs and settlement separate. Your accountant should map the VAT-inclusive guest amounts to the correct revenue and tax accounts.
What if commission is invoiced and also deducted?
Match the deduction to the invoice as its settlement. Do not book the same cost twice or pay an already settled amount again. Reconcile any remaining invoice balance, including documented credits, before arranging payment.
What if a refund appears in the next payout?
Link it to the original reservation and refund confirmation, then carry the settlement adjustment into the next batch. Keep the original matched payout intact and track when the later deduction actually clears.
Does a virtual credit card belong in this bank-transfer batch?
Only include amounts documented in that batch. A virtual credit card needs a separate trail from the card charge through the payment processor’s settlement to the bank. An available card balance is not evidence of cash received.
Sources and checks
Sources checked on 13 November 2026. The worked figures are hypothetical; apply your property’s actual payment arrangements.
