</> JMS Dev Lab
Services Pricing About Blog Contact Get in Touch
Get in Touch
  1. Home
  2. /
  3. Blog
  4. /
  5. Property Management in 2026: Why Spreadsheets Don't Scale Past 20 Units

Property Management in 2026: Why Spreadsheets Don't Scale Past 20 Units

23 March 2026

If you're a letting agent or property manager in Ireland, there's a good chance your rent roll lives in a spreadsheet. Probably colour-coded. Green for paid, yellow for late, red for trouble. It works when you're managing ten or fifteen properties. It even works at twenty, if you're disciplined about updating it.

But somewhere around the twenty-unit mark, spreadsheets start to fail in ways that are hard to see until something goes wrong. I've watched this pattern play out across different industries — I ran a multi-location retail business for 22 years and hit the exact same wall with spreadsheets tracking stock, staff, and suppliers across shops. The breaking point is always the same: the moment the data outgrows one person's ability to keep it accurate and current.

Rent Tracking Across Properties

At ten properties, you can probably remember which tenants are reliable payers and which ones need chasing. At twenty, you can't. At thirty or forty, you're relying entirely on the spreadsheet — and the spreadsheet is only as good as the last time someone updated it.

The problems compound quickly. Standing orders come in with different references. A tenant pays from a different bank account and the payment doesn't match the name on your spreadsheet. Someone pays two months at once and you mark the wrong month. By the time you're doing your monthly reconciliation, you're spending hours matching payments to tenants across multiple properties, multiple landlords, and multiple bank accounts.

A proper system handles this automatically. Payments are matched to tenants. Arrears are flagged in real time, not discovered during a monthly review. Landlord statements are generated with one click instead of assembled manually from three different tabs.

Maintenance Requests Lost in Email

Tenants report issues by email, by phone, by text, and sometimes by walking into your office. Each channel creates a separate record (or no record at all). When you have twenty properties, that's potentially dozens of open maintenance items at any given time. Which ones have been assigned to a contractor? Which ones are waiting for a quote? Which ones were reported three weeks ago and still haven't been actioned?

In a spreadsheet, tracking this means yet another tab, yet another set of columns, and yet another thing to update manually. In practice, maintenance tracking is the first thing that breaks when you're busy. A request comes in, you deal with it, but you don't update the tracker. Two weeks later the tenant rings to complain, and you have no record of what happened.

A proper maintenance system gives tenants a way to submit requests directly (ideally with photos), routes them to the right person, tracks them through to completion, and maintains a full history. When a landlord asks about maintenance costs for the year, the data is already there.

Tenant Communication

Every phone call from a tenant asking "has my deposit been returned?" or "when does my lease expire?" or "did you receive my rent?" takes time. These are reasonable questions, and tenants deserve answers. But when you're managing thirty or forty tenancies, answering them individually is a significant drain on your day.

A tenant portal eliminates most of these calls. Tenants can log in and see their payment history, their lease dates, the status of any maintenance requests, and any documents you've shared with them. They get the information they need without calling your office, and you get your afternoon back.

RTB Compliance

Every tenancy needs to be registered with the Residential Tenancies Board. Registration dates, renewal dates, notice periods, deposit records — all of this needs to be tracked and documented. For a small portfolio, you might keep this in your head or in a folder on your desk. At twenty properties, that's no longer viable.

Missing an RTB registration deadline doesn't just create administrative hassle — it can result in fines and weaken your position in any dispute. A system that tracks registration dates and sends you reminders before deadlines hit is not a luxury at this scale; it's a necessity.

The same applies to BER certificates, gas safety records, and periodic inspections. Each has its own schedule, and each needs to be documented and filed. Scattering this across spreadsheets, email, and filing cabinets is a compliance risk that grows with every property you add.

Financial Reporting for Landlords

Landlords want to know how their investment is performing. Rental income, expenses, maintenance costs, vacancy periods, net yield. They want this quarterly, or monthly, or whenever they ask for it. If this data is spread across a rent spreadsheet, an expense spreadsheet, and a folder of invoices, assembling a report is a manual process that takes hours.

This is where the spreadsheet approach breaks down most visibly. The data exists, but it's not connected. Pulling together a coherent financial picture for a single landlord means cross-referencing multiple sources. Doing it for ten landlords every quarter is a significant time commitment that delivers no revenue.

A proper system generates these reports automatically because the data is already structured and connected. Rent collected, expenses incurred, and maintenance costs are all linked to the right property and the right landlord. The report writes itself.

When Spreadsheets Break: The Twenty-Unit Threshold

There's nothing magic about the number twenty. The exact breaking point depends on the complexity of your portfolio, the number of landlords you work with, and how much help you have. But the pattern is consistent: somewhere between fifteen and twenty-five properties, the time spent maintaining spreadsheets starts to exceed the time a proper system would require. And the risk of errors, missed deadlines, and lost information starts to become material.

The irony is that most agents don't recognise the breaking point until they're well past it. The spreadsheet still looks like it's working. It's only when something goes wrong — a missed RTB deadline, a maintenance complaint that was never logged, a landlord report that turns out to have the wrong figures — that the cost of the current approach becomes visible.

What a Proper System Gives You

The alternative to spreadsheets is not necessarily an expensive off-the-shelf property management platform designed for agencies with hundreds of properties. Often, the better answer is a custom system built around how your specific business operates. Here's what that looks like:

  • One source of truth. Every property, tenant, lease, payment, and maintenance request in one place. No duplicate data, no version conflicts, no "which spreadsheet is current?"
  • Automated rent tracking. Payments matched to tenants automatically. Arrears flagged in real time. Landlord statements generated with one click.
  • Tenant self-service. A portal where tenants check their own information, submit maintenance requests, and download documents. Fewer phone calls, better service.
  • Compliance tracking. RTB registrations, BER certs, and inspection schedules tracked with automatic reminders. Full audit trail for every property.
  • Financial reporting. Landlord reports generated automatically from data that's already in the system. No manual assembly required.

A custom property management tool typically starts from EUR 6,000. If your business is eligible, the LEO Grow Digital Voucher can fund up to 50% (up to EUR 5,000). We have 9 production apps live and build fixed-price tools for Irish businesses. If you want to explore what this could look like for your agency, visit our property management page or get in touch. No obligation, no jargon.

</> JMS Dev Lab

Custom software for businesses that are too unique for off-the-shelf tools and too small for enterprise pricing.

Services
Custom Development JewelryStudioManager StaffHub Jewel Value SmartCash Pitch Side RepairDesk GrowthMap QualCanvas
Company
About Blog Contact
Legal
Privacy Policy Terms of Service Pay Invoice

Stay in the loop

New tools, insights, and product updates. No spam, unsubscribe anytime.

© 2026 JMS Dev Lab. All rights reserved.