Rebuild the rent roll from documents
A rent roll should identify each rentable unit or space, tenant, area, use, lease type, start, expiry, renewal, base rent, common charges, parking, deposit, guarantee, arrears, concession, and occupancy. Its totals should reconcile to executed leases, amendments, payment ledger, bank or manager records, and deposits. A spreadsheet prepared for sale is not enough.
Create one row per legal lease and separate residential, retail, office, parking, storage, antenna, vending, and other income. Use the same area definition for unit comparisons and flag unregistered or unapproved space.
Verify contractual rent
Read complete leases and amendments. Distinguish ordinary and fixed-term agreements, renewal provisions, rent review, termination, free rent, side letters, master leases, corporate housing, subletting, restoration, and tax treatment. A roll showing an end date does not prove vacancy or the landlord's ability to reset rent then.
Identify which charges are recoveries and which are owner income. Common charges can be fixed contractual amounts while actual utilities or services cost more. Parking and storage can have separate users, termination, and deposits.
Record any verbal or temporary concession confirmed by payment history. If the tenant pays less than the signed contract, the lower collected amount is the underwriting starting point until the difference is explained and recoverable.
Reconcile collections
Compare at least twelve months of monthly billed, received, arrears, guarantee receipts, and write-offs by unit. Trace the roll total to bank deposits and property-manager statements. Explain timing differences rather than forcing them into one month.
Calculate physical occupancy, economic occupancy, collection rate, and effective rent separately. A unit can be physically occupied but economically delinquent. A guarantee payment can maintain collections while signalling tenant stress or future contract risk.
Separate one-time key money, renewal, cancellation, deposit deductions, insurance claim, and repair reimbursement from recurring rent. Do not annualise them.
Reconcile deposits and guarantees
Maintain a tenant-deposit liability schedule showing original receipt, transfers, permitted deductions, refunds, and current balance. Compare it with leases, receipts, general ledger, bank handling, and sale settlement. Deposits are not extra purchase yield.
For a guarantee company, record provider, covered obligations, term, renewal, claims, exclusions, cancellation, tenant fee, owner duties, and transfer on sale. A “guaranteed” column does not establish that every missed payment will be paid or that the contract continues after ownership change.
For a master lease, identify the master tenant, sublease income information available, rent revision, vacancy allocation, repairs, termination, and counterparty strength. Underwrite the contracted master rent and its revision risk, not the sum of end-tenant asking rents.
Measure concentration and lease events
Calculate rent concentration by tenant, unit type, use, floor, and expiry period. One shop can provide a large share of income while creating a large release cost. Several leases expiring in the same quarter can create correlated vacancy.
Build a 24-month lease-event schedule: expiries, renewals, fixed-term notices, break options, rent reviews, guarantee renewals, deposits, planned tenant works, and known departures. Overlay building projects that could disrupt access or use.
For small units, tenant turnover may be frequent but distributed. For a single-family rental, one vacancy removes all rent. Use the actual concentration in the downside case.
Compare current rent with achieved evidence
Portal asking rents show competition, not completed leases. Ask managers and brokers for recent achieved evidence with property, area, age, floor, station access, equipment, condition, fees, and incentive information. Adjust for concessions and tenant-paid initial costs.
Calculate rent per square metre using consistent internal area and charge treatment. Do not compare a furnished gross rent including utilities with an unfurnished base rent.
Classify each lease as below, near, or above supported market with a range and evidence date. Below-market rent is not immediate upside if the lease continues; above-market rent is not durable income merely because the tenant currently pays.
Connect rent to expenses and capital
Rebuild net operating income with management, cleaning, utilities, taxes, insurance, repairs, leasing, guarantee, legal, common-area, lift, waste, internet, security, and capital reserves. Reconcile owner-paid and tenant-recovered items.
Identify vacant-unit work, old equipment, restoration exposure, and building projects. A full rent roll can still produce weak cash flow if the expense and capital side is omitted.
Worked roll test
Suppose a ten-unit building shows JPY 12 million scheduled annual rent. One unit is vacant, one tenant is two months late, and JPY 600,000 of the total is non-recurring renewal income. Effective recurring billed rent is therefore lower before collection and vacancy assumptions. If one large unit provides 22% of base rent and expires in six months, the downside is concentrated.
The buyer should reconstruct unit-level cash, then run lease events, market rent, turnover cost, and capital work. The example does not establish an expense ratio or vacancy norm.
Make the seller explain every exception
Create an exceptions sheet rather than burying anomalies in notes. Flag undocumented occupants, cash rent, side agreements, expired terms, zero deposits, deposit balances that do not reconcile, arrears described as temporary, related-party tenants, unusual free-rent periods, owner-paid utilities and leases signed immediately before sale. Assign each item an amount, evidence request, owner and closing treatment.
The goal is not a perfect spreadsheet. It is a chain from signed lease to bank receipt to deposit liability to sustainable net income. Where the chain breaks, use a conservative assumption or make the correction a condition of closing. A rent roll is credible because it reconciles, not because it arrives on company letterhead.
Primary sources
- MLIT — Rental housing management portal: https://www.mlit.go.jp/tochi_fudousan_kensetsugyo/pm_portal/
- MLIT — Rental housing guide for foreign tenants and landlords: https://www.mlit.go.jp/jutakukentiku/house/jutakukentiku_house_tk3_000017.html
- National Tax Agency — Real-estate rental income: https://www.nta.go.jp/taxes/shiraberu/taxanswer/shotoku/1370.htm
- MLIT Real Estate Information Library: https://www.reinfolib.mlit.go.jp/realEstatePrices/
Reviewed against the linked sources on 23 August 2026. Actual leases, receipts, deposits, and property records control.
Looking for a shorter starting point? Browse direct answers to common Japan property questions.
Apply this to a real property
Send us the asset or the brief.
We can review whether the property, structure, financing path, and exit logic hold together.
