Using net bank deposits as revenue
A bank deposit is what survived fees, refunds and timing — not what the villa earned. Recording deposits as revenue understates income, hides platform costs and makes every later comparison meaningless.
Airbnb bookkeeping Bali · OTA payout reconciliation
Airbnb & OTA Payout Reconciliation for Bali Villa Owners
Step-by-step reconciliation of Airbnb, Booking.com, Agoda, VRBO and direct bookings for Bali villas — from gross booking value to the bank receipt, with every fee, refund and timing difference explained. Packages from Rp 2.9m/month.
The problem
A bank deposit is not villa revenue.
Most Bali villa books go wrong in the same quiet way: the amount that lands in the bank is recorded as income. That deposit has already survived platform commissions, host fees, refunded stays, cancelled reservations, cleaning-fee treatment, held reserves and a payout calendar that ignores your month-end. Two villas with identical bookings can deposit different amounts; one villa can deposit more in a worse month simply because a delayed payout finally arrived. When the deposit becomes the revenue line, none of that is visible — and none of it can be explained later.
The damage compounds across channels. Airbnb settles one way, Booking.com invoices commission another way, Agoda and VRBO run their own payout timing, and direct bookings bypass platforms entirely. Add a payout converted from USD or AUD into IDR and a refund deducted from next month's settlement, and the spreadsheet total drifts further from what guests actually booked. Owner reports built on deposits cannot answer the only questions that matter: what did we earn, what did the channels keep, and what is still owed to us?
It also weakens everything downstream. An owner cannot judge pricing or channel mix from figures that hide fees. A manager cannot be asked about a shortfall that was really a reserve. And when a licensed Indonesian tax adviser reviews the records for PBJT, PPh or another obligation, a deposit total with no statement-level evidence behind it is not a record pack — it is a claim. Proper OTA payout reconciliation fixes the source: every rupiah is traced from booking, to platform, to bank, with the differences named instead of buried.
How a proper reconciliation works
Five steps from booking export to owner report.
The same sequence runs every month, for every channel, so one month can be compared with the next. No direct platform integration is promised — the work uses the exports and statements you supply, which keeps the evidence in your hands.
- 01
Export or receive the platform transaction reports
Start with the source, not the bank. Collect the transaction or payout report for Airbnb, Booking.com, Agoda and VRBO, plus the direct-booking schedule for reservations taken outside a platform. Each line should keep the booking reference, property, check-in and check-out dates, currency and gross amount identifiable. A monthly total exported without reservation detail cannot be reconciled — it can only be guessed at.
- 02
Map gross booking value to platform fees to net due
For every channel, walk the same bridge: gross booking value, less platform commission and host fees, less refunds, cancellations and adjustments, equals the net amount the platform owes you. Cleaning fees and extra-guest charges belong in this map as their own lines, not folded into the nightly rate, so the owner can see what guests paid for and what the platform kept.
- 03
Match the net due to bank receipts and explain the timing
A payout released by a platform is not the same event as money arriving in the bank. Settlements combine several reservations, cross month-ends, wait on reserves and land in a different currency. Match each net-due amount to a bank receipt and carry anything unmatched onto a dated timing list, so next month's close starts by clearing last month's open items instead of rediscovering them.
- 04
Flag refunds, cancellations, cleaning fees and adjustments separately
Refunds and cancellation adjustments change revenue; cleaning fees and extra-guest charges are separate guest charges; reserves are money held back, not money lost. Record each category in its own line with its supporting document. When a difference has no evidence yet, it stays visible as an open question for the owner or manager — it is never plugged into a miscellaneous total to make the month look finished.
- 05
Produce the payout bridge that feeds the owner report
The finished reconciliation becomes the payout bridge in the monthly owner report: gross bookings by channel, platform fees, net due, bank receipts, timing items still in transit and unresolved questions, each traceable back to a statement line. That bridge is what lets an owner, a manager and a licensed Indonesian tax adviser review the same month and reach the same numbers.
Illustrative payout bridge · fictional figures · IDR
How one month walks from bookings to bank
Gross booking value (all channels)Rp 100,000,000
Platform fees and commissions− Rp 15,000,000
Refunds, cancellations and adjustments− Rp 2,000,000
Net due from platformsRp 83,000,000
Bank receipts matched in the monthRp 80,000,000
Timing item still in transit (explained, not lost)Rp 3,000,000
Gross booking value → platform fees → refunds and adjustments → net due → bank receipts → timing items. The Rp 3,000,000 still in transit is an explained open item with a date and a reference — not missing money and not extra revenue. Read it beside the worked sample owner report.
The monthly owner report
What appears in the report this reconciliation feeds.
The reconciliation is not the end product — the owner report is. These are the lines a reconciled month puts in front of you, each one traceable to its source document.
Inspect the sample owner reportMonthly villa financial reporting in Bali
- Gross bookings by channel — Airbnb, Booking.com, Agoda, VRBO and direct bookings shown separately, never merged into one deposit total
- Platform fees and commissions, matched to the commission invoice or payout statement that charged them
- Refunds, cancellations and adjustments as their own lines, with the approval or platform notice behind each one
- Net due from each platform for the period, before any money moves
- Bank receipts matched to those net-due amounts, with the value date and currency recorded
- Timing items — payouts released but not yet received, reserves still held, and receipts that arrived for a different period
- Unresolved questions and missing evidence, listed openly instead of being absorbed into the figures
- Evidence references for every line, so a reviewer can walk from the report back to the statement, invoice or booking record
Common errors that create gaps
Six mistakes that make villa numbers unreliable.
Missing refund and cancellation entries
A cancelled stay that was refunded after payout appears as a quiet deduction in a later settlement. If refunds are not recorded as their own lines, revenue stays overstated and the deduction looks like a missing deposit.
Ignoring reserves and delayed payouts
Platforms hold reserves and release payouts on their own calendar. Treating a held reserve as lost income — or a delayed payout as a shortfall — creates false alarms and false comfort in alternate months.
Mixing owner funding with rental income
Money an owner transfers to cover a supplier or top up an account is not guest revenue. Booking it as income inflates performance and corrupts the record pack a tax adviser later relies on.
Incomplete multi-currency conversion records
A payout converted from USD or AUD into IDR changes value between booking, release and receipt. Without the rate and date recorded for each conversion, the difference gets misread as a fee or an error.
No evidence trail for PBJT or PPh review
Local accommodation taxes and income-tax positions are assessed by the responsible qualified adviser — but only from records that exist. A report without statement-level evidence behind each total leaves that review with nothing to stand on.
Records required before work starts
The checklist we reconcile from.
Scope and fees are confirmed before engagement, after a short review of these records. Send the first message without financial files — the document handover is agreed privately once fit and scope are clear.
- Platform transaction or payout exports for every active channel (Airbnb, Booking.com, Agoda, VRBO), covering the full period — not screenshots of monthly totals
- Bank statements or transaction exports for every account that receives payouts or pays villa costs
- The booking calendar or reservation list, with property, dates and booking references that match the platform exports
- Direct-booking records and refund approvals for reservations taken outside a platform
- Supplier invoices, receipts and payroll schedules for costs that should appear beside the income
- Prior owner reports and opening balances, where they exist, so the first reconciled month starts from a known position
- Notes on owner funding, withdrawals and transfers between your own accounts, so they are never mistaken for guest income
Service connection
Reconciliation inside a monthly bookkeeping package.
OTA reconciliation is not sold as a one-off spreadsheet fix. It runs inside the monthly close, so every month starts from last month's cleared position.
Starter
Rp 2,900,000/ month
- 1 villa
- Monthly bookkeeping
- Up to 2 booking channels
- Basic monthly P&L
- Private document folder
Professional
Rp 4,900,000/ month
- Monthly bookkeeping
- Full owner financial report
- Payroll and BPJS tracking
- All booking channels
- Monthly review call
Premium
Rp 6,900,000/ month
- Monthly bookkeeping and reporting
- Tax-pack for Konsultan Pajak (record handover only)
- Forecast versus actuals
- Annual position summary
- Priority account review
Tax advice and official filings are not included in bookkeeping packages; tax-compliance support is a separate engagement. Behind on past months? Historical cleanup starts at Rp 7,900,000 for up to 12 months, subject to records review.
How do you reconcile Airbnb payouts when the bank amount is lower?+
We walk the payout bridge: gross booking value, less Airbnb fees, refunds and adjustments, gives the net due; then we compare that with the bank receipt. A lower bank amount is usually fees, a refund deducted from a later payout, a reserve still held, a currency conversion, or a payout still in transit. Each cause is recorded as its own line with its evidence. If none of them explains the difference, it stays on the open-questions list — it is not written off as a fee.
What is the difference between gross booking value and net due?+
Gross booking value is what guests booked before platform deductions. Net due is what the platform owes after its commission and host fees, refunds, cancellations and other adjustments. The bank receipt is a third number again, because payouts combine reservations and arrive on the platform's calendar. A useful owner report shows all three instead of presenting the deposit as revenue.
Do you handle Booking.com commission invoices?+
Yes, within the agreed bookkeeping scope. Booking.com commission invoices are matched against the reservations they relate to and recorded separately from the payout or bank receipt, so the cost of the channel is visible. We work from the invoices and exports you supply; no direct platform integration or account access is promised.
Can you reconcile multiple villas or channels?+
Yes, where the records are supplied per property and channel and the scope is agreed in advance. Each villa keeps its own booking, fee and payout lines; shared costs follow a documented allocation. Starter is scoped for 1 villa and up to 2 booking channels; wider setups are confirmed before agreement so the close stays achievable.
What evidence do you attach for the tax consultant?+
The handover pack connects each reported total to its source: platform statements, commission invoices, bank receipts, refund approvals and the dated list of unresolved items. That gives a licensed Konsultan Pajak a traceable record for PBJT, PPh or other reviews. The bookkeeping pack organises evidence; tax treatment and filings remain the adviser's separate, separately scoped work.
How long does a monthly close take once documents are complete?+
The 15th is our target after complete and timely source documents are received — it is not a guaranteed date. A close moves faster when exports, statements and invoices arrive together and open questions get answered; late or partial records move the delivery date, and we say so rather than closing the month on assumptions.
How much does OTA reconciliation cost?+
It is part of the monthly bookkeeping packages: Starter Rp 2,900,000, Professional Rp 4,900,000 and Premium Rp 6,900,000 per month, with channel and property limits confirmed before agreement. Historical backlogs are scoped separately as a cleanup, starting at Rp 7,900,000 for up to 12 months after a records review.
What is not included in this service?+
Tax advice, official filings, payroll execution and BPJS administration are not included in bookkeeping. We do not control bank or platform accounts, authorise payments, or promise direct OTA integrations. Where tax-compliance support is needed, it is agreed as a separate engagement with the responsible qualified professional.
What should I do if my payout records are already behind?+
Start with a records review rather than a monthly package. A cleanup engagement — starting at Rp 7,900,000 for up to 12 months, subject to review — reconstructs what the evidence supports, lists what is missing, and establishes an opening position so the recurring reconciliation starts clean.
Go deeper
Guides that support this reconciliation workflow.
- Booking.com commission reconciliation checklist
- Handling Airbnb reserves and delayed payouts
- Reconciling Airbnb and Booking.com payouts, step by step
- Airbnb refunds, cancellations and payout reserves
- Multi-currency bookkeeping and exchange differences
- Bank reconciliation: resolving unmatched transactions
- What monthly accounting deliverables should include