Bank Reconciliation for Short-Term Rentals: A Step-by-Step Guide

Reconciliation is where the truth comes out

Bank reconciliation is the moment your books meet reality. You take what your accounting software says happened and compare it against what your bank statement says happened, line by line, until the two agree. For most businesses this is tedious but straightforward. For short-term rental hosts it is the single most painful part of the month, because the figures almost never line up cleanly — and the reason they do not is built into how the platforms pay you.

This guide explains why short-term rental reconciliation is uniquely awkward, walks through a reliable step-by-step method, and shows how Airflow removes most of the manual matching. It is part of our wider guide to accounting for short-term rentals.

Why hosts' payouts never match their invoices

If you invoice a guest for £600 and the matching payout that lands in your bank is £510, your reconciliation has a problem before you start. The gap is not an error — it is the platform's fee, deducted before the money reached you. Multiply that across dozens of bookings and several platforms, and you get a bank statement full of round-ish numbers that correspond to no single invoice.

Three platform habits cause most of the pain:

• Fees are netted out. The guest pays gross; you receive net. The difference is the platform's commission, invisible unless you record it deliberately.
• Payouts are batched. Booking.com and others frequently roll several bookings into one transfer, so one bank line maps to many invoices.
• Currency is converted. A booking priced in euros can land in your sterling account at a rate the platform chose, on a date you did not pick.

We cover the mechanics of this in detail in why your Airbnb payouts don't match your invoices and the broader pattern across platforms in OTA payouts don't match. The short version: if your invoices only ever record the net payout, your books will reconcile easily and be wrong. If they record gross income and fees correctly, they will be right and harder to reconcile by hand — which is the problem this guide solves.

The step-by-step method

Done manually, a sound reconciliation for a rental business looks like this:

1. Export your bank transactions for the period from your bank or accounting software.
2. List your draft and approved invoices for the same period, each showing gross income and the platform fee separately.
3. Group invoices by payout. For batched platforms, work out which bookings were settled in each transfer.
4. Match each bank deposit to its invoice group. The deposit should equal the gross of those invoices minus the platform fees.
5. Account for the fee. Where the deposit is short by exactly the commission, the fee expense explains the gap — confirm it is recorded.
6. Handle currency. Where a foreign-currency booking landed in your home currency, record the conversion and any FX difference rather than forcing a match.
7. Flag the outliers. Refunds, chargebacks, adjustments and held deposits will not fit the pattern; set them aside for individual treatment.
8. Confirm the period balances. Once every deposit is explained, your bank balance and your books should agree.

The method is not complicated. What makes it exhausting is volume and the batching step — pulling apart one transfer into the four or five bookings it actually settled, then proving each one nets correctly.

Where it goes wrong

The failures are predictable. A host short on time folds the cleaning fee into accommodation, drops the platform fee entirely, or replaces the guest with a generic "Airbnb" contact. Each shortcut makes one reconciliation faster and the next twelve harder, because the underlying detail that lets a deposit be explained has been erased.

The most common outcome is a "reconciliation" that balances only because income was recorded net. The books agree with the bank, but they understate revenue and hide every penny of platform cost — so the P&L is fiction and the tax return is wrong. A reconciliation that hides errors is worse than one that surfaces them.

How Airflow makes deposits explainable

Airflow does not reconcile your bank for you — your accounting software does that, and it does it well once the underlying invoices are right. What Airflow does is make every deposit explainable by creating the correctly structured invoice in the first place.

You forward a booking email, or connect Gmail or Outlook so new bookings are picked up automatically. Airflow's extractor reads the email and pulls out the guest, dates, nightly rate, cleaning fee, platform service fee, host payout, currency and booking reference. From that it builds a draft invoice in your accounting software with:

• Gross income and the platform fee on separate lines, so the difference between what the guest paid and what you received is recorded, not erased
• The booking reference preserved, so any bank deposit can be traced back to its source booking
• Currency converted at invoice time with the rate, source and timestamp logged, so FX differences are documented rather than guessed
• Deduplicated guest contacts, so refunds and adjustments tie back to the original invoice

Every invoice lands as a draft you review and approve — nothing posts to your books on its own. When the payout arrives, your accounting software's bank rules can match it to the right invoice because the amounts, reference and dates line up, and the netted fee is already accounted for. The reconciliation that used to be an afternoon of detective work becomes a confirmation.

Airflow connects to Xero, QuickBooks, Sage and FreshBooks, so the approach is not tied to one package. More on the full picture in automated accounting for hosts.

A note on batched and multi-currency payouts

Two situations deserve extra care, and they are exactly the ones hosts dread.

For batched payouts, the trick is having each booking already recorded as its own invoice with its own reference, so a single transfer can be matched to the group of invoices it settled. Without per-booking invoices, you are reverse-engineering a lump sum; with them, you are confirming a sum.

For multi-currency, the goal is to document the conversion rather than fight it. Because Airflow records the rate and source used at invoice time, any difference between that and what your bank actually gave you is a small, explainable FX line — not a mystery that blocks the whole reconciliation. We go deeper on this in multi-currency is breaking your spreadsheet.

Reconciliation should be a confirmation

The aim is not to make reconciliation disappear — it is a genuine control, and you want to keep doing it. The aim is to make it honest and quick: every deposit explained, every fee accounted for, every currency conversion documented, so the monthly check confirms what you already know rather than uncovering a mess you have to fix.

For the wider context, read the complete short-term rental accounting guide, and when filing season comes, getting your books ready in a weekend shows how clean, reconciled invoices make it painless.

Get started — early access includes 3 months free. Connect your accounting software, forward a booking email, and review the draft invoice that appears. A card is required at checkout, with no charge during the free period.