The first year I owned rental property, I lost track of about 140,000 yen in repair receipts because I stuffed them in a kitchen drawer and forgot which unit they belonged to. Come tax season, I couldn’t claim half of what I’d actually spent. That mistake taught me more about bookkeeping than any accounting class could have, and it’s why I built a system that now takes me about 20 minutes a week to maintain across all 9 of my properties.
You don’t need expensive software or an accounting degree to track rental income properly. You need a structure that’s simple enough to actually stick with, because the fanciest spreadsheet in the world is worthless if you abandon it after three months.
Start With One Spreadsheet Per Property, Not One Big Mess
ud83duded2 RECOMMENDED ON AMAZON US
Personal Finance & Real Estate Books
The financial mindset shift that made property investment possible on a salary.
My biggest early mistake was trying to track everything in a single tab. With 9 properties now, that would be chaos, but even with 1 or 2 units it causes problems. I use a separate sheet for each property inside one workbook, plus a summary tab that pulls totals automatically. Each property sheet has the same 6 columns: date, description, category, income, expense, and running balance. Consistency across sheets matters more than how fancy any single one looks, because it’s what lets the summary tab work without manual re-entry.
Set Up Categories Before You Need Them
ud83duded2 RECOMMENDED ON AMAZON US
Budget Planners for Property Owners
Track every yen in and out u2014 the foundation of profitable landlord accounting.
I use 8 expense categories and stick to them rigidly: mortgage/loan payment, property tax, insurance, repairs and maintenance, utilities (for vacant units), management fees, supplies, and miscellaneous. When categories are vague, you end up with 40% of your expenses dumped into “other,” which makes year-end tax prep painful. Repairs alone should probably be its own category since it’s usually the largest and most audit-relevant line item u2014 I typically log 15 to 25 repair entries per property per year.
- Rent received (income)
- Mortgage or loan payment
- Property tax and insurance
- Repairs and maintenance
- Utilities during vacancy
- Property management or agent fees
- Supplies (paint, fixtures, tools)
- Miscellaneous (capped at under 5% of total expenses if possible)
Photograph Every Receipt the Same Day
This is the single habit that fixed my drawer-full-of-receipts problem. Every time I buy something for a property u2014 even a 380 yen bag of screws u2014 I photograph the receipt with my phone before I leave the store parking lot, and I name the file with the date and property number, like “0714_unit3_screws.jpg.” Then I log the entry in the spreadsheet the same evening. Waiting even a week creates a backlog that’s genuinely painful to catch up on. I keep a dedicated folder per property per fiscal year, and I’ve never lost a receipt since switching to this method.
Track Income Separately From Deposits Received
ud83duded2 RECOMMENDED PRODUCTS
Tax Guides for Property Investors
Knowing the tax rules turns a good investment into a great one.
Rent income and security deposits are not the same thing on your books, and mixing them up is a common beginner error. A security deposit isn’t income when you receive it u2014 it’s a liability you may need to return. I keep deposits on a separate small ledger with the tenant name, amount (usually 1 month’s rent, so around 65,000 to 90,000 yen depending on the unit), and move-in date. This has saved me from accidentally overstating my income by roughly 600,000 yen across my properties in a single year, which would have meant paying tax on money that technically wasn’t mine yet.
Reconcile Monthly, Not Just at Tax Time
Once a month, usually the first Sunday, I compare my spreadsheet entries against my bank statement for each property’s dedicated account. This takes about 45 minutes for all 9 units combined. I use one bank account per property specifically so this reconciliation is clean u2014 mixing personal and rental finances in one account is the fastest way to create an audit nightmare. If a number doesn’t match, I catch it within 30 days instead of discovering a mystery gap 11 months later when it’s much harder to remember what happened.
Build a Year-End Summary Before You Need It
By early December each year, I already have a rough profit-and-loss summary for every property, because my monthly habit means the data is already there u2014 I’m just totaling it. This summary shows gross rent collected, total expenses by category, and net income per property. Having this ready 4 to 6 weeks before tax deadlines means I can spot a property that’s underperforming and plan a rent adjustment or repair budget for the following year, instead of just reacting to whatever number my accountant hands me in March.
That’s the bookkeeping approach I use across all 9 of my properties, and it’s turned tax season from a dreaded scramble into a two-hour formality.
Renovation Cost Reduction Checklist (60% Savings Method)
My step-by-step process management template that cut renovation costs by 60% across 3 apartment buildings over 15 years.
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
