Landlord MTD ITSA Quarterly Tracker — Property Income (SA105)

For landlords brought into Making Tax Digital for Income Tax, the hardest calculation is usually the Section 24 finance-cost restriction — since April 2020 mortgage interest can't be deducted from rental profit; instead you get a 20% tax reduction on the lowest of your finance costs, your property profit, and your income above the Personal Allowance, with any excess carried forward. This Excel tracker is built to get that right.

The ten tabs include:

• Settings for up to five named properties, cash or traditional basis
• Income and Expense Logs mapped to the correct SA105 boxes, per property, with a 'disallowable / private use' category
• A cumulative Quarterly Update showing residential finance costs separately, as the rules require
• A Property Dashboard: income, costs and profit per property
• A Year-End SA105 tab with every figure box by box, including the Section 24 reducer and carry-forward
• Deadlines & Penalty Points, covering the post-2025 abolition of Furnished Holiday Lettings rules

Every box is mapped against HMRC's published SA105 form, and the maths — including all three limiting cases of the Section 24 reducer plus carry-forward — is proven with a 41-transaction, 3-property worked example, hand-calculated then independently re-checked. 90 of 90 QA checks pass, shown on the file's QA & Version tab.

This is a record-keeping tool, not tax advice and not HMRC-recognised filing software.