fullstreak
Direct booking13 minute read

Airbnb transaction history: how to match payouts to bookings

Christian, Co-founder, Fullstreak; co-owner, MINT @Naschmarkt, Vienna

Published
At a glance
Who this is for
Operators for whom platform commission is the largest line they do not control.
What you get
Your Airbnb payout export and your transaction history will never tie out inside one calendar month, because the two files are dated on different clocks. Here is why, and the bridge tab that ties every payout line back to its booking.
In this piece
6 sections, 13 minute read
Published
Filed under
Direct booking

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:

  1. 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.
  2. 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.
  3. 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.
  4. 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.

  1. 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.
  2. Put every payout line into the bridge, one row per line, never one row per deposit.
  3. Fill in the confirmation code for each line. Where a deposit bundles several stays, split it into as many rows as there are codes.
  4. Add your invoice total for each code from your own records.
  5. 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.
  6. 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.

Questions operators ask

Why does my Airbnb payout not match my nightly rate?
Airbnb publishes eleven reasons, including calendar pricing, length-of-stay discounts, monthly stay installments, co-host payouts, routing rules, VAT, processing and Fast Pay fees, currency exchange, adjustment fees and host coupons. For a small property the big three are installments on stays of 28 nights or more, payouts held for review, and adjustments taken out of a later payout. Installments, holds and adjustments are standard parts of how Airbnb pays out, and none of them will show up in the nightly rate you set.
Can I search Airbnb for a booking by the guest's name?
No. Airbnb's earnings search accepts the reservation confirmation code or the payout amount, and there is no guest name field. The amount is unreliable as well, because one payout can settle several reservations at once. Use the confirmation code, which is unique to one reservation and appears in the transaction detail and the booking confirmation email.
What is the difference between gross earnings and my payout?
Gross earnings is the full amount the guest paid before Airbnb's service fee and any adjustments. The payout is what reached your bank after those deductions. Under the single fee structure Airbnb charges most hosts 15.5%, and typically 14% to 16% for everyone else. Your tax form reports the gross figure, so it will always read higher than your net payout.
How do I download my Airbnb transaction history?
Go to the Earnings dashboard, choose Upcoming or Paid, filter by date, listing and earnings type, then export to CSV. The export carries earnings, host service fees, a cleaning fee where you charge one, gross earnings and taxes withheld for each earning. Download the CSV export. The summary PDF only totals the period, and the reconciliation needs the line-by-line detail that only the CSV includes.
Will I get a 1099-K from Airbnb?
Only above the federal threshold. The IRS restored the pre-2021 reporting rule, so a platform must file a 1099-K only when gross reportable payments to you exceed $20,000 and the number of transactions exceeds 200 in a calendar year. Operators at eight to twenty-five units clear both. If no form arrives, the income is still reportable and your own records are the only evidence of it.
How long can Airbnb hold a payout?
Up to 45 days after guest check-in where a payout goes to review, and Airbnb also reserves the right to pause a payout or, in rare cases, remove it. Its help page carries no plain-text release day count per reservation type, so the landing month cannot be predicted in advance. Reconcile on the confirmation code and pull the neighboring months' exports.
What does my bookkeeper need from me each month?
The transaction history CSV, the payout report, and the bridge that ties them together on the confirmation code. Airbnb's own guidance is to use the Earnings Summary and the Transaction History together. Send the bank statement too, so your bookkeeper can match deposits to payout lines directly.

Who wrote this

Christian

Co-founder, Fullstreak; co-owner, MINT @Naschmarkt, Vienna

I own MINT @Naschmarkt in Vienna with Maxine, and I run Ekamoira, the agency Fullstreak came out of. Almost every booking we took arrived through the platforms, so we built the site that takes the booking, the plumbing that keeps one calendar, and the pages Google and the AI assistants quote. MINT ran it first. Fullstreak is that work, made repeatable for operators like you.

MINT @Naschmarkt, Vienna

Every vendor claim traces to the vendor's own page, checked on the month shown under each table. MINT numbers come from our own books.

See where your own bookings leak.

Twenty minutes on a call. You get a read on where your bookings start today, what the platforms take, and what a direct channel would take to build. It is yours whether or not you hire us.

Ask an assistant about this page

ChatGPTOpensClaudeOpens

The question is written for you. Nothing is sent until you send it.

Share this post

Get the next one by email

New posts when they land, and the numbers behind them. Write to us any time to come off the list.

By subscribing you agree that we store your email address and this consent line. The address is used for the letter alone, and we delete it whenever you ask at hello@fullstreak.com.

Book a call

Twenty minutes, prepared for your property.

Fullstreak, a brand of Ekamoira Digital GmbH, will send you text messages about your enquiry and your call, at most a few a month. Consent is not a condition of any purchase. Message and data rates may apply. Reply STOP to any message to opt out, or HELP for help.

TermsPrivacy