1. Start with one confirmed reservation and its contractual payment method.
2. Separate the guest total, hotel revenue, commission, taxes, adjustments, settlement amount, and bank amount.
3. Match every settlement line to a reservation before posting the batch to the ledger.
4. Escalate only the exact difference that remains after timing, currency, and bank charges are isolated.
Trip.com settlement reconciliation fails when finance compares amounts that answer different questions. The guest total is not automatically the hotel receivable. The settlement total may contain several reservations, later adjustments, or a different currency. The bank deposit can differ again because of conversion and receiving charges.
Use a booking-to-bank trail. Begin with the reservation, calculate the expected commercial result under the property contract, match it to the settlement batch, and then clear the actual deposit.
Build a Booking-Level Reconciliation Record
Create one record for every Trip.com booking included in the review period. Capture the property ID, Trip.com booking number, guest name, booking and stay dates, room and rate plan, reservation status, payment method, guest-facing total, taxes and fees, hotel amount, commission basis, commission rate, currency, and any modification or cancellation.
Keep three dates separate: the booking date, the stay or checkout date, and the settlement or bank value date. A booking can belong to one operating month but settle in another. Posting it only by deposit date hides revenue timing and makes older adjustments look like current-period errors.
Use the final reservation version, but preserve the original version and every change. If nights, occupancy, rate, tax, cancellation status, or penalty changed after confirmation, finance needs the before-and-after amounts to explain the settlement line.
Confirm the Contract and Payment Method First
Do not infer the payment method from the rate plan name or from how another Trip.com booking was paid. Open the reservation and the settlement details available to the property, then confirm who collected the guest's money and how the property is due to receive funds.
The commission rate comes from the property's contract and can differ from another property or commercial arrangement. Trip.com's property partner information places the commission rate in the contract workflow and requires correct virtual-card or bank-transfer details for settlement. Treat the signed contract and the current booking record as the controls for the calculation.
If the reservation uses a virtual card, record the eligible charge amount, activation conditions, expiry, and currency without copying protected card data into a spreadsheet or support ticket. If the account settles by bank transfer, record the settlement ID, payable date, payment date, bank reference, and receiving account.
Reconcile One Reservation to One Settlement Line
Work in this order so each difference has a clear owner:
- Confirm the final reservation status and latest stay details in eBooking.
- Rebuild the accommodation amount from nights, rates, occupancy charges, and included items.
- Separate taxes and fees by who collects and remits them.
- Apply the contracted commission to the correct commissionable base, not automatically to the guest total.
- Add or subtract approved cancellation fees, refunds, amendments, incentives, or manual adjustments.
- Calculate the expected hotel receivable in the settlement currency.
- Match the booking number and expected receivable to the settlement line or virtual-card amount.
- Match the settlement batch to the bank or card-processor transaction.
- Post any bank fee or currency difference separately from room revenue and channel commission.
The control equation is:
Expected hotel receivable = commissionable accommodation amount minus commission, plus or minus booking adjustments, plus property-payable taxes or fees
The exact fields vary by contract, market, and payment method. The important control is that each component has a source and is not hidden inside one unexplained net figure.
Smart Order's hotel reporting software keeps reservation revenue, room nights, channel source, and operating metrics visible while finance clears Trip.com settlements separately.
Keep Trip.com Revenue Traceable Before Settlement
Review reservation revenue and channel performance from one hotel reporting workflow, then match the financial settlement without changing the original booking value.
Calculate Commission Without Using the Wrong Base
A common error is multiplying the displayed guest total by the commission percentage. First determine whether taxes, service charges, meals, extra-person charges, property-collected fees, or platform-funded benefits belong in the commissionable base.
For example, a guest may see a total of 540 while the commissionable accommodation amount is 500. At a hypothetical 15% contracted rate, commission on 500 is 75, not 81. This is an illustration only; use the base and rate attached to the property's actual contract and reservation.
Keep commission expense separate from net cash. If the hotel records only the deposit as revenue, ADR and channel production become understated. A cleaner ledger records gross room revenue according to the hotel's accounting policy, commission as an expense or contra-revenue account, the Trip.com receivable, applicable tax liabilities, and the later cash clearing entry.
Do not overwrite the PMS room charge merely to make it equal the settlement. Correct a PMS amount only when the reservation itself is wrong and the approved booking amendment supports the change.
Diagnose the Remaining Difference
The reservation total is higher than the settlement line. Check the commissionable base, commission, property-collected taxes or fees, platform-funded benefits, and whether part of the amount is paid directly at the property. Then verify that the reservation has not been partially refunded or shortened.
The settlement line is lower than expected after a modification. Compare the modification timestamp with the batch cut-off. The original amount may have entered one batch and the correction another. Search later and earlier settlement periods before raising a missing-payment case.
The bank deposit is lower than the settlement batch. Match currency, exchange rate, transfer charges, intermediary-bank deductions, card-processor fees, value date, and whether the bank split one payment. Do not assign a bank charge to Trip.com commission.
The bank deposit is higher than one booking. Search the settlement ID for additional reservations and adjustments. Batch cash should be reconciled to the complete batch, not to the largest reservation in it.
A cancelled or no-show booking still has commission. Confirm whether a fee was charged and whether the contract makes that collected fee commissionable. A free cancellation, charged cancellation, waived fee, and no-show are different financial events.
The same booking appears twice. Compare reservation number, settlement ID, adjustment type, sign, and date. One line may be the original payable amount and the second its reversal or correction. Do not book both as revenue.
Control Currency and Settlement Timing
Maintain separate fields for booking currency, settlement currency, and bank-account currency. Store the source amount, applied exchange rate when available, converted amount, and bank amount. Without those fields, every currency movement becomes an apparent commission error.
Do not mark a settlement late using the checkout date alone. Compare the property's contract, payout method, batch cut-off, payable status, payment status, and bank value date. Weekends, bank processing, an incomplete payout profile, or a failed transfer can delay cash after the booking becomes eligible.
Use a settlement clearing account. Post booking-level receivables against the settlement ID, then clear the ID when the bank transaction arrives. Any balance left in the clearing account points to a specific booking, adjustment, fee, or currency difference.
Close the Batch and Prevent Repeat Errors
Before closing a Trip.com settlement period, confirm that every settlement line has one booking or adjustment reference, every reservation has one final status, commission uses the approved base and rate, taxes are posted to the correct party, and the settlement ID clears to the bank transaction.
Retain the reservation export, settlement report, contract version, adjustment evidence, bank reference, reconciliation worksheet, and reviewer sign-off for the hotel's normal accounting retention period. Limit access to payment details and redact protected information before escalation.
If a difference remains, send Trip.com Lodging Support the property ID, booking number, settlement ID, currencies, expected calculation, actual line, batch date, bank reference, and exact unresolved amount. Ask one precise question, such as which adjustment changed the payable accommodation amount, instead of requesting an explanation of the entire statement.
A connected hotel PMS reduces rekeying by keeping the source reservation and channel reference together. Finance should still complete an independent settlement-to-bank control.
Reconcile Channels Without Rebuilding Every Booking
Keep OTA references, stay values, and hotel reporting connected so finance can isolate settlement differences at booking level.
Frequently Asked Questions
Why does a Trip.com settlement not equal the reservation total?
The reservation total can include commissionable and non-commissionable items, taxes, fees, or amounts collected by different parties. The settlement may also include adjustments or several bookings.
Where should the reconciliation begin?
Begin with the final reservation and payment method, calculate the expected hotel receivable under the contract, and then match that result to the settlement line and bank deposit.
Should commission be calculated on the guest total?
Only if the contract defines that entire amount as commissionable. Use the documented accommodation base and separate taxes, property-collected fees, and funded benefits.
Can one bank deposit contain several Trip.com bookings?
Yes. Reconcile the deposit to its complete settlement ID or batch and then allocate each booking and adjustment within that batch.
Should the PMS revenue be changed to match the deposit?
No. Keep revenue, commission, tax, receivable, currency difference, bank fees, and cash settlement separate unless an approved reservation amendment changes the underlying stay value.
Trip.com settlement reconciliation is complete only when the final reservation, contractual commission, settlement line, payout batch, and bank entry form one traceable chain. That chain protects both cash control and channel profitability reporting.
