Tracking Expenses on a Rental Property in Kenya (Without a Spreadsheet Meltdown)

Somewhere in Nairobi right now there's a landlord opening a spreadsheet called "Expenses2025_FINAL_v3.xlsx" that hasn't been touched since March, trying to remember whether the KES 8,500 M-Pesa payment from April was for the Kasarani unit's plumber or the askari's salary advance. This is not a hypothetical. This is Tuesday for a huge number of Kenyan landlords, and it's exactly the kind of moment that makes people swear off spreadsheets entirely, usually right before building an even messier one.

The good news is that tracking rental property expenses doesn't actually require sophistication. It requires consistency, which is a much lower bar, and a system that doesn't depend entirely on your memory and goodwill at 11pm after a long day.

The Expenses Landlords Actually Forget to Track

Everyone remembers the big ones: a new water pump, repainting after a tenant moves out, a roof repair. The ones that quietly erode your actual profit are the small, recurring ones that never feel worth writing down in the moment:

• Askari and caretaker wages, especially when paid partly in cash and partly via M-Pesa, which splits the record across two places nobody checks together.
• Land rates and county levies, paid once or twice a year and easy to forget by the time annual accounting rolls around.
• Small plumbing and electrical call-outs that cost a few thousand shillings each but happen constantly across a multi-unit property.
• Garbage collection fees if you're covering it rather than passing it through to tenants.
• Transport and fuel for property visits, which adds up more than most landlords expect across a year of back-and-forth trips.
• Bank and M-Pesa transaction charges on every rent collection and every payout, a genuine cost that rarely gets subtracted from anyone's mental math.

None of these feel significant individually. Add them up over a year across several units and they can represent a meaningful chunk of what looks like profit on the surface but isn't, once everything is actually counted.

Why the Spreadsheet Usually Fails, Specifically

Spreadsheets aren't inherently bad tools. The failure mode is almost always the same: the spreadsheet depends on someone remembering to open it, remembering the category structure, and manually typing in a number from a receipt that may or may not still exist by the time they get around to it. Multiply that by a caretaker who also needs to log expenses but has never used Excel, and the system collapses under its own maintenance burden long before it collapses under complexity.

The spreadsheet doesn't meltdown because expense tracking is hard. It melts down because the system has no memory of its own, and relies entirely on human discipline that, realistically, nobody sustains indefinitely across dozens of small transactions a month.

A Simpler Structure That Actually Holds Up

Categorize by type, not by date

Group expenses into a short, fixed list: maintenance and repairs, staff wages, utilities and rates, transport, bank and transaction fees, and "other." Resist the urge to create a new category every time something slightly unusual happens. A stable set of categories is what makes year-over-year comparison and tax preparation actually useful later.

Record the expense against the property, not just the amount

If you own more than one property, every single expense needs a property tag from the moment it's recorded. Trying to retroactively split a year of mixed expenses between two buildings is one of the most painful admin tasks a landlord can set themselves up for, and it's entirely avoidable by tagging at the point of entry.

Capture the expense close to when it happens

The single biggest predictor of whether expense tracking actually works is how long the gap is between the expense happening and it being recorded. A photo of a receipt taken on the spot and logged the same day survives. A pile of receipts "to be entered later" rarely does.

Where a Proper System Earns Its Keep

This is the part a spreadsheet structurally can't do well: letting more than one person log an expense the moment it happens, from wherever they are, without it depending on them opening a laptop later. A caretaker who just paid a plumber KES 3,000 should be able to log it from their phone, with a photo of the receipt, tagged to the right unit, in under a minute. That record should then be visible to you instantly, not discovered three weeks later in a pile of paper.

This isn't about replacing good habits with software. It's about removing the dependency on perfect habits in the first place, because a system that works when you're tired, busy, or simply forgetful is a system that actually survives a full year, which is the only kind of expense tracking that's genuinely useful when tax season or a profitability review comes around.

What This Buys You Beyond Tidiness

Clean, categorized expense records make three things dramatically easier: calculating your actual yield on each property rather than guessing, preparing for tax filing without a weekend of reconstruction, and spotting a cost that's quietly crept up, a water bill that's doubled, a caretaker's informal "extras" that have become a pattern, before it becomes a real problem rather than after.

Stop reconstructing expenses from memory and a shoebox of receipts. Start a free 30-day trial at Makeja Homes and track every expense, by property, by category, from your phone, the moment it happens.