Rental Property Tracker

Keep your rentals organized and see what every property really earns. The Rental Property Tracker is built for small landlords with up to 10 properties or units. Enter your properties once, record rent as it comes in and log your bills. The workbook flags late rent, tracks balances owed and works out NOI, cash flow, cap rate, cash-on-cash return and occupancy for each property and your whole portfolio. WHAT'S INCLUDED • Portfolio dashboard: rent collected, NOI, cash flow, occupancy, rent outstanding, cap rate, cash-on-cash and leases ending soon, with charts • Rent ledger: 12 months for each of up to 10 units, with rent due, paid, date paid, late flag and running balance • Expense log (600 rows) with property and category dropdowns: mortgage interest, property taxes, insurance, repairs, management, utilities, HOA, CapEx and more • Cash flow by property: expenses by category, NOI, mortgage payments, CapEx, cash flow, cap rate (NOI / purchase price) and cash-on-cash • Properties tab: address, purchase price, cash invested, mortgage payment, rent, tenant and lease dates, with lease alerts (60 days, adjustable) • Setup tab for your year, rent due day, grace period and categories • Start Here guide • Two files: a blank tracker and a filled-in example WORKS WITH • Microsoft Excel (2010 or later, Windows and Mac, and Excel online) • Google Sheets (free): upload the file to Google Drive and open it with Google Sheets HOW IT WORKS 1. Purchase and download instantly from your Etsy Purchases page. 2. Open the file in Excel, or upload it to Google Drive and open it in Google Sheets. 3. Add your properties, then record rent and expenses as you go. PLEASE NOTE • This is a digital download. No physical item will be shipped. • Amounts are in US dollars ($). Currency formatting can be changed in your spreadsheet app. • For personal use. Please don't resell or share the file. • Not tax, legal or financial advice. Results are estimates based on what you enter. How we make it: Every Penny & Pencil template and worksheet is designed in-house with AI-assisted tools, then each page, formula and answer key is checked and tested before it is listed. Questions? Send us a message. We usually reply within a day.