For landlords with one to a few properties

Landlords

• 

  For landlords letting one or more homes in the UK

  Rental income and expenses

  Log your rent and your letting costs for each property through the tax year. The workbook adds up each property, sorts your costs by category, keeps mortgage interest and other finance costs apart from your expenses, and sets your income against the £1,000 property allowance.

  £9Excel (.xlsx) and Google Sheets

• 

  For landlords with one or more let properties

  Property portfolio overview

  See every property you let on one page: what it's worth, what you owe, your equity and loan to value, the rent, the monthly costs, the cash left over and the gross yield. A second sheet keeps each property's safety and renewal dates, works out when the gas check, the electrics and the EPC are next due, and turns a date amber when it's within 60 days.

  £9Excel (.xlsx) and Google Sheets

• 

  For landlords keeping their own deposit and inspection records

  Deposit and inspection log

  Keep one row for each tenancy deposit: when you got it, which scheme protects it, when you gave your tenants the required information, and when and how much you gave back. The log works out the date it had to be protected by, the deposit cap for the rent, and flags anything that looks late or over the cap. A second sheet records each inspection: check-in, mid-tenancy and check-out.

  FreeExcel (.xlsx) and Google Sheets