How Hotels Should Reconcile Rakuten Travel Reservations and Settlement Records

Rakuten Travel settlement reconciliation is the process of proving how individual reservations became the amount recorded by the hotel. The settlement total is the ending point, not the starting explanation.

A difference does not always mean money is missing. A reservation may belong to another stay period, the guest may pay at the property, a cancellation fee may replace room revenue, or points, coupons, channel charges, taxes, refunds, and later adjustments may appear on different records.

This workflow is for hotel owners and finance managers. It focuses on practical reservation evidence and accounting decisions, not on the general cost of joining Rakuten Travel.

Start With the Hotel's Signed Commercial Rules

Before reconciling a period, keep the property's current contract, fee schedule, payment terms, tax treatment, point and coupon funding rules, cancellation handling, and settlement calendar together. Do not use a commission percentage copied from another hotel.

Write down which bookings are paid at the property and which amounts may be handled through a channel payment or settlement route available to the account. Record how cancellations, no-shows, refunds, guest points, coupons, campaign contributions, and disputed stays should appear.

Confirm the currency and date basis used by each record. The hotel may report revenue by stay date while a channel statement groups activity by booking, checkout, payment, or processing date. A timing difference should be carried forward, not forced into the wrong month.

Assign one finance owner and one operations contact. Finance can match money and fees; operations can explain stay status, guest changes, no-shows, and manual adjustments.

Gather the Four Records for the Same Period

Use four evidence sets: Rakuten reservation records, the applicable settlement or billing record, PMS stay and folio records, and the hotel's bank or payment record. Keep the original files unchanged and perform the reconciliation in a controlled working copy.

For each reservation, capture the Rakuten reservation number, guest, booking date, stay dates, room and plan, status, room amount, taxes, cancellation fee, payment method, points, coupon, promotion, channel charges, adjustments, and expected amount due to or from the hotel.

From the PMS, capture the source reservation number, checked-in or cancelled status, posted room revenue, taxes, guest payments, refunds, and any manual correction. From the bank record, capture the received or paid amount, value date, reference, currency, and transfer cost where applicable.

Use the Rakuten reservation number as the main matching key. Guest names can change, contain different characters, or repeat, so they should support a match rather than control it.

Separate Payment Paths Before Matching Totals

Do not combine every Rakuten booking into one expected payout. First separate reservations by who collected the guest's money and what the hotel should expect to receive or pay.

A pay-at-property reservation normally creates guest receivable and hotel-collected cash or card revenue. It may still create channel fees, point funding, or other charges. A channel-handled payment may create a net amount due to the hotel after permitted deductions. A cancelled or no-show reservation may create no room revenue, a cancellation fee, a refund, or a later adjustment.

Label each reservation with one expected accounting outcome before comparing it with settlement. This prevents finance from treating a hotel-collected booking as a missing channel payment or recording the same revenue twice.

When payment responsibility is unclear, return to the individual reservation and contract. Do not infer it from the bank total or from how another OTA works.

Smart Order can connect reservation source, stay status, room revenue, and hotel reporting in one review process. Finance can investigate an exception while operations confirms whether the guest stayed, cancelled, or changed the booking.

Match Every Reservation to Its Financial Result

Work reservation by reservation. Do not mark a batch as correct simply because several differences happen to cancel each other.

1. Match the Rakuten reservation number to one PMS record.
2. Confirm whether the guest stayed, cancelled, changed dates, or did not arrive.
3. Compare the booked room amount, taxes, meals, and benefits with the PMS folio.
4. Identify who collected payment and what amount the hotel should receive, retain, refund, or pay.
5. Match points, coupons, promotions, channel charges, cancellation fees, refunds, and adjustments to the applicable rule.
6. Link the resulting net amount to the settlement, invoice, bank entry, or open item.

Preserve the original booked price. A later public rate does not change the reservation's financial basis. If staff manually changed the PMS total, require a reason and approval so finance can distinguish a valid correction from lost revenue.

Reconcile Points, Coupons, and Promotions Separately

Guest incentives can affect either the amount paid by the guest, the hotel's acquisition cost, the channel settlement, or more than one record. Treat each component separately instead of recording one unexplained discount.

For points, confirm whether the guest redeemed points, earned extra hotel-funded points, or both. For coupons, identify whether Rakuten, the hotel, or a shared campaign funded the reduction. For a promotional accommodation plan, compare the actual booked plan price with the approved base and promotion rules.

Record the gross room value, guest-facing reduction, hotel-funded portion, channel-funded portion, and final hotel net in distinct fields. This protects management reporting: a funded marketing cost should not silently appear as a lower room rate if the hotel's accounting policy treats it separately.

If the statement description is unclear, flag the reservation rather than assigning the difference to commission. The same-size deduction can represent a point cost, coupon contribution, correction, tax, or payment adjustment.

Handle Cancellations, No-Shows, and Changes by Timeline

Build a short timeline for every exception: original booking, modification, cancellation or no-show, fee decision, guest charge or refund, channel adjustment, and accounting entry.

A cancellation may occur in one month while its fee or refund appears in another. A shortened stay can change room revenue without changing the reservation number. A no-show can carry a fee but no occupied room night. Keep the commercial status and the accounting status separate until both are complete.

Compare the final Rakuten record with the PMS. If one says cancelled and the other says stayed, do not solve the difference by changing the revenue total. Confirm what happened operationally, who approved any fee waiver, and which record must be corrected.

Carry valid timing differences into the next reconciliation with the reservation number, expected amount, reason, owner, and follow-up date. Never hide them inside a general “other” balance.

Investigate Differences in a Fixed Order

When the net amount does not match, check the simplest causes first: wrong period, wrong property, duplicate or missing reservation, changed stay dates, payment path, cancellation status, points, coupon funding, promotion cost, taxes, channel charges, refunds, and manual PMS entries.

For each difference, state the amount and its direction. “Short by JPY 8,000” is more useful than “settlement wrong.” Attach the reservation record, PMS folio, relevant settlement line, bank reference, and any approval for a manual adjustment.

Do not overwrite a PMS folio merely to make it match the statement. Correct the system that contains the wrong business event. If both records are correct but use different timing, keep an open reconciling item.

Escalate material or repeated differences using one evidence pack. Include property, period, reservation number, expected calculation, reported calculation, contract rule used, and the exact answer finance needs.

Close the Period With Management Controls

The reconciliation is complete when every Rakuten reservation in scope is matched, explained, or carried forward as an owned open item. The total of matched items, valid timing differences, and unresolved exceptions must bridge to the accounting and bank records.

Have a second person review manual write-offs, fee waivers, duplicate reservations, large refunds, currency differences, and promotional deductions below the approved margin. Lock or archive the working file according to the hotel's finance policy.

Give management a short summary: gross stayed revenue, cancellations and no-shows, hotel-collected amount, channel-handled amount, points and coupon cost, promotion cost, channel charges, refunds, net cash movement, open differences, and recurring causes.

Use recurring differences to improve operations. Missing reservation numbers, incomplete payment notes, unrecorded cancellations, and unclear promotion funding should become front-desk or channel-control fixes before the next close.

Frequently Asked Questions

Should every Rakuten reservation appear in a payout?

No. The expected financial record depends on who collected payment, the stay status, the commercial terms, and the period used by the settlement.

Can finance reconcile only from the settlement total?

No. The total can hide offsetting errors. Match each reservation and deduction before accepting the batch.

How should points and coupons be recorded?

Separate the guest discount from the hotel-funded and channel-funded portions, then follow the property's accounting policy and signed commercial rules.

What should happen to a timing difference?

Carry it forward with the reservation number, amount, reason, owner, and expected clearing period. Do not force it into the wrong month.