KeyMatrix vs Excel and WhatsApp groups
Excel and WhatsApp work, until the society outgrows one person holding it together. This is what breaks first, what a switch involves, and the size below which staying put is the right answer.
Below roughly twenty to thirty flats, with a treasurer who is organised and nobody complaining, Excel and a chat group are a perfectly reasonable answer and we will say so. Above that, the two things that break are collections tracking and institutional memory — and both break quietly, so the committee that inherits the problem is rarely the one that created it.
Societies running on Excel and WhatsApp typically fail first at collections tracking and institutional memory: arrears ageing goes stale between updates, reminders depend on someone’s patience, disputes have no searchable record, and every committee change risks the files being lost entirely.
KeyMatrix vs Excel and WhatsApp at a glance
The honest framing is that Excel is not bad software. It is excellent software being used as a system of record by an organisation that changes hands every year or two.
| Area | Excel and WhatsApp | KeyMatrix |
|---|---|---|
| Billing | A weekend of formula work each month, by one person | Generated on the cycle date, delivered automatically |
| Arrears visibility | As at the last time the sheet was opened | Live ageing per flat, at any moment |
| Late fees | Applied to whoever somebody noticed | Applied uniformly on the day they fall due |
| Complaints | Scroll back through a chat group | Tickets with owners, deadlines and escalation |
| Gate record | A paper register nobody can search | Searchable entries with photographs |
| Records at handover | One member’s laptop and their memory | A generated pack; nothing depends on goodwill |
| Cost | Free, plus a great many volunteer hours | Per flat per month |
Where Excel and WhatsApp fit well
For a small society they are genuinely adequate, and a committee that has a working spreadsheet and an organised treasurer should be slow to abandon it. Twenty flats, a single gate, no employed staff and a bill that is the same every month is not a problem that needs a platform, and buying one is over-engineering.
Excel is also better than most software at the thing it is actually good at: ad-hoc analysis. A treasurer modelling a rate increase, testing a repair fund scenario or building a one-off comparison will do it faster in a spreadsheet than in any product, ours included. That does not stop being true after you adopt a platform, which is why everything exports.
And WhatsApp is where residents already are. Nothing replaces it socially, and a committee that tries to move community conversation into an app is fighting a battle it will lose. The argument is not against the chat group; it is against the chat group being the place where notices, complaints and decisions live.
- Small societies genuinely do not need more. Under about twenty to thirty flats, this is a fine answer.
- Excel is unmatched for ad-hoc analysis. Which is why we export to it rather than compete with it.
- WhatsApp is where residents already are. The problem is using it as a system of record.
Where KeyMatrix is stronger
Three failures, each of which arrives quietly and is discovered by whoever comes next.
Automated billing instead of formula archaeology
A society billing sheet accumulates. Formulas written by a treasurer three terms ago reference cells nobody understands, exceptions are hard-coded for flats whose circumstances changed years back, and the arrears column carries forward errors that compound. Nobody rebuilds it because rebuilding it means understanding it.
The visible cost is a weekend a month. The invisible cost is that the numbers become approximate — late fees applied to the flats somebody noticed, ageing as at whenever the sheet was last opened, and no way to answer what is outstanding today without redoing the work.
A searchable system of record, not forty-seven chat groups
A complaint raised at eleven at night gets three reactions and scrolls out of view by morning. Nothing was assigned, nothing had a deadline, and six months later nobody can establish what was reported or whether it was fixed. When a member disputes a decision, the evidence is somewhere in a chat history nobody can search.
The distinction that matters is between announcements and conversation. An announcement needs a defined audience and a record of delivery; a conversation needs neither. Putting both in the same channel guarantees the first is lost in the second, which is why society notices go unread.
Handover in one click instead of one hard drive
This is the failure that compounds worst. A committee turns over and the outgoing secretary hands across a folder and an explanation. What does not transfer is why the lift vendor was changed, what was agreed with the builder about the terrace, which resolutions remain outstanding, and where the insurance policy is.
The new committee spends its first quarter rediscovering things, and some decisions get reversed simply because nobody knew why they were taken. A generated handover pack — financial position, open tasks, live contracts and renewal dates, pending filings, decision log — removes the dependency on one member’s goodwill and organisation.
Pricing and contracts compared
Excel is free and a platform is not, and any comparison that pretends otherwise is not worth reading. The honest question is what the volunteer hours are worth and what the errors cost, and that answer genuinely depends on the size of the society.
The costs worth counting on the Excel side are the treasurer’s weekend each month, the collection rate difference that consistent reminders and uniformly applied late fees produce, the audit observations that arise from books kept separately from billing, and the risk of losing records at a committee change. None of those appear on an invoice, which is exactly why they get discounted.
Below roughly twenty to thirty flats the arithmetic usually does not justify a platform, and we will tell you that rather than sell to you. Above it, the per-flat cost is small against what it removes — and if you are not sure which side of the line you are on, that is a reasonable thing to work through on a call.
- Count the volunteer hours. A weekend a month is the usual figure.
- Count the collection difference. Consistent reminders and uniform late fees move it.
- Count the handover risk. Records on one laptop is a single point of failure.
- Under thirty flats, stay put. We would rather say so than sell you something.
Switching from Excel and WhatsApp: what migration looks like
Most Excel-run societies are live within a week or two, and the import validation is the most useful part of it.