Rental Property Income & Expense Tracker: Landlord Spreadsheet for Excel & Google Sheets (Schedule E)

Know what each rental actually earns, and be ready for tax time without a weekend of receipts.

Built for landlords with 1 to 10 rental properties (any number of units). Log rent and expenses as they happen; the dashboard, per-property totals and Schedule E summary update themselves.

WHAT'S INSIDE

- Dashboard: pick one property or all properties for 12 months of rent, other income, expenses, mileage, net cash flow and capital improvements, with charts

- Annual Summary: every property side by side, expenses grouped by IRS Schedule E line, plus a "for your preparer" block (capital improvements, miles, late fees, deposits kept)

- Income log: rent, late fees, pet rent, deposits kept and more, by property, unit and tenant

- Expense log: 22 landlord categories, each mapped to a Schedule E line, with a "receipt saved?" check

- Capital Improvements tab, kept separate from repairs (usually depreciated, not deducted at once)

- Repairs vs. Improvements guide in plain English, based on the IRS tangible property rules (de minimis and small-taxpayer safe harbors, routine maintenance, betterment/restoration/adaptation)

- Mileage log with the 2026 IRS standard rates pre-filled (72.5 cents Jan to Jun, 76 cents Jul to Dec; editable)

- Receipt log with automatic receipt numbers

- Examples tab: how to log a partial payment, a late fee, a kept deposit, a repair vs. an improvement

- SAMPLE-DATA version (3 properties, 4 units) + a clean blank version

- Quick-Start Guide (PDF)

WORKS WITH

Microsoft Excel (desktop or web) and Google Sheets (upload the .xlsx and open with Google Sheets). Uses only functions both support; every formula was recalculated and error-checked before release.

NOT LEGAL OR TAX ADVICE

These are generic organizational templates, not state-specific forms. They are not a lease, notice or eviction document. Landlord-tenant rules (deposits, late fees, receipts, inspections) vary by state and city: check yours.

LICENSE

Use for every property you own + up to 3 client properties you manage. No resale or sharing of the blank templates.

Instant download (.zip). Questions about the files: hello@keyandkit.com. Free updates: keyandkit.com/updates