{"product_id":"rental-property-tracker-landlord","title":"Rental Property Tracker Spreadsheet","description":"\u003cp\u003eThis rental property tracker puts the rent that was due and the rent that arrived on the same row, so arrears are a number rather than a feeling. It is a landlord spreadsheet for anyone with one unit or twenty who wants arrears and voids measured 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\u003eArrears and voids, kept apart\u003c\/h2\u003e\u003cp\u003eArrears is the gap between what was due and what came in, calculated for each unit and for the whole portfolio. A void month owes nothing and counts against occupancy instead, so a quiet month and an unpaid month never look the same.\u003c\/p\u003e\u003ch2\u003eEnter a unit once\u003c\/h2\u003e\u003cp\u003eEach unit is entered once. Every rent row, every cost and every maintenance job points at it, which is how the per-property view works without anything being keyed in twice. A unit is whatever you let separately.\u003c\/p\u003e\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eUnits:\u003c\/strong\u003e 60 rows\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRent Schedule:\u003c\/strong\u003e 400 rows of what was owed, what arrived and the gap, a rent tracker by unit\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 for each unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTenancies:\u003c\/strong\u003e a tenant tracker showing who is in which unit, on what terms and until when\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOccupancy:\u003c\/strong\u003e let against void, per unit and per month\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMaintenance:\u003c\/strong\u003e reported, quoted, booked, done, and what it cost\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\u003eFor a property investor comparing units, the yield figure uses what you actually paid for each one.\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\u003eDoes it run in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow many properties can I track?\u003c\/h3\u003e\u003cp\u003eThe Units tab has 60 rows, and a unit is whatever you let separately, so a house split into rooms can be several units.\u003c\/p\u003e\u003ch3\u003eHow does it tell arrears from an empty unit?\u003c\/h3\u003e\u003cp\u003eA void month owes nothing and counts against occupancy, while arrears is the gap between what was due and what came in. The two are never mixed.\u003c\/p\u003e\u003ch3\u003eCan I track repairs?\u003c\/h3\u003e\u003cp\u003eYes. The Maintenance tab follows each job from reported to quoted, booked and done, with what it cost, pointed at the unit.\u003c\/p\u003e\u003ch3\u003eDoes it work out tax?\u003c\/h3\u003e\u003cp\u003eIt works out tax to set aside at a rate you choose. It is a record-keeping tool, not tax or legal advice.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862666334,"sku":"OPX-047","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/rental-property-tracker-landlord-01.jpg?v=1790832193","url":"https:\/\/opxviashop.com\/products\/rental-property-tracker-landlord","provider":"OPXVIA","version":"1.0","type":"link"}