Ask a short-term rental operator what they earned last month and you'll usually get two numbers: what the platforms say, and what actually landed in the bank. They never match, and the gap isn't an error — it's commission, taxes, deposits, refunds, and payout timing, all mixed together in a single bank line that arrives a week later.
This is why STR bookkeeping quietly becomes a monthly ordeal somewhere between the third and fifth property. Not because hosts can't do accounts, but because the shape of the data an OTA gives you doesn't fit the shape an accounting system needs.
Here's what actually breaks, and what a proper sync between your property management system and Xero fixes.
Five reasons the books don't match
1. OTA payouts arrive net, aggregated, and late. A guest pays ₹40,000. Airbnb takes its cut, holds the money until after check-in, then pays you a batch covering several reservations at once. What hits the bank is one number that maps to no single booking. Reconciling it by hand means unpicking a payout into its component stays every single time.
2. Security deposits are not revenue. A deposit you're holding is a liability — money that belongs to the guest until you decide otherwise. Booked as income, it inflates your revenue, then inflates your tax bill, then has to be unpicked when you refund it. Most spreadsheets get this wrong, and most hosts don't discover it until an accountant asks.
3. Refunds and cancellations arrive after the invoice. A stay is invoiced in March, cancelled in April, partially refunded in May. Accounting systems handle this properly with credit notes against the original invoice. Ad-hoc bookkeeping handles it by editing the March figure, which quietly breaks every report that period already fed.
4. Cleaning fees, taxes and commission are different animals. Cleaning fees are revenue. Tourist tax collected on behalf of a municipality is a liability. OTA commission is an expense. When all three arrive inside one payout line and get booked as "income", the business looks more profitable than it is, and the tax position is wrong in a direction nobody enjoys discovering.
5. Multi-currency, if you operate across borders. A villa in Bali earning IDR, an apartment in India earning INR, and a Xero organisation whose base currency is neither. Rates move between the booking, the payment and the payout, and each of those is a different number.
None of this is exotic. It's the ordinary shape of the business — which is precisely why doing it by hand doesn't scale.
Where spreadsheets stop working
One property, one platform: a spreadsheet is genuinely fine. The maths is small and you can hold the whole month in your head.
The break point is usually somewhere around five properties or the second sales channel. Reconciling a Booking.com payout against four reservations, three of which had modifications and one a partial refund, is an hour of work — and it recurs every payout cycle, forever. The hosts who stay on spreadsheets past this point generally aren't saving money; they're deferring the moment they find out what their margin actually is.
The second signal is when you start managing for owners. Owner statements require you to know, per property, what came in, what was spent, what commission you took and what's owed — and to be able to show it. That's an accounting question, not a spreadsheet one.
What a proper sync actually does
The goal isn't "export a CSV once a month". It's that every financial event in your operation lands in Xero as the right kind of record, automatically, with an audit trail.
In SympleHost, that means:
- A reservation becomes an invoice. Accommodation revenue, cleaning fees, other fees and taxes each land in the account you mapped them to, rather than as one lump.
- A payment becomes a payment against that invoice — so the invoice settles the way it actually settled, including part-payments.
- A security deposit is booked to a liability account, not to revenue. It stops being your income until you decide it is.
- A refund becomes a credit note against the original invoice, rather than an edit to a closed period.
- A cancellation is handled by state: an unpaid invoice is voided; a paid one stays, with the refund arriving as its own credit note.
- Expenses become bills, and owner payouts their own records, so managed properties reconcile without a side spreadsheet.
- The guest becomes a contact, so revenue is attributable to who actually stayed.
The point of all of that is one thing: at month end you're reviewing books that are already right, instead of assembling them.
Setting it up
Three steps, and the middle one is the one that matters.
1. Connect Xero. Standard OAuth — you authorise SympleHost from inside Xero, and no credentials live in our system beyond the encrypted token.
2. Map your chart of accounts. This is the step worth doing carefully, with your accountant if you have one. Before sync can be switched on, nine categories have to be pointed at real accounts in your Xero organisation:
- accommodation revenue
- cleaning fees
- other fees
- taxes collected
- OTA commission
- the payment bank account
- security deposit liability
- a default expense account
- owner payouts
That list is the fix. Every mapping is a decision that would otherwise be made ad hoc, differently, month to month — and the reason a synced set of books answers "what did the Goa villa actually earn in March" when a spreadsheet can't.
3. Check currencies before you switch it on. If your properties earn in currencies your Xero organisation doesn't have enabled, SympleHost warns you up front rather than failing halfway through a sync. Add them in Xero first; it takes a minute and saves an afternoon.
After that it runs on its own. Reservations, payments, refunds, expenses and payouts push as they happen.
When something doesn't sync
It will happen occasionally, and the useful question is always whose problem is it. SympleHost separates the two:
- Fix-the-booking errors — something in the reservation itself is incomplete or contradictory. These are yours to correct, and the message says what to correct.
- Sync problems — Xero is rate-limiting, temporarily unavailable, or an account mapping has gone missing. These retry on their own, and the ones that need you say so.
That distinction sounds small and isn't. The failure mode of most integrations is a list of red rows that all look equally urgent, so nobody triages them and the backlog becomes permanent.
What this doesn't replace
Worth being straight about: syncing your bookings into Xero is bookkeeping, not accounting. It gets the records right and in the right places. It does not decide your tax position, your depreciation, your entity structure, or whether that Bali villa should be held personally or in a company. If you're operating across borders, you still want an accountant — you'll just be paying them to think, rather than to sort out data entry.
Frequently asked questions
Does SympleHost integrate with Xero? Yes. Reservations sync to Xero as invoices, payments as payments, refunds as credit notes, expenses as bills, and owner payouts as their own records, with your chart of accounts mapped per revenue type. Connection is by OAuth from your Xero organisation.
How do I account for Airbnb payouts in Xero? The payout is not the revenue. Each reservation should be invoiced at its gross value with commission recorded as an expense and taxes as a liability, so that the payout reconciles against several invoices rather than being booked as income itself. Doing that by hand is the work a sync removes.
Are security deposits income? No — a deposit you're holding is a liability until it's either returned or applied against damage. Booking it as revenue overstates income and, in most jurisdictions, your tax. It should map to a separate liability account, which is why deposit mapping is one of the required steps at setup.
What's the best accounting software for vacation rentals? Xero and QuickBooks both work well; the deciding factor is usually which your accountant already uses and which your property management system can push to natively. What matters more than the choice is that the connection is native rather than a CSV export — the reconciliation problem is created by manual re-entry, and only removed by removing it.
Do I still need an accountant? For anything beyond a single property, yes. A sync makes the records correct and current; it doesn't make judgement calls about tax, structure or deductions.
Related Reads
あなたの共同ホストは、眠らない。だから、あなたは眠れる。
SympleHostを30日間無料でお試しください。初期費用は不要、いつでもキャンセルできます。オンライン通話での初期設定サポートもご利用いただけます。