{"product_id":"tenant-lease-tracker-spreadsheet","title":"Tenant Lease Tracker Spreadsheet","description":"\u003cp\u003eThis tenant lease tracker keeps the calendar a landlord has to follow, not just the rent. Every lease date counts down from today, and the checks that repeat, such as an annual gas safety certificate, roll forward on their own cycle for as long as the tenancy runs.\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\u003eLease events that roll forward\u003c\/h2\u003e\u003cp\u003eA certificate that is due every twelve months is not a date you type once. The Lease Events tab handles that for you.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTwenty-six lease events across ten tenancies in the demo, every one counted down from today\u003c\/li\u003e\n\u003cli\u003eRecurring events roll forward on their own cycle: quarterly inspections, annual gas certificates, five-yearly electrical reports, deposit re-registrations and rent reviews\u003c\/li\u003e\n\u003cli\u003eEvery date comes from the tenancy start on the Tenancies tab, so changing one start date moves all of that tenancy's dates with it\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCompliance kept apart\u003c\/h2\u003e\u003cp\u003eProperty compliance is counted separately from everything else. A fixed term that has ended and is now rolling month to month is normal. An expired gas safety certificate is not, and only that kind of overdue date turns red.\u003c\/p\u003e\u003ch2\u003eRent, money and maintenance\u003c\/h2\u003e\u003cp\u003eThe rest of this landlord spreadsheet covers the money side of each rental property. Everything recalculates from one list, so nothing is typed twice.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA rent payment tracker: rent owed against rent arrived for each unit and month, with the gap shown\u003c\/li\u003e\n\u003cli\u003eIncome and expenses, coded to the property\u003c\/li\u003e\n\u003cli\u003eMaintenance jobs recorded against the unit they belong to\u003c\/li\u003e\n\u003cli\u003eProfit and loss for each property, not averaged across them\u003c\/li\u003e\n\u003cli\u003eEvery total, margin, percentage and date calculated for you\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not static pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTwelve connected tabs\u003c\/h2\u003e\u003cp\u003eA Start Here tab walks you through setup in a few minutes. The workbook covers setup, units, tenancies, lease events, the rent schedule, income, expenses, maintenance, property profit and loss, occupancy and a dashboard, so your rental bookkeeping and your dates live in the same file.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: a worked demo you can click through, and a blank one ready for your properties\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. 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 work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eDo I have to type every renewal date myself?\u003c\/h3\u003e\u003cp\u003eNo. Lease dates come from the tenancy start date, and recurring events such as inspections, gas certificates and electrical reports roll forward on their own cycle.\u003c\/p\u003e\u003ch3\u003eHow does it treat an overdue compliance check?\u003c\/h3\u003e\u003cp\u003eCompliance items are counted separately from ordinary renewals, and only an overdue compliance date turns red.\u003c\/p\u003e\u003ch3\u003eCan I see which tenants are behind on rent?\u003c\/h3\u003e\u003cp\u003eYes. The rent schedule compares rent owed with rent received for each unit and month and shows the gap.\u003c\/p\u003e\u003ch3\u003eDoes it give profit per property?\u003c\/h3\u003e\u003cp\u003eYes. Income and expenses are coded to each property, and profit and loss is shown property by property.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864599646,"sku":"OPX-085","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/tenant-lease-tracker-spreadsheet-01.jpg?v=1790832414","url":"https:\/\/opxviashop.com\/products\/tenant-lease-tracker-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}