Free Occupancy Tax Tracker Spreadsheet – Monthly Tax Log for Airbnb & Vacation Rentals, Excel & Google Sheets, No Canva

Get a free occupancy tax tracker spreadsheet for your Airbnb, VRBO or vacation rental. It is a simple monthly log: type your bookings, nights and nightly revenue for each month, set your tax rate once, and the sheet works out the tax due for every month and the total.

Many hosts only find out at filing time that they have no record of what they owe. One line per month is enough to stay ahead of it, and this log keeps those lines in one place with a total at the bottom. The sheet is pre-filled with realistic sample months so you can see how every number is worked out before you replace it with your own.

What you get

• 1 tab with a 12-month log: bookings, nights booked, nightly revenue, tax rate, tax due, date paid and notes
• One tax rate cell that every month reads: change it once if your rate changes
• A totals row and a highlighted total tax due
• Light yellow input cells, gray formula cells and a clear planning-tool note (not tax advice)
• Print setup for Letter and A4, one page

Files in the download

• Free-Occupancy-Tax-Log.xlsx (editable, US Letter print setup)
• Free-Occupancy-Tax-Log.pdf (print-ready, Letter)
• Free-Occupancy-Tax-Log-A4.pdf (print-ready, A4)
• START-HERE-How-to-Edit.pdf

How to edit it (no Canva needed)

1. Download the ZIP and unzip it.
2. Open the editable file in Excel, Google Sheets (free) or Numbers. No Canva account and no subscription are needed.
3. Type into the light yellow input cells. The gray formula cells update by themselves.
4. Replace the sample months with your own, then print the sheet or keep it open as your running log.

The START-HERE guide in the ZIP walks you through each app step by step and explains how to print at the right size.

Planning tool, not tax advice. Rates, taxable items and filing rules differ by place: check them with your tax office or a local professional.

Want the full version?

This free template is a sample of the Tax Tracker Spreadsheet. The full tracker works per booking: nights, rate, cleaning fee, tax collected vs remitted, platform fees, payout reconciliation and a quarterly summary. It is a planning tool, not tax advice. 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 this file my taxes for me? No. It is a planning tool, not tax advice. It helps you keep a clear monthly record. Check your rate, what is taxable and your filing dates with your tax office or a local professional.

Does it track tax collected by the platform or tax remitted? No. The free log is a simple monthly record of revenue and tax due. The full tracker adds tax collected vs remitted, platform fees and payout reconciliation.

Is there an A4 version? Yes. The ZIP has a Letter workbook plus Letter and A4 PDFs. To print the workbook on A4, change Paper size to A4 in your print settings; it is already set to fit one page.

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.