Start with Paid earnings, not reservation totals
Airbnb’s Earnings dashboard allows hosts to review Paid earnings and export them to a spreadsheet. Airbnb also notes that paid earnings can combine earnings from multiple listings or reservations into one payout. That means bank reconciliation should operate at payout level rather than trying to match every reservation directly to the bank.
Airbnb’s own tax reconciliation guidance also identifies Payout as a value in the CSV Type column. This tool uses those payout rows as the expected bank receipts.
Use the bank account that actually receives Airbnb payouts
Export transactions from the receiving account for the period you are reviewing. Include several days beyond the Airbnb payout date because bank posting timing can depend on payout method and processing time.
The reconciliation checks amount eligibility first, then applies a configurable date window. A payout reference found in the bank description can help narrow candidates, but it does not override an amount or date mismatch.
Interpret the exceptions separately
Airbnb payout not in bank
The Earnings export contains a payout row but no eligible bank deposit was found. Check the bank period, description filter, posting delay, payout method, and whether the payout was routed to a different account.
Bank-only deposit
A bank row passed the Airbnb filter but was not matched to a payout in the uploaded export. The bank filter may be too broad, the Airbnb export may be incomplete, or the transaction may belong to a different settlement source.
Ambiguous
More than one one-to-one assignment remains valid. The tool leaves that uncertainty unresolved rather than choosing whichever row appears first.
What a clean reconciliation means
A clean result means every uploaded payout row has one unique eligible bank counterpart and there are no remaining bank-only or ambiguous candidates. It does not replace bookkeeping, tax advice, or verification of reservation-level revenue recognition.