Annual Landlord Accounts Template UK — Free P&L Download

Every UK landlord with rental income above the £1,000 property allowance must complete a self-assessment tax return reporting their rental profits. This annual landlord accounts template gives you a structured profit and loss spreadsheet to record all income and allowable expenses across your portfolio — making self-assessment preparation straightforward and ensuring you capture every legitimate deduction.

The template covers up to five properties on individual sheets, with a portfolio summary that rolls up all income, expenses, mortgage interest, and Section 24 tax credit calculations. The summary sheet produces a single taxable profit figure and estimated tax liability — the exact inputs you need for the UK Property (SA105) pages of your self-assessment return.

It is not a substitute for professional accountancy advice — particularly for more complex situations such as furnished holiday lets, mixed personal and commercial use, or jointly owned properties. But for landlords with straightforward portfolios of one to five standard residential lets, it provides a clear, consistent framework for annual bookkeeping.

• Income section — gross rent received (April–April), any arrears recovered, and other income (e.g. insurance claims received for repairs)
• Allowable expenses — pre-formatted rows for letting agent and management fees, repairs and maintenance, buildings insurance, gas safety, EICR, advertising, accountancy, ground rent, service charge, and travel
• Finance costs section — mortgage interest separated from other expenses, with automatic 20% Section 24 credit calculation
• Net profit calculation — rental income minus allowable expenses (excluding finance costs) = taxable profit before Section 24
• Tax liability estimate — at basic (20%), higher (40%), or additional (45%) rate with Section 24 credit applied
• Portfolio summary sheet — consolidates all properties into single totals for the SA105 return
• Notes column — record invoice reference, date paid, and supplier for each expense line to support HMRC enquiries

This template is designed for UK landlords who manage their own self-assessment bookkeeping, or who want to prepare organised records before passing them to an accountant. It is particularly useful for:

• Individual landlords with 1–5 properties filing a UK Property SA105 self-assessment return each year
• Landlords affected by Section 24 who want to see clearly how the mortgage interest credit impacts their actual tax bill
• Landlords switching accountants who need a standard format to hand over organised records rather than a box of receipts
• New landlords setting up a bookkeeping system for the first time and wanting to understand what needs to be tracked

This template is provided for guidance only and does not constitute tax advice. Tax rules for landlords are complex and change frequently — including allowable expenses, Section 24 rules, furnished holiday let legislation, and HMRC reporting requirements. Always consult a qualified accountant or tax adviser for your personal position. Keep all receipts and bank statements for a minimum of six years in case of an HMRC enquiry. PropertyAlert (Eightfinity Ltd) accepts no liability for any errors in your tax return arising from use of this template.

• Section 24 Calculator — see exactly how the mortgage interest restriction affects your annual tax bill
• Rental Yield Calculator — calculate gross and net yield for your properties