Airbnb Villa Tax Reconciliation: Gross Bookings, Fees and Net Settlements
Main topic: Reconciling Airbnb data from gross bookings to payouts; the business model and responsible parties are discussed separately.
Complete foundation: Villa Tax Reporting in Bali: An Owner and Operator Guide.
Continue as needed with Airbnb Tax in Bali: Business Models, Owners and Operators and Villa PBJT Reconciliation: Airbnb, OTA, Deposits, Refunds and Bank Accounts.
Assistance is available through villa management tax reporting services.
Airbnb villa tax reconciliation in Bali should begin with more than the money reaching a bank account. For villas accepting Airbnb bookings, finance first needs to explain the relationship between gross earnings, platform fees, adjustments, payouts, the bank and the general ledger.
A common problem is straightforward: the booking value looks substantial on the platform, but the bank transfer is smaller. The difference is not necessarily an error. Without reconciliation, however, the owner can lose the trail between operating revenue, platform deductions, refunds, payouts and the figures eventually used in tax reports.
Airbnb Villa Tax Reconciliation Starts with Gross-to-Net Records
Before determining tax working paper figures, establish the transactions from their original sources.
Gross earnings are different from payouts
Airbnb provides an earnings report that can include gross earnings, adjustments, host service fees, taxes withheld where applicable and total net pay.
For listing owners, Airbnb explains the payout calculation as the nightly rate plus optional extra charges, less the host service fee and shared co-host payouts.
A payout is therefore the result of several components. Accounting should retain the gross transaction detail alongside the bank transfer amount.
Net bank settlement is not the only accounting figure
Suppose the platform shows IDR 100 million of gross earnings and the bank receives IDR 96 million after deductions recorded in the platform report. If accounting records only IDR 96 million as revenue without a bridge, the IDR 4 million difference loses its explanation in the general ledger.
These figures are illustrative only. Actual amounts must follow Airbnb reports and the host’s contract or account arrangements.
What Data Can Be Obtained from Airbnb?
For tax reconciliation, Airbnb states that the Earnings dashboard provides access to gross earnings, transactions and CSV exports.
This data can form the starting point for a reconciliation file. Finance should retain reports by period and connect them to the relevant listing, payout method and bank account.
In practice, separate at least:
- Gross earnings
- Host service fees
- Adjustments
- Refunds or corrections, where applicable
- Co-host payouts, where used
- Payouts
- Payout dates
- Recipient accounts
- The relevant listing or villa
The purpose is to make each payout traceable to source transactions, with the CSV download forming one part of that process.
Seven Controls for Airbnb Villa Reconciliation
1. Finalise gross earnings by period
Start with the Earnings report. Separate it by month and listing when an owner or villa management company manages several properties.
Use a consistent cutoff so month end bookings are not moved between periods merely because the payout arrives in the following period.
2. Identify the host service fee
The host service fee should be traceable from the platform report to the bookkeeping account used. Do not calculate it from a bank difference without checking transaction details.
If fees vary between reservations or account models differ, use Airbnb’s actual report as the source document.
3. Separate adjustments and refunds
Adjustments can make a particular month’s payout differ from its normal pattern. Use separate columns for refunds, resolution adjustments or other corrections shown in the report.
This prevents finance from recording every deduction as platform commission.
4. Match payouts to bank accounts
Once the gross-to-net bridge is complete, match payout IDs, dates, amounts and recipient accounts to the bank statement.
A difference of a few days may be a timing difference. Value differences need explanations from the reports rather than assumptions that they are bank or platform fees.
5. Separate owner and villa management transactions
If villa management operates the Airbnb account while another party owns the villa, accounting needs to read the contract.
Determine who earns the income, who receives payouts, what constitutes the management fee, which costs the owner bears and what amount ultimately becomes payable to the owner.
6. Connect reports to the general ledger
Use consistent account mapping for revenue, platform fees, refunds, owner payables, management fees and bank accounts, reflecting the substance of the parties’ relationship.
Every villa does not require the same account structure. A villa directly operated by its owner differs from a management company receiving funds for several owners.
7. Build tax working papers after reconciliation
Do not take one CSV column and immediately treat it as a tax figure.
The tax working paper should reference gross transactions, deductions, settlements and the ledger so a reviewer can explain why tax report figures differ from bank transfers.
A Gross-to-Net Reconciliation Example
The table below is an internal control format, rather than a tax rule or mandatory Airbnb format.
| Component | Amount | Source | Status |
|---|---|---|---|
| Gross earnings | xxx | Airbnb Earnings report | Matched |
| Host service fee | (xxx) | Airbnb report | Matched |
| Adjustment/refund | +/- xxx | Transaction detail | Review |
| Co-host payout | (xxx) | Airbnb report | If applicable |
| Expected payout | xxx | Reconciliation | Calculated |
| Actual payout | xxx | Airbnb payout | Matched |
| Bank receipt | xxx | Bank statement | Matched/timing |
| GL posting | xxx | General ledger | Matched/variance |
A remaining difference becomes an exception only after every component explaining the payout has been included in the working paper.
The Relationship between Airbnb and Villa PBJT
Platform reconciliation and determining tax treatment are connected tasks, each requiring its own analysis.
Within the national tax framework, PMK 70/PMK.03/2022 places accommodation services such as hotels, hostels, villas, motels and similar establishments within hospitality services meeting that regulation’s criteria.
If the villa’s activity is in substance accommodation provision, Government Regulation No. 35 of 2023 includes hospitality services among regency or city PBJT objects.
This article does not prescribe a single PBJT rate for all Bali. Rates, the tax base, administration and reporting systems must be checked by regency or city and the actual transaction model.
For accounting, the key requirement is that tax working paper figures can be reconciled back to bookings and platform reports.
Common Errors
Recording net payout as all revenue
This hides gross transactions and deductions. The bank report may appear to agree while the economic transaction detail is lost.
Treating every difference as Airbnb commission
Differences can arise from fees, adjustments, refunds, co-host payouts, timing or other report components. Check the detail before posting journals.
Combining several villas in one payout without allocation
If a payout covers several listings, allocate each villa’s share before posting to the ledger or owner statement.
Using the bank date as the only cutoff
Transaction, payout and bank receipt dates can differ. Set a consistent accounting cutoff and document timing differences.
Failing to reconcile owner statements
In villa management, amounts paid to owners need to be traced to bookings, deductions, management fees and other contractual costs. The villa owner statement reconciliation guide explains this connection further.
Documents to Prepare
For a traceable reconciliation, prepare:
- Airbnb Earnings reports
- Transaction exports or CSV files
- Payout details
- Bank statements
- The general ledger
- The chart of accounts
- Refund and adjustment details
- The listing register
- Management agreements, where applicable
- Owner statements
- Management fee invoices or working papers
- PBJT reports, where already applicable
- Related tax reports
Use documents for the same periods so timing differences can be separated from actual discrepancies.
When Is a Professional Review Useful?
A more detailed review is relevant if:
- Gross earnings have never been reconciled to bank accounts
- Finance records only net payouts
- Several listings are included in one payout
- Payouts reach different bank accounts
- Owner statements differ from platform reports
- Management fees have no bridge to gross bookings
- Refunds and adjustments frequently create differences
- PBJT uses figures that cannot be traced to bookings
- The general ledger differs from Airbnb Earnings reports
- Old OTA or owner payable balances remain outstanding
For villa businesses in Bali, Usman Tax provides transaction recording and reconciliation, Airbnb and OTA summaries, consultation and tax reporting.
Conclusion
Airbnb villa tax reconciliation in Bali should start with gross earnings and a bridge through to payouts, bank accounts and the general ledger.
The sequence is gross earnings → host service fees and other deductions → adjustments/refunds → expected payouts → actual payouts → bank → general ledger → tax working paper.
Once operational figures are traceable, analyse PBJT and other tax obligations using the business model, income recipient and villa location. Tax reporting then has an explainable trail back to the original transactions.
Do Airbnb Payouts Still Differ from Villa Bookkeeping?
If gross earnings, platform fees, adjustments, payouts, bank accounts and the general ledger cannot yet be reconciled in one working paper, start with transaction exports and payout reports before correcting journals or tax reporting.
Usman Tax provides accounting services and villa management tax reporting services for hospitality businesses in Bali. A consultation can review Airbnb transactions, OTA reconciliation and the relationship between operating figures and villa tax reporting.
FAQ Airbnb Villa Tax Reconciliation
Is Airbnb net payout the same as villa turnover?
Do not automatically equate them. Airbnb can show gross earnings, host service fees, adjustments and other payout components. Accounting needs reconciliation before determining the figures relevant to bookkeeping or tax.
Which Airbnb data should be used for reconciliation?
Use Earnings reports, transaction details or CSV files, payout details and the relevant listing data. Match them to bank statements and the general ledger.
Can Airbnb commission be calculated solely from the gross booking and bank difference?
This is not recommended. Check host service fees and adjustments in Airbnb reports because more than one component may explain the difference.
What if one payout covers several villas?
Allocate it by listing before posting to the general ledger or owner statements, so each villa retains its transaction trail from platform to bank.
Are Airbnb villas in Bali subject to PBJT?
If the activity is in substance hospitality or accommodation provision within PBJT’s scope, review the local obligations. Rates and procedures must follow the rules of the villa’s regency or city.
What distinguishes Airbnb gross earnings from payouts?
Gross earnings describe the gross income in Airbnb reports. Payouts reflect relevant deductions such as host service fees or co-host payouts, together with adjustments from the actual transactions.
Sources and References
- Airbnb Earnings Reports: Gross Earnings, Fees, Adjustments and Net Pay — Airbnb
- How Airbnb Calculates Listing Owner Payouts — Airbnb
- Airbnb Earnings Data for Tax and Reconciliation — Airbnb
- General PBJT and Hospitality Services Provisions — Ministry of Finance JDIH
- Hospitality Services Criteria under Tax Regulations — Ministry of Finance JDIH
- Hotel and Villa Tax Review: Prepare for Your Consultation — Usman Tax
- Airbnb Tax in Bali: Business Models, Owners and Operators — Usman Tax
- Villa PBJT Reconciliation Guide — Usman Tax
Read Also: Villa Tax Reporting in Bali: An Owner and Operator Guide

