Landlords with 3+ properties: How do you track inventory and maintenance?

Question

Tax season just reminded me how disorganized I am. Spent days digging through receipts and spreadsheets trying to compile expense reports for my accountant.

How do you all track:

• Appliances and items in each unit (fridge serial numbers, HVAC install dates, etc.)

• Maintenance records and costs (what was fixed when, how much)

• Which contractor did what work

• Purchase dates/receipts for depreciation schedules

Currently using Excel but it's a mess across 5 properties. Lost track of when the water heater was replaced in one unit and ended up paying for the same repair twice.

What's working for you? Any tools you swear by or avoid?

Specifically interested in:

1. How you organize it (app, spreadsheet, paper, memory?)

2. How long it takes you to pull reports for tax time

3. Whether you've found anything that actually saves time vs creates more work

Appreciate any advice!

Lucas Kurtz · Answer

You’re definitely not alone. Tax season is usually when people realize their “system” isn’t really a system 😅. Paying twice for the same repair because the history isn’t clear is more common than you’d think.

I’ll share what I’ve seen actually work for self-managing owners without getting buried in expensive software. For context, I’m Lucas with Howzer Property Management in MA.

Appliances & unit items If you’re using Excel, the biggest improvement is having one master sheet per property, not a bunch of random tabs.

Each unit gets basic info:

• Appliance type
• Brand / model / serial
• Install date
• Warranty info
• Last service date

Appliance type

Brand / model / serial

Install date

Warranty info

Last service date

Most people track invoices, not assets. Once repairs are tied to the actual appliance, repeat issues jump out fast. That alone avoids the “wait… didn’t we already replace this?” moment.

Maintenance history Instead of a generic maintenance spreadsheet, think of it as a running log.

Per entry:

• Date
• Unit
• What broke
• What was done
• Cost
• Who fixed it
• Link to the invoice

Date

Unit

What broke

What was done

Cost

Who fixed it

Link to the invoice

Linking receipts in Google Drive instead of storing them locally makes tax time way easier. One click and everything’s there.

Contractors This doesn’t need to be fancy. Just keep a simple list:

• Vendor name
• Trade
• Which properties they’ve worked on
• Notes (pricing, reliability, issues)

Vendor name

Trade

Which properties they’ve worked on

Notes (pricing, reliability, issues)

It saves a ton of time when you’re trying to remember who actually did decent work last time.

Receipts & depreciation Big mistake I see all the time is mixing repairs and capital items.

What works well:

• One Drive folder per property
• Subfolders for CapEx, Repairs, Utilities, Taxes
• Clear file names (date + item + unit)

One Drive folder per property

Subfolders for CapEx, Repairs, Utilities, Taxes

Clear file names (date + item + unit)

Your accountant will thank you.

To answer your questions directly:

• How do you organize it? Google Sheets + Google Drive with consistent naming. Paper and memory always fall apart eventually.
• How long does tax prep take? With a clean system, maybe 30–60 minutes per property. Without one… days.
• Does anything actually save time? Yes, but only if you stick to it. Light systems work if you maintain them. Bigger platforms save time by forcing structure. Where people get burned is being half-in on software and half-in on spreadsheets.

How do you organize it? Google Sheets + Google Drive with consistent naming. Paper and memory always fall apart eventually.

How long does tax prep take? With a clean system, maybe 30–60 minutes per property. Without one… days.

Does anything actually save time? Yes, but only if you stick to it. Light systems work if you maintain them. Bigger platforms save time by forcing structure. Where people get burned is being half-in on software and half-in on spreadsheets.

One honest observation from the PM side: most owners don’t bring on management because of rent collection. It’s the admin, documentation, and “where did that money go?” stress that usually pushes them there.

Drew Sygit · Answer

1) Appliance Tracking: pics of unit and serial number

2) MNT: Building Folder with all scanned receipts, using specific naming convention

3) Contractor: put in parenthesis in file naming convention

4) Date: include in file naming convention

EXAMPLE NAMING CONVENTION: yyyy-mm-dd main_123 (vendor) abbreviated description $xx*Be careful: you only have 256 characters for file namd AND path!

If you enter these consistently on a properly designed spreadsheet (one tab for each property), you should be able to just send this to your tax professional.

Ryan D. · Answer

I was in your exact spot. Self-managing a larger portfolio and tracking appliances, maintenance history, contractor info, and receipts across separate spreadsheets that were always out of date. The "paid for the same repair twice" thing hit home — I've done that.

What finally fixed it for me was putting everything under one roof. Every appliance, install date, warranty, service history, which contractor did the work, what it cost, all tied to the property and unit. When something breaks I can see the full history in seconds instead of digging through files.

Tax time went from days of scrambling to basically just pulling a report.

I couldn't find anything that did this the way I needed so I built my own system. Happy to share if you want to DM me.

Richard F. · Answer

You might look at Microsoft Access, their database program. They have a variety of templates available, including a "Project Management" model that looks to have some potential. Unfortunately far too many folks try to create Excel (or generic spreadsheets) to store, manipulate, and generate forms for word data, which, at least in the context of PM, is very much different from number data. Access has some pretty easy tools to create forms, queries, reports and other objects, and a "switchboard manager" to greatly simplify setting up a main control panel. With a little experimentation, and focus, you can create exactly what suits you, without ever actually writing any code.

Years ago I developed a great app for managing the maintenance for over 500 units, which I used for quite a few years. When I changed companies, the newer ones would not support the idea, insisting we kept doing things the old way...paper, duplicitous Excel lists, and missing info.

Just as a note, I have not kept up with newer PM apps, but for instance Yardi and competitors are all based on accounting practices, with double entry systems, forensic researching capabilities, and other elements to make the money trail rock solid. Which is a good thing. But there is a different need for tracking the physical aspects as well as the people (Owners, Tenants, Contractors, Employees, and others) and much of what they do. It needs to be more flexible in terms of type and amount of info that can be added and easily retrieved.

Heath M. · Answer

I’ve got formulas in excel and then I’ll compare that to my online portal download. Usually takes me an hour a month for 8 properties. My spreadsheet entries align with the tax form and it splits everything up between our 8 properties. Save receipts by year-month-day and then the name of the place. So today would be 2026-02-04 Lowe’s.

On the spreadsheet the row would be:

Price, classification (repair, etc), vendor, description, property

Then the formulas at the bottom will look at the property column and categorize the expenses appropriately. About every 2-3 months I’ll compare to my online portal (maybe twice a year I’ll flub a number and have to find my error.

I figure at 10 properties I’ll upgrade to something more robust.

Fulton Abraham Sanchez · Answer

@Taher Abouzeid, hi. Five properties is exactly when the 'Excel Tax' starts to cost more than a pro. You're not just losing time; you're likely missing Partial Asset Dispositions, like writing off the remaining 'book value' of that old water heater when you replaced it.

Most of my clients at your scale move to a 'Class-based' system in QuickBooks or specialized REI software. It turns tax season into a 10-minute report pull rather than a 10-day scavenger hunt. I actually specialize in setting up 'Done-for-You' bookkeeping specifically for portfolios like yours so you can focus on deal-finding instead of serial numbers. Happy to connect.

Joseph Guzzardi Jr · Answer

My suggestion is you use one of the many web based property management systems that you can research online. There's plenty to choose from based upon your needs and budget. Use something that has some form of reminders at the very least. Excel can't do that...

Taher Abouzeid · Answer

Lucas - really appreciate you taking the time to break this down! Your system makes way more sense than my current mess.

Quick question on the appliance tracking - when you said tying repairs to specific appliances helps catch repeat issues, do you find that saves actual money? Or is it more about peace

of mind knowing what's been done?

I'm trying to decide if it's worth the effort to set up your Google Sheets system properly or if I should just bite the bullet and hire a PM. My accountant keeps telling me I need

better records but I never seem to have time to organize everything.

What made the owners you work with finally decide to either get organized OR hire you guys? Was it a specific breaking point (like tax season nightmare) or just gradual burnout?

Asking because I'm at 5 properties now and constantly debating whether to keep DIY-ing this or find an app or someone to take it off my plate.

Lucas Kurtz · Answer

Hey really glad that was helpful.

On the appliance tracking side: honestly, it’s both money and peace of mind. Tying repairs to specific appliances lets you spot patterns fast like a fridge that’s been serviced three times in 18 months or a washer that’s becoming a money pit. That usually leads to earlier replacement instead of death-by-a-thousand service calls. Over time, that absolutely saves money. But just as important, it gives you clarity when you’re making decisions instead of guessing.

As for whether it’s worth setting up your own system vs hiring a PM that’s usually where people hit a crossroads.

Most owners we work with don’t wake up one day and randomly decide to hire management. It’s almost always one of three things:

• Tax season becomes a nightmare • Tenant issues start eating into nights/weekends • Or they realize they’re spending real time managing instead of growing

A lot of folks try the “I’ll just get more organized” phase first, apps, spreadsheets, better folders totally normal. Sometimes that works. But once portfolios hit your size, the bigger issue usually isn’t tools it’s bandwidth.

The breaking point tends to be when owners realize their time is worth more than the DIY savings, especially once you factor in coordination, follow ups, compliance, and being the 24/7 point person.

At 5 properties, you’re right in that gray zone where either path can work it really comes down to whether you want to keep building systems… or start buying back your time.

Happy to talk it through anytime if helpful even just from a strategy standpoint.

Lucas- Howzer Property Management

Landlords with 3+ properties: How do you track inventory and maintenance?

Landlords with 3+ properties: How do you track inventory and maintenance?

Most Popular Reply

10 Replies