The first time I sat down with a rent roll for a 12-unit building, I almost signed off on a purchase that was quietly bleeding 340,000 yen a year in phantom income. The sheet looked clean u2014 every unit occupied, every rent amount filled in neatly. It took me about 40 minutes with a highlighter and a calculator to realize three of those tenants were paying rents that had been frozen since 2016, well below what the building could actually earn today.
Over 15 years and 9 properties, the rent roll has become the single document I trust the least at face value and study the hardest before I make an offer. It is not lying to you, exactly, but it is only telling you what the seller wants you to notice first. Here is how I actually read one.
What a Rent Roll Actually Tells You
ud83duded2 RECOMMENDED ON AMAZON US
Real Estate Investment Books
The books that changed how I think about money, leverage, and long-term wealth.
A rent roll is just a snapshot: unit number, tenant name (sometimes redacted), monthly rent, lease start date, and deposit held. That is it. It does not tell you why a tenant is paying 18% below market, whether a unit has been vacant for 5 months disguised as month-to-month, or whether the owner just dropped rent to fill a unit fast before listing the building for sale. I treat every number on the page as a claim to verify, not a fact to accept.
The Gap Between Advertised Rent and Actual Rent
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.
The first thing I calculate is the spread between what each unit is renting for and what a comparable unit nearby is currently listed at. On one 8-unit building I looked at last year, the rent roll showed an average of 78,000 yen per unit, but similar 1LDK units two blocks away were listing at 92,000 yen. That 18% gap is either upside (rents can be raised at turnover) or a red flag (something about the building or the neighborhood is keeping rents suppressed). You only find out which by walking the block yourself and checking listing sites, not by trusting the seller’s summary sheet.
Lease Start Dates and Turnover Risk
I always sort the rent roll by lease start date, not by unit number. This single reordering has saved me from bad purchases twice. If 6 of 10 tenants all started their lease within the same 3-month window, that usually means the building had a mass vacancy event u2014 maybe a fire, a bad manager, or a rent-control dispute that pushed everyone out at once. On the flip side, tenants who have been in place for 8 to 10 years at below-market rent are a different kind of risk: stable cash flow now, but a big rent jump (and possible turnover) waiting whenever they eventually leave.
Security Deposits, Key Money, and Hidden Liabilities
ud83duded2 RECOMMENDED PRODUCTS
Investment Analysis Templates
Spreadsheet analysis is the difference between a good deal and a disaster.
In Japan, the rent roll should also list shikikin (security deposit) and any reikin (key money) collected. When you buy the building, you typically inherit the obligation to return those deposits at move-out u2014 so a rent roll showing 1.2 million yen in total deposits held is really a 1.2 million yen liability transferring to you, not free cash. I have seen buyers get surprised at closing because this line item was buried in small font at the bottom of the sheet. Always ask the agent to confirm this figure matches what shows up in the actual bank account, not just what is printed on the document.
A Pre-Offer Checklist I Run on Every Rent Roll
Before I put in an offer on any multi-unit property, I go through the same short list. It takes about 2 hours per building but has kept me out of at least 3 deals that looked good on paper and were not.
- Confirm current occupancy by calling or visiting, not just trusting the seller’s stated rate
- Compare each unit’s rent against 3 comparable listings within a 500-meter radius
- Sort by lease start date and flag any cluster of leases starting within the same 90-day window
- Verify total deposits held against actual bank records, not just the printed rent roll figure
- Ask for 12 months of bank deposit history to cross-check against the claimed rent amounts
- Check for any units marked month-to-month, since these often signal a tenant already planning to leave
Cross-Checking the Rent Roll Against Bank Statements
This is the step most first-time buyers skip, and it is the one that matters most. A rent roll is a document the seller typed up; a bank statement is proof money actually moved. I ask for at least 12 months of deposit history and match every incoming transfer against the rent roll line by line. On one deal, this caught a unit listed at 85,000 yen per month that had only received 9 payments in the prior 12 months u2014 a vacancy problem the rent roll had smoothed over completely. If a seller resists sharing bank statements, I take that as a signal in itself and slow the deal down rather than speed it up. I also compare the deposit dates against the rent roll’s due dates u2014 a tenant who consistently pays 10 to 15 days late every single month is not a red flag on its own, but it is worth factoring into your vacancy and collection-loss assumptions when you run the numbers on cap rate.
None of this requires special software or a broker’s help u2014 just patience, a spreadsheet, and a willingness to double-check every number before you wire a deposit. That is the same approach I use across all 9 of my properties, and it is the reason I have never bought a building that turned out to earn less than what was on paper.
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
