Free Rental income and expenses spreadsheet for UK landlords
This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. To find out more about cookies on this website and how to delete cookies, see our privacy notice.
Analytics

Tools which collect anonymous data to enable us to see how visitors use our site and how it performs. We use this to improve our products, services and user experience.

Marketing

A bit of data which remembers the affiliate who forwarded a user to our site and recognises orders from those who become customers through that affiliate.

Essential

Tools that enable essential services and functionality, including identity verification, service continuity and site security.

About the Free Landlord Income and Expenses Spreadsheet

Making spreadsheets can be tough. Sometimes you just need a fast and effective way of calculating your property income tax. We’ve put together this free spreadsheet to help you do just that. You won’t find any #DIV/0! Errors here!
RLA Landlord Vision Rental Income and Expense Tracker
Download Your Free Landlord Income and Expenses Spreadsheet
To use the free spreadsheet enter your name and email address in the form below and you’ll be taken to a download link. We’ll also send you the download link via email.
Was this resource useful?
Thanks for your vote!
You already voted.

Share with friends:


Tax reliefs in the income and expense tracker

The income and expense spreadsheet is a simple tool for landlords with straightforward portfolios, so it is down to you to check that you are entitled to the reliefs that are listed in the spreadsheet and the checklist. Once you’ve entered all your property income and expenditure details, the dashboard at the top of the spreadsheet will show you your overall income and expenditure and will calculate the figure you may have to pay tax on. You can also use the tax band guide in the spreadsheet to see which tax band you fall into.

How to access the income and expense spreadsheet

Using the income and expense spreadsheet is easy. The spreadsheet has been created in Excel and saved in .xls format so it is compatible with many older versions of windows. This format means the spreadsheet is also easy to open in Numbers for Mac, Google Sheets, Open Office and many other spreadsheet providers. Very few people have problems opening the spreadsheet, but if you do, please contact us and we will do whatever we can to help you.

Where to get More Information on Mortgage Relief and 20% Tax Credit (Section 24)

The aim of this income and expense spreadsheet is to give landlords a simple way to track income and expenditure and to help them prepare for their tax returns. Because this is a simple spreadsheet some of the more complicated tax rules around mortgage interest relief aren’t accounted for. We have not included mortgage interest relief in any of the spreadsheet’s calculations.

From 2017 you have been able to claim a 20% tax credit on mortgage relief, this only applies in the simplest of cases, it is down to you to check you are eligible for this relief before applying it when you submit your tax return. You can learn more about section 24 in the guide on the right.

Where to get More Information on Mortgage Relief and 20% Tax Credit (Section 24)

Tips for designing your own landlord spreadsheet

Each landlord is different. While this simple spreadsheet helps most landlords when it comes to tax preparation, your needs might be slightly different and in that case, you’ll want to design your own spreadsheet. If you are creating your own landlord spreadsheet take a look at the article on the right.

Tips for designing your own landlord spreadsheet

The limitations of the landlord income and expense spreadsheet

This income and expense spreadsheet is a great and simple tool to help landlords prepare for their tax return. For those who have one to three properties this spreadsheet should help you in a straightforward way.

If you have a large portfolio you may find it difficult to do all the admin needed to aggregate your costs into this spreadsheet. There are also more complicated tax considerations as your portfolio grows. If you’ve purchased or sold properties in the last tax year, you’ll find it difficult to account for this in the spreadsheet.

For a more comprehensive way of managing your income and expenditure and preparing your tax return try Landlord Vision. The software can handle an unlimited number of properties and tenancies and, will help you fill in your tax return in less than 5 minutes. Find out how landlord Vision can help make managing every aspect of your portfolio easy.

Property taxes and
finances made easy

  • Live bank feeds make it easy for you to record your rental payments and expenses
  • Track all your expenses and pull reports to help you understand property performance. Submit digital tax returns or pull a report that tells you what numbers to put into your online return.
  • Create and manage rent receipts and upload receipts and invoices for one touch expense creation
Screenshots of the income tax report and summary of income payments in Landlord Vision.
Software screenshot that shows the Landlord Vision calendar view.
Find out why Landlord Vision
transcends spreadsheets
Join a live demo, see the software in action and ask us any questions you might have about how it can work for you