Landlord Expense Log
A structured Excel workbook for logging rental property expenses throughout the year — organized by IRS Schedule E category so tax time is straightforward.
Most landlords scramble at tax time — digging through bank statements, trying to remember what a charge was for, and guessing at categories. This log gives you one place to record every expense as it happens, already organized the way your tax preparer needs it.
What you log
Schedule E categories included
- Advertising
- Auto & travel
- Cleaning & maintenance
- Commissions
- Insurance
- Legal & professional fees
- Management fees
- Mortgage interest
- Other interest
- Repairs
- Supplies
- Property taxes
- Utilities
- Other expenses
What the Summary tab shows
- Set the tax year at the top — the summary filters automatically to that year
- Total expenses per Schedule E category with approximate IRS line numbers
- Each category's share of total expenses
- Grand total for the year — hand this to your tax preparer
What's included
- Landlord Expense Log Excel workbook (.xlsx)
- Log tab with 150 pre-formatted expense rows (expandable)
- Category dropdown matching IRS Schedule E
- Summary tab with tax year filter and category totals
- Lifetime minor updates included
- Immediate download after purchase
FAQ
Can I use this for multiple properties?
Yes. The Property column lets you label each entry by address or property name. You can filter the log by property in Excel to see expenses for any individual property.
Does it handle depreciation?
No. Depreciation is calculated differently from out-of-pocket expenses — it's based on the property's basis and recovery period, not a transaction you log. Your tax preparer handles this separately. The log covers all cash expenses that go on Schedule E.
What if I need more than 150 rows?
Select any expense row, copy it, and paste below the last row. The formatting, dropdowns, and Summary calculations extend automatically.
Is this a subscription?
No. One-time purchase, lifetime minor updates included.