BooksReady

Convert a Airbnb earnings CSV to QuickBooks Online

In short: Airbnb's earnings export puts each Payout row before the reservations and adjustments it pays, and lists service fees, cleaning fees and occupancy taxes in their own columns. QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. Drop the file below. It is converted on your device and never uploaded.

Convert your file

Airbnb to QuickBooks Online (CSV)

Earnings CSV from Menu > Earnings > Paid > Export CSV

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

1. Export the file from Airbnb

  1. On airbnb.com (desktop) click Today > Menu > Earnings.
  2. Open the Paid tab (Upcoming lists money not paid yet).
  3. Filter the dates and listings you want.
  4. Click Export CSV, choose what to include, and click Export CSV again.

Why a raw Airbnb export fails in QuickBooks Online

Imported raw, a payout and the reservations inside it are both counted, so income appears twice, and the amount QuickBooks needs sits in a different column depending on the row type.

QuickBooks Online maps the first row as column names and expects every following row to be a transaction. Extra header lines, balance and total rows, currency symbols, and cells that contain only zero are common reasons an upload fails or imports wrong amounts.

What is unusual about the Airbnb file

  • Each Payout row comes first and is followed by the reservations and adjustments it pays; Paid out equals the sum of their Amount.
  • Amount is after the host service fee; Gross earnings includes the cleaning fee.
  • Occupancy taxes are collected and paid by Airbnb and are not part of your payout.
  • Dates are short, like 11/30/25.
  • Column names are translated into your Airbnb language; English and Spanish are recognized.
  • A long stay can appear in several Reservation rows.

What QuickBooks Online requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

2. Before and after

Before: the Airbnb earnings CSV as downloaded

Date,Arriving by date,Type,Confirmation code,Booking date,Start date,End date,Nights,Guest,Listing,Details,Reference code,Currency,Amount,Paid out,...
11/30/25,12/5/25,Payout,,,,,,,,"Transfer to Pat Example, Checking 0000 (USD)",G-TESTPAYOUT2,USD,,190.95,,,,,,
11/30/25,,Reservation,HMTEST0001,10/29/25,11/2/25,12/7/25,35,Lee Fakeguest,"2-bedroom, garden view",,,USD,190.95,,5.91,,0,196.86,19.05,2025
10/11/25,10/17/25,Payout,,,,,,,,"Transfer to Pat Example, Checking 0000 (USD)",G-TESTPAYOUT1,USD,,2581.58,,,,,,
10/11/25,,Adjustment,HMTEST0002,8/29/25,9/24/25,10/8/25,14,Kim Testperson,New studio,,,USD,-629.53,,-19.47,,-32.14,,-104.29,2025
10/11/25,,Resolution Payout,HMTEST0003,,9/17/25,9/27/25,10,Jo Mockguest,Lovely 2-bedroom,,,USD,95,,,,,95,,2025
10/11/25,,Reservation,HMTEST0004,9/29/25,10/10/25,11/10/25,31,Sam Notreal,Cozy getaway,,,USD,3116.11,,96.37,,110,3212.48,310.94,2025

After: what QuickBooks Online receives

After: airbnb-2025-10-11-to-2025-11-30-quickbooks-3col.csv
DateDescriptionAmount
10/11/2025Reservation - HMTEST0004 - Sam Notreal - Cozy getaway - 10/10/25-11/10/253212.48
10/11/2025Fee: Reservation - HMTEST0004 - Sam Notreal - Cozy getaway - 10/10/25-11/10/25-96.37
10/11/2025Resolution Payout - HMTEST0003 - Jo Mockguest - Lovely 2-bedroom - 9/17/25-9/27/2595.00
10/11/2025Adjustment - HMTEST0002 - Kim Testperson - New studio - 9/24/25-10/8/25-649.00
10/11/2025Fee: Adjustment - HMTEST0002 - Kim Testperson - New studio - 9/24/25-10/8/2519.47
10/11/2025Airbnb payout - Transfer to Pat Example, Checking 0000 (USD)-2581.58

Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.

3. Import the converted file into QuickBooks Online

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

Questions

Are occupancy taxes in the Airbnb export my income?
Occupancy taxes that Airbnb collects and pays for you appear in the export without ever reaching you, so the converter does not count them in your payout. Where you collect and pay them yourself, ask your tax preparer how to record them.
Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
Should I import payouts or reservations?
Match the bank with payouts, and record income from the reservations inside them. The journal entry does both: one entry per payout, with reservation income and fees as separate lines.
Why does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.

Other ways to convert Airbnb

Other exports to QuickBooks Online (CSV)

Common import problems