How to Use the UK Landlord Income & Expense Spreadsheet
Learn how to use the UK Landlord Income & Expense Spreadsheet to keep track of your rental property finances in one place. In this video, we walk through the spreadsheet step by step, showing you how to record rental income, enter property expenses and monitor the financial performance of your portfolio. Whether you own one rental property or manage several, this tutorial will help you get started and make the most of the spreadsheet.
This UK landlord income and expense spreadsheet is designed to work as a simple landlord accounting spreadsheet, helping property owners record rental income, track allowable expenses and keep their property finances organised throughout the tax year.
Watch: How to Use the UK Landlord Income & Expense Spreadsheet
The UK Landlord Income & Expense Spreadsheet is designed to give landlords a clear view of their property finances without having to build complicated spreadsheets from scratch.
It brings your rental income, property expenses and financial performance together in one organised workbook. Once you enter your property details and transactions, the spreadsheet automatically updates the relevant summaries and dashboard figures, helping you see how each property and your overall portfolio are performing.
You can use the spreadsheet throughout the year to record income and expenses as they occur, rather than trying to reconstruct everything at the end of the tax year. This can make it easier to identify costs, monitor cash flow and keep your property financial records organised.
The video above walks you through the main sections of the spreadsheet and shows you how to start using it effectively.
What You’ll Learn in This Video
This step-by-step video shows you how to set up and use the UK Landlord Income & Expense Spreadsheet effectively. You’ll learn how to:
- Set up your landlord profile and enter the key information needed to get started.
- Add and manage rental properties within your portfolio.
- Record rental income and keep track of payments received.
- Record property expenses and organise costs into the appropriate categories.
- Track income and expenses by property so you can see how individual investments are performing.
- Use the dashboard to get a quick overview of your rental income, expenses and overall financial position.
- Review monthly and annual figures to understand how your portfolio is performing over time.
- Keep your landlord financial records organised throughout the year.
- Use the spreadsheet more efficiently and understand how information entered in different sections feeds into the overall dashboard.
Video Transcript
In this video, we walk you through how to use the UK Landlord Income & Expense Spreadsheet, from the initial setup through to recording transactions and reviewing your financial dashboard.
You’ll see how to enter your landlord and property information, add the rental properties you want to track, and keep your portfolio records organised in one place.
The tutorial then explains how to record rental income and property expenses, including how to assign transactions to the relevant property and expense category. As you add information, the spreadsheet automatically uses the data to update the relevant summaries and dashboard figures.
We also look at the Dashboard, which provides an at-a-glance overview of your property finances. This allows you to review key figures across your portfolio and understand how your rental income and expenses are changing over time.
By keeping the spreadsheet updated throughout the year, you can maintain a clearer record of your landlord finances, review the performance of individual properties and have your income and expense information organised when you need it.
Watch the full video above for the step-by-step demonstration of each section of the spreadsheet.
Get the UK Landlord Income & Expense Spreadsheet
Ready to start organising your rental property finances?
The UK Landlord Income & Expense Spreadsheet gives you a simple, structured way to record rental income, track property expenses and monitor the financial performance of your properties throughout the year.
Instead of managing information across different spreadsheets or trying to recreate records later, you can keep your key landlord financial information together in one easy-to-use workbook.
Whether you have one rental property or a growing portfolio, the spreadsheet is designed to help you stay organised and maintain a clearer picture of your property finances.
Download the UK Landlord Income & Expense Spreadsheet.
Using the Spreadsheet as a Landlord Accounting Spreadsheet
Although this template is not a replacement for dedicated accounting software or professional accounting advice, it can be used as a practical landlord accounting spreadsheet to keep your property finances organised throughout the year.
The spreadsheet provides a structured way to record your rental income and property expenses in one place. Instead of relying on bank statements, receipts and separate notes at the end of the tax year, you can update the spreadsheet regularly as income is received and costs are incurred.
Using an accounting spreadsheet for landlords can make it easier to:
- Record rental income received from each property
- Track property-related expenses throughout the tax year
- Keep income and expenditure records organised in one place
- Review the financial performance of your rental properties
- Identify transactions that may need further review when preparing your accounts
- Provide clearer financial records to your accountant or tax adviser
For landlords with one or several rental properties, maintaining accurate records throughout the year can also make year-end bookkeeping much easier.
The spreadsheet is designed specifically with landlords in mind, making it more relevant than a generic income and expense spreadsheet. It gives you a simple system for maintaining your property financial records without requiring you to use full accounting software for day-to-day tracking.
Important: The spreadsheet is a record-keeping and property finance management tool. It does not determine whether an expense is allowable for tax purposes, calculate your final tax liability, or replace advice from a qualified accountant or tax professional.
Koye Beckley is a UK property investor and founder of UncommonDeal, with practical experience in buy-to-let, property auctions, refurbishment projects and investment deal analysis. Through UncommonDeal, he publishes property market research, property deal sourcing and compliance guidance, investment guides and data-driven analysis to help investors evaluate buy-to-let, BRRR, flip and auction opportunities.
