GuidesHow-to videos/Comparison/PAM vs spreadsheets
Comparison

Spreadsheet for landlords: is it still enough in 2026?

Spreadsheets are free, flexible and perfectly fine for a property or two. Here's an honest look at where they hold up, where they crack as your portfolio grows, and what changes with Making Tax Digital.

By PAM·Updated 8 July 2026·6 min read
Key takeaways
  • A spreadsheet is genuinely fine for 1-2 properties, simple income logs and landlords who enjoy manual admin.
  • Spreadsheets have no automatic reminders, so a missed EICR, gas safety or EPC renewal is a real and costly risk.
  • Rent reconciliation, audit trails and error-free formulas all rely on you remembering to do the work correctly, every time.
  • From April 2026, MTD for Income Tax phases in and requires digital records plus quarterly submissions that a plain spreadsheet cannot file on its own.
  • Software like PAM adds reminders, automated rent matching, a tenant app and MTD-ready filing, keeping the parts of a spreadsheet you liked.
  • The tipping point is usually 3+ properties or the moment compliance and tax deadlines start to feel risky.

If you manage your rentals in Excel or Google Sheets, you are in good company. Spreadsheets are free, endlessly flexible and, for a lot of landlords, genuinely all they have ever needed. A single tab with rent in, expenses out and a few cert dates can run a small portfolio for years without drama.

But the honest answer to is a spreadsheet enough? is: it depends on how many properties you hold, how much manual admin you enjoy, and what the taxman now expects. Below is a fair look at both sides, so you can decide whether to stay put or upgrade.

Is a spreadsheet enough for landlords?

For one or two properties with straightforward tenancies, yes, a spreadsheet is usually enough. It becomes a liability as you scale, because it cannot remind you of expiring certificates, reconcile rent automatically, or file the quarterly MTD returns that HMRC phases in from April 2026.

The value of a spreadsheet is that it does exactly what you tell it and nothing more. That is also its limitation. Every reminder, every reconciliation and every deadline lives in your head or your calendar, not in the file. With a couple of properties that is manageable. With five or ten, the gaps start to cost money.

Where do spreadsheets break as a portfolio grows?

They break at the points that depend on you remembering to act: compliance renewals, rent chasing and tax deadlines. A spreadsheet will happily hold an out-of-date EICR date and never say a word, and a mistyped formula can quietly misreport your income for a whole year.

No automatic compliance reminders

This is the big one. Your spreadsheet can store the expiry date of an EICR, gas safety certificate, EPC or deposit protection, but it will not warn you when one is about to lapse. Miss a gas safety check or let deposit protection slip and you face penalties, invalid Section 21 notices and real risk to your tenants. Software watches those dates for you and sends the reminder before it matters.

Manual rent reconciliation

In a spreadsheet you type in each rent payment by hand, then cross-check it against your bank statement. It works, but it is slow and easy to get wrong, especially across several tenancies. Miss an entry and your arrears tracking silently drifts out of line with reality.

Error-prone formulas and version chaos

One dragged formula, one deleted row, one wrong cell reference and your totals are off, often without any obvious sign. Add shared files, email attachments and "final_v3_actual.xlsx", and it becomes hard to know which version is the truth. There is no audit trail showing who changed what and when.

What changes with Making Tax Digital in 2026?

From April 2026, Making Tax Digital for Income Tax begins phasing in for landlords over the income threshold. It requires digital record-keeping and quarterly updates to HMRC through compatible software. A plain spreadsheet cannot submit those returns by itself, so most landlords will need software or bridging tools.

MTD for Income Tax Self Assessment (ITSA) is the change that pushes many spreadsheet landlords to rethink. Keeping records in a spreadsheet may still form part of a compliant setup, but the actual quarterly submissions have to go to HMRC digitally through recognised software. For property income, that means SA105-categorised records that are ready to file, not just a tidy tab of numbers. You can read more about how PAM handles MTD ITSA for property income.

Spreadsheet vs property management software: a fair comparison

Spreadsheets win on cost and flexibility. Software wins on automation, reminders, audit trails and tax-readiness. The right choice depends on portfolio size and how much manual admin you are willing to carry.

TaskSpreadsheetPAM
CostFreeFrom £12/month, 14-day free trial
Rent trackingManual entry, manual bank checkCollected via GoCardless Direct Debit and reconciled automatically
Compliance remindersNone; you must rememberAutomatic expiry alerts for EICR, gas, EPC, deposits
MTD filingNot on its own; needs bridging softwareSA105 categorisation and quarterly submissions built in
MaintenanceLogged by hand, if at allAI triage over WhatsApp and voice
Tenant accessNoneTenant app for contact and requests
Audit trailNone by defaultRecorded automatically
FlexibilityTotal; build it any way you likeStructured around lettings workflows

When a spreadsheet is genuinely fine

If you own one or two properties, have stable long-term tenants, keep simple income and expense records, and are comfortable tracking cert dates in your own calendar, a spreadsheet is a perfectly reasonable tool. There is no need to pay for software you will not use.

Plenty of landlords run happily on a spreadsheet, and there is nothing wrong with that. It is cheap, it is under your control and it does not lock you into a subscription. As long as you stay on top of compliance dates manually and your MTD obligations are met through a compatible route, a well-kept spreadsheet can serve you well. The question is simply how long that stays true as your portfolio and the rules grow around it.

When is it time to move to software?

The usual tipping point is three or more properties, or the moment compliance and tax deadlines start to feel like a risk rather than a chore. If you have ever missed a renewal, lost track of arrears, or dreaded MTD, that is the signal to upgrade.

Moving to software does not mean losing what you liked about your spreadsheet. Good tools keep the clarity of a single source of truth while removing the manual chasing. PAM adds automatic compliance reminders, GoCardless rent collection, AI maintenance triage, a tenant app, a document vault and MTD-ready tax filing, so the admin that used to live in your head lives in the system instead. You can see the full list of PAM features to compare against your current setup.

A simple rule of thumb: if your spreadsheet is mostly a record of what already happened, it is fine. Once you need it to remind you, chase people and file returns, you have outgrown it.

Frequently asked questions

Can I still use a spreadsheet for my rental accounts under MTD?

You can keep digital records in a spreadsheet, but from April 2026 the quarterly submissions to HMRC must go through MTD-compatible software or bridging tools. A plain spreadsheet cannot file on its own, so most landlords use dedicated software for the actual returns.

Is property management software worth it for one property?

For a single, stable tenancy it is often not necessary; a spreadsheet and calendar can cover it. Software becomes worth it once you have multiple properties, or when compliance reminders and MTD filing start to feel like a real risk to manage manually.

What is the biggest risk of managing rentals in a spreadsheet?

Missed compliance deadlines. A spreadsheet holds cert dates but never warns you, so an expired gas safety certificate, EICR or lapsed deposit protection can slip through, leading to penalties and invalid possession notices.

How is PAM different from a spreadsheet?

PAM automates the parts a spreadsheet leaves to you: it sends compliance reminders, collects and reconciles rent via GoCardless, triages maintenance over WhatsApp, gives tenants an app, and files MTD ITSA returns with SA105 categorisation. Plans start from £12/month with a 14-day free trial.

Will I lose my data if I move from a spreadsheet to software?

No. You can bring your existing records across; a spreadsheet is often the starting point for setting up software. The difference is that once your data is in a structured system, it gains reminders, an audit trail and tax-ready categorisation.

At what point should a landlord stop using a spreadsheet?

A common tipping point is three or more properties, or the moment you have missed a renewal, lost track of arrears, or started to worry about MTD deadlines. If your spreadsheet needs to remind and chase rather than just record, you have outgrown it.

This guide is general information for UK landlords, not personal financial, tax or legal advice. Rules and thresholds change — always confirm the current position on gov.uk or with a qualified professional before acting.

Get started

Run your rentals on autopilot.

Compliance reminders, rent collection and HMRC MTD filing on one property record.

Start free trial →Explore tools