Property maintenance receipts pile up fast. A roof repair, a furnace tune-up, a new water heater, a pest control visit; each one is tax-deductible, but only if you can prove it later. A solid maintenance expense template keeps those records grouped by property, by vendor, and by year, so you can answer an IRS question in seconds instead of digging through a folder of crumpled thermal paper.
This template gives rental property owners, real estate agents, and landlords a starting structure for tracking every repair and maintenance cost across a portfolio. It pairs naturally with SlipSheet's receipt scanning workflow: scan a maintenance receipt, the data lands in the right columns, and you have a paper trail from invoice to Schedule E.
What the template is
The maintenance expense template is a single-purpose spreadsheet designed to log every repair, service call, and improvement under the deduction threshold. One row per invoice. Each row captures the property, the vendor, the service type, the cost, the date, the warranty window, and free-form notes.
Unlike a generic expense log, this template assumes you are tracking deductible expenses across more than one property. The Property column is the first field, not an afterthought, because IRS Schedule E asks you to report expenses per property at tax time. Aggregating everything into one unfiltered list is the most common mistake landlords make, and it costs hours at filing.
Columns and what each one does
Every column answers a question the IRS, your accountant, or your future self will eventually ask.
- Property: the address, nickname, or unit identifier. Keep it consistent across rows so you can filter, sum, and report per property without cleanup.
- Service type: a short category such as Plumbing, HVAC, Roofing, Electrical, Pest Control, Landscaping, Appliance, Cleaning, or General Repair. Categories let you slice the year for budget planning and answer insurance claims quickly.
- Vendor: who did the work. Repeat vendors are common; grouping by vendor shows you who you rely on and which invoices you still owe.
- Date: the service date, not the payment date. The IRS cares about when the cost was incurred, not when the credit card cleared.
- Cost: the total invoiced amount, including tax and labor. Lump everything on one number; splitting parts and labor in the same row creates columns nobody reads.
- Warranty: the warranty window in months, or a yes/no flag, plus the expiration date. When a repair fails a month later, this column tells you whether to call the vendor or write a new check.
- Notes: anything that does not fit the structured columns. Model numbers, paint colors, parking notes for the vendor, whether the tenant was present, follow-up reminders.
How to use it day to day
Open the template on the first of the month and create one new row per receipt. Three habits keep the data clean without extra effort:
- Log the receipt the day it arrives. Same-day entry means you remember the context: which tenant called, what the technician said, whether the part is still under warranty from a previous fix.
- Attach the source document. SlipSheet scans the paper receipt and links the PDF or image to the row. A spreadsheet with a paper trail is audit-ready; one without is just a list of numbers.
- Tag the property before tagging anything else. Pick the property from a dropdown or type the same identifier every time. Filtering by property is the single most common operation you will run.
At quarter-end, run a quick review: check for duplicate vendor entries, confirm every row has a property and a cost, and re-export to your accountant's preferred format (CSV for QuickBooks, XLSX for Excel-based workflows, PDF for a printed file).
Customization options
The template is intentionally simple because simple scales. Three common customizations make sense once the basic log is in steady use:
- Add a Tax Year column if you manage properties across entities or fiscal years. Filtering by tax year avoids losing expenses in the wrong reporting period.
- Add a CapEx vs Repair flag if you have renovations that need to be depreciated rather than expensed in the year incurred. The IRS treats anything that adds value, extends life, or adapts a property to a new use as a capital improvement, which means different forms and different timelines.
- Split into per-property tabs once you cross five or six units. A single sheet is fine for small portfolios; a tab per property is faster to navigate and share with co-owners at scale.
Pair this template with SlipSheet's receipt scanning so that maintenance invoices from contractors land in the right row with the vendor, cost, and date filled in automatically, ready for tax season.
Start your 14-day SlipSheet trial and turn paper maintenance receipts into a clean, searchable expense log you can hand straight to your CPA.
FAQ
What counts as a maintenance expense versus a capital improvement?
Repairs and maintenance keep the property in its current condition; capital improvements add value, extend useful life, or adapt it to a new use. Replacing a few shingles is maintenance; replacing the whole roof is a capital improvement that must be depreciated.
Do I need a separate expense log for each rental property?
You can keep all properties in one sheet with a Property column, or split into per-property tabs once you have five or more units. The IRS requires reporting expenses per property on Schedule E, so consistency in the property identifier matters more than the layout.
How long should I keep maintenance receipts?
Keep records for at least three years from the date you file the related return, and longer if the work is a capital improvement that gets depreciated over multiple years. Digital scans linked to each row are the easiest way to retain the paper trail.
Can I deduct maintenance performed by the tenant?
Yes, if you reimburse the tenant and the cost meets ordinary repair thresholds. Document the reimbursement with a receipt and note the tenant-paid arrangement in the Notes column so the deduction survives an audit.
Should I log the receipt date or the payment date?
Use the service date on the invoice for the Date column. The IRS deducts expenses in the year incurred, not when the credit card clears, so matching the invoice date keeps each year's totals accurate.