1. Separate the booking, cancellation outcome, guest refund, hotel payout, and Agoda compensation instead of treating them as one transaction.
2. Identify Agoda Collect or Property Collect before deciding who refunds the guest and where the financial adjustment should appear.
3. Match every cancellation to its booking ID, policy outcome, payment record, payout batch, and adjustment reference.
4. Do not close the period while a refund, fee waiver, charge attempt, or post-payout adjustment remains unexplained.
Agoda refund reconciliation starts after the cancellation decision has been recorded. The finance team is not deciding which policy should apply; it is proving that the reservation, guest refund, cancellation charge, channel compensation, and cash movement agree.
That makes this process different from a cancellation-policy review. Policy setup, fee-waiver rules, and cancellation prevention determine the commercial outcome. Reconciliation tests whether that outcome reached the hotel’s books and bank account correctly.
Define the Five Records You Are Matching
One cancelled booking can create several records on different dates. Keep the original reservation as the source document, then match the cancellation or amendment notice, payment-model record, Agoda finance transaction, and hotel accounting entry.
Do not overwrite the original room revenue with the refund amount. Preserve the booked value, cancelled value, fee retained or waived, channel charge, tax treatment, and cash movement as separate fields. This makes later disputes and audit sampling possible.
Use the Agoda booking ID as the common reference. Add the property ID, guest name, stay dates, booked currency, payment model, cancellation timestamp, policy outcome, payout ID, adjustment ID, and bank or card reference. Never copy full guest-card or virtual-card details into an ordinary spreadsheet.
Identify Who Controlled the Money
For Agoda Collect, Agoda collects from the guest and pays the property through its configured payout method. A cancellation can reduce or eliminate the payable amount. If payout was already confirmed, the corrected amount may return as an adjustment against a later payout rather than as a separate bank debit.
For Property Collect, the property normally collects the stay amount from the guest. Agoda compensation is commonly offset against amounts Agoda owes the property for prepaid bookings. A cancellation therefore requires two checks: what the hotel collected or refunded, and what Agoda charged or reversed through the offset process.
The current Agoda Property Collect explanation describes this offset mechanism and the booking-level statement available with completed payments. Use the property agreement and current Partner Portal record when a market or payment method differs.
Do not infer responsibility from the booking status alone. For a card-guaranteed Property Collect cancellation, viewing the guest card can change who is responsible for collecting a cancellation fee. Finance should retain the action history, not only the final status.
Smart Order’s hotel reporting software gives finance a booking-source and revenue record to compare with Agoda transactions. The Agoda statement remains the channel source document, while the PMS supplies the operational side of the match.
Reconcile Agoda Against the Booking Record
Compare channel revenue, reservation status, and hotel records before posting a cancellation adjustment or closing the period.
Reconcile One Agoda Cancellation Step by Step
Work at booking level before reviewing payout totals. A batch can balance while two individual reservations are posted incorrectly.
- Open the original reservation and record the Agoda booking ID, booked value, currency, taxes, payment model, cancellation terms, and payment method.
- Open the cancellation or amendment notice and confirm the effective timestamp, cancelled amount, fee outcome, and whether the cancellation is complete or partial.
- Check whether the property had already received, confirmed, or charged any Agoda payout for the booking.
- In Partner Portal, locate the booking under the relevant Finance area and capture its payable, paid, reversed, or adjusted amount.
- Match the transaction to its payout or remittance reference and then to the actual bank deposit, Agoda card charge, UPC charge, or Property Collect receipt.
- Post the accounting treatment approved for the property, keeping revenue, cancellation income, channel compensation, tax, refund, and receivable or payable movements distinct.
- Mark the item reconciled only when the difference is zero or supported by a named, dated adjustment that remains open.
If a cancellation occurs after payout, look for the correction in Adjustments. Agoda’s current payout workflow includes post-payout cancellations, outstanding balances, overcharges, and booking rejections as adjustment cases. A negative receivable can be offset by additional payable bookings rather than settled as a standalone positive payout.
Match the Refund to the Correct Accounting Period
The reservation date, cancellation date, original payout date, adjustment date, and bank value date may fall in different months. Choose the accounting period according to the hotel’s policy and local requirements, then retain a reconciliation bridge between operational and cash dates.
A month-end cutoff should identify cancellations recorded by Agoda but not yet reflected in a payout. It should also find refunds issued by the hotel that have no matching Property Collect liability change, and Agoda adjustments posted after the original stay period.
Avoid netting unrelated bookings in the PMS merely because Agoda offsets them in one payout. The bank receives a net amount, but finance still needs the booking-level composition: payable stays, cancelled stays, Property Collect compensation, and other adjustments.
For bank transfer, match the payout ID or batch reference to the remittance value date. For card-based settlement, match the exact authorized amount and transaction date. Differences caused by bank fees or currency conversion should remain separately identified.
Diagnose Common Agoda Reconciliation Differences
The payout is lower than the reservation report
Symptom: Agoda cash is below PMS Agoda revenue. Check: cancelled or amended bookings, Property Collect compensation, fee waivers, rejected bookings, prior overpayments, and payout timing. Action: rebuild the batch at booking level and assign every deduction to a source reference.
A refund appears after the booking was paid
Symptom: the original payout is correct, but a later batch is reduced. Check: whether the guest cancelled inside a refundable period after payout confirmation. Action: match the later adjustment to the original booking instead of reducing an unrelated stay’s revenue.
Property Collect commission does not match cash collected
Symptom: Agoda deducts compensation while the hotel shows no guest receipt. Check: cancellation status, no-show reporting, card-view history, fee collection responsibility, and whether the hotel waived the charge. Action: resolve the guest receivable and Agoda liability separately.
The same cancellation is posted twice
Symptom: both the PMS and bank reconciliation contain duplicate refund entries. Check: whether one record is the guest refund and the other is Agoda’s offset of a prior payout. Action: preserve both source transactions but reverse only the duplicate accounting entry.
Build the Month-End Agoda Control
Run three totals for the period: cancelled booking value, cancellation fees retained or receivable, and refunds or adjustments settled. Reconcile each total to both the PMS booking population and the Agoda finance population.
Age unresolved items by reason rather than placing everything in “OTA difference.” Useful categories include pending Agoda adjustment, pending guest refund, failed collection, fee waiver pending, currency difference, payout not due, disputed amount, and missing source document.
Require a second-person review for manual journal entries, cancellations with prior payouts, negative batches, and Property Collect card cases. The reviewer should be able to trace the entry from ledger to bank, payout, cancellation notice, and original reservation.
Retain evidence according to local tax, privacy, and recordkeeping requirements. Agoda statements support the channel side, but they do not replace the hotel’s invoice, tax, or guest-payment obligations.
Frequently Asked Questions
Is Agoda refund reconciliation the same as setting a cancellation policy?
No. Policy setup determines the guest and hotel’s commercial rights. Reconciliation verifies the resulting refund, fee, payout, compensation, and accounting records after a cancellation occurs.
Where do Agoda payout adjustments appear?
Current Partner Portal payout workflows show adjustments with payable bookings in the Finance area. Exact labels depend on payout method and account configuration.
What happens if an Agoda booking is cancelled after payout?
The corrected amount can appear as an adjustment in a future payout. Match that adjustment back to the original booking and payout instead of posting it as an unidentified current-period channel cost.
Why can a Property Collect cancellation create an Agoda deduction?
The property collects guest funds under Property Collect, while Agoda compensation can be offset against prepaid amounts owed to the property. The guest transaction and Agoda compensation therefore need separate reconciliation.
Can finance reconcile only from the bank deposit?
No. A net deposit can combine payable bookings and multiple adjustments. Finance needs booking-level statements and payout references to explain the total.
What evidence should support a reconciled cancellation?
Keep the reservation, cancellation or amendment notice, payment model, policy outcome, fee or waiver record, payout and adjustment references, cash evidence, and approved accounting entry.
An Agoda cancellation is reconciled when the operational outcome and every financial movement tell the same story. Preserve the original booking, separate refund from compensation, trace later adjustments, and close differences only with booking-level evidence.
