Free tool
Free rental property expense spreadsheet
A real income and expense workbook, not just a blank grid. Log rent and costs on one tab, and a second tab totals your income, expenses by category, net cash flow, and a per-property breakdown automatically. Built for tax time, and it opens in Excel or Google Sheets.
Excel (.xlsx), free, no sign-up. Works in Google Sheets too.
What it does for you
- A Transactions tab to log every rent payment and cost
- A Summary tab that totals it all automatically
- Total income, total expenses, and net cash flow
- Expenses broken down by tax category
- A per-property income, expense, and profit rollup
- Dropdown menus so every entry stays consistent
Categories to track
Tired of the spreadsheet?
Unitly records rent and expenses as they happen, categorizes them, and gives you the totals per property without any manual entry. Free for your first 5 units.
Get started freeCommon questions
How do I track rental property income and expenses?
Log every rent payment and every cost on the Transactions tab, tagged to a property, category, and amount. The Summary tab then adds up your total income, expenses by category, net cash flow, and per-property profit automatically, so your numbers are ready at tax time.
What expense categories should a landlord track?
Common ones are mortgage interest, property tax, insurance, repairs and maintenance, utilities, property management, HOA or condo fees, advertising, legal and professional fees, supplies, travel, and capital improvements. The workbook has these built into a dropdown so you categorize consistently.
Does it open in Excel and Google Sheets?
Yes. It is an Excel (.xlsx) workbook with the formulas built in. It opens in Microsoft Excel, Google Sheets, Numbers, and other spreadsheet apps, and recalculates the totals as you add rows.
See all free tools.