Managing a property portfolio well comes down to one discipline: every property, occupier, lease, key date and figure lives in one trusted place that someone checks weekly. Get that right and the rest — rent collection, renewals, reporting — becomes routine. Get it wrong and the portfolio is run by whichever spreadsheet was opened last. This guide covers the admin system that actually does the managing, written from the working end: we build and run the database a UK commercial-property firm manages its whole portfolio on.
What managing a portfolio actually involves, day to day
Most guides about property portfolios are about buying more property. Almost none are about the unglamorous part that decides whether the portfolio makes money: the admin. Day to day, managing a portfolio means knowing, without looking anything up twice:
- who occupies each unit, what they pay, and when it changes
- which lease events are coming — breaks, expiries, rent reviews — and how long you have to act
- what is owed, what is overdue, and who is chasing it
- where every lease, licence and certificate actually is
- what the whole book looks like when the bank or the board asks
Every one of those is a record-keeping problem before it is a property problem. That is why the system you keep the records in matters more than any individual decision about a tenant or a rent.
Should you self-manage or use a letting agent?
The honest answer is that this is a cost-versus-control decision, and the numbers are knowable. A managing or letting agent typically charges 8–12% of rental income for full management. On a portfolio collecting £300,000 a year, that is £24,000–£36,000 — real money, but it buys someone else handling tenant calls, maintenance and voids.
What an agent does not do is keep your master records for you. Agents manage properties; they do not maintain your consolidated book — your entity structure, your finance facilities, your cross-portfolio reporting. Plenty of firms pay an agent and still run the portfolio itself off spreadsheets. Whichever way you go on management, the record system stays your problem.
The records a portfolio actually needs
This is the record structure we ended up with after building a portfolio database that a UK commercial-property firm uses every day. It is the minimum that makes a portfolio manageable:
| Record | What it holds | Why it matters |
|---|---|---|
| Properties & units | Address, units, sizes, EPC, ownership entity | The spine everything else hangs off |
| Occupiers | Company, contacts, covenant notes | Who you actually deal with, not just a name on a lease |
| Leases | Start, expiry, break dates and notice periods, review dates, rent | The dates that cost money when they slip |
| Financials | Rent roll, arrears, deposits, facilities | The money next to the record it belongs to |
| Documents | Leases, licences, certificates, correspondence | Found in seconds, attached to the right record |
| Events & reminders | Every upcoming date with a countdown | The system does the remembering |
Whether you keep this in a spreadsheet or in software matters less than whether it exists at all, in one place, with one owner. One version of the truth, checked weekly, beats a sophisticated system nobody trusts.
The dates that cost real money
The expensive failures in portfolio management are almost never dramatic. They are dates that arrived before anyone had done the thinking: a break clause notice served a day late, a rent review left to default, an expiry that turned into an undocumented holdover. Courts enforce break conditions strictly — a missed break on a £40,000-a-year lease with five years to run is a six-figure commitment made by omission.
The discipline is to track the deadline to act, not the event itself: the break date minus the notice period, the review date minus the time your surveyor needs, the expiry minus 12–18 months of renewal planning. We wrote a full guide to the reminder schedule, with a free Excel tracker whose columns mirror the fields our production system uses.
Spreadsheet or software?
A spreadsheet is genuinely enough for a handful of properties with one careful owner — we say that plainly, because it is true. Spreadsheets crack in predictable ways as a portfolio grows: more than a couple of dozen leases, more than one person editing, versions multiplying across inboxes, contact history scattered, and reporting that means rebuilding the same pivot table every month. The failure mode is never the formula; it is versioning, access, and the fact that a spreadsheet cannot chase anyone.
When the spreadsheet stops being trusted — when people double-check it against their own notes — that is the signal to move. We compared the whole UK market honestly, with real prices, in our commercial lease management software guide: from free templates through £8–£19/month deadline tools to enterprise platforms priced on application.
Reporting: what the bank and the board actually ask for
Sooner or later every portfolio has to explain itself — to a lender at refinance, to a board each quarter, to an auditor at year end. The questions are always the same: rent roll, occupancy, arrears, WAULT, sector split, upcoming lease events, covenant position. If the records are in one system, that report is minutes; if they are in five spreadsheets, it is a week of retyping every quarter.
This is the part we ended up automating hardest. TenureBook, the product that grew out of the client system we run, drafts board packs from the live records — KPIs, sector splits, arrears, debt — with the commentary written from your own figures in plain English for you to edit and approve before it leaves the room.
What a proper portfolio system costs
Real numbers, because almost nobody in this market publishes theirs:
- A spreadsheet — £0 with our free tracker template. Right answer for a handful of leases with one careful owner.
- TenureBook — from £295 a month (3 seats, live within a minute of checkout, Excel import for your existing records; £425 a month adds your branding across every board pack, 7 seats). The middle ground between spreadsheets and enterprise platforms.
- A bespoke build — £7,000 to build, then £100 a month, when no product fits how your firm works. The Proprietary Database, modelled on the system we run for a real firm.
- Enterprise platforms (Re-Leased, MRI, Yardi) — priced on application, built for managing agents and large portfolios with accounting and client-money handling.
The way to judge any of these: estimate the hours a week the portfolio currently loses to retyping, checking and chasing, multiply by what that time is worth, and compare it to the cost. A system that saves one person two hours a working day pays for itself quickly — before counting the missed break clause it prevents.
The one-page system, summarised
- One record system, one owner, checked weekly — spreadsheet or software.
- Track deadlines-to-act, not event dates.
- Money lives next to the record it belongs to.
- Documents attach to records, not inboxes.
- Move to software when trust in the spreadsheet breaks, not before.
- Automate the reporting — it is the highest-value admin to stop doing by hand.
If you want a second opinion on your own setup, book a short call — we will tell you honestly if the free template is all you need, because it sometimes is. Or send us the details and we will come back with a considered view.