Rental Property Spreadsheet, Small Landlord Income Expense Tracker, Rent Roll, Schedule E, Cash Flow, Cap Rate, Excel, Google Sheets
What you get
- Excel file (.xlsx) that also opens in Google Sheets and Numbers
- Formulas and totals built in
- A short how-to PDF
- Instant download after checkout
Made for accidental and small landlords with 1–5 doors who want to track rent, expenses and profit and prep for taxes without buying property-management software.
Why this one: Built for the 1–5 door hobby landlord: expense rows pre-mapped to Schedule E tax categories, an auto-calculating cash-flow and cap-rate summary, a simple rent roll / tenant payment tracker, and a plain dashboard — delivered in both Excel and Google Sheets with sample data and a quick-start tab, priced well under the dashboard crowd.
Track every dollar across your rental portfolio without buying expensive software — built for landlords with 1 to 5 doors.
YOU WILL RECEIVE - product.xlsx — 6-tab spreadsheet (Start Here, Properties, Rent Roll, Income & Expenses, Cash Flow & Cap Rate, Dashboard) with sample data included; works in Excel and uploads directly to Google Sheets - how-to-use.pdf — 1-page quick-start guide
HOW IT WORKS After purchase, your files appear instantly on your Etsy purchases page and in the confirmation email Etsy sends you. Download both files and open product.xlsx to get started. No physical item is shipped.
HOW TO USE Open the file in Excel or upload it to Google Sheets via File > Import. Replace the sample rows with your own properties on the Properties tab — purchase price, market value, monthly rent and mortgage are all you need to enter. The Rent Roll tab tracks tenant payments and auto-calculates balance and payment status. Log income and expenses on the Income & Expenses tab; expense categories are pre-mapped to IRS Schedule E lines so tax prep is a copy-paste job. The Cash Flow & Cap Rate tab calculates NOI, cap rate and annual cash flow per door automatically. The Dashboard pulls portfolio totals into one summary view. Edit only the plain white cells; cells with a dark header or a formula in the formula bar are calculated for you.
DISCLAIMER Colours may appear slightly different on your screen versus in print. This file is for personal use only; resale or redistribution is not permitted. Because this is a digital file, refunds are not available once downloaded.
Browse the rest of the shop for more spreadsheets and printables built for everyday money management.
This design was created with AI assistance under the creative direction of the shop owner.
