Spreadsheet or software: when a landlord should actually switch
A spreadsheet is a legitimate way to track rent and works well for a small portfolio on fixed rent. It fails in specific, recognisable ways: carried balances drift, variable charges get estimated, there is no record the tenant can see, several copies diverge, nothing reminds anyone of anything, and nobody can reconstruct what happened six months ago. Each failure has its own fix, and not all of them require replacing the spreadsheet.
Spreadsheets are not the problem people say they are
Software vendors talk about spreadsheets as though using one were a mistake. For a landlord with a few units on fixed rent, a spreadsheet is accurate, free, portable, and understood by everyone who needs to read it. That is a better position than being locked into a product you did not need.
What is worth knowing is how spreadsheets fail, because they fail quietly. Nothing breaks visibly. The numbers simply stop matching reality, and you find out during a dispute or at tax time.
The six failure modes
These are the ways rent spreadsheets actually go wrong, with what each costs you.
| Failure | How it shows up | What it costs |
|---|---|---|
| Carried balances drift | A part payment is recorded but the opening balance next month is not adjusted | You under-collect or over-claim, and cannot prove which |
| Variable charges get estimated | Meter readings are skipped for a month and a figure is assumed | Disputes, and a number you cannot defend when challenged |
| No record the tenant can see | Your sheet is yours; the tenant has their own recollection | Disagreements become unresolvable rather than factual |
| Copies diverge | A file is shared, someone edits a download, two versions now exist | Nobody knows which is authoritative |
| Nothing reminds anyone | Due dates pass because the sheet is passive | Later collections, and the awkwardness of chasing |
| No audit trail | A cell was changed; there is no record of when, or by whom, or what it said before | At tax time or in a dispute, history cannot be reconstructed |
Fix the failure, not the tool
Most of these have a targeted fix that does not involve abandoning your spreadsheet, which matters if you are not convinced you need a system.
If variable charges are the problem, do that calculation properly rather than estimating it, and give the tenant the reading-by-reading breakdown. If the gap is a record the tenant can rely on, issue a real receipt for every payment and keep copies; the receipt, not the sheet, is what settles arguments. If reminders are what you avoid, use a written template so the message is routine rather than personal.
The two failures that genuinely resist a patch are carried balances and audit trail. Both are about state changing over time, which is exactly what a flat grid is bad at. If arrears are routine in your portfolio, that is the strongest single argument for a system that tracks balances for you.
The honest switch test
Two or more of these together is a real signal. One on its own usually is not.
- Someone is carrying a balance across months, and you are the one keeping track of it.
- You have estimated a variable charge rather than calculated it, more than once.
- You have had a disagreement with a tenant about what was paid or what was owed.
- More than one person edits the record, or needs to read it.
- You avoid sending reminders because doing it manually feels confrontational.
- Assembling the year's figures for your return takes an evening rather than a minute.
Free tools you can use
Spreadsheet vs software FAQ
Is a spreadsheet good enough for tracking rent?
For a small portfolio on fixed rent paid in full and on time, yes. Spreadsheets are accurate, free and portable. They fail in specific ways: carried balances drift, variable charges get estimated, there is no tenant-visible record, copies diverge, nothing sends reminders, and there is no audit trail.
When should a landlord stop using Excel for rent?
When two or more of these are true: a tenant is carrying arrears across months, you have estimated rather than calculated a variable charge more than once, you have had a dispute about payment, several people edit the record, or compiling your year-end figures takes hours.
What is the most common mistake in a rent spreadsheet?
Losing a carried balance when a bill is recomputed. If a charge is corrected or added, the month's total is recalculated and the arrears brought forward from earlier months silently drop out. The figure looks correct and is short by exactly the amount owed.
Can I keep my spreadsheet and fix just the problem parts?
Often yes. Calculating metered charges properly, issuing real receipts, and using a written reminder template address three of the six failure modes without changing how you track anything. Carried balances and audit trail are the two that genuinely need something that tracks state over time.
Does a spreadsheet count as proof in a rent dispute?
It is your own record, which the tenant has no reason to accept and which carries no trace of when it was edited. Dated receipts issued at the time of payment are far stronger, which is why issuing them is worth doing regardless of how you track the rest.