Introducing Terrace Accounts Receivable: Stop profit leakage in your hotel — Read more →
terrace
OTA Reconciliation

Booking.com Reconciliation for Hotels

Terrace AI helps hotel accounting teams match Booking.com invoices, commission statements, payments, cancellations, no-shows, and reservation data against PMS records so they can catch mismatches and close faster.

less time on Booking.com matching
80%less time on Booking.com matching
faster invoice review
5xfaster invoice review
more commission recovered
40%more commission recovered
The unified Booking.com workflow

One reconciliation platform for every Booking.com payout.

Terrace ingests Booking.com invoices and remittance statements, matches every reservation to the PMS, validates commission and VCC amounts, and posts clean records — replacing the channel-by-channel spreadsheets your team runs today.

  • Direct Booking.com invoice and statement ingestion
  • Reservation ID matching against Opera, Mews, Cloudbeds, and 30+ PMS
  • Dispute-ready exceptions with statement + PMS evidence attached
Terrace Booking.com reconciliation overview dashboard

What is Booking.com reconciliation?

Booking.com reconciliation is the process of matching Booking.com invoices, commission statements, and payment records against your PMS data to confirm that every reservation settled correctly. For hotel accounting teams, this means verifying commission rates, cancellation handling, no-show charges, VCC payments, and that every Booking.com reservation ID maps to the correct PMS record.

What teams check
  • Every reservation ID matched to PMS confirmation
  • Commission rate and amount verified
  • Cancellation and waived fees confirmed
  • No-show treatment matches PMS records
  • VCC amounts match folio totals
  • Accounting postings reflect actual receipt

Why Booking.com reconciliation is painful for hotel accounting teams

Reservation IDs don't map to PMS records

Booking.com uses its own reservation IDs that don't directly correspond to PMS confirmation numbers, making automated matching difficult.

Commission rates vary by rate plan

Different rate plans carry different commission percentages. Discrepancies between the invoice and PMS records are common without per-booking verification.

Cancellation handling differs between systems

Cancellations and no-shows are processed according to Booking.com policy, which may differ from how the PMS recorded the same event.

VCC adds a separate reconciliation layer

Virtual credit card payments must be reconciled against folio totals and bank settlements as a separate step from commission reconciliation.

Volume grows with every property added

Manual spreadsheet work scales with the number of Booking.com bookings. High-volume properties can't sustain line-by-line review.

Dispute documentation is slow to assemble

Disputes require evidence from Booking.com extranet and PMS records that must be assembled manually from multiple systems.

What data needs to be matched for Booking.com reconciliation?

Booking.com invoices
Monthly statement
  • Reservation ID
  • Gross booking
  • Commission amount
PMS reservation records
Opera, Mews, Cloudbeds, etc.
  • Confirmation number
  • Stay dates
  • Rate plan
VCC payment records
Booking.com VCC
  • VCC amount
  • Charge date
  • Folio reference
Folio and room revenue
Per-stay billing
  • Room revenue
  • Tax and fees
  • Folio total
Cancellation records
PMS and Booking.com
  • Cancellation status
  • Waived or charged fee
  • Policy applied
Accounting postings
GL ledger
  • Posted amount
  • Account code
  • Period

Common Booking.com reconciliation exceptions

Commission rate mismatch

Booking.com applies a commission rate that differs from your contracted rate for that rate plan or property.

Cancelled reservation still on invoice

A reservation cancelled in the PMS still appears on the Booking.com invoice with a commission charge.

No-show treatment differs

Booking.com records a no-show charge that the PMS did not post, or the PMS posted a charge that Booking.com did not.

VCC amount does not match folio

The virtual card amount charged differs from the folio total due to a room rate change, ancillary, or cancellation.

Room revenue changed after booking

A rate modification or upgrade occurred after the booking was made, creating a revenue difference between systems.

Reservation ID not in PMS

A Booking.com reservation ID on the invoice cannot be matched to any record in the PMS.

How hotels manually reconcile Booking.com invoices

  1. 1

    Download the Booking.com invoice for the period and export PMS reservation data for the same dates.

  2. 2

    Map Booking.com reservation IDs to PMS confirmation numbers in a spreadsheet.

  3. 3

    Compare commission rates and amounts line by line against PMS room revenue.

  4. 4

    Check cancellation status and no-show treatment in both systems.

  5. 5

    Verify VCC amounts against folio totals and bank deposits.

  6. 6

    Flag mismatches and research each one using the Booking.com extranet and PMS records.

  7. 7

    Prepare dispute documentation for any items that need to be challenged.

  8. 8

    Post corrections to the accounting system and file the audit trail.

Automated Booking.com reconciliation with Terrace AI

Terrace AI connects to your PMS and pulls Booking.com invoice data automatically, replacing the manual spreadsheet process with a live exception queue.

ID matching

Reservation ID matching

Terrace automatically matches Booking.com reservation IDs to PMS confirmation numbers across formats.

Booking.com extranet ↔ PMS
Reservation ID linkage
4 rows
B.BKG-441820CONF-78821
Matched
B.BKG-512230CONF-81100
Matched
B.BKG-477004CONF-83902
Confidence 86%
B.BKG-398012
Unmatched
3 matched · 1 needs reviewView all 142 →

Commission check

Commission rate and amount check

Each invoice line is verified against your contracted commission rate and PMS room revenue.

BKG-441820 · Checkout Mar 15
Commission rate verification
Underpaid
Room revenue
$1,410.00
Rate plan
BAR · Standard
Contracted rate
15.0%
Booking.com applied
18.0%
Commission calc
Expected: $1,410 × 15.0%$211.50
Charged: $1,410 × 18.0%$253.80
Overcharge+$42.30
Recoverable via disputeOpen dispute →

Cancellations

Cancellation and no-show reconciliation

Terrace compares cancellation status and no-show treatment across Booking.com and the PMS.

BKG-398012 · Stay Feb 28
Cancellation status reconciliation
Mismatch
Booking.com
Charge applied
Cancellation policy fee: $148.00
Cancelled Feb 27, 22:14
PMS · Opera
Fee waived
Waived by mgr · code MGR-WAIVE
Cancelled Feb 28, 08:02
Status disagree — dispute eligible
PMS shows waived fee; Booking.com applied policy charge. Recoverable: $148.00
2 of 11 cancellations mismatchDispute →

VCC matching

VCC matching

Virtual card amounts are matched against folio totals and bank settlements and flagged when they differ.

Booking.com VCC · Mar 14
VCC ↔ folio total
VCC-338821
VCC charged
$618.00
Mar 14 · auth ok
Folio total
$589.00
Folio #4481 · 2 nights
VCC over by $29.00
  • • Original folio: $618 (pre-arrival rate)
  • • Rate adjusted at check-in: −$29
Suggested action: Refund $29 via Booking.com extranet

Exception queue

Dispute-ready exception queue

Flagged mismatches surface with supporting evidence attached and ready for submission to Booking.com.

Dispute queue · evidence attached
Ready for Booking.com submission
3 open
BKG-441820
Commission rate overcharge
$42.303d to dispute
Statement linePMS folioContract
BKG-398012
Cancellation fee disputed
$148.009d to dispute
Cancellation logPMS notes
BKG-477004
Reservation not in PMS
$284.0014d to dispute
Statement linePMS search
$474.30 recoverableSubmit all →

Audit trail

Audit trail maintained

Every matched and resolved record is stored with the evidence used to close it.

Audit trail · last 7 days
Reconciliation event log
142 events
Apr 9 · 09:14
BKG-441820 dispute filed
User: a.thomson · evidence v2
Apr 8 · 16:42
BKG-512230 auto-matched
Confidence 100% · folio #2291
Apr 8 · 11:08
BKG-398012 cancellation flagged
Mismatch with PMS · waived
Apr 7 · 14:33
BKG-477004 closed
Manual resolution · note saved
Immutable log · exportableDownload CSV →
Exception review queue
Sample data — illustrative only
Records reviewed
5
Auto-matched
1
Exceptions surfaced
4
Source recordPMS recordIssue detectedTerrace status
BKG-441820 — Checkout Mar 15CONF-78821 — Checkout Mar 15Commission 18% vs PMS rate 15%Needs review
BKG-398012 — Cancelled Feb 28CONF-65400 — Cancelled Feb 27Cancellation on invoice; PMS shows waived feeDispute-ready
BKG-512230 — Checkout Mar 22CONF-81100 — Checkout Mar 22Room revenue and commission matchAuto-matched
VCC-338821 — Mar 14 paymentFolio #4481 — Mar 14VCC amount $618 vs folio total $589Check payment
BKG-477004 — Checkout Mar 30No match foundReservation ID not in PMSMissing PMS match
Get started

Put hotel revenue on autopilot

From OTA statement to GL posting — faster cash, accurate books, and less manual reconciliation.

Frequently asked questions

Booking.com reconciliation is the process of matching Booking.com invoices, commission statements, and payment records against your PMS data to confirm that every reservation settled correctly and that your accounting records reflect the actual amounts.