1. Match each Traveloka payout line to a reservation number and final stay status.
2. Separate guest revenue from commissions, discounts, refunds, taxes, and other adjustments.
3. Match the completed payout batch to the actual bank or card settlement.
4. Keep unexplained differences open instead of changing room revenue to force a balance.
Traveloka payout reconciliation is not a direct comparison between the guest's reservation total and the amount deposited into the hotel's bank account. The payout may reflect commissions, promotions, taxes, refunds, cancellations, previous adjustments, or timing differences.
The reliable method is to begin with one payout batch, match every included reservation, and then match the batch total to cash received. This lets finance explain the difference without hiding it inside room revenue.
TERA menus and document names may vary by market, property contract, payment arrangement, and user permission. Use the payment and reservation records available in the property's account, following the same control sequence below.
Start With One Payout or Bank Deposit
Choose one completed payout, card settlement, or bank deposit. Record its reference, currency, amount, expected payment date, actual bank date, and the property receiving the funds.
Do not begin with the entire month if the hotel receives several batches. A single payout gives finance a defined total and a limited group of reservations to investigate.
Open the corresponding Traveloka payment record in TERA and identify the reservations and adjustments included. Download or save the available statement using the hotel's normal finance process.
If the bank received one combined amount for several properties or currencies, split the reconciliation by the supporting payout references before matching individual stays.
Prepare the Final Reservation Records
For each reservation included in the payout, find the same booking in TERA and the PMS. Use the Traveloka booking number as the main reference, then confirm guest name, property, check-in and check-out dates, room type, final status, currency, and total stay value.
Use the latest version of the reservation. Date changes, shortened stays, room changes, cancellations, no-shows, or partial refunds can make the original confirmation different from the final payable amount.
The PMS record should show what the hotel recognized as room revenue and extras. The TERA record should show the current Traveloka reservation and payment status. The payout record should show what moved toward the hotel. These records serve different purposes and should not be forced into one figure.
Match Every Reservation to the Payout
Work through the payout one reservation at a time:
- Match the Traveloka booking number to the PMS reservation.
- Confirm the stay was completed, cancelled, amended, refunded, or marked as a no-show.
- Record the final reservation amount and the amount eligible for payment under the hotel's agreement.
- Record commission, promotion contribution, taxes, fees, refund, or adjustment separately when shown.
- Calculate the expected amount for that reservation and compare it with the payout line.
- Mark the reservation as matched or move the difference to an exception list.
- Add all matched reservation amounts and adjustments, then compare the result with the payout total.
Do not net several unexplained differences against each other. A missing $40 reservation and an unrelated $40 deduction do not become correct simply because the batch total happens to balance.
When reservation revenue and channel totals can be reviewed together, finance spends less time rebuilding the month from separate files. Smart Order's hotel reports and analysis helps managers compare channel revenue and reservation records before posting the Traveloka payout to the ledger.
Reconcile Traveloka Revenue From One Hotel Record
Compare reservation revenue and channel performance in one workflow, then investigate only the payout lines that do not match.
Explain the Difference Without Hiding It
Commission or channel charge
Record the reservation at the hotel's recognized revenue amount and record the Traveloka commission or channel charge separately according to the chart of accounts. Do not overwrite room revenue with the net bank amount.
Promotion or discount contribution
Confirm whether the hotel funded the discount, Traveloka funded it, or the cost was shared. The guest selling price alone does not show how much the hotel should receive.
Cancellation, no-show, or refund
Check the final status, cancellation terms, chargeable amount, and refund record. A reservation can remain in the history while contributing zero, a partial fee, or a later adjustment to the payout.
Tax or fee difference
Separate taxes and fees collected by the hotel from amounts handled under the Traveloka arrangement. Use the property's local accounting and tax policy rather than assuming every charge belongs in room revenue.
Currency or bank difference
Confirm the payout currency, bank currency, conversion rate, transfer charge, and value date. A bank deduction or exchange difference should not be recorded as a missing reservation.
Timing difference
A completed stay may belong to a later payout because of the payment schedule, a pending review, or the date the reservation became eligible. Keep it as an open receivable until its payout batch is identified.
Match the Payout to the Bank
After every payout line has been matched or listed as an exception, compare the payout total with the actual bank deposit or card settlement.
Confirm the property legal entity, bank account, currency, value date, and payment reference. If the bank amount is lower, look for bank fees or currency conversion before reopening completed reservation work.
Post the payout using the hotel's normal accounting policy. Keep gross room revenue, Traveloka-related costs, guest receivables, Traveloka receivables, refunds, and cash received in the appropriate accounts.
Attach the payout statement, reservation match file, bank evidence, and exception notes to the close. This creates a clear trail for the owner, accountant, and next month's reconciliation.
Resolve Exceptions in Priority Order
Start with reservations missing entirely from the payout, then investigate wrong amounts, duplicate lines, unexpected deductions, refunds, and timing differences.
For each exception, write one sentence showing expected and actual results. For example: “Traveloka booking X completed for amount Y, but it is not included in payout Z.” Add the booking record, final status, payout reference, and redacted bank evidence.
Do not send one support request containing several unrelated payout periods. Group issues only when they share the same cause or payout reference.
Escalate quickly when a large payout is missing, the wrong property received funds, the currency is incorrect, several completed stays are absent, or the same adjustment appears more than once.
Build a Repeatable Month-End Control
Assign one owner to download the Traveloka payout records, one deadline for PMS revenue to be final, and one exception list. Finance should not begin while front desk is still changing stay status or posting refunds without notice.
Use the Traveloka booking number in the PMS and accounting export whenever possible. Consistent references reduce manual searches and prevent two bookings with similar guest names from being matched incorrectly.
Review open exceptions from the previous month before closing the current one. A later adjustment may resolve an earlier difference, but it should be linked back to the original reservation rather than treated as current-month room revenue.
The reconciliation is complete when every payout line has a reservation or documented adjustment, the batch total matches the bank, and every remaining difference has an owner and next action.
Frequently Asked Questions
Why is the Traveloka payout lower than reservation revenue?
The payout may include commission, hotel-funded discounts, refunds, taxes, fees, earlier adjustments, or currency and bank differences. Match the individual reservations before deciding which explanation applies.
Should finance match payouts by booking date or checkout date?
Use the reservation and payout eligibility rules in the property's agreement, then keep the booking date, stay date, payout date, and bank date as separate fields. They may fall in different accounting periods.
What if a completed reservation is not in the payout?
Confirm its final status, payment arrangement, eligibility date, and whether it appears in another batch. Keep it as an open exception until Traveloka or the hotel's records explain where it belongs.
Can the hotel use the net payout as room revenue?
That can hide commission, discounts, refunds, and bank charges. Record revenue and deductions separately according to the hotel's accounting policy so channel profitability remains visible.
