Spreadsheets are often a sensible place to start managing property. With one or two properties, a straightforward sheet may be enough to record values, rent, mortgage information and key dates. It is familiar, flexible and easy to change.
As a portfolio grows, however, the information surrounding each property can grow much faster than the number of rows. A portfolio list may show the assets, but it may not show the documents, dates, ownership context, maintenance history and decisions that make those assets manageable.
That is the important distinction: a portfolio list is not necessarily an operational property record. The challenge is usually not using Excel or Google Sheets. It is relying on a collection of disconnected records to keep the whole portfolio understandable.
Why spreadsheets work — until they don't
A well-designed spreadsheet can be an excellent property-management tool. It can support calculations, financial modelling, scenario analysis, budgets, forecasts, one-off analysis and bespoke reports. For a small and relatively simple portfolio, that flexibility may be all an owner needs.
There is no universal property-count threshold at which a spreadsheet stops being useful. One complicated mixed-use building may require more management than several simple residential properties. Complexity matters more than the number of addresses.
The difficulty appears when the spreadsheet becomes responsible for jobs it was not originally created to coordinate: mortgage tracking, tenancy information, compliance dates, maintenance history, document indexing, shared access and portfolio reporting. The calculation may still work while the surrounding record becomes harder to trust.
Warning signs that the spreadsheet is becoming a system
A spreadsheet may be becoming an operating system for the portfolio when:
- several versions of the same file exist;
- important information lives in email or messages;
- compliance is tracked in a separate sheet;
- calendar reminders are maintained manually;
- certificates and agreements sit in unrelated folders;
- it is difficult to find the latest document;
- tenancy information is separate from the property record;
- maintenance history is difficult to reconstruct;
- mortgage and finance information is disconnected from the asset;
- the same change must be entered in several places; or
- another person cannot understand the portfolio without asking the owner.
None of these signs means that spreadsheets are inherently bad. They indicate that the portfolio may now need stronger relationships between its records. The problem is fragmentation, not the grid itself.
Build one property record
A useful property record makes the asset the anchor for the information that relates to it. Depending on the portfolio, that record may connect:
- address and core property information;
- ownership and organisation;
- portfolio and units;
- valuation and acquisition information;
- finance or mortgage information;
- tenancies or leases;
- income and operating costs;
- compliance records;
- maintenance history;
- documents and key contacts;
- important dates and events; and
- eventual disposal or sale history.
Not every landlord needs every field. The principle is more useful than a fixed checklist: record information where it belongs, then make it possible to understand that information at the level of the property and the wider portfolio.
The same approach sits behind the wider guidance in our article on how to manage a property portfolio effectively.
Separate the portfolio view from the property record
Portfolio-level and property-level questions are related, but they are not the same.
At portfolio level, an owner may want to know: What is happening across everything I own or manage? Useful context might include property count, estimated portfolio value, rent roll, occupancy, upcoming dates, open maintenance and compliance requiring attention.
At property level, the question is different: What is happening with this particular asset? The answer may involve units, tenancy, mortgage, certificates, maintenance, documents, ownership and property-specific dates.
A useful system should make it possible to move between both views. A portfolio total is more useful when the owner can understand which properties contribute to it. A property record is more useful when its place in the wider portfolio is clear.
Connect dates to the records that create them
A separate calendar can be useful, but a date is more useful when its source is visible. Compliance expiry, an inspection, lease expiry, rent review, break date, maintenance appointment or finance review date should be understandable in relation to the property or record that created it.
When dates are maintained manually in a diary, the owner has to preserve the connection themselves. If a property is sold, a tenancy changes or a compliance record is renewed, the related reminders may need to be found and updated in another place.
The goal is not to eliminate calendars. It is to reduce the amount of duplicated administration required to keep dates and records aligned.
Our guide to property compliance management for landlords explains how requirements, status, dates, evidence and responsibility can remain connected at property and portfolio level.
Keep documents with the information they support
A folder containing property files answers one question: where can the file be saved? A connected property record answers a different question: what does the file relate to?
- a tenancy agreement can be associated with the tenancy;
- an EPC or other certificate can be associated with the relevant compliance record or property;
- a mortgage statement can be associated with the finance facility;
- a maintenance document can be associated with the relevant property or job; and
- a sale document can remain part of the property lifecycle.
Context becomes increasingly important when portfolios grow or responsibilities are shared. It reduces reliance on filenames, folder conventions and one person remembering why a document matters.
Our guide to property portfolio management software explores this broader question: how should documents, finance, compliance, maintenance and property records work together rather than sitting in separate systems?
Think about ownership structure as well as property count
The management problem is not always simply "20 properties". It may be 20 properties across several organisations: some held personally, some through a limited company and some through other property-owning businesses.
An owner may need to see the whole authorised portfolio while preserving organisational separation. That means answering both questions: what do I own or manage overall, and what belongs to this particular organisation?
These views should not require unrelated workbooks for every entity. At the same time, combining everything into one undifferentiated list can lose important ownership context. A structured record should preserve the separation while allowing an authorised user to work efficiently across their property interests.
Fructus supports multiple organisations for an authorised account. Each organisation remains separate and has its own Fructus subscription.
Create repeatable workflows
Moving beyond spreadsheets does not mean transferring spreadsheet rows into another table. The useful change comes from establishing repeatable processes around the records.
- Adding a property: create the property, ownership context, finance, units, tenancy or lease, compliance and documents as relevant.
- Creating a compliance record: record the requirement, add important dates, attach evidence and monitor the next action.
- Managing maintenance: record the issue, status, contractor context, completion and retained history.
- Selling a property: record the disposal process while preserving the historical property record rather than deleting the asset.
These are illustrative workflows, not requirements for every portfolio. Their value is that they make the connection between an action and the underlying property explicit.
What should property management software replace?
Good property management software should not simply replace a spreadsheet with an online table. It should reduce fragmentation between property information, dates, leases, compliance, maintenance, finance and documents.
That does not mean every external tool disappears. Spreadsheets can remain useful for modelling and bespoke analysis. Accounting, banking, legal and professional-adviser workflows may also remain separate. The question is whether the operational property record is clear and whether the owner can trace portfolio information back to the assets and records beneath it.
A property management system becomes more useful when it reduces repeated entry, preserves context and makes the next action easier to understand.
When should you move away from spreadsheets?
A spreadsheet may remain perfectly adequate when the portfolio is small or simple, information is easy to find, dates are reliably controlled, records are not fragmented and only one person needs access.
A more structured system may be worth considering when administration is being duplicated, important dates depend on manual diary updates, documents are difficult to associate with records, several people need access, several organisations are involved, or the owner cannot quickly answer basic questions about the portfolio.
The useful threshold is not a number of properties. It is the point at which maintaining the relationships between records becomes a significant part of the work.
A sensible transition does not need to happen all at once. Start by identifying the records that create the most repeated work or the greatest uncertainty. For one owner, that may be mortgage dates. For another, it may be compliance evidence, maintenance history or the ability to give a property manager access without sharing an entire workbook.
Keep the spreadsheet where it adds value, but decide which information should have one authoritative home. That boundary is often more useful than trying to recreate every existing formula or historical note in a new system on day one.
How Fructus approaches the problem
Fructus is property management software built around connected property records. It brings together areas such as portfolios, properties, units, leases and tenancies, ownership and finance information, compliance, maintenance, events and documents.
The purpose is not to tell every landlord to abandon spreadsheets. It is to provide a structured operating record for the parts of property management that become difficult to keep connected as a portfolio grows.
The portfolio management features are designed around the same principle: property-level records should build the portfolio view.
The article should remain useful even if a reader never signs up. The practical test is simple: can the owner find the information needed to understand what is happening, what needs attention and what happens next?
From spreadsheet management to property control
The objective is not to eliminate spreadsheets for the sake of it. Spreadsheets remain useful analytical tools, particularly for modelling, forecasting and bespoke calculations.
The goal is to stop relying on a collection of disconnected spreadsheets, calendars, folders and inboxes as the operating system for a growing property portfolio. A connected property record gives the owner a clearer place to start, while preserving the detail behind the portfolio view.
Bring your property portfolio into one place and start a 14-day free trial through the live Fructus signup journey.