Expedia Reconciliation for Hotels
Terrace AI helps hotel accounting teams match Expedia reservations, commission records, Hotel Collect activity, Expedia Collect payments, VCCs, cancellations, no-shows, and PMS data in one review workflow.
- less manual Expedia review
- 75%less manual Expedia review
- faster VCC reconciliation
- 4xfaster VCC reconciliation
- more disputes recovered
- 35%more disputes recovered
Hotel Collect, Expedia Collect, and VCCs reconciled in one place.
Terrace pulls Expedia remittance and commission statements, matches every booking to the PMS, validates VCC and commission amounts across both Hotel Collect and Expedia Collect, and posts the result to your accounting system.
- Hotel Collect and Expedia Collect both ingested natively
- VCC amounts reconciled against folio totals per stay
- Commission validation against your contracted rate
What is Expedia reconciliation?
Expedia reconciliation is the process of matching Expedia reservation data, commission statements, Hotel Collect and Expedia Collect payment records, VCC charges, cancellations, and no-shows against your PMS to confirm every booking settled correctly. It requires reconciling two distinct payment models: Hotel Collect, where your hotel processes payment and pays Expedia a commission, and Expedia Collect, where Expedia collects from the guest and remits to the hotel.
- Hotel Collect commissions verified against PMS revenue
- Expedia Collect remittance timing confirmed
- VCC amounts matched to folio totals
- Cancellation and no-show treatment reconciled
- Reservation IDs matched to PMS records
- Accounting postings reflect actual amounts received
Why Expedia reconciliation is difficult for hotel accounting teams
Hotel Collect and Expedia Collect follow different payment flows
Hotel Collect commissions and Expedia Collect remittances must be reconciled separately, requiring different matching logic and data sources for each booking model.
Expedia Collect remittance timing differs from PMS records
Remittance timing from Expedia often does not align with when the PMS or accounting system expects the payment, creating apparent mismatches that require manual investigation.
VCC payments add a separate reconciliation layer
Virtual credit cards must be matched against folio totals and bank settlements as a separate step, and mismatches occur frequently when folio amounts change after booking.
Cancellation and no-show status differ across systems
Expedia and the PMS can record cancellations and no-shows differently, leading to commission or payment discrepancies that are not immediately obvious.
Reservation IDs don't map directly to PMS confirmation numbers
Expedia assigns its own reservation IDs that require manual lookup to match against PMS confirmation numbers, slowing down reconciliation for high-volume properties.
Commission verification requires per-booking rate checks
Hotel Collect commission amounts must be checked against PMS room revenue and rate codes for each booking, and non-commissionable rates can slip through without automated validation.
What data needs to be matched for Expedia reconciliation?
- Reservation ID
- Commission rate
- Room revenue
- Remittance amount
- Payment date
- Reservation reference
- Confirmation number
- Stay dates
- Rate code
- VCC amount
- Authorization date
- Folio reference
- Cancellation status
- No-show treatment
- Fee applied
- Folio total
- Posted amount
- Account code
Common Expedia reconciliation exceptions
The Hotel Collect payment record and PMS commission posting differ in amount, timing, or reservation reference.
Expedia Collect remittance arrives in a different period than when the PMS or accounting system recorded the revenue.
The virtual card amount charged differs from the folio total due to a rate change, ancillary charge, or cancellation applied after booking.
Expedia records a cancellation or no-show differently than the PMS, resulting in a commission or payment discrepancy.
The commission amount on the Expedia statement does not match the expected commission based on PMS room revenue and the contracted rate.
An Expedia reservation ID on the statement cannot be matched to any record in the PMS.
How hotels manually reconcile Expedia records
- 1
Export Expedia Hotel Collect and Expedia Collect records separately and pull PMS data for the same period.
- 2
Map Expedia reservation IDs to PMS confirmation numbers for each booking model.
- 3
Verify Hotel Collect commission amounts against PMS room revenue.
- 4
Confirm Expedia Collect remittance amounts and timing against PMS and accounting postings.
- 5
Match VCC charge amounts against folio totals and bank deposit records.
- 6
Check cancellation and no-show status in both systems.
- 7
Flag any mismatches and research using Expedia Partner Central and PMS records.
- 8
Post corrections and file the audit trail.
Automated Expedia reconciliation with Terrace AI
Terrace AI handles both Hotel Collect and Expedia Collect reconciliation in a single workflow, automatically matching records and surfacing only the exceptions that need review.
HC + EC matching
Hotel Collect and Expedia Collect matching
Terrace handles both booking models in a single workflow, automatically matching records from each Expedia payment type.
Commission check
Commission verification for Hotel Collect
Each commission amount is checked against PMS room revenue and your contracted rate for that rate code.
Remittance check
Remittance verification for Expedia Collect
Expedia Collect remittance amounts and timing are verified against PMS records and accounting postings.
VCC matching
VCC matching against folio totals
Virtual card amounts are matched against folio totals and bank settlements and flagged when they differ.
Cancellations
Cancellation and no-show reconciliation
Terrace compares cancellation and no-show status across Expedia and the PMS and surfaces discrepancies automatically.
Exception queue
Dispute-ready exception queue
Flagged mismatches surface with supporting evidence attached and ready for submission to Expedia Partner Central.
| Source record | PMS record | Issue detected | Terrace status |
|---|---|---|---|
| EXP-HC-221340 — Checkout Apr 5 | CONF-90221 — Checkout Apr 5 | Hotel Collect payment $842 vs PMS posted $798 | Needs review |
| EXP-EC-198821 — Checkout Apr 8 | CONF-91004 — Checkout Apr 8 | Expedia Collect remittance timing differs by 3 days | Needs review |
| VCC-EXP-447120 — Apr 4 charge | Folio #5512 — Apr 4 | VCC $1,204 vs folio total $1,204 | Auto-matched |
| EXP-HC-204118 — No-show Apr 3 | CONF-88940 — No-show Apr 3 | No-show fee not posted in PMS | Dispute-ready |
| EXP-EC-231009 — Checkout Apr 12 | No match found | Expedia reservation ID not in PMS | Missing PMS match |
Put hotel revenue on autopilot
From OTA statement to GL posting — faster cash, accurate books, and less manual reconciliation.
Frequently asked questions
Expedia reconciliation is the process of matching Expedia reservation data, commission statements, Hotel Collect and Expedia Collect payment records, VCC charges, cancellations, and no-shows against your PMS to confirm every booking settled correctly.
Continue exploring AR reconciliation workflows
The parent workflow for all OTA reconciliation across channels.
Match Booking.com invoices, commissions, and VCC payments.
Tie merchant deposits and card settlements back to PMS records.
See the full Terrace AR platform for hotel accounting teams.