Free Airbnb Income and Expense Tracker – Simple Monthly Spreadsheet for Hosts with Running Profit, Excel & Google Sheets, No Canva
Free Airbnb Income and Expense Tracker – Simple Monthly Spreadsheet for Hosts with Running Profit, Excel & Google Sheets, No Canva
Start tracking your rental money with this free Airbnb income and expense tracker. It is one clean spreadsheet tab for one property and one month: type the date, pick a category, add the amount, and the sheet adds up your total income, total expenses and profit for you, with a running profit total on every row.
It works in Excel and Google Sheets, with ten ready-made categories in a drop-down list (booking payouts, cleaning, supplies, utilities, repairs, platform fees, insurance and more). Sample rows show how it works; delete them and type your own. It is a simple log for your own records, not tax advice.
What you get
- One spreadsheet tab: a monthly income and expense log for one property
- Columns for date, category, description, income, expense and a running profit total
- Totals at the top: total income, total expenses and profit, calculated automatically
- Category drop-down list with 10 common host categories
- Print-ready PDF in US Letter and A4
Files in the download
- Free-Income-Expense-Tracker.xlsx (editable)
- Free-Income-Expense-Tracker.pdf (US Letter)
- Free-Income-Expense-Tracker-A4.pdf
- START-HERE-How-to-Edit.pdf
How to edit it (no Canva needed)
- Download the ZIP and unzip it.
- Open the editable file in Excel, Google Sheets (free) or Numbers. No Canva account and no subscription are needed.
- Type into the light yellow input cells. The gray formula cells update by themselves.
- Start a fresh copy each month, or print the PDF and fill it in by hand.
The START-HERE guide in the ZIP walks you through each app step by step and explains how to print at the right size.
Want the full version?
This free template is a sample of the Host Income & Expense Tracker. The full version is a complete short-term rental bookkeeping spreadsheet for Excel and Google Sheets that goes well beyond this one basic log tab. Running several listings or want everything at once? The Host Mega Bundle includes every paid Welcome Desk Co. template in one download.
FAQ
Is it really free? Yes. Add it to your cart, complete the free checkout and download the ZIP.
Do I need Canva? No. The file opens in Excel, Google Sheets (free) or Numbers.
Can I change the wording, colors and fonts? Yes. Every word is real, editable text, and you can change colors and fonts like in any other document.
Does it work in Google Sheets? Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas and drop-down list keep working.
Is this tax advice? No. It is a simple record-keeping template, not tax or accounting advice. Ask a tax professional about your situation.
License
Free for personal use on your own rental property. You may edit, print and share the finished pages with your guests. Please do not resell or redistribute the template files. Airbnb, VRBO and Booking.com are trademarks of their respective owners; Welcome Desk Co. is not affiliated with Airbnb, VRBO or Booking.com and this template is not endorsed by them.