Rental Property Tracker hero with a real Excel dashboard showing gross income, cash expenses, net cash flow, cash-on-cash return, outstanding rent, and short-term rental occupancy.

Rental Property Tracker Excel | Landlord Income & Expense Spreadsheet | Long-Term + Short-Term Rentals

$12.99
Skip to product information
Rental Property Tracker hero with a real Excel dashboard showing gross income, cash expenses, net cash flow, cash-on-cash return, outstanding rent, and short-term rental occupancy.
  • Rental Property Tracker hero with a real Excel dashboard showing gross income, cash expenses, net cash flow, cash-on-cash return, outstanding rent, and short-term rental occupancy.
  • Rental property Excel dashboard preview showing portfolio income, cash expenses, net cash flow, outstanding rent, cash-on-cash return, and short-term rental occupancy from fictional sample data.
  • Rent Roll spreadsheet preview showing expected rent, rent received, balance, and Paid, Partial, or Unpaid status for fictional long-term rental records.
  • Short-term rental spreadsheet preview showing available nights, booked nights, occupancy, booking revenue, ADR, and related performance fields using fictional sample data.
  • Side-by-side real Excel previews of the Income and Expenses tabs used to enter rental cash transactions by property, date, category, description, and amount.
  • Annual Summary Excel preview showing per-property gross income, cash expenses, net cash flow, cash invested, cash-on-cash review, and expense-category totals.
  • Properties Excel tab preview with fictional long-term and short-term rental records, property IDs, rental type, units or rooms, cash invested, and notes.
  • Graphic showing all eight workbook tabs: Start Here, Properties, Income, Expenses, Rent Roll, STR Occupancy, Annual Summary, and Dashboard.
  • Two included Excel files shown side by side: a populated SAMPLE workbook with fictional data and a CLEAN START workbook ready for the buyer's own records.
  • Included and not-included product boundaries for the rental tracker, covering income and expense tracking, rent status, STR occupancy, and exclusions such as bank feeds and rent collection.
  • Rental Property Tracker hero with a real Excel dashboard showing gross income, cash expenses, net cash flow, cash-on-cash return, outstanding rent, and short-term rental occupancy.
  • Rental property Excel dashboard preview showing portfolio income, cash expenses, net cash flow, outstanding rent, cash-on-cash return, and short-term rental occupancy from fictional sample data.
  • Rent Roll spreadsheet preview showing expected rent, rent received, balance, and Paid, Partial, or Unpaid status for fictional long-term rental records.
  • Short-term rental spreadsheet preview showing available nights, booked nights, occupancy, booking revenue, ADR, and related performance fields using fictional sample data.
  • Side-by-side real Excel previews of the Income and Expenses tabs used to enter rental cash transactions by property, date, category, description, and amount.
  • Annual Summary Excel preview showing per-property gross income, cash expenses, net cash flow, cash invested, cash-on-cash review, and expense-category totals.
  • Properties Excel tab preview with fictional long-term and short-term rental records, property IDs, rental type, units or rooms, cash invested, and notes.
  • Graphic showing all eight workbook tabs: Start Here, Properties, Income, Expenses, Rent Roll, STR Occupancy, Annual Summary, and Dashboard.
  • Two included Excel files shown side by side: a populated SAMPLE workbook with fictional data and a CLEAN START workbook ready for the buyer's own records.
  • Included and not-included product boundaries for the rental tracker, covering income and expense tracking, rent status, STR occupancy, and exclusions such as bank feeds and rent collection.
Rental Property Tracker Excel | Landlord Income & Expense Spreadsheet | Long-Term + Short-Term Rentals

Rental Property Tracker Excel | Landlord Income & Expense Spreadsheet | Long-Term + Short-Term Rentals

$12.99

Rental Property Tracker for Microsoft Excel

Track rental income, cash expenses, long-term rent status, short-term occupancy, and per-property performance in one formula-driven Excel workflow.

What you’ll receive

  • 1 ZIP digital download containing exactly 2 Excel workbooks
  • SAMPLE workbook with fictional populated data
  • CLEAN START workbook ready for your own records
  • 8 tabs in each workbook: START HERE, PROPERTIES, INCOME, EXPENSES, RENT ROLL, STR OCCUPANCY, ANNUAL SUMMARY, DASHBOARD

What you can track

  • Up to 20 property records
  • Rental income and other cash income
  • Cash expenses by category and cash-flow class
  • Expected rent vs. actual rent received
  • Paid / Partial / Unpaid long-term rent status
  • Short-term rental available nights and booked nights
  • Occupancy %, gross booking revenue, ADR, and revenue per available night
  • Gross income, total cash expenses, net cash flow, and simple cash-on-cash review
  • Annual per-property summary and portfolio dashboard

Format & compatibility

  • Microsoft Excel .xlsx
  • No macros, VBA, or external data connections
  • Currency: USD
  • Google Sheets compatibility is not claimed for this exact final workbook

Important boundaries

This workbook is a manual rental-property operations and cash-flow tracker. It is not accounting software, tax-preparation software, legal advice, accounting advice, tax advice, or investment advice. It does not determine deductibility, calculate depreciation automatically, collect rent, screen tenants, connect to bank feeds, or connect automatically to booking platforms or property-management systems.

Delivery: Digital download. No physical item is shipped.

AI disclosure: This digital workbook and listing visuals were created with AI-assisted tools under seller direction, then reviewed, tested, and finalized by PoonthaiDigital.

You may also like