Rental Property Income & Expenses Template
Track rental income and property-related expenses across multiple properties. Perfect for UK landlords.
File format: .xlsx (Microsoft Excel, Google Sheets, LibreOffice compatible)
Property Tracker
- Track up to 5 properties
- Rent roll per property
- Property expense categories
- Mortgage interest tracker
What is a Rental Property Income & Expenses Tracker?
A Rental Property Income & Expenses Tracker is a dedicated spreadsheet for UK landlords to record rent received, property expenses, mortgage interest, and maintenance costs across multiple properties. It calculates taxable profit per property and in total, producing clean figures for your Self Assessment SA105 tax return.
Common use cases:
- Recording rental income from tenants across multiple properties
- Tracking property expenses: repairs, maintenance, insurance, agent fees
- Calculating taxable profit after Section 24 mortgage interest restrictions
- Preparing SA105 property income figures for Self Assessment
- Monitoring which properties are profitable and which are costing money
When to use this template
- You are a UK landlord with one or more rental properties
- You need to report property income on your Self Assessment tax return
- You want to understand the true profitability of each property
- You need to track Section 24 mortgage interest relief calculations
What Your Template Contains
Everything you need, pre-built and ready to use. Just enter your data in the blue cells.
Track Up to 5 Properties
Separate income and expense sections for each property. Add more sheets if needed for larger portfolios.
Rent Roll Per Property
Record monthly rent received, tenant details, and lease dates. See rental income trends at a glance.
Property Expense Categories
Repairs, maintenance, insurance, letting agent fees, council tax, utilities, ground rent, and more — all SA105-aligned.
Mortgage Interest Tracker
Records mortgage interest paid per property. The template calculates the 20% tax credit under Section 24 restrictions.
Taxable Profit Calculation
Auto-calculates profit per property and total portfolio profit, accounting for allowable expenses and restrictions.
Annual Summary for Tax Return
Year-end totals ready for your SA105 property income pages. No manual adding up at tax time.
How This Template Helps Your Business
HMRC-Ready Property Records
All categories align with HMRC SA105 form. When it is tax time, copy the figures straight to your return. No recategorising, no guessing.
Know Your Real Profit Per Property
One property might look profitable until you factor in maintenance and mortgage interest. This template reveals the truth — per property and portfolio-wide.
Section 24 Made Simple
Mortgage interest is no longer fully deductible. The template handles the 20% tax credit calculation automatically — one of the most confusing parts of landlord tax.
Get Started in Minutes
No accounting knowledge required. Follow these simple steps and you'll be tracking your finances in no time.
Download TemplateDownload the template and open in Excel or Google Sheets
Enter your property details and tenant information on the cover sheet
Record rent received each month in the income section per property
Record all property expenses as they occur — repairs, insurance, fees, etc.
Enter mortgage interest payments in the dedicated mortgage section
Review the annual summary for your SA105 tax return figures
Related Templates
You might also find these useful
Cash Book
Track income and expenses month by month with automatic running balance, bank reconciliation, and profit summary.
Self-Employed Log
Designed for sole traders and freelancers. Simple transaction list that auto-summarises into HMRC-friendly categories.
MTD Quarterly
Making Tax Digital quarterly updates for UK landlords. 4 quarterly income and expense sheets with MTD-aligned categories.
Expense Tracker
Detailed expense logging with receipt tracking, mileage integration, and HMRC-compliant categorisation.
Frequently Asked Questions
Quick answers about this template
Ready to Get Started?
Download this free template and take control of your business finances today.
Free download, no email required. Works in Excel and Google Sheets.