Manual meter settlements every monthThe tenant texts you a photo of the meter, you type the reading into the spreadsheet, calculate consumption at the tariff rate, and email the result. Every month, for every apartment, separately.
Tracking payment deadlinesA spreadsheet won't remind the tenant about rent or tell you who's behind. You check the bank account and match payments against the table by hand.
File versionssettlements_v3_corrected_FINAL.xlsx — a year on, it's hard to say which file is current and how it differs from the last one.
Documents scattered across emailsThe lease is an attachment from two years ago, the handover report is in another thread, the addendum is somewhere on your drive. When a tenancy ends, gathering the documents can eat up an entire evening.
No change historyWhen a tenant disputes a settlement from six months ago, the spreadsheet won't show who changed a cell's value, when, or what the previous version looked like.
Formula errors at thresholds and pro-rated amountsBilling a partial month or a mid-period rate change are classic spots where a formula silently miscalculates — and the error only surfaces once there's a dispute with the tenant.