Resource library

Spreadsheets and templates you can use this afternoon

Every file downloads instantly — no email gate, no account, no watermark. The financial tools are real Excel workbooks with live formulas, formatting, and protected calculated cells; the inspection checklist is a printable PDF. Column headers match Schedule E so your bookkeeping and your tax return finally agree.

Printed rental property worksheets, keys, and a pen on a desk in an Austin home office

Financial

Income, expenses, reserves, and return metrics — the numbers that decide whether a property works.

XLSX spreadsheet

Monthly Cash Flow Tracker

A full workbook: an Instructions tab, a 12-month Schedule E tracker with monthly NOI and cash flow, and a Summary tab that derives cap rate, cash-on-cash, and DSCR.

EditableLive formulas3 tabs
Download Spreadsheet
XLSX spreadsheet

Capital Reserve Planner

Calculates component age, remaining life, and the annual and monthly reserve contribution for every major system, then totals the monthly transfer to fund replacements.

EditableLive formulas2 tabs
Download Spreadsheet
XLSX spreadsheet

Rental Deal Analyzer

Turns purchase price, financing, income, and operating assumptions into NOI, cap rate, annual cash flow, cash-on-cash, and DSCR with a live P&I calculation. Change an input and the returns update.

EditableLive formulas2 tabs
Download Spreadsheet
CSV spreadsheet · 3 rows

Rental Expense Spreadsheet

Schedule E expense log with date, vendor, category, property, and memo columns so tax prep becomes a copy exercise.

DatePropertyCategory (Schedule E)VendorDescription…
CSV spreadsheet · 13 rows

Annual Budget Planner

Twelve-month operating budget per property with income, fixed and variable expenses, reserve contributions, and projected cash flow.

MonthGross RentOther IncomeVacancy %Property Tax…
CSV spreadsheet · 4 rows

Property Portfolio Dashboard

One row per property with address, units, market value, loan balance, equity, NOI, cash flow, and cap rate for portfolio-level review.

PropertyAddressUnitsMarket ValueLoan Balance…

Management

Turnover, inspections, and lease workflows that keep each tenancy documented.

CSV spreadsheet · 3 rows

Rent Roll & Lease Tracker

One row per unit with lease dates, deposit held, renewal window, and delinquency status for portfolio-level review.

PropertyUnitTenantBedroomsMarket Rent…
PDF checklist

Move-In / Move-Out Condition Report

A branded, room-by-room inspection form with property and tenant fields, OK / Dirty / Damaged checkboxes, photo reference columns, meter readings, follow-up items, and signature lines.

Printable3 pages
Download PDF
CSV checklist · 8 rows

Lease Renewal Checklist

Renewal workflow with rent review, market comparable check, inspection scheduling, notice timeline, and signed renewal tracking.

StepTaskTarget DateCompleted DateOwner or Vendor…
CSV checklist · 7 rows

Tenant Move-In Checklist

Move-in day workflow with utilities transfer, key handoff, condition walkthrough, and welcome packet delivery.

StepTaskTarget DateCompleted DateResponsible Party…
CSV checklist · 8 rows

Move-Out Checklist

Turnover workflow with notice verification, move-out inspection, damage assessment, deposit accounting, and re-listing.

StepTaskTarget DateCompleted DateResponsible Party…

Maintenance

Preventive and seasonal planning that turns surprise repairs into scheduled line items.

How to use these together

  1. 01Set up the rent roll first so every unit, lease date, and deposit is in one place.
  2. 02Enter last month into the Financial Tracker using Schedule E category names.
  3. 03Fill the Reserve Planner with install years, then automate the monthly transfer.
  4. 04Print the Move-In / Move-Out Condition Checklist before every turnover and photograph each line.
  5. 05Load the Maintenance Planner into your reminders and review it each season.

Want the new templates first?

Subscribers get new spreadsheets and calculator updates as they publish.

Free resources: Financial Tracker, Maintenance Checklist, Inspection Checklist, Turnover Checklist, and calculators. One email every other week. No spam, unsubscribe anytime.