How I Track Utility Costs I Cover as a Landlord

On three of my nine rental units, I cover the shared water bill and a slice of common-area electricity out of my own pocket, and last year that quietly added up to about 214,000 yen. None of it shows up as rent income, but every yen still comes straight out of my cash flow, so if I do not track it carefully I end up guessing at my real profit margin instead of knowing it.

Early on I just paid these bills as they arrived and filed the receipts in a drawer. That worked until I had four properties and could no longer remember which building’s water usage had jumped, or whether a tenant’s shower habits were the reason or a hidden leak was. Now I run a simple system that takes about 15 minutes a month and has already saved me over 60,000 yen in caught leaks and billing mistakes.

Why I Cover Some Utilities at All

Not every property needs this. On six of my nine buildings, each unit has its own separate meter for water, gas, and electricity, so tenants pay their own utility company directly and I stay completely out of it. The other three are older buildings, built more than 30 years ago, where the water line was never split per unit. Replacing that plumbing to add individual meters would run around 380,000 yen per building, so instead I absorb the shared water cost and build a small utility allowance into the rent. I also cover hallway and stairwell lighting on every property, which is a smaller but constant line item.

The Simple Spreadsheet I Use Every Month

I keep one spreadsheet per property, not one giant combined sheet, because it is much easier to spot a trend in a single building’s history than to hunt for it in a mixed table. Each row is one billing month, and I track five columns: the billing period, total yen charged, number of occupied units that month, cost per unit, and a short note field for anything unusual, like a new tenant moving in or a pipe repair.

I enter the numbers the same day the bill arrives, straight from the utility company’s paper invoice or their online portal. Waiting even a week means I forget the small details, like whether a spike was because a tenant had guests staying over for two weeks. That note field has probably saved me more money than the numbers themselves, because it lets me look back six months later and understand why a bill was high instead of assuming something is broken.

Splitting Costs Fairly Between Shared Meters

For the three shared-water buildings, I divide the total bill by the number of occupied units, not by the total number of units in the building. If a four-unit building only has three tenants that month, splitting by four would undercharge everyone and leave me eating the difference. I list this method plainly in the lease so nobody is surprised, and I have never had a tenant push back once they see the calculation written out.

• Record the total bill amount and billing period as soon as it arrives
• Count occupied units for that exact billing period, not the current month
• Divide total cost by occupied units to get a per-unit allowance figure
• Compare the result against the prior three months before finalizing anything
• Note any anomalies, like vacancies or repairs, directly next to the entry

Catching Leaks and Spikes Before They Cost Me

Because I log every month in the same format, a leak tends to announce itself fast. Two years ago, one building’s shared water bill jumped nearly 40 percent in a single month, from about 18,000 yen to 25,000 yen, with no new tenants and no unusual notes from the prior period. I walked the property that weekend and found a toilet fill valve running constantly in a vacant unit. The fix cost me 3,400 yen in parts and twenty minutes of my time, but if I had not noticed the spike for another two or three billing cycles, it would have cost far more.

I set myself a simple rule now: any month where a property’s utility cost moves more than 20 percent from its trailing three-month average gets a physical inspection within a week. It is a rough threshold, but it has caught two leaks and one billing error from the utility company in the past three years.

Building Utility Costs Into My Rent Pricing

Once I have twelve months of clean data for a property, I calculate the average monthly utility cost per unit and fold roughly that amount into the advertised rent as a flat utility allowance, rather than billing it separately every month. Tenants like the predictability, and I like not having to send out invoices and chase payments for small amounts. I revisit that number once a year at lease renewal, since utility rates in Japan have crept up noticeably over the past few years, and a number that made sense 24 months ago can quietly leave me covering a gap I did not intend.

Keeping It Sustainable Over Time

None of this requires accounting software or anything complicated. I use a basic spreadsheet, a folder of scanned invoices organized by property and year, and a recurring reminder on the first of every month to enter the latest bills. The habit matters more than the tool. After doing this across 9 properties for more than 15 years, the pattern I trust most is simple: log it the day it arrives, compare it to history immediately, and walk the property yourself the moment a number looks off.

That is the approach I use across all 9 of my properties, and it is the difference between utility costs being a mystery line item and being just another number I control.

同じカテゴリの記事を読む

8棟自主管理の経験から書いた関連記事 — まとめて読むと理解が深まります

▸ DIY Repairs

Repairing a Dented Garage Door Panel

▸ English

Kitchen Series Vol.43: Installing the Sink Light u2014 DIY Dad’s Renovation Chronicles

▸ English

Apt. 1 Kitchen Renovation Vol.1: Rethinking the Kitchen Layout u2014 DIY Dad

▸ English

Adding a Bench or Storage Seat to a Small Genkan

▸ Cost & Finance

How I Estimate the Payback Period on Attic Insulation Upgrades

▸ English

Ledger Board Attachment: Connecting Your Deck to the House Safely