Property accounts spreadsheet

Last updated: 13/04/2026 • First published: 17/07/2020

Provided by our partners at

Take control of your finances throughout the 2026-27 tax year.

Do you struggle to accurately record all the costs of your property portfolio?

Looking for an easy way to see whether you're in profit or not?

Fed up of staring at a drawer full of receipts?!

Take Control!

With the RITA Property Accounts spreadsheet you can now keep thorough and complete records of your property whether for business purposes or just your own personal portfolio. In addition, it is good practice to separate records between properties, especially if you let more than one.

Although the spreadsheet enables you to keep complete records, it has been designed so that simplicity is the key.

The spreadsheet is organised so you can instantly compare and contrast similar costs for up to 10 properties on the same page, while also allowing you to delve into the specific cost types to each of your properties.

Keeping accurate records will benefit you in many ways, such as:

  • Having a greater understanding of your income, costings and profits.
  • Being ready for any HMRC enquiries into your records.
  • Reducing accountancy and tax advisory fees.
  • Easily identifying deductions available when calculating your capital gains tax.

The 2026-27 RITA Property Accounts spreadsheet is useful if you are an inexperienced landlord, serving as a tool to monitor different costs involved in letting your property and what financial responsibilities you have.

Property Tax Spreadsheet 2026-2027
95.00 KB 24/07/26
Download
Property Tax Spreadsheet 2025-26
97.00 KB 24/07/26
Download

The spreadsheet will help you manage your properties and enable you to understand which costs are proving the most expensive and where you could be saving money. The sheet can also be used to calculate the return on investment of each property and help model the potential risk or reward of investing in an additional property in the future.

The costs categories covered include:

  • Overall Income
  • Ground rent, insurance, rates, utilities
  • Property Repairs and maintenance
  • Mortgage and Loan Interest
  • Legal and Professional Fees
  • Services e.g. Gas Safety Checks
  • Other Expenses
  • Capital Expenses and Improvements
  • There's even a column to record expenses you would prefer to check with your accountant, as to whether they are allowable deductions!

The spreadsheet enables an individual landlord, associate or property leasing agent to accurately record costs in a saveable and printable format.