How to Import Income from Airbnb and Vrbo into DeductFlow

Manually entering every reservation payout is unnecessary and error-prone. DeductFlow's CSV import reads your Airbnb, Vrbo, and Booking.com transaction history directly, maps it to your income records, and reconciles against your 1099-K—in about 10 minutes per platform.

Where to Download Your Platform CSV

Select the full calendar year date range (January 1 – December 31) when downloading. Downloading a partial year and importing multiple files is fine—DeductFlow checks for duplicate confirmation codes to prevent double-counting.

Step-by-Step: Importing Your Income CSV

1. 1

   Download Your Platform CSV

   Follow the paths above for your platform. For Airbnb, the export includes columns for: Date, Type (Reservation, Payout, Resolution), Amount, Confirmation Code, Listing, and Guest. Make sure you select "All transactions" rather than "Payouts only" so you capture gross amounts before the platform's service fees.

2. 2

   Navigate to the Import Tool

   In DeductFlow, navigate to Income > Import Income. From the platform dropdown, select:

   • Airbnb — Pre-configured mapping for Airbnb's CSV format
   • Vrbo / HomeAway — Pre-configured mapping for Vrbo exports
   • Booking.com — Pre-configured mapping for Booking.com exports
   • Custom CSV — Manual column mapping for other platforms

   Selecting the correct platform saves time because column mapping is handled automatically.

3. 3

   Upload and Map Columns

   Click Upload File and select your CSV. For Airbnb and Vrbo, the column mapping preview will show green checkmarks on all required fields. For a custom CSV, map each column:

   • Date — Transaction or payout date
   • Amount — Gross amount (before fees)
   • Type — Reservation, refund, fee, or payout
   • Reference — Confirmation code or reservation ID
   • Property — Listing name or ID (for multi-property imports)

   DeductFlow automatically filters out non-income transaction types (like payouts, which are just transfer records, not new income events).

4. 4

   Review Imported Transactions

   Before finalizing, review the transaction preview screen:

   • Check the transaction count against what you expect from your booking volume
   • Look for any rows flagged as duplicates (yellow highlight)—these are already in your account from a previous import
   • Verify that refunds appear as negative amounts
   • If importing for multiple properties, confirm the property assignment for each row

   Deselect any rows you don't want imported, then click Confirm Import. The transactions are added to your Income ledger immediately.

5. 5

   Verify Against Your 1099-K

   Navigate to Reports > Income Summary. Compare the gross income total to your 1099-K. Airbnb and Vrbo send 1099-Ks in late January showing gross amounts processed through the platform. Your DeductFlow total should match within a small variance (refunds, resolution adjustments).

   If there's a significant discrepancy, check:

   • Did you import gross amounts or net payouts? (Gross is correct)
   • Are any reservations from December that paid out in January missing?
   • Were any refunds or resolutions issued that offset income?

Gross vs. Net: The Critical Distinction

This is the most common import error STR hosts make. Your Airbnb 1099-K reports gross guest payments—what guests paid before Airbnb deducted its service fee. Your bank shows net payouts after the fee. These are different numbers, and the IRS sees the gross figure.

Platforms Supported