Your bank account shows money arriving from Airbnb, Booking.com and the odd direct guest, and at some point someone will ask what you actually earned. The deposits can't answer that on their own. Some arrive with fees already taken out, some have a commission bill that lands a month later, and some contain tourist tax that belongs to the municipality.
Vacation rental bookkeeping is the habit of splitting those deposits back into their parts. Start with one quick step: download last month's earnings report from Airbnb and last month's reservation statement from Booking.com, and put them next to your bank statement. Everything below builds on those three documents.
This guide covers the records. It isn't accounting or tax advice, and it doesn't cover which expenses you can deduct. For that, see our separate guide to vacation rental tax deductions and talk to an accountant who knows your country.
What does vacation rental bookkeeping need to track?
Vacation rental bookkeeping needs to track what each booking was worth before fees, what each platform charged, what you spent to run each unit, and any tax you collected for someone else.
The common mistake is treating the bank deposit as income. On Airbnb, the host service fee is deducted before the payout. Airbnb's service fee article says most hosts on the single fee structure pay 15.5%, others typically 14–16%, and that hosts using property management software must use that structure. On Booking.com, commission is a percentage of the booking amount set by your country, property type and agreement. It's applied after checkout and isn't charged on city tax.
Set up these categories once and use them every month:
| Category | What goes here | How to treat it |
|---|---|---|
| Gross booking revenue | Nightly rate plus fees you charge the guest, such as cleaning | Income |
| Platform fees and commission | Airbnb host service fee, Booking.com commission and payment fees | Cost of each booking |
| Direct operating costs | Cleaning, laundry, supplies, repairs, per-unit utilities | Expense, tagged to a unit |
| Shared costs | Software, insurance, a cleaner covering several units | Expense, split by a fixed rule |
| Tourist or occupancy tax you collect | Tax charged to the guest that you pay to the authority | Held for the authority, not revenue |
| Tax a platform collects for you | Occupancy tax or VAT the platform remits itself | Note it, but it never reaches you |
| Bank deposits | What actually arrived | Used to check the ledger, not to build it |
Whether collected tourist tax counts as income or as a liability in your accounts is a question for your accountant. What matters for your books is that it sits in its own line, so nobody mistakes it for rent.
How do you reconcile Airbnb and Booking.com payouts with your bank?
Reconcile each platform from its own statement, not from the bank. Record gross revenue and fees per reservation from the platform's report, then check the total against what arrived, allowing for fees billed later.
Airbnb. Airbnb's Download your earnings article says it generates monthly and annual earnings reports, broken down by listing and payout method, showing gross earnings, adjustments, host service fee, taxes withheld and net pay. From the Upcoming or Paid tab you can export a CSV that lists earnings, host service fees, cleaning fees and taxes withheld for each earning. In some jurisdictions, Airbnb collects and remits occupancy tax or VAT itself, so that tax never appears in your payout.
Booking.com. Its reservation statement article describes a statement listing every reservation included in an invoice, downloadable as XLS or CSV from Finance in the extranet. Booking.com's invoice guide says the commission invoice arrives in the first week of each month, covers the previous month's check-outs, and must be paid within 14 days of issue. If you use Payments by Booking.com, commission is deducted from payouts instead.
That timing difference is where many ledgers go wrong. Here's a worked example with hypothetical numbers: a €600 stay (nights plus cleaning) on each platform, an Airbnb fee of 15.5%, an example Booking.com contract rate of 15%, and €12 of tourist tax on the Booking.com stay that the guest pays you at the property.
| Line | Airbnb stay | Booking.com stay (guest pays you) |
|---|---|---|
| Gross booking revenue | €600 | €600 |
| Platform fee | €93, deducted before payout | €90, invoiced next month |
| Tourist tax | Not in payout if Airbnb remits it in your area | €12, held for the authority |
| Arrives in your bank | €507 | €612 this month |
| Leaves your bank later | Nothing | €90 when you pay the invoice |
| Net booking revenue | €507 | €510 |
The Booking.com deposit is bigger than what you earned, because it includes tax and unpaid commission. To compare channels over a whole month, our guide to short-term rental financial metrics covers net revenue per night by channel, and Booking.com commission explained covers the commission side in more depth.
What should a short term rental bookkeeping spreadsheet include?
A short term rental bookkeeping spreadsheet needs one row per reservation or expense, a unit column on every row, and columns that match the categories above, so you can total by unit and by month.
You don't need accounting software to start. An Airbnb bookkeeping spreadsheet with these columns covers most small hosts:
- Date (checkout date for bookings, payment date for expenses)
- Unit
- Channel (Airbnb, Booking.com, direct, other)
- Reservation or receipt reference
- Gross booking revenue
- Platform fee or commission
- Tourist tax collected, and a separate column for tax remitted
- Expense category and amount
- Bank deposit or payment date, for matching
The unit column matters most, because blended totals can hide a unit that loses money every off-season. For costs that serve several units, such as one internet plan for a building, pick a split rule (even split, or by nights booked) and keep it. Changing the rule mid-year makes months impossible to compare.
Then run the same routine once a month, after the platforms close the previous month:
- Download the Airbnb earnings CSV and the Booking.com reservation statement and invoice.
- Enter each reservation's gross revenue and fee, tagged by unit and channel.
- Enter the month's expenses with receipts attached or filed by reference.
- Move tourist tax collected into its own line and record any payment to the authority.
- Match the totals against your bank. Any gap should be explained by timing, such as an unpaid commission invoice or a payout still in transit.
Keep the downloaded files. Booking.com says its extranet shows invoices going back up to five years, and not those from a previous owner after a change of ownership, so saving your own copies means you don't depend on the platform keeping them.
How should you record short term rental expenses and tourist tax?
Record every short term rental expense with a date, unit, category and receipt, and record tourist tax you collect as a separate item that you track until it's paid to the authority.
Photograph paper receipts on the day and file them with the month's statements. Recording an expense isn't the same as deducting it: which costs reduce your taxable income depends on your country, and for US hosts our tax deductions guide walks through IRS guidance.
For tourist tax, the key question is who collects it on each channel. Airbnb lists the places where it collects and remits taxes for hosts, and says hosts remain responsible for other tax obligations. Where the platform doesn't collect it, you usually charge the guest and pay the authority yourself, so your books need a trail from collection to payment. Our recommendation: keep a running balance of tourist tax collected minus tax paid. It should fall back toward zero after each filing, and a growing balance tells you a payment is overdue.
When this advice does not apply
- This is not accounting or tax advice. Income recognition, VAT registration, tourist tax rules, deductions and how long you must keep records all depend on your country and business structure. Confirm them with a qualified accountant or your tax authority.
- Trust accounting. If you manage units for other owners and hold their money, you may be subject to trust account rules that a simple spreadsheet doesn't cover.
- Companies and VAT-registered hosts. Formal bookkeeping obligations, invoicing rules and VAT returns usually require proper accounting software or an accountant.
- Payments by Booking.com users. Commission is deducted from payouts, so the timing gap in the worked example doesn't arise in the same way.
What to do next
- Download last month's Airbnb earnings CSV and Booking.com reservation statement.
- Set up a spreadsheet with the columns above and a unit column on every row.
- Record last month's reservations and expenses, with tourist tax on its own line.
- Match the totals to your bank and write down what explains each gap.
- Book an hour with an accountant to confirm how your country treats tourist tax, VAT and record keeping.
FAQ
Is bookkeeping for Airbnb different from other rentals?
The categories are the same. What changes is where the data comes from: Airbnb deducts its fee before paying you, while Booking.com may invoice commission separately. Record each channel from its own report.
How do I start accounting for Airbnb income?
Start from the earnings report or CSV, not the bank. It shows gross earnings, host service fees and taxes withheld per reservation, which is what your ledger needs.
Do I need bookkeeping software for a short-term rental?
A spreadsheet works for many small hosts with a few units. Consider software or an accountant once you're VAT-registered, operate as a company or manage other owners' money.
Free tool: BookBed's Airbnb fee calculator breaks a booking into guest price, host fee and payout, so you can check what each Airbnb reservation should add to your ledger before the payout arrives.
Sources
- Airbnb Help Center, "Download your earnings" — Verified 2026-09-30
- Airbnb Help Center, "Airbnb service fees" — Verified 2026-09-30
- Airbnb Help Center, "Areas where tax collection and remittance by Airbnb is available" — Verified 2026-09-30
- Booking.com for Partners, "Reviewing your reservation statement" — Verified 2026-09-30
- Booking.com for Partners, "Paying your invoices from Booking.com" — Verified 2026-09-30