Short answer
Our UK Landlord MTD Record-Keeping Kit 2026/27 (£19.99) is a one-off Excel (.xlsx) and Google Sheets workbook for UK residential landlords. You log rent and expenses once; the workbook separates your per-property profit and loss while combining all UK properties into a single set of cumulative quarterly figures mapped to HMRC's SA105 boxes. Record-keeping only; does not submit directly to HMRC.
Last checked against GOV.UK: 23 October 2026. Sources are linked in each section. HMRC updates its guidance, so always check the source before you act.
The problem UK landlords face under Making Tax Digital
Under HMRC's Making Tax Digital for Income Tax rules, landlords with qualifying gross income over £50,000 (from 6 April 2026, based on 2024/25) or over £30,000 (from 6 April 2027, based on 2025/26) must keep digital records of every property income and expense transaction (date, amount and HMRC category) and send four cumulative quarterly updates a year for their UK property business as a whole.
- One UK property update, multiple properties: HMRC requires a single combined UK property update across all your properties, while you still need per-property rent, expenses and net yield for your own records.
- Section 24 residential finance costs must stay separate: mortgage interest and loan finance costs on residential lets (SA105 box 44) receive a 20% basic-rate tax reduction rather than being deducted from rental income alongside repairs or insurance (GOV.UK).
- Cumulative year-to-date quarters & the 1–5 April boundary: each MTD quarterly update covers from 6 April to the end of the quarter (or from 1 April if your accounts run 1 April–31 March and you elect calendar quarters in your software before sending Update 1; GOV.UK). If your 2025/26 Self Assessment return ran to 5 April 2026, transactions dated 1–5 April 2026 belong to 2025/26 and must not be entered into your 2026/27 workbook.
Not sure when you join MTD or whether the £1,000 property allowance beats actual expenses? Use our free Making Tax Digital deadline checker and £1,000 property allowance calculator.
See the finished result (fictional sample data)
Below are actual screenshots from our UK Landlord MTD Record-Keeping Kit 2026/27 populated with fictional sample transactions only (three imaginary properties: 14 Oak Road, Flat 3, Mill Court and 22 Station Street). Select either image to open the full-resolution PNG in a new tab on mobile.
A landlord's year with the kit: monthly, quarterly and year-end (fictional example)
Short answer: each month you log the rent that came in and the bills that went out. After each quarter ends, the kit already shows the year-to-date totals, and you use separate HMRC-recognised bridging software to send them. After the tax year ends, the full-year figures are ready for your tax return. The spreadsheet keeps the records; the bridging software does the sending.
Fictional example. The landlord and the three properties (14 Oak Road, Flat 3, Mill Court and 22 Station Street) are made up and match the sample screenshots above. This shows one way to organise the routine. It is not tax advice, and how long it takes depends on how many transactions you have.
Each month: log what came in and what went out
- Add each rent payment as it arrives, with the date, the amount and the property it came from.
- Add each bill or receipt, for example a plumber's invoice for Flat 3, Mill Court or the letting agent's fee for 22 Station Street. Choose the property and pick the expense type from the dropdown.
- Keep the receipt or invoice somewhere safe, such as a folder or a photo on your phone.
- Check the warnings: the kit flags any row with no expense type or property, so you can fix it while you still remember what it was.
Each quarter: check the totals, then send them with bridging software
- After the quarter ends, open the Quarterly Summary. The year-to-date totals for the update that is due are already worked out, so there is nothing to add up yourself.
- Sense-check each property on the Per-Property Summary, for example whether the rent for 14 Oak Road matches the months it was let.
- Use HMRC-recognised bridging software to send the update, with the figures linked digitally from the workbook (an upload or import, not retyping). Some bridging tools are listed on GOV.UK with a free version, for example TaxUpdates (HMRC ID 3303) and My Tax Digital (Free) (HMRC ID 3255). Compatibility with our spreadsheet has not yet been verified, so check each tool's import format and pricing first in our MTD filing and bridging software guide.
- Mark the update as sent in the workbook, with the date. In the sample, Update 1 is marked as sent on 1 August 2026, before its 7 August deadline.
For 2026/27 the quarterly update deadlines are 7 August 2026, 7 November 2026, 7 February 2027 and 7 May 2027, whether you use standard or calendar quarters. A quarter with no transactions still needs an update (GOV.UK).
After the tax year ends: your tax return
- Once the year ends on 5 April 2027 and Update 4 is sent, the Annual Summary shows the full-year property figures, including how the £1,000 property allowance compares with your actual expenses.
- Make any year-end adjustments and submit your tax return (the Final Declaration) by 31 January 2028, using software that supports it. A tool with free quarterly updates does not automatically cover the year-end return, so check its GOV.UK listing before you rely on it.
What the example landlord ends up with: every property's rent and bills in one place, year-to-date totals ready each quarter, a clear view of how each let is doing, and full-year figures ready for the tax return.
What this spreadsheet does – and what it does not do
Record-keeping only; does not submit directly to HMRC. We do not promise tax savings, guaranteed time saved, or universal MTD compliance from buying a spreadsheet alone.
What this kit DOES
- Records date, amount, property and HMRC category for up to 500 income rows and 500 expense rows in 2026/27.
- Supports both standard tax-year quarters (from 6 April) and calendar quarters (from 1 April) via a single Settings dropdown.
- Applies your ownership share % per property for jointly owned rental property.
- Separates Section 24 residential finance costs (box 44) from deductible property running costs (boxes 24–29) and flags unused finance costs brought forward (box 45).
- Compares the £1,000 property allowance against your logged allowable expenses on the Annual Summary tab.
What this kit DOES NOT do
- Record-keeping only; does not submit directly to HMRC. Spreadsheets cannot talk to HMRC's API by themselves.
- Does not replace MTD bridging or filing software (you still need HMRC-recognised software to send quarterly updates and your Final Declaration).
- Does not calculate your overall personal Income Tax bill across employment, pension, dividend or Scottish/rest-of-UK tax bands.
- Does not handle foreign property (SA106), Furnished Holiday Lettings rules prior to April 2025, or limited company (Corporation Tax) accounts.
- Negative cumulative category limitation: individual refund rows reduce a category's cumulative total automatically while that category stays at £0.00 or above, but HMRC's MTD API and bridging templates reject net-negative category totals (
< £0.00). If a refund makes an entire SA105 category negative for the year to date, export for that box is blocked (CHECK (<0)) until you review or reallocate the adjustment.
What's inside the UK Landlord MTD Record-Keeping Kit (£19.99)
The workbook contains 9 unlocked worksheets with formula protection hints, dropdown validation and zero macros:
| Worksheet tab | What it records or calculates |
|---|---|
| 1. Start Here | Step-by-step setup checklist, colour key (pale yellow = your inputs; white/grey = automatic formulas) and GOV.UK source links. |
| 2. Settings | Choose Standard (6 April) or Calendar (1 April) update periods, toggle HMRC's two-total expense consolidation (under £90,000 turnover), and enter any brought-forward property loss or unused Section 24 finance costs. |
| 3. Properties | Register up to 10 UK rental properties with address/nickname, ownership share % (e.g. 50% for a joint let), letting type and notes. |
| 4. Income Log | 500-row digital log for rent received and other property income, with automatic quarter assignment, ownership-share scaling and uncategorised-row warnings. |
| 5. Expense Log | 500-row digital log mapped to HMRC's SA105 categories (full landlord expenses list), plus separate tags for Section 24 residential finance costs, capital costs and personal items. |
| 6. Quarterly Summary | Update 1–4 deadline tracker, Section A cumulative MTD figures (with SA105 box references), Section B discrete 3-month figures, and Section C memo items excluded from update totals. |
| 7. Per-Property Summary | Side-by-side income, allowable expenses, net rental profit and Section 24 finance costs for each of your 10 property slots. |
| 8. Annual Summary | Full-year SA105 box summary, £1,000 property allowance vs actual expenses comparison, and a 20% Section 24 finance cost tax-reduction illustration (noting that overall tax depends on your other income). |
| 9. Lists | Reference table of HMRC UK property categories and SA105 box numbers used by the dropdown menus. |
Also for landlords: Renters' Rights Admin Pack & Landlord + Sole Trader Bundle
If you let residential property in England, the Renters' Rights Act 2025 introduces new tenancy rules from 1 May 2026 (including the 31 May 2026 tenant Information Sheet deadline, Section 13 rent-increase notice rules and pet-request response limits – test your dates in our free Renters' Rights dates checker). If you have both rental property and self-employed income, our bundle pairs both MTD kits at a lower combined price.
Planned: a monthly landlord MTD and tax deadline digest. Join the free landlord membership waitlist.
Questions
What file format do I get, and how is it delivered?
You receive an instant digital download immediately after checkout containing the unlocked .xlsx spreadsheet workbook (no macros or VBA) and a PDF Quick-Start Guide that includes a one-click link to copy the workbook into a free Google Sheets account.
Which spreadsheet programs and devices are supported?
The workbook works in Microsoft Excel (2016, 2019, 2021 and Microsoft 365 on Windows and Mac), free Google Sheets in any modern browser, and LibreOffice Calc.
Does this spreadsheet submit my quarterly updates to HMRC?
No. This kit is for record-keeping only; it does not submit directly to HMRC. If you are required to use Making Tax Digital for Income Tax, you must use HMRC-recognised bridging or filing software to send your quarterly updates and Final Declaration. See our MTD filing and bridging software guide.
What does a landlord's routine with the kit look like?
Log rent and bills as they happen, check the year-to-date totals after each quarter ends, then use separate HMRC-recognised bridging software to send each quarterly update, and after the tax year ends submit your tax return using software that supports it. The kit keeps the records; it does not submit directly to HMRC. See the fictional worked example on this page.
Will I have to pay separate software fees to file with HMRC?
Possibly. Buying our workbook is a one-off payment (£19.99) for the spreadsheet itself. Bridging and filing software is provided by third-party vendors listed on GOV.UK: some offer free tiers for quarterly updates, while others charge monthly or annual fees or restrict free plans at year-end. Check our software explainer and the official GOV.UK software finder before choosing a filing tool.
What is your refund and cancellation policy for digital downloads?
Under Regulation 37 of the UK Consumer Contracts (Information, Cancellation and Additional Charges) Regulations 2013, you have a 14-day statutory cancellation period for digital downloads. You only lose that 14-day right to cancel before the 14 days expire if you start downloading or copying the files after giving explicit prior consent to immediate supply and acknowledging that your right to cancel will be lost once the download begins (where those consent and acknowledgment steps are not completed, or before downloading starts, the 14-day cancellation right remains). Separate from cancellation rights, under the Consumer Rights Act 2015 (sections 34–37), digital content must be of satisfactory quality, fit for purpose and as described – if a file is faulty or does not match its description, email [email protected] for a repair, replacement or refund.
What if I also have self-employed income or need England tenancy deadline tracking?
UK property and self-employment have separate MTD quarterly updates and different HMRC categories (SA105 vs SA103F). Our UK MTD Spreadsheet Bundle (£29.99) includes both the Landlord and Sole Trader workbooks. For England tenancy admin (Section 13 rent-increase notice dates, pet-request deadlines and safety certificates), see our Renters' Rights Act Landlord Admin Pack (£14.99) below.
How do I get support if I have a question about the workbook?
Email [email protected] if you need help downloading, opening or using the spreadsheet formulas. We cannot provide personal tax, legal or accounting advice.
About TaxYearSheets: what we do and don't do
What we do: UK record-keeping spreadsheets (Excel and Google Sheets) and free browser-based checkers for landlords, sole traders and online sellers. Every date and rate is sourced to GOV.UK or legislation.gov.uk.
What we don't do: we're not HMRC software and we're not connected to HMRC. Our spreadsheets don't submit anything to HMRC; if you're in Making Tax Digital you still need software that works with it. Nothing here is personal tax advice. More about us.
Free UK tax deadline reminders
A short email 1–3 weeks before key UK tax dates: Making Tax Digital quarterly updates, the 31 January Self Assessment deadline and the end of the tax year. Each one says what's due and who it applies to, and links to the GOV.UK source.
- How often: about once a month, never more than 2 a month.
- What else: occasionally a note about our record-keeping spreadsheets. No spam, and we never share or sell your address.
- Leave any time: there's an unsubscribe link in every email.