Reconcile Airbnb Payouts to Your Bank Statement

TL;DR An Airbnb payout on your bank statement is a net figure: the booking's accommodation and cleaning fees, minus the host service fee, plus or minus any adjustments, and sometimes several reservations bundled together. To reconcile, download your Airbnb earnings or transaction history for the month, match each payout to a deposit on your bank statement by amount and date, then break each payout into its parts so your books show gross rental income, cleaning fees, host fees and adjustments separately. Treat any occupancy taxes Airbnb collects and remits on your behalf as not your income. Payout timing follows check-in, not booking, so a payout can land in a different month from the stay. Reconcile monthly and keep the exports with your bank statements.

If you host on Airbnb, your bank statement probably shows a series of deposits from Airbnb with amounts that don't obviously match any booking. One might be a single three-night stay minus fees; another might combine two reservations and a damage claim reimbursement. If you record those deposits as income, your rental income is understated (because fees are already deducted), your expenses are understated (because the fees never appear), and your tax figures are wrong in both directions.

This guide shows how to reconcile Airbnb payouts to your bank statement step by step, with a worked example and a monthly routine. Airbnb's host dashboard and reports change from time to time, and fee structures depend on your settings and location, so we describe the process in general terms. Check your own reports for the exact fields available to you. Tax points here are general information, not tax advice.

How Airbnb payouts work

Understanding the money flow makes reconciliation much easier.

The guest pays Airbnb, not you. When a guest books, they pay Airbnb. Airbnb holds the money and releases it to you later.

Payouts are released after check-in. Airbnb generally sends the payout for a reservation shortly after the guest checks in, not when they book. For longer stays, payouts may be released in instalments. Then your bank needs time to receive it, which depends on the payout method you've chosen.

Fees are deducted before you're paid. Airbnb charges hosts a service fee. Depending on your fee structure, the host fee may be a small percentage with the guest paying a separate service fee, or a larger host-only fee. Either way, what reaches your bank is after the host fee.

Several items can be combined. A payout may cover one reservation, several reservations, or a reservation plus an adjustment, such as a refund to a guest, a cancellation, or a reimbursement.

Taxes may be handled by Airbnb. In some places, Airbnb collects and remits occupancy or tourist taxes directly. Those taxes are not part of your income. In other places, hosts are responsible for collecting and paying them. Check the rules for your location.

What to download

You need three things for each month:

1. Your bank statement, converted to rows. If it's a PDF, SheetStatement converts it to Excel or CSV with a balance check; the free plan covers 3 pages a month.
2. Airbnb's payout or transaction history for the month. Hosts can usually view earnings and download a report of completed payouts and their underlying reservations. Look for a report that shows, per payout, the date, the amount, and which reservations or adjustments it includes.
3. Booking details for any reservation you need to break down: nights, accommodation amount, cleaning fee, host fee and any taxes.

Download a slightly wider date range than the month itself, a few days either side, because a payout sent at the end of one month often arrives in your bank at the start of the next.

Step 1: match payouts to bank deposits

Put the Airbnb payouts on one sheet and the bank deposits from Airbnb on another. On the bank sheet, filter descriptions for Airbnb. The exact wording depends on your bank.

Match each payout to a deposit by amount, allowing a few days' difference in date. With payouts in a table named Payouts (columns PayoutDate, Amount) and bank rows in Bank (Date, Description, Amount), a lookup like this finds the matching bank date:

=XLOOKUP(1, (Bank[Amount]=[@Amount]) * (ABS(Bank[Date]-[@PayoutDate])<=5), Bank[Date], "Not found")

That returns the bank date for a deposit of the same amount within five days. Our guide to matching bank transactions with XLOOKUP explains this pattern and how to handle two payouts with the same amount.

Then check the totals:

=SUM(Payouts[Amount]) - SUMIFS(Bank[Amount], Bank[Description], "*AIRBNB*")

Adjust the wildcard text to match your bank's description. Zero means every payout in the period reached the bank. A non-zero result usually means a payout is in transit across the month boundary, or a deposit was returned.

Step 2: break each payout into its parts

This is where reconciliation turns into proper bookkeeping. For each payout, rebuild it from the reservation details:

Accommodation + Cleaning fee + Other host charges − Host service fee ± Adjustments = Payout

Taxes collected and remitted by Airbnb don't appear in this equation, because they never pass through your hands. If your reports show them, list them for reference but keep them out of income.

Build a breakdown table:

With a check column:

=ROUND([@Accommodation]+[@Cleaning]-[@[Host fee]]+[@Adjustments]-[@Payout], 2)

Every row should show zero. If not, look in the reservation details for something you've missed, such as an extra guest fee, a pet fee, a discount, or a partial refund.

Step 3: record it in your books

With the breakdown, you can record each payout properly. A typical approach:

• Rental income for the accommodation amount.
• Cleaning fee income, either in its own income account or within rental income, depending on how you or your accountant prefer to report.
• Host service fees as an expense, such as Platform or commission fees.
• Adjustments to the category they relate to: refunds to guests reduce income; reimbursements for damage might offset a repair expense.
• The bank deposit for the net payout.

In QuickBooks or Xero, you can record this as a single deposit with several lines, or post the gross income and fees through a clearing account and then match the bank deposit to it. Our guides to importing bank statements into QuickBooks Online and the Xero bank reconciliation process cover the matching side.

If you keep your books in a spreadsheet, keep the breakdown table as your income record and link it to the bank deposits by payout date. Our rental property bookkeeping guide shows a full structure for income and expenses by property.

Step 4: deal with timing

Payouts follow check-in, so they don't line up neatly with calendar months.

• A guest who books in May for a stay in July generates nothing until July.
• A guest who checks in on 30 June may be paid out in late June or early July, and the deposit may land in July.
• A long stay crossing a month end may be paid in parts.

For a cash-basis view, which many small hosts use, income is recorded when the money is received. For an accrual view, income relates to the nights stayed. Which applies to you depends on how you keep your books and the tax rules where you are; ask an accountant if you're unsure.

Practically, at month end, list:

• Payouts sent but not yet in the bank (in transit). These explain differences in Step 1.
• Reservations checked in but not yet paid out. These matter if you use accruals.

A worked example

A host with one apartment has these Airbnb payouts in a month:

The host fee here is an illustrative 3% of accommodation plus cleaning; your actual fee depends on your account settings. Guest C's adjustment is a $50 partial refund for a broken coffee machine.

Check each row: Guest A, 360 + 60 − 12.60 = 407.40. Guest B, 575 + 60 − 19.05 = 615.95. Guest C, 250 + 60 − 9.30 − 50 = 250.70. Guest D, 480 + 60 − 16.20 = 523.80. All zero differences.

The bank statement shows Airbnb deposits on Aug 4 ($407.40), Aug 11 ($615.95) and Aug 19 ($250.70). The $523.80 payout sent on Aug 25 isn't on the August statement; it appears on Sep 1. So:

• Total payouts in August: $1,797.85.
• Airbnb deposits on the August bank statement: $1,274.05.
• Difference: $523.80, the payout in transit.

The reconciliation is complete with one timing item.

For the books (cash basis, August): accommodation income $1,185.00 (Guests A to C), cleaning fee income $180.00, host fees $40.95, refund $50.00. Net: 1,185.00 + 180.00 − 40.95 − 50.00 = $1,274.05, which equals the bank deposits. Guest D's payout goes into September.

Look at what you'd have reported if you'd just recorded deposits: $1,274.05 of income and no fees. With the breakdown, income is $1,365.00 gross, with $40.95 of fees and a $50.00 refund. Both get you to the same cash, but only the breakdown tells you what the property actually earned and cost.

Co-hosts, multiple listings and payout methods

Multiple listings. If you host several properties, add a Listing column to the breakdown so you can produce income per property. That matters for both performance and, in many places, tax reporting.

Co-hosts. If a co-host receives part of the payout directly, your payout is smaller than the full reservation amount. Record your share properly and keep the co-host arrangement documented; how to treat payments to co-hosts depends on your setup, so ask your accountant.

Several payout methods. If you route payouts to more than one bank account, reconcile each account separately and make sure every payout is matched in exactly one place.

Currency. If your payouts are in a different currency from your listing price, the bank deposit reflects conversion. Record the amount that actually reached your bank and note the original amount.

Refunds, claims and cancellations

Adjustments are where most Airbnb reconciliations go wrong, because they can arrive at different times from the reservation they relate to.

Partial refunds to guests. If you agree to refund part of a stay, the refund may be deducted from that reservation's payout, or from a later payout if the original has already been paid. Either way, record it as a reduction of rental income (or a separate refunds account that reduces income), and link it to the original reservation in a Notes column.

Cancellations. If a guest cancels before check-in, there may be no payout at all, or a partial payout under your cancellation policy. If the reservation was already paid and then cancelled, a negative adjustment can appear on a later payout. Make sure your breakdown shows it so the later payout still reconciles.

Damage reimbursements. If you receive money for damage, record it against the cost it relates to. If you paid $120 to replace a lamp and were reimbursed $120, the net cost is zero; recording the reimbursement as rental income would overstate income and leave the repair expense in your figures. Keep the claim reference with the bank deposit.

Payouts that go negative. Occasionally an adjustment is larger than the next payout. Airbnb may then recover the balance from future payouts. Track the outstanding amount until it clears, so you don't lose sight of it.

The other half: expenses paid from the bank

Reconciling payouts covers income, but a short-term rental also has costs that go through your bank account or card: cleaners, laundry, supplies, utilities, internet, repairs, insurance and, depending on your arrangement, mortgage interest or rent. Convert the bank and card statements for the same month, categorise those payments, and add a Listing column so costs and income sit side by side for each property. Our guide to categorising business expenses from bank statements shows a reliable system.

Once both halves are in place, a simple pivot table by listing and month gives you net income per property, which is what most hosts actually want to know.

Monthly routine

1. Convert the month's bank statement and confirm the opening and closing balances.
2. Download Airbnb's payout history for the month plus a few days either side.
3. Match payouts to deposits; list any in transit.
4. Break each payout into accommodation, cleaning, fees and adjustments.
5. Record the breakdown in your books or spreadsheet.
6. Save the exports with the bank statement.

Doing this monthly rather than once a year has real advantages. Airbnb's reports are easiest to download and understand while the reservations are recent, and you'll still remember why a guest received a partial refund or why a payout was split. Problems such as a payout returned because of outdated bank details are also much easier to fix within weeks than months later. A typical month for a single listing takes a short session once the workbook is set up, because the matching formulas and breakdown table carry over from one month to the next. Copy last month's sheet, paste in the new data, and work through the checks.

At year end, add up the breakdown for gross income and fees, and compare the totals with any annual summary or tax form Airbnb provides. Our guide to reconciling 1099-K forms to bank deposits explains how to approach a form that reports gross amounts while your bank shows net.

Common problems

Deposit doesn't match any single payout. It may combine several reservations. Look for payouts on the same date and add them up.

Payout smaller than expected. Check for a refund, a cancellation adjustment, or a different fee structure.

Deposit missing. It may be in transit across the month end, held, or returned because of a bank detail problem. Check the payout status in Airbnb.

Income looks too low compared with bookings. You're probably recording net deposits as income. Use the breakdown.

Taxes included in income. If Airbnb collects and remits occupancy taxes, remove them from income.

For similar marketplace reconciliations, see our guides for Etsy deposits and Shopify payouts.

Get your bank deposits into a spreadsheet

Upload your bank statement PDF to SheetStatement, confirm the balances, and export the deposits to Excel for matching. The free plan covers 3 pages a month; paid plans are $9, $19 and $39 a month.

FAQ

Why doesn't my Airbnb deposit match the booking price?

The deposit is net of the host service fee and any adjustments, and may combine several reservations. Taxes collected and remitted by Airbnb are not paid to you.

Should I record Airbnb deposits as rental income?

Record gross accommodation and cleaning income, with host fees as an expense and adjustments shown separately. The net equals the deposit, but the breakdown gives accurate figures.

When does Airbnb pay hosts?

Generally shortly after guest check-in, with longer stays sometimes paid in instalments. Bank processing time depends on your payout method.

What if a payout arrives in the next month?

List it as in transit at month end. It will appear on the next bank statement and reconcile then.

Are occupancy taxes collected by Airbnb my income?

Where Airbnb collects and remits them, they're not your income. Rules vary by location, so check local requirements.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Paid plans are Starter at $9 a month, Pro at $19 and Business at $39.