How to Export Airbnb Tax Data: Step-by-Step Host Guide

Airbnb's built-in earnings export covers the basics, but if you manage more than two listings — or split revenue across Airbnb, VRBO, and direct bookings — the native CSV leaves you reconciling spreadsheets at 11pm in April. Here's exactly how to pull your tax data, what's missing from Airbnb's export, and which tools actually close the gap.

What Airbnb's Native Export Actually Gives You

Log into your host account, go to Menu → Host → Earnings, and click "Download CSV" for any year. The file includes payout date, payout amount, listing name, confirmation code, reservation dates, and a line-by-line breakdown of host payout, cleaning fee, and adjustments. That's the good news.

What it doesn't include: occupancy taxes Airbnb collected and remitted on your behalf (you need this number to prove you're not double-paying on state returns), any expense data, or bookings from other channels. If 15% of your revenue came from VRBO or direct, that's a separate export entirely. Airbnb's tax documentation explains what's included, but it buries the gaps.

Airbnb also issues a 1099-K when gross payouts exceed $600 in a calendar year — the IRS threshold dropped from $20,000 starting tax year 2023. The 1099-K reflects gross payouts before Airbnb's service fee is deducted, which means it's consistently higher than your actual net. Your CSV and your 1099-K will show different numbers. The 1099-K is gross. The CSV is net. Reconcile this before handing anything to your accountant or you'll spend an hour explaining a discrepancy that has a two-sentence answer.

Step-by-Step: Exporting Your Airbnb Tax Data

1. Download the annual earnings CSV. Go to airbnb.com/hosting → Earnings → select the tax year → "Download CSV." Do this for each calendar year you're filing. The export is not retroactive by default — you have to manually select each year.
2. Download the occupancy tax report separately. Under the same Earnings section, look for a "Taxes" tab or filter your transaction history by type "Tax." Airbnb remits state and local occupancy taxes in most major markets. You need this total to reconcile your gross income on state returns, or your state filing will show unexplained income above your 1099-K.
3. Export your VRBO and direct-booking data. VRBO's earnings export lives under Owner → Financials → Transaction History. Direct bookings from your own website have no automated export — pull from Stripe, Square, or whatever PMS you're using for direct reservations.
4. Import to accounting software. QuickBooks Online and Wave Accounting both accept CSV imports. Map the column headers once, save the template, reuse it every year. TurboTax Premier has a direct 1099-K import from Airbnb built into the Schedule E rental property workflow — convenient for single-property hosts, but it pulls only the gross total, not line-item transactions per booking.
5. Categorize cleaning fees as income, not pass-through. Most CPAs treat guest-paid cleaning fees as taxable rental income — you then deduct what you actually pay your cleaner as a separate business expense. If you've been netting cleaning fees out before reporting gross income, your reported number is understated. Fix this explicitly with your accountant before you file.
6. Merge all channels into one reconciliation. A PMS with financial reporting — OwnerRez at $40+/mo or Hospitable at $29–$99/mo — handles the multi-channel merge automatically. Without one, you're doing manual VLOOKUP work across separate files from each platform.

In Q1 2026: The Depreciation Question I Wasn't Ready For

In Q1 2026, I was prepping taxes for my Columbus GA properties and my accountant asked about equipment depreciation. I'd installed a Yale Assure 2 lock on the Fort Benning house in mid-2024, an ecobee SmartThermostat Premium in the main living area that same summer, and a Nest 3rd-gen thermostat as a backup zone in the master bedroom. She needed purchase dates and dollar amounts for all three — plus the Ring Video Doorbell Pro I'd added in October 2024. The receipts existed somewhere, but they weren't attached to the property record in any organized way. We spent 45 minutes tracking down four Amazon order confirmations that should have been a five-minute lookup.

Smart home hardware — locks, thermostats, cameras — is depreciable property. Your tax export discussion usually stops at reservation revenue, but if you're adding devices to your listings every year (and most hosts scaling past five properties are), that's real tax basis that disappears when it lives only in your Amazon order history. A system that connects your hardware purchases to your property record saves this kind of time at tax prep.

Tools That Actually Work

Hospitable ($29–$99/mo in 2026)

Hospitable aggregates revenue across connected channels into one financial dashboard. Filter by listing, date range, or channel, then export to CSV. The field names are normalized across platforms, which is meaningfully better than pulling separate exports from Airbnb, VRBO, and Booking.com and reconciling inconsistent column headers manually. The limitation: no native QuickBooks or Xero sync. You're still doing a CSV import on the accounting side, which adds one manual step.

OwnerRez ($40+/mo in 2026)

OwnerRez has the strongest financial reporting in the sub-$100/mo PMS tier. It tracks gross revenue, channel fees, cleaning fees, taxes collected, and net payout per booking across Airbnb, VRBO, Booking.com, and direct. The native QuickBooks Online integration pushes transactions automatically — no manual import. If you're in a state with complex occupancy tax rules (Texas, Colorado, Florida), OwnerRez's tax tracking alone justifies the monthly cost.

TurboTax Premier ($69–$129 during filing season)

TurboTax Premier has a direct Airbnb 1099-K import in the Schedule E rental property workflow. It pulls the gross total automatically — you don't manually type the 1099-K number. It does not import the transaction-level CSV, so multi-property hosts still need to do per-property income allocation manually. For a host with one listing on one channel, this is the lowest-friction path to a filed return.

Wave Accounting (Free)

Wave handles CSV imports cleanly and has adequate rental property expense categorization. It's the right call for 1–3 listings when you're not ready to pay for a full PMS upgrade. Past that scale, the manual reconciliation time outweighs the cost savings of free software.

The Limitation Worth Naming

Every tool above — including the one I built — treats this as a reporting problem. The deeper issue is that Airbnb payouts are delayed. A stay that checks out December 29th might not pay out until January 4th, shifting revenue between tax years. You need to decide: cash basis (report when money arrives) or accrual basis (report when earned, meaning checkout date). Most small hosts default to cash basis for simplicity. But if you have significant late-December revenue, the method choice carries real dollar implications. Settle this with your accountant explicitly before you export anything. The CSV gives you raw data. It doesn't make the accounting method decision for you.

Where Koohost Fits In

I built Koohost partly to solve the multi-channel reconciliation problem. The PMS layer aggregates reservations across Airbnb, VRBO, Hospitable, Lodgify, Smoobu, and direct iCal bookings into one database — every reservation stores payout amount, cleaning fee, channel, and dates. At tax time, one export covers everything instead of three. Solo Host plan is $15/mo (direct/iCal only); Pro Host is $30/mo (full PMS API across channels).

If you're already on OwnerRez with QuickBooks wired up, stay there. OwnerRez's accounting integration is more mature than mine at this point. But if you're currently stitching together three separate CSVs and also want AI-drafted guest messages and smart lock automation in the same tool, the $15–$30/mo price point changes the math considerably. See the full feature comparison or the alternatives overview if you're still deciding between tools.

Try Koohost free for 30 days — no credit card.

FAQ

Does Airbnb automatically send tax forms?

Yes. Airbnb issues a 1099-K when gross payouts exceed $600 in a calendar year (current IRS threshold since 2023). The form appears in your account under Account → Taxes → Tax Documents by late January. It reflects gross payouts before Airbnb's host service fee — so the number is higher than your net earnings, which is expected and correct. The gap between your 1099-K and your CSV is the host service fee Airbnb charged you.

What's actually in the Airbnb earnings CSV?

The CSV includes payout date, payout amount, listing name, confirmation code, check-in and checkout dates, and a line breakdown of host payout, cleaning fee, and any adjustments or resolutions. It does not include occupancy taxes Airbnb collected and remitted on your behalf, expense data, or bookings from other platforms. You need a separate pull for each of those.

Can I export Airbnb data per listing instead of all listings together?

Yes. Filter by listing in the Earnings dashboard before downloading. Alternatively, download the full multi-listing CSV and then filter by the listing name column in Excel or Google Sheets. For multi-property hosts, pulling the full year across all listings is usually faster — you can slice it however you need after the fact.

Why does my 1099-K show a higher number than my actual earnings?

The 1099-K reflects gross payouts — what Airbnb collected from guests before deducting their host service fee. Your CSV shows net payouts after that deduction. The difference is Airbnb's host service fee, which is a fully deductible business expense. Report gross income matching the 1099-K on Schedule E, then deduct the host service fee as a separate line-item business expense. Your accountant can confirm the specific Schedule E placement.

What if I list on multiple platforms — Airbnb, VRBO, and direct?

Each platform has its own export. VRBO is under Owner → Financials → Transaction History. Direct bookings pull from your payment processor (Stripe, Square) or PMS. A tool that aggregates all channels — OwnerRez, Hospitable, or Koohost — gives you one unified export instead of three. The BiggerPockets STR forum has active threads comparing multi-platform accounting workflows. Manual reconciliation is manageable at two platforms. Past three, the time cost compounds fast enough that a $30–$40/mo tool pays for itself in the first week of April alone.

Cash basis vs. accrual basis — which should I use for STR taxes?

Cash basis means you report income when Airbnb actually pays you. Accrual means you report when the guest's stay ends (checkout date). Most small hosts default to cash basis for simplicity. The distinction matters most when stays cross calendar year boundaries — a December 29th checkout that doesn't pay out until January 4th shifts revenue between tax years. Agree on the method with your accountant before you download anything, or you may file using whichever basis produces the wrong number without realizing it.