Tracking Depreciation Schedules Across Multiple Properties

The first year I owned two rental properties, tracking depreciation was easy enough to do in my head. By the time I hit 9 properties, it wasn’t. Each building has its own purchase date, its own depreciable basis, and its own useful-life schedule under Japan’s fixed-rate method, and I once discovered I had been running one property’s kitchen renovation through the wrong depreciation class for three years straight. That mistake cost me about 140,000 yen in corrected filings and a very awkward phone call with my accountant.

These days I have a system that keeps all 9 schedules straight without needing an accounting degree, and I want to walk through exactly how it works, because I built it the hard way through trial and error over about 15 years.

Why depreciation gets tangled once you scale past two or three units

A single rental property has one building, one roof, maybe one set of appliances. Once you own several properties bought in different years, at different prices, in different structural classes (wood-frame buildings depreciate over 22 years, steel-reinforced concrete closer to 47), the schedules stop lining up. Add renovations that each start their own depreciation clock, and a spreadsheet that made sense at property number 3 turns into a mess by property number 7. I’ve found that the root problem is almost never math error u2014 it’s that people track everything by property instead of by asset. A single building might have four or five separate depreciation lines running at once: the structure itself, a water heater replaced in year 6, a kitchen remodel from year 9, and exterior siding work from last year.

Building one master ledger instead of nine separate ones

I keep a single spreadsheet with one row per depreciable asset, not one tab per property. Each row lists the property name, the asset description, acquisition date, acquisition cost, useful life in years, annual depreciation amount, and accumulated depreciation to date. This one change u2014 moving from nine scattered files to a single ledger u2014 probably saved me 10 hours a year in tax-season prep alone. When my accountant asks for a specific property’s current book value, I filter the sheet instead of hunting through folders.

The columns I consider essential are:

• Property ID and asset name (be specific u2014 ‘Property 4 exterior paint 2022’ not just ‘paint’)
• Acquisition date and original cost, including installation labor if I did the work myself and paid for materials only
• Useful life category and the applicable depreciation rate
• Annual depreciation expense and running accumulated total
• Remaining book value, updated every fiscal year end

Separating structure, equipment, and capital improvements

One habit that cleaned up my records more than anything else: I stopped lumping renovation costs into the building’s original basis. If I replace a water heater for 180,000 yen, that’s a new asset with roughly a 6-year useful life, tracked separately from the building’s 47-year schedule. If I redo a bathroom for 850,000 yen, that’s its own 15-year fixtures line. Mixing these into one number made my early spreadsheets look tidy but made them functionally useless whenever I needed to sell a property and calculate remaining basis. Since I started separating every improvement over roughly 200,000 yen into its own line, my year-end numbers have matched my accountant’s calculations on the first pass for the last four years running.

Keeping renovation records that actually support the schedule

A depreciation schedule is only as good as the paperwork behind it. For every renovation I now keep three things in the same folder: the itemized invoice, a dated photo of the finished work, and a one-line note in my master ledger pointing to that folder. I learned this after an old renovation invoice was rejected during a routine tax review because it only showed a lump sum with no material breakdown. Now every invoice I request from a contractor has to itemize labor and materials separately, or I ask for a revision before I pay the final installment. I also scan every receipt into a shared folder the same week the work finishes, because I used to tell myself I would file paperwork later, and later almost always meant six months later, digging through a shoebox trying to remember what a 45,000 yen hardware store run was actually for.

My year-end reconciliation routine

Every December I block out one full Saturday, about 6 hours, to run through all 9 properties against the master ledger. I check that every completed renovation from the year has a corresponding new asset line, confirm accumulated depreciation totals against the prior year’s closing figures, and flag anything that looks off before it ever reaches my accountant. This single day of review has caught errors worth over 300,000 yen in potential misfiling across the past three tax years combined, simply because I caught mismatches before they became official numbers.

Working with an accountant without losing control of your own numbers

I still use a tax accountant for the actual filing, but I never hand over raw receipts and hope for the best. I send my accountant the master ledger with everything already categorized, and that alone cuts my accounting fees by roughly 30% compared to a full bookkeeping engagement, because he’s reviewing my classifications instead of building them from scratch. It also means I understand my own numbers well enough to catch a mistake if one slips through, which happened twice in 15 years u2014 both times because a renovation invoice was miscategorized as a repair expense instead of a capital improvement.

That’s the system I run across all 9 of my properties, and it’s the difference between dreading tax season and treating it as a two-hour formality.

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

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

▸ English

Stair Tread Replacement: Removing Old and Installing New

▸ English

Protecting Wood Siding from Moisture

▸ English

Kitchen Vol.23: Built-in Dishwasher Install Vol.1 u2014 DIY Dad’s Renovation

▸ English

Wood Deck DIY Part 6: Choosing Floor Materials u2014 DIY Dad

▸ English

Toilet Renovation Vol.13: Wainscot Panel Making Pt.4

▸ English

How to Spot an Overpriced Listing in a Hot Market