Airbnb Income Tracker Spreadsheet - Short-Term Rental Profit, Fees, Expenses & Occupancy for Excel and Google Sheets

Renting your place out is easy. Knowing what you actually made is the hard part. Between platform fees, cleaning costs, utilities and the mortgage, the payout number in your app is not your profit. This tracker logs every booking, fee and expense for your Airbnb or VRBO rentals - and shows your real profit, occupancy and average nightly rate at a glance.

- DASHBOARD - total gross revenue, total platform fees, total expenses and net profit, plus total nights booked, occupancy % and average nightly rate, all pulled in automatically; set Nights Available to 365 or your season length
- BOOKINGS - every stay: property, guest, check-in and check-out, with Nights, platform Fee and Payout calculated automatically (12 sample bookings prefilled, room for more)
- EXPENSES - every running cost with property and category dropdowns (Cleaning, Utilities, Supplies, Maintenance, Mortgage, Insurance, Platform, Other) and an automatic by-category summary powered by SUMIF, plus a grand total
- CLEANING LOG - every turnover clean with date, property, cleaner and cost; informational only, so cleaning is never double-counted - cleaning costs reach your profit from the Expenses sheet
- PROPERTY SUMMARY - up to 3 properties side by side: gross revenue, platform fees, expenses, net profit and nights booked per property, totaled automatically with SUMIF
- START HERE - a 5-step setup guide; up and running in minutes

WHAT'S INSIDE (6 sheets):
- START HERE - 5-step setup guide
- DASHBOARD - your whole hosting business at a glance, fully automatic
- BOOKINGS - stay log with nights, fee and payout formulas
- EXPENSES - expense log with dropdowns and SUMIF category summary
- CLEANING LOG - turnover cleaning tracker (informational)
- PROPERTY SUMMARY - per-property profit comparison

HOW IT WORKS: Download instantly, type in the yellow cells, everything calculates automatically. No spreadsheet skills needed - if you can type, you can run this.

WHAT YOU GET: 1 Excel file (.xlsx, 6 sheets), works in Microsoft Excel and Google Sheets. Instant download.

PLEASE NOTE: Digital download; no physical item ships. The file comes prefilled with sample data (two properties - a seaside condo and a mountain cabin - with a season of bookings, expenses and cleans) so you can see every formula working - just type over it with your own rentals.

Organizer only - not tax advice. This tracker helps you organize your rental income and expenses; talk to a qualified tax professional about your own situation.

FREQUENTLY ASKED QUESTIONS:

Q: I opened the spreadsheet in Google Sheets and it says "view only" - how do I edit it?
A: That happens with Google Sheets from time to time. Open the file, then in the top menu choose File, then Make a copy. The copy belongs to you and is fully editable. If it still won't open, try a computer or laptop instead of a phone, a different browser, make sure you're signed in to Google Sheets, and check that your Google Drive has space. Still stuck? Message me on Etsy and I'll help you sort it out.

Q: I can't download my purchase on my phone - what am I doing wrong?
A: Nothing - the Etsy app doesn't support downloading files. Open your browser (log out of the Etsy app first if it keeps redirecting you), sign in to Etsy, and download from your Purchases page on a mobile browser, or use a laptop or desktop. Once the file is saved you can open it on your phone any time.

Q: What exactly is a spreadsheet template?
A: It's a ready-made spreadsheet with all the formatting and formulas already built in. Download it, type in the yellow cells, and everything else calculates itself. Colors, headings and layout can be customized if you like, but you never need to touch a formula.

Q: Does it work for more than one property?
A: Yes - the sample file tracks two properties and the Property Summary has a third row ready. Use the same property name on the Bookings and Expenses sheets and the summary totals it automatically.

Q: Can I return or exchange my purchase?
A: Because this is a digital download, returns and exchanges aren't possible once the file has been downloaded - you'll always keep access to it in your Etsy account. If you bought it by accident and haven't downloaded it yet, send me a message and I'll take care of it.

Q: Is it available in other languages?
A: Right now the planner is in English only.

*This digital product has been created with the assistance of AI Tools, then refined by me, the seller*