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
Rental Property Investor · Seattle, WA · Member since 2013 · 2k+ posts · 1k+ votes
6mo
You are getting good input.
Either direction you go, consistency pays off. When you get a paper receipt put it in the folder for that year. If you get an electronci reciept put it in the folder for that year.
If you use Excel code each transaction with the proprty, the tax category, the reporting catgeory if different from the tax cateogory and a yes/no for receipt. In seperate tabs you can list the major purchases and details that you want to remember.
It doesn't need to be complicated or time consuming, it needs to be consistent.
Hello, I used to track it in excel, but I have been using an App since last year which has made it a lot easier. It doesn't have a place to store Fridge serial numbers, or HVAC install dates, but I guess you could put it in the notes of the activity you are recording. You could attach the picture of the seriral number to the activity.
Exporting the data is easy, but the data is as good as you enter it. The more detail you have the better you will be at tax time.
Investor · Buffalo, NY · Member since 2026 · 42 posts · 19 votes
7mo
I'm in the same boat regarding the asset management. One place to store all information regarding an asset (i.e. fridge, hvac) would be awesome. This would actually be a pretty simple thing to implement in my app Doortrackr, which I use for organized expense tracking. Doortrackr in it's current state would take care of some of what you're looking for regarding purchase dates and receipts for an asset like an hvac, you would just assign it to a job and name it something like HVAC Replacement. But the other stuff you mentioned, warranty information, maintenance logs, etc. would be great to have. I waste a ton of time hunting down warranty information and serial numbers. Would you be interested in chatting further about this so I could build it into the app?
Investor · Charleston, SC · Member since 2018 · 198 posts · 84 votes
7mo
@Taher Abouzeid you are hitting the exact wall that most landlords hit somewhere between property 3 and property 7. Excel works great for a while and then one day you realize you have no idea when the HVAC was installed at your second property or whether that water heater replacement was 2 years ago or 4.
I have 10 doors in Birmingham, all with third party property managers, so I will answer your specific questions from that perspective.
For appliance and system tracking, the key categories I track per property are: HVAC (install date, model, warranty expiration), water heater (same), roof (last replacement or major repair, estimated remaining life), electrical panel, plumbing (any major work like repiping or sewer line replacement), and major appliances if furnished. For each item I store the install or purchase date, cost, contractor who did the work, and warranty expiration. This matters because it directly feeds your depreciation schedule and tells you when you should be budgeting for replacements.
For maintenance records, I categorize everything by property and by whether it is a repair (deductible immediately on Schedule E Line 14) or a capital improvement (depreciated over time). This distinction is critical for taxes. A $200 garbage disposal replacement is a repair. A $6,000 HVAC replacement is a capital improvement you depreciate. Getting this wrong is one of the most common audit triggers for rental property owners.
On contractor tracking, I keep a list per market of who did what work, what they charged, and whether I would use them again. When your PM sends you an invoice, you want to know if the plumber they called is charging market rate or if you are getting marked up.
The purchase dates and receipts for depreciation is where most landlords lose money they don't even realize. Every capital improvement starts its own depreciation clock. If you replaced a roof in 2024 for $8,000, that is a separate 27.5 year depreciation line from the building itself. If you are not tracking each improvement separately, your CPA is either missing deductions or guessing, and neither is great.
Your story about paying for the same repair twice is painfully common. That happens when maintenance records live in email threads, PM portals, and random spreadsheet tabs instead of one place organized by property. At 5 properties you probably have over 50 different documents floating around (PM statements, inspection reports, insurance certs, invoices, leases) and finding anything specific means digging through email or hoping you saved it to the right folder.
What I found is that the problem isn't really about finding the perfect app. It is about having a system where every document and every transaction is tied to the right property and categorized correctly from day one. Once you have that, pulling reports for your CPA takes minutes instead of days.
Rental Property Investor · Seattle, WA · Member since 2013 · 2k+ posts · 1k+ votes
6mo
You are getting good input.
Either direction you go, consistency pays off. When you get a paper receipt put it in the folder for that year. If you get an electronci reciept put it in the folder for that year.
If you use Excel code each transaction with the proprty, the tax category, the reporting catgeory if different from the tax cateogory and a yes/no for receipt. In seperate tabs you can list the major purchases and details that you want to remember.
It doesn't need to be complicated or time consuming, it needs to be consistent.