“Keep your receipts and download your bank statements” is incomplete advice for landlords. Neither tells you how much rent an agent collected before deductions. A mortgage payment does not identify its interest component. A furniture receipt does not establish whether you replaced a tenant’s broken wardrobe or furnished an empty property for the first time.
Those distinctions matter more than the neatness of the spreadsheet. A perfectly reconciled bank account can still produce a misleading property-income record.
Useful UK landlord expense records separate evidence from tax treatment. Capture what happened in full, then keep the fields needed to review how it should be treated. Do not let an automated category make that decision silently.
This checklist covers general record-keeping for personally owned rental property, not tax advice. Companies, trusts, overseas property and specialist lettings need different checks with HMRC or an adviser.
Reference checklist: build the property record in transaction order
1. Set up the property register before entering transactions
- Give each property a permanent ID, such as
LEEDS-01, and use it on every related row. - Record its address, letting start date, ownership details, agent and mortgage account reference.
- Record the accounting basis being used, confirmed against HMRC’s property-income guidance.
Use the UK tax year, 6 April to 5 April, rather than calendar-year summaries alone. Keep both invoice date and payment date: an electrician’s invoice dated 30 March 2027 but paid on 8 April belongs to different periods depending on the accounting basis. Do not resolve that by changing the invoice date.
Your transaction columns should include property ID, document date, payment or receipt date, supplier or payer, description, gross amount, category, evidence link, payment reference and review status.
Check Making Tax Digital for Income Tax at setup. From 6 April 2026, it applies to qualifying individuals with qualifying income over £50,000; the threshold falls to £30,000 from April 2027. HMRC’s qualifying-income measure generally combines gross self-employment and property income before expenses. Check its eligibility guidance, including joint-income rules and exemptions. A spreadsheet alone does not submit the required updates; compatible software or a suitable bridging arrangement is needed.
2. Document ownership before dividing any income
- Keep the ownership agreement, relevant deeds and evidence of beneficial interests with the property register.
- Record who paid each bill separately from the ownership allocation.
- Add effective dates to any change in ownership or allocation.
For spouses or civil partners living together, jointly owned property income is generally treated on a 50:50 basis, subject to exceptions. Unequal beneficial ownership may support a different split through HMRC’s Form 17 process; the declaration normally must reach HMRC within 60 days of signing. It is not a way to choose whichever percentage gives the preferred result.
Other joint owners can have different arrangements. Keep the agreement and have the treatment checked rather than copying the married-couple rule.
Suppose siblings’ agreed allocation is 60:40 and one pays a £240 plumber’s bill. Record the full £240 once, with £144 and £96 in allocation columns. Record any reimbursement separately as an owner settlement, not another repair expense. Apply the documented allocation consistently to income and relevant costs.
3. Reconstruct rent before recording the agent’s bank transfer
- Save tenancy agreements, rent schedules and each agent statement.
- Record gross rent and individual deductions, not just the net remittance.
- Track arrears, credits and deposits outside the ordinary expense categories.
For September 2026, an agent’s statement might support these entries:
| Date | Property | Entry | Income | Expense |
|---|---|---|---|---|
| 5 Sep 2026 | LEEDS-01 | September rent collected | £1,250 | — |
| 5 Sep 2026 | LEEDS-01 | Management fee, including VAT | — | £150 |
| 5 Sep 2026 | LEEDS-01 | Electrician: loose socket | — | £84 |
Bank remittance: £1,250 − £150 − £84 = £1,016.
Entering £1,016 as rent understates both income and costs. Adding the £84 invoice again later doubles the repair expense. Link that invoice to the existing row instead.
Keep the agent’s collection date and remittance date; they are not necessarily interchangeable for accounting purposes. Track refundable tenancy deposits separately, with scheme references where applicable. If money is later retained or released, save the agreement or adjudication and flag its treatment for review.
4. Capture purchase evidence while its purpose is still obvious
- Save the complete receipt or invoice, including item descriptions and totals.
- Add the property ID and a factual purpose:
Replacement lock after tenant lost keys, notmaintenance. - Separate personal items and keep refunds linked to the original purchase.
A £93.40 Screwfix receipt containing £71.20 of rental-property materials and £22.20 of tools bought for your own home needs both the original total and the allocation. Overwriting the receipt amount with £71.20 makes reconciliation harder.
Scan2Sheet extracts receipt data into your own Google Sheet, with automatic categorisation, duplicate detection and cloud-stored receipt images linked from each row. Its multi-page capture helps preserve long receipts; check that the first item, final total and every intervening section are readable.
Treat duplicate flags as prompts, not verdicts. Two identical £18 parking charges on different inspection dates may both be genuine. Conversely, a scanned receipt and an emailed invoice may document one purchase.
Record VAT shown on the document without assuming it is recoverable. Ordinary residential letting is generally VAT-exempt; other property activities can differ. Check HMRC’s VAT property guidance before building recovery assumptions into formulas.
5. Split mortgage payments using lender evidence
- Retain mortgage statements and annual interest certificates.
- Separate interest, capital repayments and fees.
- Keep loan-purpose evidence, especially for refinancing or mixed-use borrowing.
For individual landlords, residential property finance costs are generally subject to a restriction: relief is normally handled through a basic-rate tax reduction rather than an ordinary deduction from rental income. That is why mortgage interest needs its own category. Recording it as repairs, or folding it into general expenses, obscures the information required for the calculation.
A lender statement for October 2026 might show:
| Payment component | Amount | Record category |
|---|---|---|
| Interest | £612.40 | Residential finance costs — review |
| Capital repayment | £367.60 | Loan capital movement |
| Total direct debit | £980.00 | Bank reconciliation total |
Neither the £980 payment nor the £612.40 interest figure should silently become an ordinary operating expense. Keep arrangement fees separately for review, too.
Do not infer the borrowing’s purpose from the property securing it. If a remortgage funded both rental work and personal spending, preserve the drawdown trail and allocation evidence. HMRC’s residential finance-cost guidance governs the treatment; lender statements alone cannot establish it.
6. Describe building work before assigning a tax category
- Ask contractors for itemised invoices separating distinct jobs.
- Keep before-and-after photographs, specifications and relevant survey findings.
- Flag improvement, acquisition-related and mixed projects rather than forcing them into repairs.
“Works at flat — £8,400” leaves too much unexplained. “Repair existing kitchen cabinet doors — £640; install additional fitted units — £2,100” preserves facts that can support a proper review.
The distinction is not simply cheap versus expensive. Nor does work automatically become a routine expense because it happened after a tenant moved in. Repairs around purchase, substantial alterations and projects combining restoration with improvement need their circumstances documented.
Maintain a separate acquisition-and-improvements file containing purchase completion statements, legal invoices and major works evidence. These records may remain relevant when the property is sold, long after the ordinary annual filing cycle.
7. Pair domestic-item purchases with the items they replace
- Identify the old item, its location and why it was replaced.
- Save the new invoice, delivery and disposal charges, and any proceeds from selling the old item.
- Record material upgrades and retain a contemporary like-for-like price where available.
Replacement of domestic items has its own rules. First-time provision is not the same as replacement, and fixtures need separate consideration under HMRC’s property-income guidance.
Replacement example: on 12 November 2026, you buy a £429 washing machine from AO for an existing tenancy. Delivery costs £25, removal £20, and the old machine is sold for £30. Keep the inventory entry, a note that its drum failed, and all four amounts:
£429 + £25 + £20 − £30 = £444 net cash cost.
That is an evidence reconciliation, not a declaration of the amount eligible for relief. Record that the new machine is broadly equivalent; if it is a significant upgrade, keep a dated quote for a comparable replacement.
Contrasting example: you spend the same £429 furnishing a newly acquired, previously empty flat. There is no old machine. Mark the row initial provision, with no invented replacement link. Identical retailer totals do not establish identical tax treatment.
8. Reconcile monthly, then preserve the property-allowance comparison
- Match rows to bank, card and agent statements, including refunds and owner-funded purchases.
- Resolve missing evidence and uncategorised entries before accepting automatic expense summaries.
- Keep a year-end note of the recording method and any allowance decision reviewed with your adviser.
Use explicit statuses such as matched, invoice missing and classification query. A £240 bank transfer to a plumber with no invoice is a specific unresolved item, not a reason to delete the transaction or manufacture a receipt.
The £1,000 property allowance is generally an alternative to deducting actual expenses, not an extra expense row. It is per eligible individual, not per property. Joint owners need their own position reviewed using their share of relevant gross income.
Keep underlying costs even while considering the allowance. They enable a comparison and preserve evidence if circumstances change. Check HMRC’s property-allowance guidance for exclusions and interactions: it cannot simply be combined with actual expenses, replacement-of-domestic-items relief or the residential finance-cost tax reduction. Do not make a spreadsheet formula choose solely by comparing £1,000 with the repairs total.
9. Freeze the filing evidence and schedule its retention
- Save the year-end spreadsheet, supporting documents, allocation workings and submitted return together.
- Record unresolved adjustments and their eventual resolution without erasing the original entries.
- Set retention dates and test that evidence links still open outside your usual phone session.
For the tax year ending 5 April 2027, the usual Self Assessment deadlines are 31 October 2027 for a paper return and 31 January 2028 for an online return. Where a new obligation requires notification, the usual notification deadline is 5 October 2027. Check HMRC’s requirements for your circumstances; Making Tax Digital introduces separate update deadlines where applicable.
HMRC generally requires landlord records to be retained for at least five years after the relevant 31 January filing deadline. For 2026/27, that normally means at least 31 January 2033. Late returns, enquiries and other circumstances can extend this; retain acquisition and improvement evidence for longer where needed.
Keep an independent backup of essential files. A spreadsheet link is useful only while its destination remains accessible.
Use Scan2Sheet to capture the next property receipt into your own Google Sheet, then add the property ID and the detail only you know.