Importing Airbnb Transaction Reports into QuickBooks Online

Who This Is For

If you manage short-term rentals on Airbnb and use QuickBooks Online to track your finances, this guide is for you. It covers hosts and property managers with anywhere from one listing to a small portfolio - people who want their books to reflect reality, not just what landed in their payout account.

Getting Airbnb data into QBO cleanly is harder than it looks. The platform pays you net of its service fee, bundles multiple reservations into single payouts, and uses its own date logic that doesn't always match when you actually earned the income. That complexity is normal - it's what happens when a booking platform sits between a guest and an operator, and it requires deliberate handling on your side.

What Airbnb's Transaction Report Actually Contains

Before importing anything, download and read your Airbnb transaction report. Go to airbnb.com > Account > Transaction History > Export to CSV.

The report includes:

• Date - the date Airbnb initiated the payout, not the check-in or check-out date

• Type - payout, adjustment, refund, or resolution

• Listing - name of the property (not a unique ID, which matters if you have similarly named listings)

• Confirmation code - the unique reservation identifier

• Nights - number of nights stayed

• Guest - guest name

• Amount - the net payout amount, after Airbnb's host service fee

• Paid out - the amount actually sent to you

Notice what's missing: the gross booking amount and the Airbnb host service fee as separate line items. You have to calculate those or pull them from a second report.

The Earnings Summary Report

Airbnb also provides an Earnings Summary (go to Progress > Earnings in the host dashboard). This report shows gross earnings per reservation broken out into accommodation fare, cleaning fee, Airbnb service fee, and total payout. Download both reports before you import anything into QBO.

Why Net Payout Alone Isn't Enough

For Schedule E (IRS Form 1040, Supplemental Income and Loss), you're required to report gross rental income - not the net amount after platform fees. If you only book the payout you receive, you're understating revenue and missing a legitimate expense deduction.

Example:

A guest books your cabin at $250/night for 4 nights. Gross accommodation fare: $1,000. Airbnb charges a 3% host service fee: $30. Your payout is $970.

If you record only the payout, your books show:

• Revenue: $970

• Airbnb fee expense: $0

What your books should show:

• Revenue: $1,000

• Airbnb host service fee (expense): $30

• Net: $970

The difference matters at tax time. Recording net shortchanges your gross revenue figure and eliminates a real business deduction. Across a full year and multiple properties, this distortion compounds quickly.

Setting Up Your Chart of Accounts in QBO

Before importing, confirm your chart of accounts has the right buckets. At minimum, you need:

• Rental income - gross accommodation revenue (Schedule E, Line 3)

• Cleaning fee income - if you charge guests separately for cleaning

• Airbnb host service fees - an expense account, categorized under Commissions and Fees or Merchant Fees

• Occupancy tax collected - a liability account if you collect and remit tax yourself (in many markets Airbnb remits directly, so verify what applies to your listings)

• Refunds and adjustments - contra-revenue or expense, depending on whether you've already recognized the original income

If you manage properties for owners and hold their funds before remitting, you'll also need trust liability accounts structured correctly. The owner trust accounting guide covers how to set those up without commingling funds.

Mapping Airbnb Fields to QBO

Here's how the Airbnb report columns map to QBO transaction fields:

Cash vs. Accrual Accounting

If you're on cash basis - which most small STR operators are - book income on the payout date. If you're on accrual, book it on the checkout date. This distinction matters when a reservation spans two months or two tax years. Pick one method and apply it consistently. Switching mid-year requires an accounting adjustment and, in some cases, IRS notification.

Three Ways to Get the Data Into QBO

Option 1: Manual Entry

For operators with under 10 reservations per month, manual sales receipts or journal entries work fine. Create one sales receipt per reservation using data from your Earnings Summary. It's time-consuming but gives you the most control over categorization.

Option 2: CSV Import via a Mapper Tool

QBO accepts CSV imports for certain transaction types. Third-party mapper tools can reformat the Airbnb CSV to match QBO's import template. You still need to verify mappings and check for duplicate entries, especially when a payout covers reservations from the prior month.

Option 3: Integration via a PMS

If you use a property management system like OwnerRez, Hostfully, or Guesty, that system may already pull Airbnb reservation data and push it to QBO through a native integration. The key question: is your PMS posting gross or net amounts? This is one of the most common sources of miscategorized revenue in multi-property books. The STR property management accounting guide goes deeper on how PMS-to-QBO integrations affect your overall accounting structure.

Common Errors to Watch For

Even with a clean import process, certain errors appear repeatedly in Airbnb-to-QBO workflows:

1. Duplicate revenue entries If your PMS posts reservation income and you also import the Airbnb CSV, you'll double-count revenue. Check your income accounts each month for duplicate confirmation codes.

2. Cleaning fees miscoded as rent Cleaning fees are often taxed differently than accommodation revenue and belong in a separate income account. Lumping them into rental income distorts both your revenue breakdown and your tax exposure.

3. Resolution center payouts miscategorized When Airbnb pays you through the resolution center for damages or missing items, that's not rental income. Code it as other income or a reimbursement.

4. Refunds booked as negative income instead of proper contra entries If you've already recognized the original revenue, a refund is a contra-revenue entry. If you haven't recognized it yet, it's a cancellation and no entry is needed at all.

5. Occupancy tax included in income In markets where Airbnb collects and remits occupancy tax on your behalf, that tax amount doesn't belong in your revenue. In markets where you collect it yourself, it's a liability - not income.

Catching these errors across a full year of transactions is exactly the kind of work that surfaces during a free owner statement audit before they compound into a tax problem.

A Monthly Sanity Check

After any import, run this quick check before closing the period:

1. Pull your Airbnb Earnings Summary for the period. Note total gross earnings.

2. Pull your QBO rental income account for the same period. Note the total.

3. The two numbers should match, adjusted for any accrual timing differences.

4. If they don't match, you have missing entries, duplicates, or miscategorized transactions.

This takes about 10 minutes per month and catches most import errors before they become a real problem.

To see how PX Accounting automates this kind of cross-checking across your owner statements, take a look at the PX features overview.

Frequently Asked Questions

Should I record Airbnb income as gross or net in QuickBooks?

Record gross accommodation revenue as income and the Airbnb host service fee as a separate expense. For Schedule E reporting, the IRS expects you to report gross rental income. Recording only the net payout understates your revenue and eliminates a deductible expense from your books.

What date should I use when entering Airbnb transactions in QBO?

It depends on your accounting method. Cash-basis operators should use the payout date - the date Airbnb transferred funds. Accrual-basis operators should use the checkout date, which is when the income was earned. Pick one method and apply it consistently throughout the year.

How do I handle Airbnb payouts that cover multiple reservations?

Split the payout entry into individual line items, one per reservation. Use the confirmation code in the memo field to keep each reservation identifiable. This makes it easier to match income to owner statements, handle refunds, and spot errors later.

Does Airbnb remit occupancy taxes for me, or do I track them separately?

It depends on your market. In many US states and cities, Airbnb collects and remits occupancy tax directly to the taxing authority on your behalf. In those markets, you don't need to track the tax in QBO at all. In markets where you collect and remit tax yourself, that tax is a liability in QBO - not income. Check your Airbnb host dashboard under Taxes to confirm what Airbnb handles in your specific location.

What if my PMS is already sending Airbnb data to QuickBooks?

Verify whether your PMS integration is posting gross or net amounts, and check for duplicate entries if you're also importing the Airbnb CSV separately. PMS-to-QBO integrations can save significant time, but they still require periodic review to confirm income is categorized correctly and no transactions are being double-counted.

Next Steps

Getting Airbnb data into QBO accurately is a process you refine over time. Start with a clean chart of accounts, confirm whether your import method posts gross or net amounts, and run a monthly check against your Airbnb Earnings Summary.

If you've been importing Airbnb transactions for a while and aren't certain your books are clean, PX Accounting can review your owner statements and accounting data to find miscategorizations, missing entries, and payout mismatches - before they affect your tax return.

By Jessica Hudson, CPA - specializing in short-term rental tax, bookkeeping, and financial operations for vacation rental hosts and property managers.