How to reconcile Airbnb payouts to bank deposits
Your booking subtotal and bank deposit usually should not be the same. Airbnb may remove its host fee, combine several reservations into one payout, or include an adjustment. Reconciliation means rebuilding that path until the platform total and bank deposit agree.
The four amounts you are matching
| Amount | Plain-language meaning | Where to find it |
|---|---|---|
| Booking subtotal | The reservation amount before the host service fee | Platform earnings or transaction detail |
| Host fee | The amount the platform kept from that subtotal | Platform earnings or transaction detail |
| Expected payout | Booking subtotal minus host fee, adjusted for anything else shown | Your spreadsheet calculation |
| Actual payout | The deposit that reached your bank | Bank activity |
Do not start by comparing your nightly rate with the bank. A reservation can also include cleaning fees, extra guest fees, refunds, taxes withheld, or other adjustments. Start with the payout detail the platform actually shows.
Step 1: export the Airbnb earnings detail
On desktop, Airbnb currently directs hosts to the Earnings area, then Upcoming or Paid. Choose the listings, payout methods, and date range you need, select Get report, configure the fields, and create the report. The exported CSV can include gross earnings, host service fees, cleaning fees, and taxes withheld.
Source: Airbnb Help Center, “Download your earnings”, checked July 18, 2026. Menu labels can change, so use Airbnb's current instructions if your screen looks different.
Step 2: calculate the expected payout
For a simple reservation with no extra adjustment, the check is short:
If the bank also shows $464.75, the payout is matched. If it shows a different amount, do not force the spreadsheet to zero. Keep the difference visible and look for the missing line.
Step 3: use one row for each bank payout
A single Airbnb payout may contain one reservation or several. The cleanest rule is one spreadsheet row per bank deposit:
- For a single-reservation payout, enter that reservation's subtotal, host fee, and ID.
- For a batched payout, add the included subtotals together, add the host fees together, and keep every reservation ID in the ID or Notes field.
- Enter the actual deposit once—the same way it appears in the bank.
Batched-payout example
Reservation A should pay $464.75 and Reservation B should pay $337.25. Airbnb sends one bank deposit of $802.00. Record a single row with the combined booking subtotal, combined host fee, both reservation IDs, and $802.00 as the actual payout. The row should finish at MATCHED.
Step 4: investigate any difference
When expected payout minus bank deposit is not zero, check the platform detail for:
- a refund or resolution adjustment;
- tax withheld from the host payout;
- a cleaning fee or extra guest fee included in the subtotal;
- a currency conversion or payout-method fee;
- a reservation added to or removed from a batched payout; or
- a payout that is still pending and has not reached the bank yet.
Step 5: close the month while the details are fresh
- Export the completed month's paid transactions.
- Check that every platform payout appears in the sheet.
- Match every sheet row to one bank deposit.
- Resolve every row marked Check, or leave a clear note explaining the open item.
- Save the platform report and completed reconciliation with that month's records.
This is an organizing workflow, not tax advice. If your tax professional needs gross earnings, fees, taxes, or adjustments separated in a particular way, follow their instructions rather than guessing from a deposit.
Common payout questions
Why is my Airbnb payout lower than the booking total?
The platform normally removes the host service fee and may also show refunds, taxes withheld, or other adjustments. Use the transaction detail instead of estimating the gap from a headline percentage.
Why does one deposit contain several reservations?
Platforms can batch multiple reservation payouts. Add the included reservation amounts and fees, keep all reservation IDs together, and compare the combined expected payout with the single bank deposit.
Should the payout date equal the check-out date?
Not necessarily. The platform's release timing, weekends, bank processing, payout method, and account review can all affect when money arrives. Match by amount and payout detail as well as date.
Do I need accounting software for this?
No. A spreadsheet is enough for a small host if it preserves the subtotal, host fee, expected payout, actual deposit, and explanation for any difference.