How do you track maintenance and repairs for tax time?

Question

For small landlords — how are you tracking maintenance and repairs for tax time?

Spreadsheet, software, or something else?

James Mc Ree · Answer

I use linked Excel workbooks to manage 14 SFRs. Each property has a workbook with all of the property details. I have aggregator workbooks to bring together data for specific purposes, such as my monthly ledger and taxes.

I scan each bill or receipt, or download them, for each property. They are stored in a folder for each property if I ever need to refer back to them.

I think this is a good, low cost solution. It does not scale to significantly larger portfolios in which staff members are managing this data. Data corruption always occurred when I tried this in my day job.

Mike Poe · Answer

Appreciate all the replies here — super helpful.
I ran into the same “tax time scramble + receipt chaos” problem and ended up building a lightweight maintenance log for myself.
Lets you tie repairs to a property, attach receipts/photos, and export cleanly for your CPA.
Not property management software — just a simple repair log.

If anyone wants the link I’m happy to share it via DM.

Curtis Mears · Answer

Have a bank account that is only used for business. Then, you can find an app that will take the data and allow you to categorize the expenses. I use a free app called the wave. It's ok but I do have to manually download the bank data monthly. There are other apps that will link to the bank account.

Lucas Kurtz · Answer

Lucas here from Howzer Property Management.

Most small landlords I talk to start with spreadsheets + receipts… and once you’re past a couple units it usually turns into a scramble at tax time.

What I see work best (even for self-managing owners):

• Some type of software (Buildium, AppFolio, etc.) so expenses are auto-categorized
• Separate bank account for the portfolio
• Every invoice tied to the unit + type of repair
• Quick monthly P&L check instead of waiting until April

The real value isn’t just tracking it’s having clean numbers so your CPA can clearly see repairs vs capex, recurring maintenance, and actual cash flow per property.

If you’re DIY right now, even just consistent categories + uploading receipts monthly makes a huge difference.

Happy to share the expense categories we use if helpful.

Lucas

Priya Menon · Answer

I've been tracking everything in a Google Sheets master tracker across my 6 SFH for a few years now. The one thing that actually keeps tax time painless is categorizing every expense as repair vs improvement the same day I pay it. Three months later you will not remember if that $800 was a water heater replacement or just a repair. I tag each line with property address, date, vendor, amount, and repair/improvement. Takes maybe 20 minutes a month total and my CPA just gets a clean export.

Eduardo Cavasotti · Answer

@Sam Tato appreciate that, and you nailed it on the CPA point. That's exactly how I think about it too. Your job as the owner is to hand your CPA clean, categorized data so they can focus on strategy and tax optimization, not organizing receipts.

I learned this the hard way. My first year with 10 doors in Birmingham, I handed my CPA a stack of PM statements and bank records. He spent 6 billable hours just sorting and categorizing before he could even start on the actual returns. At $225/hr that was over $1,300 I basically threw away on data entry.

Now I categorize every transaction against the correct Schedule E line item as it happens throughout the year. When tax season comes, my CPA gets a clean export with everything already mapped. His review takes about 90 minutes per entity instead of a full day. That saved me roughly $2,000 last year across my two LLCs.

The biggest thing I tell other landlords: the repair vs. capital improvement distinction (Line 14 vs. depreciation) is where most CPAs catch the expensive mistakes. A $4,500 water heater replacement is a repair you deduct in full that year. A $12,000 new roof is a capital improvement you depreciate over 27.5 years. If you categorize that wrong, you either o@vSearmp aTya ttoa xaepsp roerc ifaltaeg tyhoautr,s ealnfd fyooru anna ialueddi ti.t Hoanv itnhge tChPaAt pcoaitnetg.o rTihzaetd' sc oerxraeccttllyy hboewf oIr et hyionukr aCbPoAu te vietn tsoeoe.s Yiotu rs ajvoebs aesv etrhyeo noew nteirm ei sa ntdo mhoannedy .your CPA clean, categorized data so they can focus on strategy and tax optimization, not organizing receipts.

I learned this the hard way. My first year with 10 doors in Birmingham, I handed my CPA a stack of PM statements and bank records. He spent 6 billable hours just sorting and categorizing before he could even start on the actual returns. At $225/hr that was over $1,300 I basically threw away on data entry.

Now I categorize every transaction against the correct Schedule E line item as it happens throughout the year. When tax season comes, my CPA gets a clean export with everything already mapped. His review takes about 90 minutes per entity instead of a full day. That saved me roughly $2,000 last year across my two LLCs.

The biggest thing I tell other landlords: the repair vs. capital improvement distinction (Line 14 vs. depreciation) is where most CPAs catch the expensive mistakes. A $4,500 water heater replacement is a repair you deduct in full that year. A $12,000 new roof is a capital improvement you depreciate over 27.5 years. If you categorize that wrong, you either overpay taxes or flag yourself for an audit. Having that categorized correctly before your CPA even sees it saves everyone time and money.

Sam Tato · Answer

@Eduardo Cavasotti super informed response.

I would say no matter what tool you use, it's important to have a CPA to to look things over. It's the job of the owner to organize the information well for the CPA, and let the CPA make the tax decisions. I don't think anyone wants to pay their CPA $200+ an hour to organize receipts.

Eduardo Cavasotti · Answer

@Mike Poe this is a great question and the answers in this thread show how differently people approach it. I will share what finally worked for me after trying most of the methods mentioned here.

I have 10 rental doors in Birmingham, all with third party property managers. For the first few years I tracked everything in spreadsheets and it worked okay until it didn't. The problem isn't tracking the expenses themselves. The problem is categorizing them correctly against Schedule E line items throughout the year so you're not doing it all at once in March.

Here is what tripped me up the most: Schedule E has very specific line items and getting them wrong is one of the top audit triggers. Line 7 (rents received) seems simple until your PM withholds a maintenance charge from your disbursement and you need to record the gross rent plus the expense separately. Lines 9, 10, 11 (insurance, legal, management fees) are straightforward. But Lines 12 through 14 (mortgage interest, repairs, supplies) and Lines 16 and 17 (taxes, utilities) require you to know exactly what category each expense falls into.

The biggest trap is Line 14 (repairs) versus capitalizing an improvement under depreciation. A new water heater is a repair. A new roof is a capital improvement you depreciate over 27.5 years. The IRS has gotten more aggressive about this distinction and it is one of the most common audit triggers for rental property owners.

Then there is the mortgage payment itself. One monthly payment actually splits into 4 or 5 Schedule E line items: principal (not deductible), interest (Line 12), property tax escrow (Line 16), insurance escrow (Line 9), and sometimes PMI. If you are not splitting that correctly every month, your Schedule E is wrong.

What changed everything for me was categorizing transactions against the correct Schedule E line item as they happen throughout the year instead of trying to sort through 12 months of PM statements in April. My PM sends monthly statements that lump everything together, so I cross reference those against actual bank deposits and break out each line item. It takes maybe 15 minutes a month now instead of the 8 to 10 hours I used to spend during tax season.

QuickBooks works but it is built for businesses, not rental portfolios. The chart of accounts doesn't map to Schedule E without heavy customization, and if you have multiple properties you end up with class tracking or location tracking that gets messy fast. The landlords I know who use QuickBooks successfully have a bookkeeper or CPA setting it up specifically for rentals, which adds cost.

Whatever system you use, the key is making sure every transaction maps to a Schedule E line item in real time. If you wait until tax season to categorize, you will either spend a painful weekend sorting through statements or you will guess, and guessing is how you either overpay taxes or trigger an audit.

Jason Malabute · Answer

I’d recommend moving this into QuickBooks instead of tracking it in a spreadsheet. Spreadsheets are fine early on, but as transactions grow, it’s really easy for formulas to break, rows to get overwritten, or things to be missed altogether. QuickBooks helps keep everything structured, reduces manual errors, and gives you cleaner reports that actually tie out. It also makes tax time and reviews way smoother since everything is already categorized and reconciled.

Markus Shobe · Answer

There are a lot of ways to do this and really depends on how big your portfolio is. Spreadsheets can work at the beginning but once you start to grow it becomes more of a hassle to deal with. Using some type of software or even dropbox can work. I recommend software such as Buildium, Quickbooks, Xero, or etc. There are a lot of software's to choose from.

How do you track maintenance and repairs for tax time?

How do you track maintenance and repairs for tax time?

Most Popular Reply

20 Replies