How to Manage a Property Portfolio Without Losing Your Mind

Managing one property is straightforward. Managing five is manageable with a spreadsheet. Managing ten or more with spreadsheets is where things start to break down — compliance deadlines get missed, rent arrears go unnoticed, and you spend more time on administration than on actually growing the portfolio. This guide covers the systems that work at scale.

The Problem With Spreadsheets

Spreadsheets are where UK landlords start and where many stay too long. The problems compound as the portfolio grows:

• No automatic alerts — you have to remember to check expiry dates
• One file for everything becomes unwieldy and fragile
• No mobile access (or a terrible mobile experience)
• No audit trail — changes overwrite history
• Can't share with a property manager without giving them everything
• No connection between compliance, rent, maintenance and finances

The turning point is usually a missed gas certificate, a missed Section 21 deadline, or a dispute where you can't find the evidence you need. At that point, moving to a proper system stops being optional.

Organising by Company

If you own properties through multiple companies — a common structure for tax efficiency — your management system needs to reflect that. Keep properties separated by legal entity so that income, expenses, compliance and reporting are all cleanly attributed to the correct company.

This matters at tax time (P&L per company), during refinancing (lenders want company-level data) and if you ever sell one company's portfolio while keeping another.

The Five Things You Must Track Per Property

1. Compliance status: Gas cert, EICR, EPC, HMO licence expiry dates with alert lead times
2. Rent payment history: Paid, late, missed, void — month by month and day by day
3. Tenancy details: Tenant name, start date, end date, rent amount, due date, deposit scheme
4. Maintenance jobs: Open and closed repairs with contractor details and costs
5. Financials: Income, expenses, yield and equity per property

Health Scores — Seeing Problems Before They Become Crises

A health score system assigns each property a score out of 100 based on its current status across compliance, rent, tenancy and maintenance. Properties with scores below a threshold are immediately visible — you can see at a glance which properties need attention this week without checking every individual item.

Common things that drop a property's health score:

• Compliance certificate expiring within 60 days
• Rent missed or in arrears
• Tenancy ending within 90 days with no renewal logged
• Open maintenance jobs over 14 days old
• Property vacant for over 30 days

Multi-Property Rent Tracking

The rent tracker overview — showing all properties across all companies with their monthly payment status in one scrollable view — is the single most time-saving feature for multi-property landlords. At a glance you can see which months are green (paid), which are red (missed) and which are grey (void). Expanding any month shows the day-level detail.

Delegating Without Losing Control

As a portfolio grows, you'll likely bring in a property manager, accountant or VA. The key is giving them access to exactly what they need — no more. An accountant needs income and expense reports; they don't need to see tenant messages. A property manager needs to log maintenance jobs; they don't need to see your deal pipeline.

Per-company access controls — where team members can be given access to specific companies within your portfolio — are the right architecture for this.

Reports That Actually Save Time

The reports that matter most for a growing portfolio:

• P&L per property: Income minus expenses — the bottom line per property
• Compliance status: Which certificates expire in the next 90 days, across all properties
• Arrears report: Properties with outstanding rent and the amount owed
• Occupancy report: Void periods and occupancy rate per property
• Yield report: Gross and net yield per property, ranked

Ideally all of these are exportable to CSV for your accountant or for further analysis in Excel.

← Back to all guides