Villa Bookkeeping

Bali Airbnb Bookkeeping: Reconcile Airbnb and Booking.com Payouts

Learn Airbnb bookkeeping for Bali villas: match bookings to OTA statements and bank receipts, separate fees and refunds, and document month-end payout timing.

Illustrative close-up of booking receipts being reconciled to platform payout schedules and a bank deposit ledger, calculator and teak desk in a Bali villa office

By Bali Accounting editorial desk · Editorial updated 2026-10-23. General information, not a claim of licensed professional review.

Airbnb and Booking.com make it possible to receive villa bookings from several markets, but their payout reports do not always look alike. One platform may group several reservations into a single transfer, while another may show adjustments, commissions, or refunds in a different section. The bank statement usually shows only the final amount received.

Monthly OTA payout reconciliation for Bali villas connects those two views. It explains how a deposit was produced, confirms that the deposit reached the correct bank account, and preserves a clear trail for follow-up. This is useful for villa owners, operators, and managers who need reliable monthly records without confusing cash received with booking revenue.

Why OTA payout reconciliation matters

A bank feed answers one question: what cash entered or left the account? An Airbnb or Booking.com report answers a broader question: which reservations, guest charges, platform fees, refunds, and adjustments produced that cash?

Reconciling both records helps you identify:

Reconciliation is not simply checking whether the month’s total looks reasonable. A total can appear correct while one reservation is missing, a refund is assigned to the wrong period, or a commission has been posted as a separate expense when it was already deducted from the payout.

Define the period before downloading reports

Start with one clearly defined payout period. Record whether the period is based on payout date, bank settlement date, reservation date, or another internal close convention. For a cash-focused bank reconciliation, payout and settlement dates are usually the most useful starting points, but the bookkeeping process should apply one consistent method and document exceptions.

Before reviewing the numbers, note the following:

A reservation arriving on the last day of a month may be paid in the next month. Similarly, a payout generated at the end of a month may settle after a weekend or holiday. Keeping booking dates and payout dates separate prevents timing differences from being treated as errors.

Use source reports, not screenshots alone

Download the platform report in a format that allows the underlying lines to be reviewed. Keep the original file in the monthly records, together with the bank statement or transaction export used for matching. A screenshot can help explain an unusual item, but it is less useful as the main working record because it may not contain all reservation IDs, fee lines, or payout details.

Build a payout bridge for every transfer

A payout bridge explains how the platform arrived at the net amount sent to the bank. It can be maintained in a spreadsheet, bookkeeping workpaper, or another controlled record. The important point is that the components should add back to the payout rather than relying on a single net figure.

For each payout, capture relevant lines such as:

Include the platform payout ID and the related reservation IDs. If a platform groups several reservations into one transfer, list each underlying reservation and show how their combined activity reaches the transfer total. This makes the work easier to review when the bank contains only one deposit description.

Illustrative example: A platform report shows three reservations included in one transfer. The bridge lists the gross guest charges for all three, subtracts the platform fees and a refund connected to one reservation, and arrives at the net amount shown on the payout report. The example is only a bookkeeping illustration; the actual components must come from the relevant platform statement.

Match the payout bridge to the bank

Once the bridge is prepared, search the bank statement by amount, date, currency, and transaction description. A direct one-to-one match is easiest, but it is not always available. International settlement timing, weekends, holidays, and bank processing can cause the bank date to differ from the platform payout date.

Use the following matching sequence:

  1. Compare the expected net payout with the banked amount.
  2. Check whether the payout currency matches the bank transaction currency.
  3. Review the bank description for a platform reference or transfer identifier.
  4. Allow for a reasonable settlement delay based on the records available to the business.
  5. Match one bank deposit to one payout where possible.
  6. For grouped deposits, link the bank transaction to every underlying payout ID.
  7. Document unresolved differences rather than forcing the amounts to agree.

Illustrative example: Two platform payouts are issued near a weekend and arrive as one bank deposit. The reconciliation can show the single bank transaction, link both payout IDs, and explain the combined amount. It should not create a made-up third payout simply because the bank contains one line.

Do not hide foreign-exchange differences

When the platform reports one currency and the bank receives another, preserve both amounts. Record the exchange-rate source used by the bookkeeping process and identify the date associated with the conversion. If the banked amount differs from a simple conversion of the platform amount, retain the supporting information and flag the variance for review.

Changing the original booking value to make it equal the bank deposit removes useful information. A better control is to keep the platform activity, banked amount, and documented conversion or variance visible as separate parts of the reconciliation.

Handle common exceptions carefully

Refunds and cancellations

Link each refund to the reservation and payout where the platform provides that information. Note whether the refund reduced a future payout or left the bank account separately. If the refund left the bank on a different date, record that date and retain the related platform detail.

Fee changes or unexpected commissions

Retain the platform statement that shows the commission or service-fee calculation. Compare the fee to the amount used in the payout bridge and flag changes for review. Do not assume that a difference is an error until the statement, reservation terms, and payout detail have been checked.

Missing deposits

If a payout appears in the platform report but not in the bank, mark it as outstanding and record the expected settlement information. Check whether it was sent to another approved account, held by the platform, reversed, or included in a later grouped transfer. Keep the item open until the evidence supports a conclusion.

Manager collections

When a property manager receives guest funds and later transfers money to the owner or operating account, the manager’s transfer is not automatically the same thing as the guest booking. Obtain the manager’s statement, identify the reservations or period covered, and distinguish the manager’s transfer from the original platform activity.

Manual adjustments

Manual entries may be necessary for an identified timing or currency difference, but they should include a clear explanation and supporting document. Avoid using a general adjustment account as a permanent holding place for unexplained payout differences.

A monthly OTA reconciliation checklist

Use this checklist at each monthly close:

For the wider close process, see the monthly Bali villa bookkeeping checklist. If you are also organising records for professional tax review, the guide to preparing Bali villa records for an Indonesian Konsultan Pajak explains how to assemble a cleaner adviser pack.

When to improve the process

Manual reconciliation can become difficult when a villa has multiple listings, currencies, bank accounts, managers, or frequent refunds. Warning signs include unresolved differences rolling from month to month, deposits being posted only as unexplained net income, or staff needing to rebuild the same payout bridge repeatedly.

A more controlled process can standardise report downloads, file naming, payout IDs, bank matching, exception ownership, and monthly review. It can also separate operational questions—such as whether a guest charge or commission is recorded correctly—from tax questions that require professional advice.

Bali Accounting can discuss a bookkeeping workflow for your villa’s OTA reports, bank accounts, and monthly close requirements. Visit the Bali Accounting services page to review the available support and share the records you want to bring under a consistent reconciliation process.

OTA reconciliation is a bookkeeping control, not Indonesian tax advice. It does not determine tax treatment or replace advice and official filings by a licensed Indonesian Konsultan Pajak. Keep the underlying reports and ask your licensed adviser how the records should support tax reporting.

Build a repeatable short-term rental payout reconciliation

For every settlement, retain the reservation reference, property, gross activity, fee or adjustment, payout reference and matching bank receipt. If one payout includes several reservations, reconcile the components before assigning the net amount to a month. Keep currency and transaction dates visible so a later review can explain the result.

Do not close a difference simply by calling it a platform fee. Use the supporting statement, or flag the question for the owner or manager. Carry outstanding settlements into the next period's checklist and record when they clear. This source-record approach applies to the agreed Airbnb, Booking.com and direct-booking records without implying automatic platform integration or authority over the owner's accounts.

Related services and next steps

For ongoing records, explore our Bali accounting and villa bookkeeping services. For this topic, see Airbnb bookkeeping and payout reconciliation. Advice and project work require their own agreed scope; these articles are general information.

Speak with Client Advisory

Related guides

Need help applying this process? Explore the relevant service scope, sample owner report and bookkeeping package inclusions.