Hotel Payment Reconciliation Sri Lanka: Cards, QR, Cash, and Transfers

Hotel payment reconciliation in Sri Lanka should answer one question every day: can every folio receipt be traced through its channel to cash or bank, including fees, refunds, and timing differences? If not, occupancy and revenue reports can look healthy while cash remains uncertain.

For a collections layer, see Capricon Pay. Tour operators and DMCs that need the same discipline across traveller and supplier payments can start at the tour operator software Sri Lanka guide.

Reconcile by tender, not one daily total

• Cash: cashier opening float, receipts, paid-outs, refunds, drops, and closing count.
• Cards: terminal batch, tips or extras where applicable, fees, reversals, chargebacks, and bank settlement.
• QR: merchant transaction references, settlement batch, fees, failures, and reversals.
• Bank transfers: payer reference, value date, booking match, agent or company account, and over/underpayment.
• Online links or portals: request ID, gateway transaction, booking reference, settlement, and refund state.

Use clearing accounts for timing differences

A card or QR payment may settle after checkout and may arrive net of fees. Posting directly from the folio to bank can hide timing and fee differences. A documented clearing-account workflow lets finance match the guest receipt first, then clear it when the provider settles.

Hotel reconciliation control checklist

1. Define one tender code for each channel and provider.
2. Require booking or folio reference on payment requests and transfers.
3. Close cashier shifts with named approval and cash count.
4. Import or record provider transaction references without manual retyping where practical.
5. Match gross, fee, refund, and net settlement separately.
6. Assign an owner and ageing status to every unmatched item.
7. Lock reconciled periods and audit later changes.

Handle split payments, agents, and multiple currencies

Sri Lankan hotels may receive a deposit from an overseas agent, a card balance from the guest, and cash for extras. Keep each receipt as a separate allocation to the same folio. Record transaction and accounting currency, rate source, and realised difference according to the hotel's approved finance policy.

Exceptions management should be a daily queue

• Unidentified bank receipt.
• Folio tender does not match provider channel.
• Cash shortage or overage beyond approved tolerance.
• Card or QR settlement missing after expected provider timing.
• Refund approved but not completed or posted.
• Duplicate receipt or duplicate folio allocation.
• Agent credit used without approval.

Build one traceable payment chain

Use Capricon Pay to centralise payment requests and collection visibility, then connect booking references and settlement outcomes to the finance system. For operators coordinating complete itineraries, pair the process with Capricon Voyage through the tour operator software hub. Contact Capricon to map one property's exception flow.