{"product_id":"airbnb-utility-subscription-tracker","title":"Airbnb Utility Tracker Spreadsheet – Utility \u0026 Subscription Costs, Cost per Booked Night, 12-Month Trend, Renewals, Excel \u0026 Sheets, No Canva","description":"\u003cp\u003e\u003cstrong\u003eUtility \u0026amp; Subscription Cost Tracker\u003c\/strong\u003e is an Excel and Google Sheets workbook that shows what your vacation rental really costs to keep running. Type each month's electric, water, gas, internet, streaming, trash, lawn and pest bills once, and it works out your 12-month total, budget versus actual, the cost per booked night and which renewals need a decision next.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eNo Canva needed.\u003c\/strong\u003e This is a plain spreadsheet with no macros and no add-ons. Yellow cells are for typing and gray cells hold the formulas. It works in Excel, Google Sheets and Numbers.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eTemplate only; not financial or tax advice.\u003c\/strong\u003e All sample figures are made up.\u003c\/p\u003e\n\u003ch3\u003eWhat is inside (7 sheets)\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSettings\u003c\/strong\u003e - your property name, the first month of your 12 months, and up to 16 accounts: service dropdown (electric, water, gas or propane, internet, streaming, trash, lawn, pest, pool service, security monitoring, phone or SIM, software, other), provider, plan, billing cycle, monthly budget, auto-pay, renewal date, lead days, account reference placeholder and cancel notice days.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly Entries\u003c\/strong\u003e - amounts paid for each service in each of the 12 months, a booked nights row and an occupancy percent row, with row totals, averages, each service's highest month and its name.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAnalysis\u003c\/strong\u003e - per service: 12-month total, average, budget, variance in dollars and percent, an Over budget flag and share of spend; the cost per booked night by month and by service; a note on what a one-night price bump covers; a 12-month trend line against budget and a cost share chart.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRenewals\u003c\/strong\u003e - renewal date, notify-by date, days until renewal, a status of Act now, OK or Renewed?, the cancel-notice deadline, an action dropdown (keep, renegotiate, cancel, switch), notes and a next-5-renewals list.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSubscriptions\u003c\/strong\u003e - an audit table for streaming, software and monitoring plans: monthly cost, used by guests, last reviewed, keep or not, annual cost and the yearly savings, plus six trimming tips.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard\u003c\/strong\u003e - total for 12 months, monthly average, cost per booked night, highest-cost service, renewals due within 30 days and potential subscription savings, with a trend chart and a budget versus actual chart.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead Me\u003c\/strong\u003e - how to use the workbook, how the flags work and a Google Sheets note.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eComplete sample data is included, so every flag, total and chart shows real numbers from the first click: 11 accounts, 12 months of bills, booked nights and 8 audited subscriptions. Replace the sample rows with your own. This workbook tracks utilities and subscriptions and their cost per night; it is not a full income and expense ledger.\u003c\/p\u003e\n\u003ch3\u003eWho it is for\u003c\/h3\u003e\n\u003cp\u003eHosts and small property managers who want to know what utilities and subscriptions cost per booked night, catch seasonal swings and never miss a renewal or cancel-notice date.\u003c\/p\u003e\n\u003ch3\u003eFiles you receive\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eUtility-Subscription-Cost-Tracker.xlsx - editable workbook\u003c\/li\u003e\n\u003cli\u003eUtility-Subscription-Cost-Tracker.pdf - printable overview of every sheet\u003c\/li\u003e\n\u003cli\u003eSTART-HERE-How-to-Edit.pdf - editing guide for Excel, Google Sheets and Numbers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eHow it works\u003c\/h3\u003e\n\u003col\u003e\n\u003cli\u003eDownload the ZIP after checkout.\u003c\/li\u003e\n\u003cli\u003eOpen the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.\u003c\/li\u003e\n\u003cli\u003eList your accounts and budgets on Settings.\u003c\/li\u003e\n\u003cli\u003eType each month's bills and booked nights on Monthly Entries; the analysis, renewals and dashboard update.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch3\u003eFAQ\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eDo I need Canva?\u003c\/strong\u003e No, this is an Excel file.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHow is the cost per booked night calculated?\u003c\/strong\u003e Total utilities and subscriptions for the period divided by the booked nights you type in. Months with no nights stay blank rather than showing an error.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCan I track quarterly or annual bills?\u003c\/strong\u003e Yes. Type the full bill in the month you paid it and leave the other months empty.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDo the renewal dates update by themselves?\u003c\/strong\u003e Yes. Status, days left and the cancel-notice deadline use today's date.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDoes it work in Google Sheets?\u003c\/strong\u003e Yes. Upload the file and open it with Google Sheets. The formulas avoid add-in and dynamic-array functions.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eLicense:\u003c\/em\u003e personal and single-business use. Please do not resell or redistribute the files. Airbnb, VRBO and Booking.com are trademarks of their respective owners; this product is not affiliated with or endorsed by them.\u003c\/p\u003e","brand":"Welcome Desk Co.","offers":[{"title":"Default Title","offer_id":68031774753020,"sku":"WDC-B7-098","price":4.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0829\/2358\/5788\/files\/utility-subscription-tracker__01-hero.jpg?v=1793256093","url":"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-utility-subscription-tracker","provider":"Welcome Desk Co.","version":"1.0","type":"link"}