Rental Maintenance Log + Tenant Request Tracker

Log every repair and tenant request, and get yearly totals that line up with Schedule E.

Receipts in a shoebox cost you money at tax time and credibility with tenants. This workbook keeps every repair and maintenance request in one place, organized by property and unit, and totals it all for the year.

Maintenance Log (200 rows): date, property, unit, category (plumbing, HVAC, electrical, appliance, and more), description, vendor, cost, status, date completed, paid, linked request #, and notes.

Tenant Requests (100 rows): date received, property, unit, tenant, issue, priority, status, assigned vendor, date resolved, and automatic days-open.

Yearly Summary: pick a year to see:

• Cost by Schedule E line (cleaning and maintenance, repairs, supplies, utilities, other, and a separate capital-improvements bucket that shouldn't be expensed), with a tie-out check
• - Cost by work category
• - A property-by-line grid
• - Open job and request counts

What's inside: a Setup tab where you list properties and vendors and remap categories to lines, a How to use tab, and fictional sample data. Yellow inputs, gray formulas, no macros.

It works in Excel and Google Sheets. It's an instant download (.xlsx). This is a bookkeeping tool, not tax advice; confirm the categories with your preparer.

Tags: maintenance log, repair tracker, tenant request tracker, landlord spreadsheet, rental property maintenance, schedule e, property management, google sheets