Your Airbnb transaction history lives in the Earnings dashboard, under the Paid tab, and it exports as a CSV with one row for every charge and fee. What it will not do is match the payout that lands in your bank account inside the same calendar month. Airbnb settles any stay of 28 nights or more in monthly installments and can hold a payout up to 45 days after check-in, so match each payout line back to its booking on the reservation confirmation code.
If you run eight to twenty-five units, this is the job that quietly eats a Sunday every month.
Where do I find my Airbnb transaction history?
Transaction history is the exportable log of every earning line in your Earnings dashboard, one row per charge, and it is a different file from the monthly payout report and the annual earnings summary. Airbnb's own page describes the dashboard as carrying gross earnings, all transactions and the Export CSV option in one place, checked on September 2026.
To get the files you need:
- Open the Earnings dashboard and select the Paid tab. The Upcoming tab lists money Airbnb has promised but not yet released, and the Paid tab lists money already in your account. Only the Paid tab will ever match a bank statement.
- Filter by date, listing and earnings type, then export to CSV. The spreadsheet carries earnings, host service fees, cleaning fee where you charge one, gross earnings and any taxes withheld for each earning.
- Select a row when a line looks wrong. The detail view shows the reservation information, the adjustments and the cancellation details. It also shows the confirmation code.
- Pull tax documents from Account settings for a prior year. Airbnb keeps up to four years of them.
Pull the CSV export. The PDF summary only shows a period total, and you need the individual lines underneath that total to do the matching.
Why do my payout export and my activity export disagree?
Your transaction history dates each booking to the day its charge posted, but your payout is dated to whenever Airbnb actually deposits the money into your bank account, after its service fee and any other charges come out, so a booking charged in August can sit outside your payout export until September. Airbnb publishes its own list of reasons a payout will not match the price on your listing, and it runs to eleven items.
| What Airbnb lists | What it does to your month |
|---|---|
| Calendar pricing | A date-level override set months ago and easy to forget |
| Length-of-stay discounts | A weekly or monthly discount spread across the whole booking |
| Monthly stays | One reservation paid in installments, so one booking becomes several payout lines |
| Co-Host payouts | A share routed elsewhere before the money reaches you |
| Routing rules or minimum payout amounts | Money held back or split across accounts by a rule you set once |
| VAT | Tax deducted at source in some countries, absent in others |
| Processing fee | A deduction taken before the deposit, so the bank figure is already net |
| Fast Pay fee | A charge for being paid sooner, which also moves the payout date |
| Currency exchange | A rate locked in on the day of release, days after the booking was made |
| Adjustment fee | Money owed back, taken out of a later payout entirely |
| Host coupon | A discount you issued, netted off the total |
Airbnb publishes these reasons on its page on calculating your payout, checked on September 2026. Three of the eleven cause most of the reconciliation headaches on a small property's books.
A stay of 28 nights or more is paid in installments
Airbnb's page on payouts for monthly stays states that for reservations of 28 nights or more it collects payments monthly, and releases the payouts after the initial one monthly for the duration of the reservation. A six week booking taken in March becomes two payout lines in two different months, both tracing back to the same reservation, and neither month's file holds the full total on its own.
A payout can sit for up to 45 days after the guest checks in
Some payouts go to review. Airbnb's page on when you will get your payout says this can result in funds being delayed up to 45 days after guest check-in, paused, or in rare cases removed. Forty-five days is enough to push a payout two calendar months clear of the stay it came from.
The page has headings for shorter stays, monthly stays, new hosts and listings with issues, promising the exact release day count for each. Checked on September 2026, every one of those headings sat empty, with no text underneath. The help page will not tell you which month a given stay's money lands in, and the matching has to be done on a code after the fact.
An adjustment lands on a later payout than the booking it came from
Airbnb defines an adjustment as money a host owes as a result of a cancellation, a reservation change, or a violation of its Guest Refund Policy, and says adjustments will be automatically deducted from the next scheduled payouts. A cancellation on a January booking then shows up as a smaller February payout, tacked onto a completely different stay. The February file will not explain the shortfall on its own.
Can I find a booking by the guest's name or the amount?
No. Airbnb's earnings page says you can search for specific transactions using the reservation confirmation code or payout amount, and there is no guest name field anywhere on it, checked on September 2026. A confirmation code is the short code Airbnb attaches to a single reservation. Airbnb puts it in the guest's reservation details and the booking confirmation email, and shows it in the transaction detail under a field labeled Confirmation.
The amount is no better as a key. Guesty's walkthrough for tracing a payout says plainly that a payout includes the processed amount from one or more reservations, published September 2026, and that it excludes processing fees and any funds Airbnb holds back in reserve. So one deposit can settle several stays, and the figure that reaches your bank appears nowhere in your own records.
At MINT, our own apartments in Vienna, a name-only search for a booking returned the wrong match almost every time, so we match booking records there on an ID. We searched by first name only and got 11 false matches out of 12 attempts. Only the reservation number reliably identifies one booking. A guest name can belong to several reservations, and a dollar amount often covers more than one stay bundled into a single deposit. Matching totals on a spreadsheet does not mean the bookings underneath are individually correct, and the FAQ walks through why.
The bridge tab that matches a payout to its booking
A bridge tab is one sheet with a row per booking, holding the booking's own identifier next to the payout that settled it. The bridge tab works as a matching checklist, holding the two exports side by side so each one checks the other.
| Column | What goes in it | Where it comes from |
|---|---|---|
| Confirmation code | The reservation code, one per booking, typed or pasted exactly | The transaction detail, under Confirmation, or your property system's reservation record |
| Payout date and amount | Every payout line that touched this booking, one row each if there are several | The payout export, or your payment provider's own payout report |
| Invoice total | What you billed the guest, gross, before any platform fee | Your invoicing tool |
We checked every source in that table in September 2026. Building it takes an afternoon the first time and about twenty minutes a month after that.
- Export the transaction history for the month, and the payout report for that month plus the two either side of it. The neighboring months are where the installments and the held payouts are.
- Put every payout line into the bridge, one row per line, never one row per deposit.
- Fill in the confirmation code for each line. Where a deposit bundles several stays, split it into as many rows as there are codes.
- Add your invoice total for each code from your own records.
- Sort by code. If a code has payout rows but no invoice, that booking never got billed. If an invoice has no payout row yet, either you have not been paid, or the payout is sitting in next month's file.
- Keep the tab running month to month. A booking that starts in March can still be settling in May, with a payout line landing long after the stay itself is over.
Take last month and check two things. Does every invoice carry exactly one confirmation code? Does every payout line's code appear somewhere in your invoice list? A row that fails either question stays in the bridge until you sort out why.
The property systems' own reconciliation screens use this same code. Guesty's reconciliation tool searches by date range, payout ID or reservation confirmation code, with no name field anywhere and no more than 31 days pulled at once, checked on September 2026. GuestyPay's reconciliation screen puts the codes behind a payout under a column named Merchant Transaction ID. Stripe ships a payout reconciliation report to match the payouts you receive in your bank account with the batches of payments and other transactions that they relate to, and says outright that for an instant payout it cannot identify which transactions are included, so the merchant reconciles those.
We built the same tab at MINT first, before anything else there, after a booking's payments split across two monthly exports and we learned that a single month's payout file is never proof of what a booking paid: installments, refunds and settlement timing routinely spread one booking's money across two calendar months. We did not replace anything to get there. easybill still cuts every invoice. My team at Ekamoira connected it to the property system so the reservation code travels along with the invoice. Stripe still carries the cards on the direct booking side. See it worked out, month by month, in the reconciliation we built for MINT.
What does my accountant actually need each month?
Your accountant needs both exports, together with the bridge that joins them. Airbnb gives the same instruction: its guidance on US tax documents tells hosts to use the Earnings Summary and Transaction History to reconcile Form 1099-K, checked on September 2026.
Gross earnings is what the guest paid, before Airbnb's service fee comes off. Under the single fee structure Airbnb charges most hosts 15.5%, typically 14% to 16% for everyone else and 16% in Brazil and Mexico, deducted directly from the payout. That structure is mandatory for anyone running property management software, so it is not negotiable at the booking level. A Form 1099-K is the information return a payment platform files with the IRS reporting what it paid you in a year.
| Figure | What it is | Where it comes from |
|---|---|---|
| Gross earnings | The full guest-paid total before any fee or adjustment | Transaction history, Amount plus Host Fee columns |
| Host service fee | Airbnb's cut, already deducted | Transaction history and the earnings report |
| Net payout | What actually reached your bank | Payout export and your bank statement |
| Taxes withheld | Anything held back at source | The monthly or annual earnings report |
We checked this in September 2026 against Airbnb's download your earnings page, which describes the report as a breakdown of gross earnings, adjustments, host service fee, any taxes withheld, and total net pay. The IRS restored the reporting rule that was in place before the American Rescue Plan Act of 2021 lowered it, so a platform is not required to file a 1099-K unless gross reportable payments to you exceed $20,000 and the number of transactions exceeds 200. At eight to twenty-five units you are over both, but a single listing held under separate ownership may not be, and the income stays reportable whether or not a form arrives.
The form itself only reports gross earnings before adjustments. Airbnb states that the totals on the 1099-K are Gross Earnings before adjustments such as resolutions, cancellations and Airbnb fees, and points hosts at the Gross Transaction History and Earnings Report to reconcile net payouts against it. Its own steps tell you to uncheck the Resolution Adjustment and Payout types under the Type column, then total the Amount and Host Fee columns to reach the figure that should correspond to Box 1a.
At MINT the gap between Airbnb gross earnings and payout on one prior invoice batch came to about €1,006 before we corrected how the invoices were cut. Platform invoices are cut on the full guest paid gross, the amount before commission, because the customer of record is the guest. The invoices we cut at MINT run under Austrian rules, so the tax forms carry different names, but the arithmetic underneath is the one you are doing.
Lodging tax moves between the platform and you depending on the channel and the state, and your bookkeeper will ask about it. We wrote up where occupancy tax appears in a reconciliation separately, and it is worth reading before you decide which figure counts as revenue.
If you would rather not build this yourself
Fullstreak is the direct booking practice at Ekamoira: we build the site that takes the booking, and we wire the property system, the payments and the invoicing so a booking carries one identifier from first inquiry to the deposit in your account. The whole system goes live in about three weeks. We take on properties past roughly $350,000 a year of bookings, because under that the commission we win back does not pay for the work in year one, and I would rather say so than take the fee.
Airbnb's 15.5% commission applies to every stay regardless of whether you can trace a given deposit back to it. Book the call and bring last month's two exports.