Villa Bookkeeping
Booking.com Bookkeeping: Reconcile Commissions and Deposits
A practical record workflow for matching Booking.com reservation activity, commission invoices, payout statements and bank deposits without overstating villa income.
By Bali Accounting editorial desk · Editorial updated 2026-10-24. General information, not a claim of licensed professional review.
Booking.com bookkeeping commission invoices should be reconciled by starting with the reservation activity, recording the platform commission separately, and then matching the resulting payout to the bank deposit. Do not post the bank receipt as the entire booking revenue. A reliable reconciliation explains the gross booking value, adjustments, commission, other deductions, payout date, currency and property before the amount reaches the ledger.
Who this applies to
This workflow is intended for Bali villa owners, remote owners, property managers and finance teams receiving reservations through Booking.com. It is also useful where one bank account receives payouts for several villas, or where a management company receives platform money and later transfers an owner share.
The central issue is timing. A guest reservation may be created in one period, changed or cancelled later, invoiced by the platform on another date, and paid into the bank on a different date again. A single deposit therefore cannot, by itself, prove the underlying income or cost. The records need to preserve the relationship between the booking and the cash.
This is a bookkeeping and evidence framework, not a conclusion about tax treatment, platform terms or the legal relationship between an owner, manager and platform. Ask the responsible accountant or tax adviser how the completed records should be used for your structure.
What must be reconciled
A useful Booking.com reconciliation has four connected layers. First is the reservation report: booking number, guest-stay dates, villa, room or unit, booking creation date, gross room value, cleaning or extra charges, discounts, cancellations and adjustments. Second is the commission document or platform statement, which identifies the charge attributed to the reservations.
Third is the payout statement. It should show which reservations were included, deductions made, currency, payout reference and the amount expected. Fourth is the bank statement, which confirms the amount actually received, value date, currency and receiving account. These layers may not share the same date, reference or exchange-rate presentation, so the reconciliation should retain both the source value and the accounting value used in the books.
| Record layer | Key fields to capture | Control question |
|---|---|---|
| Reservation activity | Booking number, villa, stay dates, gross value, adjustments | What booking created the amount? |
| Commission invoice or statement | Invoice reference, reservation references, commission amount, date | What platform charge relates to the booking? |
| Payout statement | Payout reference, included bookings, deductions, currency, expected total | Why is the payout different from gross activity? |
| Bank statement | Deposit date, amount, currency, account and transaction reference | Did the expected payout arrive? |
| Exception log | Missing documents, timing differences, unexplained variances | What remains unresolved and who owns it? |
Keep the source files in a consistent folder structure. A practical convention is property, platform, payout period and reference. Preserve the original downloaded statement rather than relying only on a spreadsheet that can be overwritten. If the platform report changes after a cancellation or adjustment, keep the revised report and note what changed.
A step-by-step reconciliation method
- Define the population. Select the payout period and list every Booking.com payout expected for it. Do not begin with only the transactions visible in the bank account, because a missing or delayed payout would disappear from the review.
- Identify each property. Assign every reservation and payout line to a villa, unit or management pool. If one payout combines several properties, retain the combined platform total and create a property allocation schedule.
- Build the gross activity list. Record the booking value before platform deductions, plus separately identified extras, discounts, refunds and cancellation adjustments. Use the platform’s labels consistently; do not silently net unlike items.
- Match commission documents. Link each commission line to a reservation or statement period. Where the invoice is aggregated, keep the invoice total and document the allocation basis used for property or booking reporting.
- Reconstruct the expected payout. Start with the relevant gross activity, subtract the commission and other documented deductions, then include additions or prior-period adjustments shown by the platform. The expected result should agree to the payout statement, subject to timing and currency differences.
- Match the bank deposit. Compare the expected payout with the bank amount, currency, date and reference. A difference is not automatically an error: it may reflect a bank charge, exchange conversion, split payout, withheld amount or a booking adjustment posted after the report was downloaded.
- Post with clear accounts. Use separate ledger categories for booking revenue, platform commission, refunds or cancellations, bank charges, foreign-exchange differences and amounts held or payable where relevant to the bookkeeping design. The exact account names should match the entity’s chart of accounts.
- Close exceptions. Give each unresolved difference an owner, amount, source to obtain and next review date. Never clear a variance by reducing revenue or commission simply because the bank deposit is lower.
The best matching key is normally the platform reservation number, but it is not always sufficient. Add the payout reference, villa, stay dates and currency. A booking can be modified, split, refunded or included in a later payout. These additional fields make a later review possible when the original platform screen is no longer available.
Worked IDR example
The following is an illustrative bookkeeping example only. It is not a tax calculation and uses simple figures in Indonesian rupiah. Assume one Booking.com payout contains two reservations for the same villa:
| Item | Amount | Effect on expected payout |
|---|---|---|
| Reservation A gross value | IDR 6,000,000 | Plus |
| Reservation B gross value | IDR 4,000,000 | Plus |
| Total gross booking value | IDR 10,000,000 | Plus |
| Booking.com commission invoice | IDR 1,500,000 | Minus |
| Documented guest refund adjustment | IDR 500,000 | Minus |
| Expected payout | IDR 8,000,000 | 10,000,000 - 1,500,000 - 500,000 |
| Bank deposit received | IDR 8,000,000 | Matches expected payout |
The bookkeeping record should not describe IDR 8,000,000 as the booking revenue merely because that is the bank receipt. The schedule shows IDR 10,000,000 of gross booking activity, an IDR 1,500,000 platform commission and an IDR 500,000 refund adjustment. The arithmetic is: IDR 6,000,000 + IDR 4,000,000 = IDR 10,000,000; IDR 10,000,000 - IDR 1,500,000 = IDR 8,500,000; IDR 8,500,000 - IDR 500,000 = IDR 8,000,000. The bank match then confirms cash settlement, not the classification of every component.
If the bank instead received IDR 7,950,000, record the IDR 50,000 difference as an open exception until its cause is supported. It might be a bank charge or currency-related difference, but the evidence should decide the classification. Do not assume that a small difference is immaterial without documenting the decision.
Currency, timing and property controls
Booking platforms may display a guest-facing amount, a payout amount and a commission amount in different currencies or at different conversion points. Record the currency of each source and the exchange-rate basis used for the ledger. The purpose is not to force every document into one number prematurely; it is to make the conversion traceable.
Timing differences need their own status. A reservation created in March may be paid in April. A cancellation in April may alter a payout that originally appeared in March. Mark whether an item is unmatched because it is pending, changed after the report date, included in another payout or genuinely missing. This prevents the same booking from being counted again in the next month.
For multi-villa operations, create a property allocation column before posting the consolidated payout. If a shared management fee or bank charge cannot be directly assigned, document the allocation basis and apply it consistently. The principle should be understandable to someone reviewing the records without asking the owner to remember an informal arrangement.
Where a manager receives the platform payout, maintain separate schedules for platform activity, manager-held cash and transfers to the owner. A transfer to the owner is not automatically a new operating expense, and an owner-funded payment should not be used to conceal a payout difference. For related controls, see rental property bookkeeping for owner contributions and the discussion of refunds, cancellations and payout reserves.
What owners get wrong
- Correction one: posting only the bank deposit. Owners often record the net deposit as revenue and leave the commission invisible. Rebuild the gross-to-net bridge so revenue, commission, refunds and other deductions can be reviewed separately.
- Correction two: treating the commission invoice as a bank payment. A commission document can explain a deduction from a platform payout without being a separate cash transfer from the villa bank account. Match it to the payout mechanics before recording a second payment.
- Correction three: closing unmatched items with a plug. A round-number adjustment may make a spreadsheet balance while destroying the audit trail. Keep an exception log, obtain the missing statement or document the supported reason for the difference.
Another common error is using the booking date for every accounting purpose without considering the platform statement and bank timing. Dates should be retained for booking creation, stay, adjustment, commission document, payout and bank settlement where available. Different reports answer different questions.
Printable month-end check and checklist
Use the following as a practical close sheet. Tick each item only when the supporting evidence is saved or the exception is recorded.
- Download the Booking.com reservation activity for the period.
- Download every relevant payout statement and commission invoice or statement.
- List each payout expected, including any pending or split payout.
- Assign bookings and deductions to the correct villa or property pool.
- Check gross booking values against reservation references.
- Separate commissions, discounts, refunds, cancellations and other platform adjustments.
- Recalculate each payout from the source schedule.
- Match each expected payout to the bank statement by amount, currency and reference.
- Investigate every difference and enter it in the exception log.
- Check that prior-period open items have not been counted again.
- Review foreign-currency conversions and document the rate or source used.
- Post approved entries using consistent ledger categories.
- Save the reconciliation, source reports and reviewer notes together.
- Send unresolved items to the responsible person with a clear requested action.
A useful close pack contains the booking detail, commission support, payout bridge, bank match, property allocation and exception list. It should allow an owner to answer three questions quickly: what guests were charged or credited, what the platform retained or adjusted, and what cash actually arrived.
For an established monthly process, compare the scope of your bookkeeping engagement with the records it actually produces. The guide to accounting services in Bali monthly deliverables explains why source collection, exception handling and reporting responsibilities should be written down. The related OTA payout reconciliation workflow can help when Booking.com and Airbnb activity share one reporting process.
Bali Accounting can discuss a suitable record workflow through its Airbnb and platform bookkeeping service. Any preparation or submission work for tax, compliance or other regulated matters requires the responsible authorised person and a separately agreed engagement; it is not automatically included in monthly bookkeeping. For a scoped discussion, use the Client Advisory channel.
General information disclaimer: This article provides general bookkeeping information for villa operators. It is not tax, legal, accounting-opinion, immigration or financial advice, and it does not determine the correct treatment for a particular entity, contract, platform arrangement or jurisdiction. Confirm classifications, reporting obligations and any filing or submission work with the appropriately authorised adviser.
Frequently asked questions
Should Booking.com commission reduce villa revenue?
Do not decide from the bank deposit alone. Preserve the gross booking activity and commission separately, then ask the responsible adviser how the records should be presented for the relevant entity and reporting purpose.
Is a Booking.com commission invoice the same as a bank transaction?
Not necessarily. The platform may deduct commission before sending a payout, so the invoice can explain a reduction in the payout without a separate bank debit. Match the invoice to the platform statement and avoid double-counting.
What if the payout does not match the bank deposit?
Check currency, value date, bank charges, split payouts, later booking adjustments and withheld amounts. Record the difference in an exception log until evidence supports its classification.
How should one payout covering several villas be recorded?
Reconcile the consolidated payout first, then allocate the supported booking activity, commissions and other deductions to each property. Keep the allocation basis with the reconciliation and identify any shared amount that cannot be directly assigned.
How often should Booking.com payouts be reconciled?
Reconcile them at the same practical rhythm as the bank close, usually by payout or reporting period rather than waiting until year-end. More frequent review is useful when cancellations, currencies or property transfers create many open items.
Related services and practical guides
Continue with Bookkeeping Cleanup: Building an Evidence-Based Opening Balance.
Scope: This article is general information, not tax advice, legal advice or immigration advice. Illustrative figures are not client results. Requirements and rates may change; ask a licensed Indonesian Konsultan Pajak or the appropriate qualified adviser about your actual circumstances. Editorial quality checks are not a licensed professional review.
For ongoing support, explore our Bali accounting and villa bookkeeping services. Project work and monthly bookkeeping have separately agreed scopes.
AI-generated editorial illustration, not an actual client property, official document or photograph of a reported event.
Related guides
- Bali Villa Cash-Flow Forecast: Booking Payouts, Costs and Owner Withdrawals
- Bali Airbnb Bookkeeping: Reconcile Airbnb and Booking.com Payouts
- How to Build a Practical Chart of Accounts for a Bali Villa
Need help applying this process? Explore the relevant service scope, sample owner report and bookkeeping package inclusions.