Landlord Rental Property Tracker — Rent Roll, Per-Property P&L & Schedule E Expenses (Excel + Google Sheets)

See your portfolio the way a lender sees it — door by door.

Landlord Rental Property Tracker is a single spreadsheet system for landlords who

want every property's real profit in one place without paying monthly for property

management software.

WHAT'S INSIDE

- Dashboard — income vs expenses by month (with chart), YTD profit, rent collected,

active leases, occupancy on a unit-month basis, a full expense-category breakdown,

and a property scorecard showing income, expenses, net and margin for EACH

property. All automatic.

- Transactions — log every rent payment, late fee, application fee and cost with

Type/Category/Property dropdowns made for landlords: mortgage interest (interest

only), property taxes, insurance, repairs & maintenance, property management

fees, HOA, landlord-paid utilities, advertising & tenant screening, eviction &

legal, supplies and more — Schedule E aligned.

- Rent roll — one row per lease: the term fills itself from the dates; monthly rent

and a security-deposit memo column per lease; Active / Ended / Notice status.

- Mileage log — showings, turnovers, repair visits and supply runs; deductible

value from your editable IRS-rate setting (the Schedule E "auto and travel" lane).

- Quarterly tax estimator — a suggested set-aside per quarter from your own

effective-rate estimate, so tax season never ambushes you.

- Settings & guide — your rates, unit count, the Properties list (edit it once and

every dropdown updates), category list, and a plain-English quick guide with the

landlord tax notes that actually matter.

WHY YOU'LL LIKE IT

- Per-property P&L: assign a Property to every row and the scorecard shows which

door earns. The sample data proves it — a duplex netting +$9,737 next to a house

running −$1,654 after an HVAC failure, in the same year, in the same file.

- Security deposits handled honestly: a held-deposit memo per lease (they're your

tenants' money, not income) plus a "Deposit withheld (kept)" income category for

when you keep part of one — the sample shows the full flow with a $250 withholding.

- Schedule E-aligned categories your tax preparer will recognize, plus notes on

mortgage interest (interest only) and why depreciation is a CPA question.

- Multi-property by design: rename the two sample properties to your own and the

Property dropdowns follow. One file, one to ten doors.

- Zero setup: no macros, no add-ins, no accounts, no subscription — ever. Opens in

Excel 2016+ and imports into Google Sheets in one click. New year? Duplicate the

file and keep going.

- Ships with clearly-marked sample data (two properties, three units, full-year

2026, 97.2% occupancy with one vacancy month) so you can see every report working

before you type a thing.

YOU GET

- Landlord-Rental-Tracker-v1.xlsx (the full system)

- Quick-start guide (PDF included in the zip)

- Single-user license (personal/business use on all your own units; no resale)

HONEST NOTES

- Brand-new product from a small template studio — v1.0. Spotted a bug or want a

category added? Message us through Payhip and we'll fix it in the next update.

Buyers get free updates to v1.x.

- Sample-data numbers are illustrative; occupancy uses a unit-month convention

(occupied unit-months ÷ your unit count × 12); estimates in the workbook are

plain math, not tax advice.