What you see
The deposit from Airbnb in your bank is a different amount from the reservations you expected, and income looks doubled when you import the earnings CSV as bank lines.
Why it happens
Airbnb's help page on earnings says the exported CSV includes earnings, host service fees, cleaning fees, gross earnings and taxes withheld.
In the export each payout row is followed by the reservations and adjustments it pays. Importing every row as a bank line counts the payout and its reservations both.
How to fix it
- On Airbnb (desktop): Today, Menu, Earnings, choose Paid, filter the dates and listings, and click Export CSV.
- Drop the file into the converter above. It is recognised as an Airbnb earnings CSV.
- Set the account names to your chart of accounts and download.
- Import it in QuickBooks Online under Import data, Journal entries, then match each bank line to the payout in your bank feed.
What this does not fix
- Use the Paid export: upcoming earnings have not reached your bank yet.
- Occupancy taxes Airbnb collects and pays for you are not counted as your payout; taxes you remit yourself are a question for your tax preparer.
- Every account named in the file must already exist in QuickBooks.
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 (journal entry import) receives
| Journal No. | Journal Date | Account Name | Debits | Credits | Description | Name |
|---|---|---|---|---|---|---|
| BR-20251017-1 | 10/17/2025 | Sales of Product Income | 3212.48 | Gross sales - Airbnb payout G-TESTPAYOUT1 | ||
| BR-20251017-1 | 10/17/2025 | Sales of Product Income | 649.00 | Refunds - Airbnb payout G-TESTPAYOUT1 | ||
| BR-20251017-1 | 10/17/2025 | Bank Charges & Fees | 76.90 | Fees - Airbnb payout G-TESTPAYOUT1 | ||
| BR-20251017-1 | 10/17/2025 | Uncategorized Income | 95.00 | Adjustments - Airbnb payout G-TESTPAYOUT1 | ||
| BR-20251017-1 | 10/17/2025 | Checking | 2581.58 | Deposit - Airbnb payout G-TESTPAYOUT1 | ||
| BR-20251205-1 | 12/05/2025 | Sales of Product Income | 196.86 | Gross sales - Airbnb payout G-TESTPAYOUT2 |
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.
Import the fixed file into QuickBooks Online (journal entry import)
- Make sure every account named in the file exists in your chart of accounts (or change the account names before downloading).
- In QuickBooks Online go to Settings (gear) > Import data > Journal entries.
- Upload this CSV and map Journal No., Journal Date, Account Name, Debits, Credits, Description and Name.
- Review and import. Each payout (or month) becomes one balanced entry.
Questions
- 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.
- Are occupancy taxes in the Airbnb export my income?
- Taxes that Airbnb collects and pays for you appear in the export without reaching you, so the converter does not count them in your payout.
- Does each journal entry balance?
- Yes. Debits and credits of every entry are equal to the cent, and the bank line is the payout amount.
Converters for this file
- Airbnb payouts to a QuickBooks journal entry
- Airbnb CSV converter
- Convert a Airbnb earnings CSV to QuickBooks Online
- Import a Airbnb earnings CSV into Xero
- Payout journal entry from a CSV export
Related import problems
Sources
The rules on this page come from these help pages, checked 2026-11-05. Software changes; if your screen says something different, the help page is the authority.