OTA Reconciliation for Hotels and Villas: Booking to Ledger

Posted October 22, 2026

Main topic: The complete OTA reconciliation workflow from reservations to settlements, bank receipts and the general ledger.

Complete foundation: Hotel and Villa Accounting: A Hospitality Finance Systems Guide.

Continue as needed: Gross vs Net OTA: Understanding Bookings, Fees and Net Settlements, Hotel OTA Refunds: Matching Bookings, Settlements and Bank Records, Bali Airbnb Villa Tax: Reconciling Gross Bookings, Commissions and Net Settlements (Indonesian).

Assistance is available through hospitality bookkeeping and accounting services.

OTA revenue should not be reconciled solely by comparing the platform dashboard with bank movements. For a hotel or villa, finance needs to trace a transaction from the reservation and booking value through commission or fees, refunds or adjustments, settlement and bank receipt to the general ledger entry.

The purpose of OTA reconciliation for hotels and villas is to ensure every difference has an explanation and evidence. Figures across systems do not always have to be identical because they may record different transaction stages, but the differences must be traceable.

OTA Reconciliation for Hotels and Villas: What Should Be Matched?

Start by identifying the property’s available data sources. In hospitality, source files may come from the PMS or reservation system, OTA dashboard, settlement statements, payment gateway, bank accounts and accounting software.

Separate bookings, gross amounts, fees and payouts

Do not use one column called OTA revenue for the entire workflow. At minimum, separate:

Reservation or booking ID.
Booking date.
Check-in and check-out dates.
Reservation status.
Transaction value or gross booking according to the source used.
Commission or platform fee.
Refund, cancellation or adjustment.
Payout or settlement.
Settlement date.
Amount received in the bank.
Payment reference number.
Journal or accounting document number.

This separation matters because the booking value and money received in the bank can differ. The Usman Tax article on OTA commission tax for hotels and villas also explains why gross bookings, fees, refunds and net settlements should be distinguished before further analysis.

Choose the transaction IDs used for matching

Reconciliation is difficult when each system uses a different reference. Map reservation IDs, OTA booking IDs, payout references, bank references and journal numbers.

If one payout contains multiple reservations, do not force a one-booking-to-one-bank-transaction match. Create a settlement batch linking several bookings to one payout, then demonstrate that its total components agree with the settlement received after allowing for actual deductions or adjustments.

The Monthly OTA Reconciliation Workflow

A consistent workflow matters more than a complex spreadsheet. Follow the same sequence each period so differences can be compared from month to month.

Stage 1: Lock the period and obtain source data

Define the reconciliation cut-off, for example all transactions included in the month-end close. Then export or retain a snapshot of the source data to be used.

Working documents may include:

PMS reservation reports.
OTA transaction or payout reports.
Commission statements or invoices, where available.
Payment gateway reports, if used.
Bank account movements.
The relevant period’s trial balance or general ledger.

Do not keep replacing source files during the process without version control. If a platform updates a transaction status after the first export, retain the new version and record why it changed.

Stage 2: Match bookings to settlements and bank receipts

Match in stages:

Match PMS reservations to OTA transactions.
Match OTA transactions to settlements or payouts.
Match payouts to bank receipts.
Match the reconciliation results to the relevant accounting accounts.
Flag transactions that remain unmatched.

The aim is to understand the economic flow rather than merely find equal amounts. A reservation may involve price changes, refunds, cancellations, no-shows or adjustments that make its final amount different from its initial value.

Stage 3: Categorise differences and unmatched items

Do not combine every difference under other. Use categories that assist investigation, such as:

Timing differences.
Payouts not yet received.
Unposted refunds.
Cancellations or no-shows.
Commission or fees differing from the documents.
Bank fees or payment fees.
Duplicate postings.
Missing bookings.
Incorrect periods.
Incorrect properties or units.
OTA adjustments.
Incomplete data.

These categories are internal control recommendations, not official classifications prescribed by an OTA or regulator.

Use an exception log for unresolved items

Each unmatched item should enter an exception log containing:

Booking or settlement reference.
Difference amount.
Issue category.
Date identified.
Person responsible.
Documents still needed.
Target resolution date.
Status.
Aging.

The exception log helps owners distinguish temporary differences from recurring problems. If the same issue keeps appearing, the cause may lie in procedures, account mapping, system integration or communication with the platform.

Example OTA Reconciliation Working Paper

The working paper should separate booking values, OTA commissions, refunds or adjustments, expected settlements and bank receipts. This structure lets finance identify causes without repeatedly reopening settlement statements.

Booking ID	Gross Booking	OTA Commission	Refund / Adjustment	Expected Settlement	Actual Bank	Difference	Status
OTA-001	IDR 5,000,000	IDR 750,000	IDR 0	IDR 4,250,000	IDR 4,250,000	IDR 0	Matched
OTA-002	IDR 3,000,000	IDR 450,000	IDR 0	IDR 2,550,000	IDR 0	IDR 2,550,000	Not yet settled
OTA-003	IDR 4,000,000	IDR 600,000	IDR 500,000	IDR 2,900,000	IDR 2,900,000	IDR 0	Matched

In simple terms:

Expected Settlement = Gross Booking − OTA Commission − Refunds/Adjustments that reduce the payout

For OTA-003:

IDR 4,000,000 − IDR 600,000 − IDR 500,000 = IDR 2,900,000

The Difference column compares expected settlement with funds actually received:

Difference = Expected Settlement − Actual Bank

Statuses can be more informative, such as Matched, Not Yet Settled, Partial Settlement, Refund Pending or Requires Investigation.

For higher-volume properties, add columns for OTA/Channel, Guest Name, Check-out Date, Settlement Date, Payout Reference, Bank Reference, GL Account, Journal Number, Person Responsible and Notes. This makes every transaction traceable from reservation to general ledger without an unexplained gap.

From OTA Reconciliation to the General Ledger

Accounting entries should be based on transactions supported by documents and clear mapping. Do not make the bank account the sole source of truth for revenue.

The Usman Tax Bali accounting services page explains that hospitality businesses have multiple revenue and cost sources, including OTA commissions, requiring structured records so financial statements can support business evaluation.

Do not post differences to an expense account without investigation

A reconciliation difference is not automatically an expense. Establish its cause before preparing an adjustment entry.

For example:

A payout has not arrived because of timing.
The OTA issued a refund.
A transaction was recorded twice.
Commission has not been posted.
A booking was assigned to the wrong property.
A settlement uses a different period.
A payment gateway withheld or deducted certain charges.

Prepare a correction entry once the cause is sufficiently clear and supported by documents. This prevents miscellaneous expenses from accumulating reconciliation problems that remain unresolved.

How OTA Reconciliation Relates to Hotel and Villa Tax

OTA reconciliation is not a tax form. Its role is to produce traceable data before figures are used in tax working papers, management reports or financial statements.

PBJT follows regency or city administration

The current local tax administration framework includes Government Regulation 35 of 2023, listed as in force on the Ministry of Finance JDIH. For implementation, apply the local government’s rules where the business is located.

For example, Badung Regency’s revenue agency provides SPTPD reporting through E-Palapa and a sample sales recap. Denpasar City’s revenue agency has its own PBJT reporting and payment provisions for its jurisdiction.

The practical implication is that net OTA settlements should not be copied directly into local tax reports merely because they equal cash received. Use reconciliation to connect operational transactions to tax working papers, then apply the relevant regency or city rules.

Analyse tax on OTA commissions separately

Revenue reconciliation and the tax treatment of OTA fees are different tasks. Once a commission or fee has been identified and documented, finance can assess its tax treatment according to the recipient and actual transaction.

For that discussion, use the dedicated OTA commission tax in Bali article so this reconciliation guide remains focused on data controls and accounting.

Red Flags Requiring Investigation

Owners or finance teams should increase their review when they find:

Large or steadily growing unmatched amounts.
Payouts repeatedly differing from settlement statements.
Many bookings without traceable references.
Refunds recorded in a different period without working papers.
Duplicate transactions in the PMS or accounting records.
Commission differences without explanatory documents.
Growing suspense or miscellaneous accounts.
Settlements received without supporting reservations.
Bookings recorded but never included in settlement.
Unexplained differences between owner, accounting and tax reports.

A red flag does not prove a tax error or loss of funds. It identifies items requiring further investigation.

Month-End OTA Checklist

Before closing the period, check:

☐ The reservation report is locked for the relevant period.
☐ All OTA statements or payout reports have been collected.
☐ Booking IDs have been mapped to settlement references.
☐ Gross amounts, fees, refunds and adjustments are separated.
☐ Settlements have been matched to bank receipts.
☐ Unmatched items are in the exception log.
☐ Duplicate postings have been checked.
☐ Correction entries are made only after establishing the cause.
☐ The general ledger has been reconciled to working papers.
☐ OTA receivable or clearing balances have been reviewed, if used.
☐ Tax working papers use data traceable to source transactions.
☐ The reviewer or owner has seen material exceptions before closing.

Adapt the checklist to each property’s systems and account structure.

Conclusion

Effective OTA reconciliation lets owners trace revenue from booking to bank and general ledger without unexplained gaps. Its foundations are separating bookings, fees, refunds, adjustments, payouts and cash; using consistent references; and keeping unmatched items in an exception log until resolved.

For hotels and villas using multiple OTAs, this should be a routine part of the month-end close. It produces accounting reports that are easier to review and data better prepared for owner reporting and tax working papers according to the business’s actual obligations.

Need to Organise OTA Reconciliation for a Bali Hotel or Villa?

If booking reports, OTA settlements, bank accounts and the general ledger still produce differences that are difficult to trace, start by building consistent working papers and an exception log before closing the period.

Usman Tax provides accounting and tax reporting services for Bali hospitality businesses. Through its accounting services, consultation can review OTA data flows, transaction mapping, bank reconciliation and working paper readiness for the hotel’s or villa’s systems.

Read Also: Hotel and Villa Accounting: A Hospitality Finance Systems Guide

FAQ OTA Reconciliation for Hotels and Villas

What is OTA reconciliation for hotels and villas?

It matches reservation and platform transaction data to settlements or payouts, bank receipts and accounting records so every difference can be explained and supported by documents.

Why can an OTA booking value differ from the money received in the bank?

Differences may result from fees or commissions, refunds, cancellations, adjustments, settlement timing, payment fees or one payout covering several bookings. Check the actual cause against the platform statement and contract.

Is net OTA settlement the same as hotel or villa revenue?

Do not automatically assume so. Net settlement is the net amount paid under a particular settlement arrangement. Finance still needs to reconcile it to transaction values, fees, refunds and company accounting policies.

What data is needed for OTA reconciliation?

Generally, PMS or reservation reports, OTA transaction and payout reports, commission statements or invoices where available, relevant payment gateway reports, bank accounts and the general ledger.

What if one OTA payout contains many bookings?

Use a settlement batch. List every booking making up the payout, total the relevant components and match the batch total to the settlement amount and bank reference.

What should happen when an OTA transaction does not match the bank?

Do not immediately make an expense adjustment. Add it to the exception log, categorise the cause, obtain further documents and complete the investigation before making a correction entry.

How often should OTA reconciliation be performed?

Frequency is an internal control decision. High-volume properties may review more frequently, but data should at least be reconciled before month-end closing and before use in management or tax reports.

Should refunds and cancellations be separated?

Yes. As an internal control, separating them helps finance identify whether changes arise from refunds, cancellations, no-shows, adjustments or other settlement issues.

Does OTA reconciliation relate to hotel or villa PBJT?

It helps produce traceable transaction data for local tax working papers but does not replace PBJT rules. Filing must follow the rules and systems of the regency or city where the business is located.

When does a hotel or villa need professional OTA reconciliation assistance?

Consider assistance when OTA volumes are high, unmatched items are numerous, settlements involve several platforms or payment gateways, clearing accounts never clear, or owner, bank, accounting and tax working paper figures repeatedly differ without explanation.

Sources and References

Usman Tax