Free Vacation Rental Utility Tracker – Monthly Utility Bill Spreadsheet, Electric, Water, Gas, Internet, Trash, Excel & Sheets, No Canva
Free Vacation Rental Utility Tracker – Monthly Utility Bill Spreadsheet, Electric, Water, Gas, Internet, Trash, Excel & Sheets, No Canva
Know exactly what your rental costs to keep running with this free vacation rental utility tracker. Type the electricity, water, gas, internet and trash bills for each month and the sheet adds up every month and the whole year for you.
Utilities are one of the biggest costs a host pays that changes with the season: air conditioning in summer, heating in winter, more water when the house is full. When you see twelve months side by side, you can spot a bill that jumped, plan for the high months and set your nightly rates with real numbers. The grid is pre-filled with a full year of sample bills so you can see how it works before you replace them with your own.
What you get
- 1 tab with a 12-month grid: one row per month, one column per bill
- Five bills: electricity, water, gas, internet and trash
- A monthly total on every row and a yearly total at the bottom, all by formula
- A yearly total at the top and a monthly average row
- Light yellow input cells, gray formula cells and print setup for Letter and A4, one page
Files in the download
- Free-Utility-Bill-Tracker.xlsx (editable, US Letter print setup)
- Free-Utility-Bill-Tracker.pdf (print-ready, Letter)
- Free-Utility-Bill-Tracker-A4.pdf (print-ready, A4)
- 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.
- Replace the sample amounts with your own, then print the sheet or keep the file open and add each bill as it arrives.
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 Utility Tracker Spreadsheet. The full spreadsheet adds streaming, lawn and pest costs, cost per booked night, a 12-month trend chart and renewal dates, so you can see what each stay really costs to run. 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.
Can I rename a bill? Yes. Click a column heading, such as Gas, and type your own bill name, for example Propane or Septic.
Are the amounts real? No. They are sample numbers to show how the totals work. Replace them with your own bills.
Is there an A4 version? Yes. The ZIP has a Letter workbook plus Letter and A4 PDFs. The workbook is set to fit one page; choose A4 in your print settings for A4 paper.
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.