Landlord Rental Income Excel - Free Template

1. Enter each rent payment or expense on the Rental Income sheet. Use one line per transaction so the totals stay clear.
2. Fill in the property name, tenant name, amount, payment method and status. That gives you a clean audit trail if you need to check a missing payment later.
3. Use the tax year and month fields consistently. If you are preparing figures for 2026/27, keep every entry in the same format.
4. Review the Property Summary sheet after you have added the month’s transactions. Check the totals for each property before you file anything.
5. Keep the Notes field for repair details, arrears chasing or receipt references. That saves time when you come back to the workbook next month.
6. File your supporting invoices and bank statements alongside the spreadsheet. The sheet is for the numbers; your paperwork backs them up.

This template suits a private landlord with one flat, a small limited company with three buy-to-lets, or a lettings bookkeeper handling several tenancies. It is most useful when you need a quick monthly check before a mortgage payment, a tenant arrears chase, or the year-end figures for Self Assessment.

Where it fits in the month

A landlord with two flats might record six rent receipts a month and three repair invoices, then review the totals at month end. A portfolio landlord with 12 properties could be looking at 60 to 80 transactions a month, which is exactly where a single, standard sheet is easier than scattered bank notes and emails.

What the summary tells you

The Property Summary sheet helps you see which property is pulling its weight. If one house brings in £1,250 a month and another only £725 because of gaps in occupancy, you can spot the problem quickly and compare it against mortgage interest, repairs and void periods.

For UK tax purposes, you need records that support the rental figures you put on your Self Assessment return. The tax year runs from 06/04/2026 to 05/04/2027, and you should keep the paperwork behind the spreadsheet for at least 5 years after the 31 January online filing deadline.

Income and expense evidence

Keep the bank statement, tenancy schedule, invoices and any mileage or repair receipts that explain each line. If you spend £486 on a boiler repair and £120 on electrician labour, that £606 needs to be backed by evidence, not just a memory when the return is due.

Landlord structure matters

A sole trader landlord owns the property personally, while a limited company landlord is registered at Companies House and files year-end accounts as well as corporation tax. If you own one property personally and another through a Ltd company, keep the records separate; mixing them makes the profit and loss figures harder to defend and harder to reconcile.

That separation is also easier to maintain when you track each deductible item in a self assessment expenses sheet rather than trying to untangle mixed records at year end.

The usual mistake is to record only the bank receipt and ignore what it was for. That looks tidy until a £1,250 payment arrives with £150 of arrears and you cannot tell whether the tenant paid late, paid short or paid in advance.

Missing references and mismatched totals

Another common fault is leaving out the receipt or invoice reference, which makes it painful to match a repair bill or chase a missed rent payment. If you have 24 monthly receipts and two of them are entered against the wrong property, your property totals will be wrong by hundreds of pounds and the error may not show until year end.

Wrong treatment of expenses

Landlords also mix up capital improvements and repairs. Replacing a broken tap is usually a repair, but fitting a full new kitchen is a different treatment and belongs in your year-end review, not buried as an ordinary expense.

Best practice is to update the sheet on the same day you review your bank account, not weeks later when the figures are fuzzy. For many landlords, the easiest habit is to do it on the first Monday of the month, straight after checking rent receipts.

Simple habits that keep it live

• Enter rent receipts weekly if you have multiple tenants, so arrears show up fast.
• Copy the previous month’s format rather than retyping headings or labels.
• Use the status field to flag paid, unpaid or part-paid entries immediately.
• Keep invoices and receipts in the same folder name as the property so matching is quicker.

When a spreadsheet is no longer enough

If you are managing 20 or more properties, dealing with agent statements and handling regular refurbishments, you may need dedicated property software. Up to that point, this workbook is usually enough for a clear monthly picture without paying for a system you do not yet need.

At that point, a cash flow forecast gives the next layer of visibility for refurbishments, agent fees and other property outgoings.