Landlord Rental Property Tracker

Know which tenants have paid, what each property really makes, and when the next gas safety certificate is due, all in one spreadsheet that does the maths for you. Made for UK landlords with 1 to 10 properties. The UK edition runs on the tax year (6 April to 5 April), groups every expense under the matching section of the property pages of the tax return, keeps mortgage interest on its own line, and gives you quarterly totals with the usual update dates. A US edition (calendar year, rental schedule lines, $) is included too. Works in Google Sheets AND Excel. WHAT'S INSIDE (9 tabs) - Dashboard: rent and income, running costs, profit and arrears this tax year, every property side by side (profit, your share if you own it jointly, arrears, gross yield) and the next 6 things due - Setup: up to 10 properties with tenant, monthly rent, the day rent is due, tenancy start, deposit and scheme reference, your share and property value. 16 expense categories, each linked to a tax return section (all editable) - Rent and Income: 600 rows for rent, late fees, deposit deductions you keep and other income - Expenses: 600 rows. Pick a category and the tax return section fills in. Tick receipts, and missing ones are flagged - Rent Check: every property, every month. Green = paid, amber = part paid, red = missed. Arrears worked out from the rent and due day - Safety and Renewals: gas safety, electrical checks (EICR), energy certificates, smoke and CO alarms, deposit protection, insurance, tenancy renewals and more. Type when it was last done and how often, and lines turn amber when due soon and red when overdue - Quarterly Totals: income and expenses for each quarter, by tax return section, with capital costs and mortgage interest kept separate - Month by Month: income, running costs, mortgage interest and profit, with a chart WHAT YOU GET - 2 versions: £ (UK tax year) and $ (US calendar year) - Quick Start guide (PDF) Reusable every year: keep logging and the dates move on to the new tax year by themselves. HOW IT WORKS - Download the files from your Etsy Purchases page - Google Sheets: upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets - Excel: just open it (Excel 2010 or later, Windows or Mac, or Excel for the web) - Type in the cream cells. Everything else updates on its own - A Quick Start PDF walks you through setup in 5 minutes GOOD TO KNOW - Plain formulas only: no macros, no add-ins, no subscriptions - Formula cells are locked so you can't break them by accident (no password, so you can unlock and customise) - Apple Numbers and LibreOffice aren't officially supported PLEASE NOTE - This is a DIGITAL download. Nothing physical will be shipped. - Personal use only. Please don't share or resell the files. This is a record-keeping tool, not tax or legal advice. It does not send anything to the tax office: quarterly updates need recognised software (bridging software can read your spreadsheet). Always check the official rules for your property. Designed by Thexton Labs. Artwork and layouts were created with our own code, with the help of AI tools.