← All prebuilt solutions
Property

Landlord Tracker

Rental income, costs, MTD and tax – property by property

£20

Secure checkout. Your download link is sent as soon as payment clears.

Landlord Tracker

Overview

Rental property brings its own tax rules: mortgage interest on homes isn't deducted from profit, repairs are treated differently from improvements, jointly owned properties are split by ownership share, and from April 2027 property income has its own tax rates. This workbook keeps your rent and costs for up to 10 properties in HMRC's UK property categories, works out your share automatically, builds the cumulative figures for Making Tax Digital quarterly updates, and estimates the tax on your rental profit after the mortgage interest tax credit.

Price
£20
Who it’s for
Property
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Properties

Your portfolio – up to 10 properties. What you do: one row per property in the yellow columns.

Properties
Transactions

Step 2

Transactions

Every rent receipt and property cost. What you do: one line per transaction.

Step 3

Property P&L

Income and costs by category for each property (your share, this tax year). What you do: nothing to enter.

Property P&L
Quarterly Updates

Step 4

Quarterly Updates

Submission tracker and the cumulative figures for each MTD update. What you do: mark quarters as submitted.

Who it is for

Made for people like you

  • Example – text
  • Landlords in MTD for Income Tax – The cumulative figures (your share) to enter in your MTD software each quarter, with a deadline tracker.
  • Landlords with a job or pension – A tax estimate that puts your rental profit on top of your other income, so you see the real rate you'll pay.
  • Joint owners – Enter every transaction in full once – your ownership share is applied automatically.
  • Portfolio landlords – Profit by property, plus portfolio value, equity, gross yield and loan-to-value.
  • WATCH OUT – This workbook prepares figures – it doesn't submit anything to HMRC. Quarterly updates and the final declaration must go through HMRC-recognised MTD software (your accountant can do this for you). It doesn't cover furnished holiday lets, overseas property, non-resident landlords, properties owned through a company, or capital gains.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your name, tax year and quarter type, your other taxable income and the tax already paid on it through PAYE, whether you're a Scottish taxpayer, any losses or unrelieved mortgage interest brought forward, and last year's Self Assessment bill and tax collected at source.
  2. Properties – List each property with its ID (P1, P2…), address, type and YOUR share. Add the purchase price, value, mortgage, monthly rent, agent fee and let date for the portfolio figures.
  3. Transactions – Enter every rent receipt and property cost in full, with the property ID and the category. Fix any line whose Check says 'Check:'.
  4. Property P&L – See how each property is doing – profit before and after mortgage interest.
  5. Quarterly Updates – If you're in MTD, copy the cumulative column for the latest quarter into your software, then mark it as submitted.
  6. Year End & Tax – Check the taxable profit, the mortgage interest credit and the tax due on your rents, and how much to set aside each month.

Key features

  • Up to 10 properties with joint ownership, values, mortgages, yields and loan-to-value.
  • Record rent and costs in HMRC's UK property categories; your share is worked out automatically.
  • Cumulative MTD quarterly figures with deadlines and a submission tracker.
  • Tax estimate with the mortgage interest tax credit, property allowance check, losses and the 2027 property tax rates.

What’s included

  • Dashboard – Year so far, portfolio and charts
  • Settings – Your details, quarters and other income
  • Properties – Your portfolio
  • Transactions – Rent and costs
  • Property P&L – Profit by property
  • Quarterly Updates – MTD figures to submit
  • Year End & Tax – Taxable profit and tax estimate
  • Categories – HMRC property categories explained
  • Tax Rates – Rates and allowances
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions