When I was shopping for my sixth rental property about nine years ago, the seller’s agent handed me a rental income history report showing 94% occupancy over three years and a rent roll that looked almost too good. It wasn’t until I sat down with the numbers for close to two hours that I found the gap – three months of empty units that had simply been left off the summary page.
A rental income history report is one of the most useful documents you get during due diligence, but it’s also one of the easiest to misread, whether by accident or on purpose. After reviewing well over 40 of these reports across my own 9 properties and a lot of deals I walked away from, here’s how I actually read one before I sign anything.
What the Report Should Actually Contain
ud83duded2 RECOMMENDED ON AMAZON US
Real Estate Investment Books
The books that changed how I think about money, leverage, and long-term wealth.
A real rental income history report covers month-by-month rent collected, unit by unit, for at least 24 to 36 months. Anything shorter than 12 months isn’t really a history, it’s a snapshot, and a single good year can hide two bad ones sitting right behind it. Look for four columns at minimum: scheduled rent, actual rent collected, vacancy days, and any concessions or discounts given to tenants. If a report only shows one lump annual total, ask for the underlying spreadsheet – I’ve had sellers claim the detailed version was lost, and I’ve walked away from three separate deals for exactly that reason.
The Occupancy Rate Trick
ud83duded2 RECOMMENDED ON AMAZON US
Financial Calculators for Investors
Run yield and cash-flow calculations in seconds u2014 worth every yen on your first deal.
Occupancy rate is the number most often massaged. A report can say 95% occupied while the building is still losing money, because occupancy counts a unit as filled even if the tenant is three months behind on rent. What matters more is the collection rate – actual yen collected divided by scheduled rent for the same period. On my own properties I treat anything below 92% collection rate as a red flag worth investigating, and I’ve seen a seller’s report advertise 96% occupancy sitting next to an 81% collection rate once I pulled the underlying bank deposit records.
Comparing Rent Per Unit to the Local Market
Pull the rent for each individual unit and compare it against three to five comparable listings within roughly 500 meters. I once found a six-unit building where four units were renting for 58,000 yen a month while the same layout two doors down was going for 72,000 yen. That gap wasn’t a sign of a bad location, it was a sign the previous owner hadn’t raised rent in 11 years. A gap like that can be upside for a buyer willing to renovate, but it also means the trailing income figure printed on the report understates what a diligent owner can realistically charge going forward.
Reading the Gaps Between Tenants
ud83duded2 RECOMMENDED PRODUCTS
Investment Analysis Templates
Spreadsheet analysis is the difference between a good deal and a disaster.
The turnover gap – the number of days a unit sits empty between one tenant moving out and the next moving in – tells you more than the headline occupancy number ever will. On the buildings I own, a well-run property turns a unit in 18 to 25 days including cleaning and minor repairs. When I see gaps of 60 days or more repeated across a report, it usually means either the unit needed real renovation work the previous owner couldn’t afford, or the rent was priced too high for the area and sat unrented while the owner refused to lower it.
What the Net Income Figure Hides
A rental income history report will often show a tidy net operating figure at the bottom, but that number depends entirely on what expenses were subtracted above it. I’ve seen reports where a full roof repair costing around 1.2 million yen was excluded because the seller classified it as a capital improvement rather than an operating expense. Always ask for the itemized expense list behind the net number, not just the total, and compare it across at least two full years – a single year with almost no maintenance spending is usually a warning that repairs are overdue, not proof that the building is cheap to run.
Cross-Checking the Report Against Utility Records
When the numbers still feel off, I ask for utility account history or the building management company’s own collection ledger. When I bought my fourth property, the seller’s report listed 11 occupied units, but the water utility account only showed active usage on 9 meters for the final 4 months before the sale closed. That mismatch let me renegotiate the price down by about 1.8 million yen. If a seller won’t provide utility records or a management company statement to back up their report, treat that refusal as information in itself.
A Quick Checklist Before You Trust the Numbers
Before I make an offer on any property now, I run through the same short list every single time:
- Confirm at least 24 months of month-by-month data, not an annual summary
- Calculate the actual collection rate, not just the stated occupancy rate
- Compare rent per unit against 3-5 nearby comparable listings
- Flag any tenant turnover gap over 45 days and ask the seller why
- Request the itemized expense list behind the net income figure
- Ask whether any capital repairs were quietly excluded from the reported numbers
- Cross-check occupied unit counts against utility or management company records
That two-hour spreadsheet session on my sixth property probably saved me close to 3 million yen in overpaid purchase price, and it’s the same process I still use to check the numbers on every one of my 9 properties today.
Property Cash Flow Calculator + Complete Guide
The exact Excel spreadsheet I use for every property purchase decision u2014 5-year projection, yield calculation, and break-even analysis included.
ud83cudfe0 More from DIY Father
15 years of landlord experience u00b7 3 apartment buildings u00b7 DIY renovations that saved millions of yen. Browse all articles at diytosan.com
