How to build a landlord spreadsheet and when to replace it

A landlord spreadsheet is a workbook, usually in Excel or Google Sheets, that records rental income, expenses, and compliance dates for one or more properties. Built properly, it remains a legitimate way to run a small portfolio in 2026, and under Making Tax Digital it can still form part of your record-keeping if it connects to HMRC-recognised bridging software. This guide sets out the exact worksheets and columns a landlord spreadsheet needs, the rules that now govern spreadsheet records, and the specific failure points that tell you it is time to move to dedicated software.

A landlord spreadsheet template: the four worksheets

A complete landlord spreadsheet needs four worksheets: an income sheet recording every rent payment against the tenancy it belongs to, an expenses sheet categorised to match your tax return, a compliance sheet tracking statutory deadlines by property, and a per-property summary that shows profit at a glance. Most templates circulating online cover the first two and ignore the second two, which is why so many landlords with tidy accounts still miss a gas safety renewal.

Build each worksheet with the columns below and you will have a rental property spreadsheet that holds up at self assessment time and survives an HMRC enquiry.

The income worksheet

Record gross rent. If a letting agent deducts their fee before paying you the balance, your income is the full rent and the fee is a separate expense line. Netting the two off understates both figures and misstates your return. If tenants ask for payment records, a rent statement template generated from this sheet covers it.

The expenses worksheet

A landlord expenses spreadsheet only earns its keep if every row is categorised the way HMRC expects. Set the category column as a dropdown matching the SA105 property pages: rents, rates and insurance; repairs and maintenance; loan interest and finance costs; legal and professional fees; services; travel; and other allowable costs.

The category column is where spreadsheets quietly go wrong. Repairs are deductible in the year; improvements are capital and are not. Our guide to allowable expenses sets out the dividing line, and categorising rental expenses covers the judgement calls in detail.

The compliance worksheet

This is the worksheet that matters most and exists least. A missed gas safety renewal is a criminal offence, and since the Renters' Rights Act 2025 came into force on 1 May 2026, landlords in England also need to maintain registration on the Private Rented Sector Database, with civil penalties reaching £40,000 for serious breaches. A spreadsheet can hold these dates; what it cannot do is chase you about them.

The per-property summary

One row per property, pulling income and expenses through with SUMIF formulas: gross rent received, total expenses by category, net profit, and yield if you record the purchase price. Check the resulting tax position against our rental income tax calculator rather than building marginal rate logic into the sheet, where a single formula error compounds silently.

Can you still use a spreadsheet under Making Tax Digital?

Yes, with conditions. As of July 2026, Making Tax Digital for Income Tax applies to landlords and sole traders with qualifying income above £50,000, having taken effect on 6 April 2026. The threshold falls to £30,000 from April 2027 and £20,000 from April 2028. Affected landlords must keep digital records and send HMRC quarterly updates through recognised software.

A spreadsheet counts as a digital record, but it cannot file. To stay compliant you need HMRC-recognised bridging software connected to the spreadsheet by digital links: cell references, formulae, or automated imports. Retyping figures from your spreadsheet into a filing tool, or copying and pasting them, breaks the digital link and breaks compliance with it. HMRC publishes the list of recognised products, including bridging tools, on its find compatible software service.

So the honest position is that a spreadsheet plus bridging software remains legal for MTD, but you are now running two systems to do the job one was doing, and the spreadsheet's error rate becomes a filing risk rather than a private annoyance. Our Making Tax Digital guide covers the obligations in full. August is HMRC-recognised for MTD for Income Tax, so records kept in August file directly without a bridging layer.

Where a landlord spreadsheet breaks down

A spreadsheet fails a landlord in four predictable ways: it records what you type rather than what happened, it cannot alert you to anything, it keeps no audit trail, and its errors compound invisibly.

The first is the expensive one. A spreadsheet shows rent as received because you typed it in, not because the bank confirmed it. Arrears surface when you reconcile against statements, which for most landlords means weeks late, and under a post-Section 21 possession regime built on evidenced Section 8 grounds, the quality of your arrears record now has legal weight.

When landlords move to August from a spreadsheet, the first data import tells the same story almost every time: duplicated expense rows, rent marked as received in months where the bank statement disagrees, and allowable deductions never claimed because the receipt went missing. None of it was carelessness. It is what happens when a filing system depends on a human remembering to update it. Automated rent tracking through a regulated open banking connection removes the typing entirely: payments match to tenancies as they arrive, and arrears flag themselves the day they occur.

The audit trail problem is quieter but real. A spreadsheet cannot show who changed a figure, when, or what it said before. If a tenant disputes a payment history or HMRC opens an enquiry, your evidence is a file that anyone with access could have edited without trace.

Spreadsheet vs landlord software: the honest comparison

Dedicated software beats a spreadsheet on automation, compliance and audit trail; the spreadsheet wins on cost, flexibility and independence. The table below is the trade-off as it actually stands in 2026.

If flexibility is the thing you value, that is a genuine reason to stay on a spreadsheet, and no software vendor should pretend otherwise. Expense capture is usually the first thing that converts a sceptic: photographing a receipt into expense tracking in August at the point of purchase removes the shoebox reconciliation that spreadsheet landlords save for a painful weekend each January.

When to switch, and how to move your data

The switching point is reached when any one of these is true: your qualifying property income is above the current MTD threshold, you manage three or more tenancies, you have missed a compliance date or an arrears event you should have caught, or your records are maintained more than a week behind reality. Below all four, a well-built spreadsheet is defensible. At any one of them, the time it consumes and the risk it carries cost more than a subscription. Whether that subscription is worth paying for is a decision in its own right, and our guide to whether landlord software is worth it works through it honestly, costs, red flags and the cases against included.

Moving is less work than most landlords expect:

1. Export or tidy your spreadsheet so each property, tenancy and open arrears balance is current.

2. Pick the platform. Our comparison of the best property management software for UK landlords covers the field with a disclosed methodology, there is a dedicated look at landlord accounting software compared if bookkeeping is your priority, and genuinely free landlord software exists if cost is the blocker.

3. Import properties and tenancies first, then historic transactions for the current tax year at minimum.

4. Run the spreadsheet and the software in parallel for one rent cycle, then stop updating the spreadsheet. A half-and-half system is worse than either alone.

5. Archive the workbook. HMRC record-keeping requirements still apply to the old records, so keep the file even after you stop using it.

Supporting landlords through the first MTD for Income Tax quarterly updates in 2026 taught us that the submission itself is rarely the hard part. The hard part is reconstructing years of spreadsheet history into clean, categorised records under deadline. Landlords who moved before their first quarter had a materially calmer time of it than those who moved during.

Frequently asked questions

Is a spreadsheet enough for one rental property? 

For a single property with reliable rent and income below the MTD threshold, yes, provided it includes the compliance worksheet and you actually maintain it. The compliance load on one property is nearly identical to the load on five, which is why single-property landlords still miss certificate renewals.

Can I use Google Sheets for Making Tax Digital? 

Yes. HMRC treats any spreadsheet as an acceptable digital record, including Google Sheets, but filing quarterly updates requires recognised bridging software connected by digital links. Manually retyping figures into a filing tool does not comply.

Do I need software if I have an accountant? 

They solve different problems. An accountant advises and files; they do not track your rent on Tuesday morning or remind you about an EICR. Good records also cut accountancy fees, because your accountant stops charging you to tidy a spreadsheet. The strongest setup for most landlords is clean software records plus an accountant for year-end judgement.

What is the quickest way to test the alternative? 

Download August and import one property. If a month of automatic rent matching and receipt capture does not beat your spreadsheet, the workbook will still be there.