Rental Property Tracker

Income, expenses, rent roll, deposits, mileage and a Schedule E summary for up to 10 properties.

Track every rental dollar in one clean spreadsheet, and have Schedule E ready when tax season comes.

What's inside

• Transactions: 2,000 rows. Pick a property and category and the Schedule E line fills itself in.
• Rent Roll: up to 50 leases. Shows who paid, who is partial and who is LATE, based on your due day and grace period.
• Security deposit ledger and mileage log.
• Dashboard: filter by property. Monthly income vs. expenses, cash flow, expense ratio and late count.
• Schedule E summary: lines 3–21, one column per property (up to 10).
• A blank workbook, a filled SAMPLE workbook, and a step-by-step PDF guide.

Works in Excel 2010+ (Windows/Mac), Google Sheets and LibreOffice. No macros, no add-ons, no subscription.

Tested: every total was checked against an independent calculation. Zero formula errors.

Not tax advice. Confirm treatment with the IRS instructions or your tax professional.

Built with AI assistance and tested by running it end to end (details in the guide).

Refunds: 30-day refund if it doesn't work as described (refund policy).

Learn the method (free)

• Build a Rent Roll That Flags Late Rent Automatically (Plus a Deposit Ledger)

  Spreadsheet formulas for a rent roll that shows Paid, Partial, Due and LATE for each unit, and a security deposit ledger that always balances.

• How to Track Rental Income and Expenses by Schedule E Line (Free Spreadsheet Method)

  A simple spreadsheet setup that sorts every rental transaction into its Schedule E line automatically, with the exact SUMIFS formulas.

• Rental Property Cash Flow Spreadsheet: Monthly NOI and Cash Flow per Property (Excel & Google Sheets)

  Build a landlord spreadsheet that shows income, operating expenses, NOI and cash flow for each rental by month, with the exact SUMIFS formulas. Tested in Excel-compatible LibreOffice and Google Sheets syntax.

Related free tools

• Bank CSV Categorizer for Schedule E and Schedule C

  Turn a bank or card CSV into categorized rows for landlord (Schedule E) or freelancer (Schedule C) spreadsheets. Runs in your browser; nothing is uploaded.

• Free Rental Property Calculator: Cash Flow, Cap Rate, Cash-on-Cash, DSCR

  Instant rental deal math in your browser: monthly cash flow, NOI, cap rate, cash-on-cash return, DSCR, GRM, 1% rule and break-even occupancy.

Save with a bundle

• Landlord Spreadsheet Bundle

  2 products for $27 instead of $34 (save $7).

• Complete Bundle (all 6 core products)

  6 products for $69 instead of $109 (save $40).

Checkout, delivery, receipts and sales tax are handled by Gumroad. Questions after purchase: reply to your Gumroad receipt email. Not tax, legal or financial advice.