What date range should I download for my taxes?

The full tax year: January 1 through December 31. If a stay or payout straddles the year boundary, download both years and check which year each row lands in — the export dates rows by payout activity, which is not always the year the guest stayed.

Why are so many cells in my Airbnb CSV blank?

That's normal. The export mixes different row types, and each type only fills the columns that apply to it — Payout rows are bank transfers, so they leave reservation columns (guest, nights, service fee) empty, while Reservation rows carry the earning details. Blank cells are not missing data.

Is the transaction history CSV the same as my 1099-K?

No. Form 1099-K is a summary information return reporting gross transaction amounts. The transaction history CSV is the detailed record — every reservation, fee, adjustment, and payout. You generally need the CSV to reconcile why the 1099-K figure differs from your bank deposits (the difference is service fees, refunds, and adjustments).

Does this work for Vrbo exports too?

This guide covers Airbnb's transaction history export. Vrbo's reports use a different structure with different column conventions. Roost Ledger currently reconciles Airbnb exports only — Vrbo support is on the roadmap.

How to Download Your Airbnb Transaction History CSV for Taxes

Q: Where do I download my Airbnb transaction history CSV?

Log in to airbnb.com on a desktop browser and go to your transaction history — the direct URL airbnb.com/users/transaction_history has been the fastest route for years. It also lives under your account's payments/payouts settings. Set the date range you need, then use the Download/Export CSV option. Airbnb reshuffles its menus periodically, so if the path has moved, search 'transaction history' in the Airbnb Help Center for the current location.

Step by step

Log in on a desktop browser. Use airbnb.com, not the mobile app — the CSV download is a web feature. Make sure you're on the account that hosts the listings (switch to hosting mode if your account has both traveler and host sides).
Open your transaction history. Go directly to airbnb.com/users/transaction_history, or navigate there from your account menu under payments & payouts. The page shows your payout activity with views for completed and upcoming transactions and a gross-earnings summary (labels vary by account and region).
Set the date range to the full tax year. January 1 through December 31 of the year you're filing for. Filter to all listings and all payout methods if you have more than one — a partial export means missing income rows.
Download the CSV from the completed-transactions view. Look for a Download CSV (or Export) option. The completed view is your record of what actually happened; upcoming transactions haven't settled yet and don't belong in a tax-year tally.
Repeat per year if you need multiple years. One file per tax year keeps your records clean, and payouts that straddle the year boundary are easier to place when you can see both years side by side.

Airbnb moves its menus. The steps above are current as of mid-2026, but Airbnb reshuffles navigation regularly and labels differ by region. If the path has changed, search “transaction history” in the Airbnb Help Center — the CSV export itself has been a stable feature for years even when the route to it moves.

Make sure you grab the right report

Airbnb offers more than one earnings document, and they answer different questions:

Transaction History CSV — the row-by-row record: every reservation, service fee, adjustment, and payout. This is the file you (or your CPA, or Roost Ledger) reconcile from. This is the one this guide is about.
Earnings summary reports — aggregated yearly or monthly totals. Useful as a cross-check, but you can't trace an individual booking's fees or a specific refund from a summary.
Form 1099-K (if you received one) — an information return reporting gross transaction amounts. It will normally be larger than your bank deposits, and the CSV is how you explain the difference. See our payouts vs. gross income guide for why reporting deposits as income is the classic mistake.

What each column in the CSV means

Exact header names drift across export versions and regions — Roost Ledger's parser normalizes dozens of variants — but these are the fields that matter and what they carry. Not every column appears in every export, and not every row fills every column (see the gotchas below).

Date: The transaction date — for payout rows, the date the money moved. Some export versions label this “Payout date”.
Type: The row type: Reservation, Payout, Adjustment, Resolution Payout, Co-Host payout, or Pass Through Tot (the last is often written “Pass-Through TOT”). This column drives everything — each type is tallied differently. Full row-type breakdown here.
Confirmation Code: The booking's unique code. Lets you match a reservation row to the specific stay (and to the guest's confirmation email).
Start Date: Check-in date of the stay the row relates to. Useful for placing year-boundary bookings.
Nights: Length of the stay in nights. Handy for occupancy tallies and per-night sanity checks.
Guest: The guest name on the reservation. Blank on rows that aren't tied to a single booking.
Listing: Which property the row belongs to. This is the column that makes per-property Schedule E worksheets possible — if you host multiple listings, don't lose it.
Details: Free-text description — most useful on adjustments and resolution rows, where it says what the money was for.
Reference: A reference code some export versions include for cross-referencing transactions.
Currency: The currency of the amounts on the row. Watch this if you host in more than one market.
Amount: The row's transaction amount. What it represents depends on the row type — earnings on a reservation row, the transfer amount on a payout row.
Paid Out: The net amount actually disbursed to your bank. This is the number people mistake for income — it isn't; it's income minus fees and adjustments.
Service Fee: Airbnb's host service fee for the booking — a deductible expense (commonly Schedule E line 8, Commissions). Payout totals hide it; this column is where it lives.
Fast Pay Fee: The fee for expedited payouts, if you use Fast Pay. Also a cost of doing business worth capturing.
Cleaning Fee: The cleaning fee charged to the guest. It's part of your gross income — what you pay your cleaner is a separate expense.
Gross Earnings: What the guest paid for the stay before Airbnb's cut — generally the income figure your return is built on, not the payout.
Occupancy Taxes: Occupancy/tourism tax on the booking. When Airbnb collected and remitted it for you, it's generally neither your income nor your deduction.
Earnings Year: The tax year Airbnb attributes the earnings to, in export versions that include it. When present, it beats guessing from dates on year-boundary rows.

Gotchas before you tally anything

Blank cells are normal. Payout rows are bank transfers — they leave the reservation columns (guest, nights, service fee) empty. Reservation rows carry the earning details. A CSV full of blanks is not a broken export.
There may be junk lines above the header. Some export versions prepend a metadata line or two before the actual column headers. Spreadsheet formulas that assume row 1 is the header silently mis-tally; check before you SUM. (Roost Ledger's parser detects and skips these automatically.)
Negative amounts can appear in parentheses. (45.00) means −$45.00 in accounting notation. A naive spreadsheet import can read it as text and drop it from totals.
Column names drift. “Paid out” vs “Net payout”, “Service fee” vs “Host service fee” — different export versions and regions name columns differently. Match by meaning, not position.
Year-boundary rows need a decision. A December stay paid out in January shows up depending on how the export dates it. Pull both years, use the Earnings Year column when present, and be consistent.
Vrbo exports are a different animal. Different columns, different conventions — nothing on this page applies to them. Roost Ledger currently reconciles Airbnb transaction-history CSVs; Vrbo support is on the roadmap.

Airbnb transaction history CSV FAQ

Where do I download my Airbnb transaction history CSV?

On desktop: log in to airbnb.com and open airbnb.com/users/transaction_history (it also lives under your account's payments & payouts settings). Set your date range and click Download CSV. If Airbnb has moved it since mid-2026, search the Help Center for “transaction history”.

What date range should I use for taxes?

The full tax year, January 1 – December 31. Pull both years if you have year-boundary stays and place them deliberately — the Earnings Year column, when your export has one, is the authoritative tiebreaker.

Why are so many cells blank?

Each row type only fills the columns that apply to it. Payout rows are transfers, so reservation columns stay empty. It's the structure of the export, not missing data.

Is this the same as my 1099-K?

No — the 1099-K is a gross-amount summary; the CSV is the detailed record that explains it. Our payouts vs. gross income guide walks through the reconciliation identity, and the Schedule E checklist covers where the deductions land.

Does this work for Vrbo?

No — Vrbo's reports are structured differently. This guide (and Roost Ledger today) covers Airbnb exports; Vrbo is on the roadmap.

How to Download Your Airbnb Transaction History CSV (and Read It) for Taxes

Step by step

Make sure you grab the right report

What each column in the CSV means

Gotchas before you tally anything

Airbnb transaction history CSV FAQ

Where do I download my Airbnb transaction history CSV?

What date range should I use for taxes?

Why are so many cells blank?

Is this the same as my 1099-K?

Does this work for Vrbo?

Got the CSV? The tallying is the tedious part.