{"product_id":"airbnb-vacation-rental-tracker","title":"Airbnb and Vacation Rental Tracker Spreadsheet","description":"\u003cp\u003eThis vacation rental tracker records nights booked, the nightly rate and what actually landed after fees. It is an Airbnb spreadsheet for hosts with one listing or several who want occupancy and short term rental income tracked properly.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eOccupancy measured the right way\u003c\/h2\u003e\u003cp\u003eOccupancy is nights let against nights available, for each unit and each month, measured against your target. Platform commission and changeover cleaning are their own expense lines rather than a single lump, so you can see what each one takes.\u003c\/p\u003e\u003ch2\u003eEvery line points at a unit\u003c\/h2\u003e\u003cp\u003eA unit is entered once. Every booking, every cost and every maintenance job points at it, which is how the per-property view works without retyping anything.\u003c\/p\u003e\u003ch2\u003eThe tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eUnits:\u003c\/strong\u003e 60 rows; a unit is whatever you let separately\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBookings:\u003c\/strong\u003e nights, nightly rate, takings and occupancy per month\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRent Schedule:\u003c\/strong\u003e 400 rows of what was owed, what arrived and the gap\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome and Expenses:\u003c\/strong\u003e 400 rows each, every line pointed at a unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProperty P\u0026amp;L:\u003c\/strong\u003e income, costs, net, margin and yield per unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOccupancy:\u003c\/strong\u003e per unit and per month, against your target\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMaintenance:\u003c\/strong\u003e jobs, status and cost, pointed at a unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e six live figures and every unit underneath\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eSetup and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat it works out for you\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eArrears per unit and for the portfolio, calculated\u003c\/li\u003e\n\u003cli\u003eOccupancy per unit and per month, with voids counted\u003c\/li\u003e\n\u003cli\u003eWhat void months cost you, in money\u003c\/li\u003e\n\u003cli\u003eYield per unit, against what you actually paid for it\u003c\/li\u003e\n\u003cli\u003eTax to set aside, at your own rate\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eRental income, costs and yield all come from the same rows, so the dashboard and the ledgers always agree.\u003c\/p\u003e\u003cp\u003eYou get four real spreadsheet files: Excel and Google Sheets, each filled with a worked year and each blank and ready for yours. Both versions are the same build, so the file you open looks like the photos whichever one you use.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for use on your own portfolio; please do not share or resell them. This is a record-keeping tool, not tax or legal advice. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Google Sheets as well as Excel?\u003c\/h3\u003e\u003cp\u003eYes. The download has Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it connect to Airbnb or other booking sites?\u003c\/h3\u003e\u003cp\u003eNo. There are no add-ins, no macros and no connections. You enter your bookings and costs, and everything else is calculated.\u003c\/p\u003e\u003ch3\u003eHow is occupancy calculated?\u003c\/h3\u003e\u003cp\u003eAs nights let against nights available, per unit and per month, and compared with the target you set.\u003c\/p\u003e\u003ch3\u003eCan I track more than one property?\u003c\/h3\u003e\u003cp\u003eYes. The Units tab has 60 rows, and every booking, cost and maintenance job points at a unit for a per-property view.\u003c\/p\u003e\u003ch3\u003eWhere do platform fees and cleaning go?\u003c\/h3\u003e\u003cp\u003ePlatform commission and changeover cleaning each have their own expense line, so neither is hidden inside general costs.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862699102,"sku":"OPX-048","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/airbnb-vacation-rental-tracker-01.jpg?v=1790832199","url":"https:\/\/opxviashop.com\/products\/airbnb-vacation-rental-tracker","provider":"OPXVIA","version":"1.0","type":"link"}