For UK landlords · Updated for the 2026/27 tax year
One spreadsheet that shows your profit, flags late rent and adds up your Making Tax Digital quarters for you. For 1 to 20 properties, in Excel or Google Sheets.
Screens from the included example file. All names and figures are fictional.
The list
Rent in, costs out, profit and an estimate of the tax to set aside, for your share, this tax year. The Dashboard updates every time you add a row, so you never have to add up a column again.
A "What needs your attention" list tells you what to do next: rent to chase, a missing receipt, the next deadline.
Rent Check compares the rent you received with the rent due, month by month, for every property. Part payments turn amber, missed rent turns red, and the Dashboard tells you who to chase.
You'll spot a £395 short payment in October, not in January when you finally do the books.
£400 behind, flagged automaticallyMortgage interest, letting agent fees, insurance and service charges go in once. The tracker posts them every month, quarter, six months or year, in the right SA105 box.
About 10 minutes a month is enough to keep everything up to date.
Each Making Tax Digital quarter is added up for you, on its own and cumulatively, with the date the update is due, the days left and a status: Submitted, Due soon or Period open.
The 2026/27 dates (7 Aug, 7 Nov, 7 Feb, 7 May) are built in, taken from gov.uk.
Q2 due soon · 5 days leftEvery cost lands in its SA105 box as you enter it: 24, 25, 26, 27, 28, 29 and 36, with residential finance costs kept apart in box 44. At year end your Self Assessment figures are already laid out, box by box.
No more sorting a year of receipts into categories in April.
Residential mortgage interest is kept out of your expenses and your 20% tax credit is estimated. The tracker also compares your actual costs with the £1,000 property allowance and shows the better option.
Estimates only, to help you plan. Check them against HMRC guidance or with your accountant.
The first tab gives you a three-step plan and a health check. An example file with five fictional properties shows how everything works, and a one-page Start-here guide walks you through it.
Cream cells are for you, the rest is worked out. Sheets are protected (no password) so formulas don't get overwritten by accident.
Compare
| Feature | Receipts & bank statements | A blank spreadsheet | This tracker |
|---|---|---|---|
| Profit per property, live | ✗No | ~ If you build it | ✓ Dashboard + P&L |
| Late rent flagged | ✗No | ~ Manual | ✓ Amber / red |
| Costs sorted into SA105 boxes | ✗ In April | ~ Your own categories | ✓ As you type |
| MTD quarter totals & due dates | ✗No | ~ You add them up | ✓ Built in for 2026/27 |
| Section 24 & £1,000 allowance | ✗No | ✗No | ✓ Estimated |
| Joint-owner share | ✗No | ~ Extra formulas | ✓ Enter it once |
| Cost | Free, plus your time | Free, plus your time | £16.99 once |
Need to send MTD updates? You still need HMRC-recognised software or bridging software. This tracker keeps your records and works out the figures to copy across. It never connects to HMRC.
What's inside
Is it right for you?
How it works
Tax year, tax rate, your properties, rent and regular costs.
Rent and one-off costs, each with a receipt reference.
Open the Dashboard, then copy your MTD quarter figures into your MTD software.
The 2026 change
Since 6 April 2026, landlords and sole traders with qualifying income over £50,000 must keep digital records and send HMRC a quarterly update. The threshold drops to £30,000 from April 2027 and £20,000 from April 2028.
A quarterly update is not a tax return and no tax is paid with it. HMRC says spreadsheets can be used alongside bridging software, which is where this tracker fits.
Sources: GOV.UK: Five things you need to know ahead of the MTD quarterly deadline · GOV.UK: Using MTD for Income Tax for the first time · GOV.UK: Penalties for MTD for Income Tax
HMRC says no penalty points apply for late quarterly updates in the 2026/27 tax year.
The offer
£16.99one-off · no subscription
Price includes VAT where applicable — calculated at checkout. Secure checkout by Payhip.
Digital download, nothing is posted. A record-keeping and planning aid, not tax advice. Terms & licence.
FAQ
No. It works out the figures for your Self Assessment (SA105) and your Making Tax Digital quarterly updates. You copy them into your tax return or your MTD software (or bridging software). It never connects to HMRC and is not HMRC-recognised software.
Microsoft Excel 2010 or newer (Windows and Mac) and Microsoft 365, and Google Sheets with a free Google account. There are no macros, so there's nothing to enable. Apple Numbers isn't supported, and a computer is recommended for data entry.
Yes. Enter what you have so far. The Dashboard and MTD tabs update as you add rows.
Yes. Record the full rent and costs and enter your share once per property. Every tax figure then uses your share.
No. It's built for individual UK landlords and joint owners: the 6 April tax year, HMRC's SA105 boxes, Section 24 and MTD for Income Tax, on the cash basis.
Yes. Change the tax year on the Settings tab and start a fresh copy of the blank file.
No. It's an estimate to help you set money aside. It doesn't model your personal allowance or other income. Check with HMRC guidance or an accountant before you file.
You get an instant download link for the zip: the example file, the blank file and the Start-here guide. Nothing physical is posted.
Yes. Message us at info@phkmedia.co.uk and we'll help you set it up.
