Fixfolder

Airbnb payout question

How do I export my Airbnb transaction history as a CSV?

On desktop, Airbnb’s help page gives the path Today > Menu > Earnings, then Upcoming or Paid, then Export CSV. The monthly and annual statements Airbnb generates are a separate thing: those you download or email as a PDF.

Airbnb’s steps on desktop

Download your earnings (Help 3632) lists these steps under “Export a CSV file of earnings on desktop”:

  1. Click Today > Menu > Earnings
  2. Click Upcoming or Paid
  3. Filter dates, listings, and earnings types
  4. Click Export CSV
  5. Choose how to export the report and what to include
  6. Click Export CSV

The wording of these steps changed between our readings on 2026-10-30 and 2026-11-07. If your screen differs, follow the current help page.

About the name: Airbnb’s current help pages put the export under Earnings. An older Resource Center article (426, from 2021, updated 2022) says: “You’ll always be able to find a record of any payouts or adjustments in your transaction history.”

CSV file or PDF report

The PDF statements. “If you want to review your earnings, Airbnb automatically generates your monthly and annual statements.” And: “You can access reports as far back as the year you started hosting, break down by listing and payout method, and download or email each report as a PDF.” Each includes “A breakdown of gross earnings, adjustments, host service fee, any taxes withheld, and total net pay”.

The CSV file. “The CSV file can be opened by any standard spreadsheet program (like Microsoft Excel, Google Sheets, or Apple Numbers).” And: “This spreadsheet includes additional information, like your earnings, host service fees or cleaning fee (if you charge one), as well as gross earnings and any taxes withheld for each earning.”

How it shows in your Airbnb report

Two lines from our free example file, with fictional data. The column names are the example file’s; the Airbnb pages we read do not list the columns, so your file may differ.

Example file, IN_Airbnb tab, rows 2 and 3 (some columns left out)
ColumnPayout lineReservation line
Date10/12/202610/12/2026
TypePayoutReservation
Reference codeG-80GGT344KTLFJempty
Confirmation codeemptyHMJZX9VKU9
Paid out352.11 (example)empty
Amountempty352.11 (example)
Service feeempty10.89 (example)
Cleaning feeempty75.00 (example)
Gross earningsempty363.00 (example)

In the example file, a payout line comes first and the lines it pays follow it. This payout, 352.11 (example), equals the reservation’s amount: gross earnings of 363.00 (example) minus the service fee of 10.89 (example). Other payouts in the example cover several lines.

Check it yourself in 3 steps

  1. Export with all listings selected. Filter by dates if you need to, but keep every listing in. A listing filter leaves the other listings’ lines out of the file.
  2. Pick one payout. Open the file in your spreadsheet app and note the payout amount.
  3. Add up its lines. Add the lines that belong to it (in the example file, the lines right after it) and compare. If the sum falls short, export the same dates again with no listing filter before you look further.

What the workbook flags

The workbook checks each payout against the sum of its lines. In the example file, it flags payout G-KWT94MQ4S9VKQ with an AB-BATCH warning (Likely): the payout is 422.85 (example), its items add up to 392.85 (example), and the note says “The export may be filtered by listing, or some items are missing.” What to check: “Export Earnings > Paid again for the same dates with all listings selected.”

When a payout covers several lines and the sum matches, the same code is only an Info note.

Discrepancies tab of the workbook with fictional sample data. Row 2: Warning, Likely, AB-BATCH, Airbnb, Harrowmint Cottage. Explanation: Airbnb payout G-5QSZN5WRKG0VY is 422.85 (example), but its items add up to 392.85 (example). The export may be filtered by listing, or some items are missing. What to check: Export Earnings, Paid, again for the same dates with all listings selected. Other rows show AB-TIMING, AB-CHANGE, BN-BATCH, OS-EXPENSE, AB-ADJUST and AB-COHOST items.
Discrepancies tab example data From the workbook’s sample set, with other names and IDs than the free example file; row 2 is the same warning. Columns G to K hidden.

Covers Airbnb and one bank account. Not tax, legal or accounting advice. Not affiliated with or endorsed by Airbnb.

Sources

Quoted word for word as read. Airbnb may change these pages.

See it in the example file

The free example is a read-only snapshot of the workbook with fictional data; it does not work with your own reports. The two lines above are rows 2 and 3 of its IN_Airbnb tab.

Back to the home page

Other Airbnb payout questions