1. Your Transaction history
Airbnb → Menu → Account → Payments → Transaction history → Download CSV (or Earnings → Download). Needs Start date, Nights or End date, and Amount or Gross earnings; Listing, Type, Service fee, Fast pay fee, Cleaning fee and Occupancy taxes are used when present. Reservation rows become stays; payouts are ignored; adjustments and resolutions are shown separately. US and day-first dates, comma, tab and semicolon files, and UTF-16 exports are read.
Choose a file or paste the text, then click Analyze.
Result
By listing
| Listing | Stays | Nights | Gross | Fees | Net | ADR | Net / night | Occupancy |
|---|
By month of check-in
| Month | Stays | Nights | Gross | Net | ADR | Net / night |
|---|
By length of stay
| Stay length | Stays | Nights | Net | Net / night | Profit / night |
|---|
The model, and what it leaves out
- Stays are Reservation rows. Payout rows are ignored so nothing is counted twice; adjustments, resolutions and refunds are listed apart and are not subtracted from stay figures.
- Reconciles. The per-listing, per-month and per-length rows each add up to the totals at the top.
- Net is the Amount Airbnb reports for the stay, or gross earnings minus the service fee and Fast Pay fee if that column is missing. Fee share is those fees over gross earnings.
- ADR is gross earnings over nights booked (it includes the cleaning fee guests paid). Net per night is net over nights booked.
- Profit subtracts the turnover cost you enter once per stay. Nothing else is subtracted.
- Occupancy is nights booked over days between a listing's first check-in and last check-out (or the days you enter). It cannot see nights you blocked.
- Not modelled: rent or mortgage, utilities, supplies, taxes owed, income booked off Airbnb, and future bookings. Months are by check-in date.
Common questions
How do I see which Airbnb listing earns the most?
Download your Transaction history CSV from Airbnb (Menu, Account, Payments, Transaction history, Download CSV, or the Earnings tab), and drop it here. The tool groups the Reservation rows by listing and shows gross earnings, Airbnb's fees, net earnings, average daily rate, net per booked night and occupancy for each. Nothing is uploaded; the file is read in your browser.
How does it work out net earnings and the fee share?
Net is the Amount column on each reservation row, which is what Airbnb pays after its service fee. If that column is missing it is gross earnings minus the service fee and any Fast Pay fee. Fee share is service plus Fast Pay fees divided by gross earnings. Occupancy taxes are shown for reference and never counted as earnings.
Which stay length makes the most money per night?
Short stays earn more per night on paper because the cleaning fee is spread over fewer nights, but each one costs a turnover. Enter what you pay for one cleaning and the tool shows profit per night for 1-2, 3-4, 5-6, 7-27 and 28+ night stays, so you can see whether a longer minimum stay or a higher cleaning fee is worth testing.
What does the tool not know?
Your mortgage or rent, utilities, supplies, platform subscriptions, blocked nights, taxes you owe and any income booked outside Airbnb. Occupancy is nights booked divided by the days between a listing's first check-in and last check-out in the file unless you enter the days available, so it overstates occupancy if you blocked the calendar. Months are by check-in date.
Is this tax or financial advice?
No. It applies arithmetic to the file you provide and does not replace your own judgement or a qualified adviser. It is independent of Airbnb and is not affiliated with or endorsed by it.