Track rent, mortgage, repairs, NOI, cash flow, and ROI on every rental property. Works in Excel, Google Sheets, Numbers, and LibreOffice.
Excel 2016+ · Google Sheets · Apple Numbers · LibreOffice
Click the download button above. The .xlsx file opens in Excel, Google Sheets, Numbers, or LibreOffice.
On the Property Summary tab, fill in purchase price, down payment, current value, loan balance, and monthly rent (blue cells).
Add each rent payment, late fee, mortgage, repair, and management fee. Categories map to IRS Schedule E.
The Monthly P&L and Annual Summary tabs auto-calculate NOI, cash flow, cap rate, and cash-on-cash return.
A spreadsheet works for 1–2 properties. Once you grow, the manual work piles up. Here's how Havyn replaces it.
Download the Excel file, open it in Microsoft Excel, Google Sheets, Numbers, or LibreOffice, and start tracking your rental income and expenses. No email signup required.
Monthly rental income, late fees, mortgage payments (P&I), property tax, insurance, repairs and maintenance, property management fees, utilities, HOA, and vacancy. It auto-calculates Net Operating Income (NOI), cash flow, cap rate, cash-on-cash return, and equity.
Yes. Upload the .xlsx file to Google Drive, right-click → Open with Google Sheets. All formulas convert automatically.
The template is designed for one property. To track multiple properties, duplicate the file per property — or skip the spreadsheet entirely and use Havyn, which starts at $19/mo (up to 10 properties) with AI-powered tracking and no manual entry.
Yes. The expense categories map directly to IRS Schedule E line items — mortgage interest, taxes, insurance, repairs, management fees, utilities, and depreciation. Hand the Annual Summary tab to your CPA at tax time.
A spreadsheet works great if you have 1–2 properties and don't mind manual entry. Once you grow, the time spent on data entry, chasing receipts, and reconciling owner statements outweighs the cost of software. Havyn automates all of it with AI — plans from $19/mo.
