Turn your Airbnb earnings CSV into a clean Excel report
Airbnb's earnings CSV mixes payouts, reservations, adjustments and resolution lines. Turn it into a tidy table per stay plus monthly or quarterly totals per listing, in your browser.
Why the raw CSV is hard to use
The download lists payouts and the reservations they pay, plus adjustments, resolution payments and taxes, with amounts on different rows. Pivoting it into “how much did each listing earn per month” takes time and is easy to get wrong.
What you get
- Each reservation once, with check-in, nights, gross, cleaning fee, host fee and payout.
- Totals per month, quarter or year, per listing, including nights for occupancy.
- Duplicates removed when files overlap (Pro, when combining files).
- Downloads: Worksheet CSV (free), stay-by-stay CSV and an Excel workbook (Pro), or a printable PDF.
Steps
- Download the earnings CSV from Airbnb.
- Drop it above and choose the period.
- Download the report. The file is processed in your browser; nothing is uploaded.
For income tax, see Airbnb earnings by month or quarter.
FAQ
Can I open the Airbnb CSV directly in Excel?
Yes, but you'll get the raw rows. Lodgetally groups them into one line per stay and adds period totals.
Is it really private?
Yes. Your file is read by JavaScript running in your browser tab; its contents — guest names, earnings, listings — are never sent over the network. You can verify this in your browser's developer tools (Network tab), or go offline after the page has loaded.
Is this tax advice?
No. Lodgetally does the arithmetic from your platform files using the rates and rules you enter. Rules differ by state, county and city — check what's taxable, the exemptions, and whether a platform collects for you with your tax office, and file on their form.
Which files work?
The Airbnb earnings / transaction history CSV, Vrbo payout and stay-tax reports, the Booking.com extranet reservations export, and most property-management exports with stay dates and amounts — CSV, TXT, XLSX, XLS or ODS. Columns are detected automatically and you can change any of them; your choice is remembered for that layout.
Why by check-in date and not payout date?
Most lodging-tax returns are based on when guests stayed. Payout dates drift from stay dates at every period boundary. You can choose check-in, check-out, payout date, or splitting each stay's receipts by nights in each month.
Does it know my tax rate?
No — you enter it (one or more rates, e.g. state + county + city), so the worksheet always matches your jurisdiction's current rate.
What's free?
Everything, one file at a time, for reports covering up to 40 reservations — the full worksheet, checks, CSV summary and printable worksheet. Pro removes the limit, combines several files (e.g. Airbnb + Vrbo + Booking.com), and adds the Excel workbook and per-stay CSV.