Landlord expense tracker spreadsheet
Small landlords usually know the rent. The expenses are what get lost: a repair paid in cash, an insurance renewal, an HOA fee. Logging them by property is how you find out what each rental really earns.
The Rental Property Tracker has an expense log (600 rows) with property and category dropdowns for mortgage interest, property taxes, insurance, repairs, management, utilities, HOA, CapEx and more. Cash flow by property totals expenses by category and works out NOI, mortgage payments, cash flow, cap rate and cash-on-cash return. It also has a 12-month rent ledger with late flags and a portfolio dashboard.
It works in Excel and Google Sheets for up to 10 properties or units and is part of the Small Business & Landlord Bundle. It is a record-keeping tool, not tax or legal advice.
Buy Rental Property Tracker on Etsy · $19.00What you get
You get two files, a blank template and a filled-in example, plus a Start Here guide. Open them in Microsoft Excel, or upload them to Google Drive and open them with Google Sheets (free). You type in the input cells; the formulas, totals and charts update themselves.
Tips
- Log every expense against a property, even small ones.
- Split CapEx (a new roof) from repairs (a fixed leak); they are treated differently.
- Review cash flow by property every quarter.