Rental Property Spreadsheet & Rental Income Tracker (US) | Excel Template

Follow the income, costs and cash flow of each rental, keep your records in Schedule E categories, and test your next purchase: one workbook for up to 25 properties.

The Rental Property Tracker (US) is a rental property and rental income spreadsheet with no macros, for Excel 2016 or later.

What you get

• Rental-Property-Tracker-US.xlsx – 11 tabs, native formulas only:
  • Start Here and Settings: tax year, status date, IRS standard mileage rates by date, Schedule E categories, drop-down lists.
  • Properties: up to 25 properties with purchase, closing costs, value; loans, improvements, cash invested, balance and equity calculated.
  • Tenants & Rent Roll: rent due month by month from the lease dates, rent received, arrears and months occupied, calculated to the status date.
  • Income & Expenses: one line per transaction, in categories named after the line captions of Schedule E (Form 1040) Part I: Advertising, Auto and travel, Cleaning and maintenance, Commissions, Insurance, Legal and other professional fees, Management fees, Mortgage interest, Other interest, Repairs, Supplies, Taxes, Utilities, Depreciation, Other (the guide flags the 2026 draft form, which splits line 13 into 13a and 13b).
  • Mortgages: payment, balance, interest and principal for each month of the tax year; Form 1098 interest override.
  • Capital Improvements: cost, placed-in-service date and recovery period, kept apart from repairs.
  • Security Deposits: held, deducted, returned, with a return-deadline flag you set for your state.
  • Mileage: trips with the IRS rate in force on the trip date (70 cents for 2025; 72.5 cents January to June 2026; 76 cents from July 1, 2026).
  • Dashboard: occupancy, rent received, arrears, NOI, debt service, cash flow (to date, per month and annualized), cash-on-cash, cap rate, equity by property; monthly cash flow by property; 2 charts; a Schedule E worksheet (lines 3 and 5 to 21; line 4, royalties, not covered) for one property or all.
  • Deal Analyzer: three acquisitions side by side with NOI, cash flow, cap rate, cash-on-cash, DSCR, break-even occupancy and a rent and rate sensitivity table. Delivered with a fictitious portfolio of 4 properties (5 units).
• Rental-Property-Tracker-Guide-US.pdf – 8 pages: monthly routine, each tab explained, repairs versus improvements in IRS wording, the Dashboard measures, the year-end checklist and the official sources (irs.gov, checked October 17, 2026).

Quality

No add-ins. Built in Excel with functions that Google Sheets also supports (no macros, no XLOOKUP, LET, LAMBDA or dynamic arrays). If you import it into Google Sheets, check charts, colors and drop-down lists after import. Recalculated in Excel with 0 formula errors; mortgage schedules, rents, cash flow and the sample deal were checked against an independent calculation.

Please note

Not tax advice; consult a tax professional. The workbook organizes records and calculates cash returns; it does not prepare a tax return, decide what is deductible or calculate depreciation.

Personal use for your own properties. Resale and redistribution are not allowed.

Fictitious sample data. Written with AI assistance and reviewed. Not legal, tax or financial advice.

Seller: SASU MOE CAPITAL, 95 impasse des Garennes, 81710 Saïx, France. Terms of Service · Consumers: 14-day right of withdrawal, Withdraw from contract here · Consumer mediator (France): Société de la Médiation Professionnelle (SMP), Alteritae, 5 rue Salvaing, 12000 Rodez, France – www.mediateur-consommation-smp.fr.