How to Track Buy-to-Let Mortgage Payments in the UK
Updated 2026-11-19Why tracking mortgage payments matters
For small landlords with one to five properties, keeping an eye on mortgage balances, interest charges and repayment dates is essential for cash-flow planning. Without a clear record you can miss a repayment, underestimate profit or struggle to meet tax deadlines. A simple, regularly-updated system also helps you demonstrate compliance with landlord duties such as gas safety checks and deposit protection.
Setting up a basic spreadsheet
- Create a master sheet - label columns for Property ID, Mortgage lender, Loan amount, Interest rate, Start date, Current balance, Monthly payment, and Repayment due date.
- Add a date column - this will let you sort entries chronologically and spot upcoming payments.
- Link to a cash-flow overview - use simple formulas (e.g.,
=SUM(Monthly payment)) to calculate total monthly outgoings across all properties.
Recording interest and principal
Mortgage statements usually split each payment into interest and capital. Enter both parts in separate columns so you can: - Track how much interest you are paying each year - useful for the Self Assessment tax return. - See how quickly the loan is being reduced, which feeds into long-term budgeting.
Aligning with tax year and Self Assessment deadlines
The UK tax year runs from 6 April to 5 April. Online Self Assessment returns and payments are due by 31 January after the end of the tax year - check GOV.UK for the current rules. By updating your spreadsheet monthly you can pull the total interest paid for the tax year and enter the figure on your return without scrambling at the last minute.
Meeting landlord legal duties (England only)
When you rent out a property you must: - Carry out an annual gas safety check and give tenants a copy of the certificate - check GOV.UK for the current rules. - Provide an Electrical Installation Condition Report (EICR) that is valid for five years - check GOV.UK for the current rules. - Ensure the Energy Performance Certificate (EPC) is valid for ten years and has at least an E rating - check GOV.UK for the current rules. - Protect the tenancy deposit in a government-approved scheme within 30 days and give the tenant the protection details - check GOV.UK for the current rules. - Install a working smoke alarm on each storey used as living accommodation and a carbon-monoxide alarm where a fixed combustion appliance is present - check GOV.UK for the current rules. - Provide the government "How to Rent" guide and carry out Right-to-Rent checks - check GOV.UK for the current rules. - From 1 May 2026, new assured shorthold tenancy agreements become assured (periodic) tenancies under the Renters' Rights Act - check GOV.UK for the current rules.
Keeping a column in your spreadsheet for each of these duties (next inspection date, certificate expiry, deposit protection deadline) turns a financial tracker into a compliance dashboard.
Using software alongside Making Tax Digital (MTD)
If your qualifying self-employment or property income exceeds £50,000 for the 2024-25 tax year you must use MTD-compatible software from 6 April 2026 - check GOV.UK for the current rules. A plain spreadsheet is not MTD-compatible, but you can run the spreadsheet alongside "bridging" software that connects to HMRC. Record all mortgage interest in the spreadsheet, then export the totals to your MTD tool when filing your return.
Numbered steps to keep your tracker up to date
- Enter new mortgage statements within five days of receipt.
- Reconcile the balance against the lender's online portal - any discrepancy should be investigated promptly.
- Update the cash-flow overview to reflect the latest total monthly outgoings.
- Check upcoming landlord duties each month and flag any that fall within the next 30 days.
- Export interest totals at the end of the tax year for your Self Assessment return.
- Review the spreadsheet before the 31 January filing deadline to ensure all figures are correct.
FAQ
Q: Do I need a separate spreadsheet for each property? A: One master sheet with a row per property works well; you can use filters to view a single property's details.
Q: Can I rely solely on the spreadsheet for tax filing? A: The spreadsheet helps you gather figures, but you must still submit a Self Assessment return via HMRC's online service or MTD-compatible software - check GOV.UK for the current rules.
Q: What if my mortgage lender changes the interest rate? A: Update the interest-rate column immediately and recalculate the monthly payment using the new rate.
Final thoughts - a time-saving template
A well-designed spreadsheet can save hours of manual calculation and reduce the risk of missed deadlines. The Buy-to-Let Mortgage & Repayment Planner template provides pre-built columns for mortgage balances, interest, repayment dates, and landlord compliance tasks, so you can focus on growing your portfolio rather than chasing numbers. Use it as a shortcut to a tidy, up-to-date record-keeping system.