Airbnb earnings CSV: the 5 fields a small host needs for payout tracking
An Airbnb earnings export gives you platform transaction detail—not a finished bookkeeping system. For each payout, keep five simple fields: stay dates, property, platform, gross booking income, and platform host fee. Then calculate the expected payout and compare it with the bank deposit in a separate step. That last comparison is how you catch a missing fee, adjustment, or timing difference.
First: what an Airbnb earnings CSV can and cannot tell you
Airbnb's Earnings dashboard lets hosts review gross earnings and transaction information, then export a CSV. On the current dashboard, a host can filter paid transactions by payout method, dates, listings, and earning types before exporting.
Do not treat the CSV as a promise of five fixed columns. Airbnb's report views, field choices, and labels can vary. The five fields below are the small-host tracking checklist to pull from the export or enter into your own ledger—not a claim about Airbnb's permanent column names.
Source: Airbnb Help Center, “Earnings dashboard”, checked August 14, 2026. If the menu or available fields differ, follow Airbnb's current help instructions.
The five fields to keep
| Ledger field | What to record | Why it helps later |
|---|---|---|
| Stay dates | The check-in to check-out dates, or Airbnb's clearest stay-date reference. | Lets you find the reservation again without relying on a bank date. |
| Property | The listing name or your own property label. | Keeps income and fees attached to the right rental when you manage more than one. |
| Platform | Airbnb for this export; keep the field so Airbnb, Vrbo, and direct bookings can share one ledger later. | Prevents platform payouts from being blended together. |
| Gross booking income | The booking earnings before the host service fee, using the detail Airbnb shows for that payout. | Creates a visible starting amount before fees and adjustments. |
| Platform host fee | The host service fee Airbnb shows for that earning or payout. | Explains why the bank deposit is lower than the gross booking amount. |
Expected payout comes next. Actual payout comes after that.
Airbnb says a listing owner's payout starts with the nightly rate and optional extra charges, then subtracts the host service fee and any shared co-host payouts. The transaction detail may also show items such as refunds or adjustment fees, currency exchange, and payment-processing fees.
So use the CSV to rebuild the expected payout from the amounts Airbnb actually shows. The actual payout is different: it is the deposit that later arrives in the bank. It is a comparison field, not one of the five CSV tracking fields.
This worked example assumes no other adjustment, co-host split, withholding, or conversion fee. If the bank deposit is $552.90, the payout matches. If it is not, leave the difference visible and return to the payout detail—do not edit the amount just to make the row balance.
Source: Airbnb Help Center, “Calculating your payout”, checked August 14, 2026. Airbnb notes that payout amounts can also be affected by pricing differences, discounts, installments, co-host payouts, routing rules, processing fees, currency exchange, adjustments, and host coupons.
A 10-minute workflow after each payout
- In Airbnb Earnings, filter to the paid transactions and date range you want. Export the report or open the payout detail.
- For each payout, record the five fields above. Use consistent property names so future reports stay readable.
- Record the platform fee shown, then add any clearly documented adjustment or co-host split needed to calculate the expected payout.
- When the bank deposit arrives, enter it separately as the actual payout and compare it with the expected payout.
- For every difference, add a plain-English note and keep the related Airbnb report with your monthly records.
One clean ledger row
Stay dates: May 10–13 · Property: Garden Loft · Platform: Airbnb · Gross booking income: $570.00 · Platform host fee: $17.10 · Expected payout: $552.90 · Actual payout: bank deposit checked later.
Two mistakes this prevents
- Calling the bank deposit “booking income.” The deposit can be lower because a platform host fee or another item was subtracted. Keep gross booking income and platform fee separately.
- Assuming a CSV settles the bank match. Exported earnings explain the platform side. A reconciliation is only complete once the expected payout has been compared with the actual bank deposit.
Common questions
Are these five fixed Airbnb CSV columns?
No. Airbnb lets hosts export earnings and transaction information, and its report views, selected fields, and labels can vary. These are the five fields to keep in your own tracking ledger after reviewing the export.
Should actual payout be a CSV field?
Use actual payout as a separate bank-side comparison. Build the expected payout from Airbnb's detail first; then compare it with the deposit that reached your bank.
Can I use gross booking income as tax income?
No single spreadsheet field decides what is taxable. Keep the records, then ask a qualified tax professional how to report them for your situation.