UK Landlord Rental Tracker | Rental Income & Expenses Spreadsheet, SA105 Categories

Keep the digital records behind your quarterly updates tidy: one dated line per transaction, in SA105 categories, with your share of jointly owned property and a tab per quarter that adds it all up.

Making Tax Digital for Income Tax requires HMRC-recognised software; use this workbook to keep and organise your records, together with bridging or MTD-compatible software. Not tax advice.

The UK Landlord Rental Tracker is a spreadsheet with no macros, for Excel 2016 or later, for up to 25 UK properties.

What you get

• UK-Landlord-Rental-Tracker.xlsx – 14 tabs, native formulas only:
  • Start Here and Settings: tax year, standard (6 April) or calendar (1 April) update periods with their deadlines, status date, the Making Tax Digital thresholds (£50,000 from 6 April 2026, £30,000 from 6 April 2027, £20,000 from 6 April 2028, from gov.uk), HMRC fixed mileage rates, SA105 categories, drop-down lists.
  • Properties: up to 25 properties, residential or non-residential, with your ownership share.
  • Income & Expenses: your dated records with property, tenancy, SA105 category and box, your share and the update period.
  • Tenants & Rent Roll: rent due from each tenancy and rent received read from the records; arrears to the status date.
  • Q1, Q2, Q3 and Q4 Update: totals by SA105 category for the period and cumulative from the start of the tax year, memo items (residential finance costs box 44, replacement of domestic items box 36, capital costs) and four checks to clear before you send.
  • Mortgages & Finance: repayment or interest-only loans; interest and capital by payment, allocated to the quarter of the payment date; box 44 for residential lets, box 26 for non-residential.
  • Deposits: protection within 30 days and return within 10 days of agreement flagged (England: gov.uk; Wales: the same 30-day protection for occupation contracts).
  • Mileage: journeys at 55p for the first 10,000 car miles and 25p after (2026 to 2027, HMRC PIM2220), 24p for motorcycles.
  • Dashboard: rent, arrears, profit before finance costs (your share), finance costs, cash flow before capital costs, yields by property, monthly cash flow, 2 charts and the year's update timetable.
  • Deal Analyser: three purchases side by side, before tax, with voids in weeks, interest-only or repayment, yields, cash-on-cash and rental cover at your lender's stress rate. Delivered with a fictitious portfolio of 3 properties (a flat, a jointly owned house and a shop).
• UK-Landlord-Rental-Tracker-Guide.pdf – 8 pages: Making Tax Digital for Income Tax in short (who, when, periods, deadlines, digital records), the SA105 boxes in plain English, each tab explained, and the gov.uk sources with their dates, checked on 17 October 2026.

What it is not

It does not connect to HMRC, does not send updates and does not calculate your tax. Use it with HMRC-recognised (bridging or MTD-compatible) software of your choice.

Quality

No add-ins. Built in Excel with functions that Google Sheets also supports (no macros, no XLOOKUP, LET, LAMBDA or dynamic arrays). If you import it into Google Sheets, check charts, colours and drop-down lists after import. Recalculated in Excel with 0 formula errors; quarterly totals, finance costs, arrears and the sample deal were checked against an independent calculation.

Personal use for your own lettings. Resale and redistribution are not allowed.

Fictitious sample data. Written with AI assistance and reviewed. Not legal, tax or financial advice.

Seller: SASU MOE CAPITAL, 95 impasse des Garennes, 81710 Saïx, France. Terms of Service · Consumers: 14-day right of withdrawal, Withdraw from contract here · Consumer mediator (France): Société de la Médiation Professionnelle (SMP), Alteritae, 5 rue Salvaing, 12000 Rodez, France – www.mediateur-consommation-smp.fr.