Rental Property Tracker Google Sheets | Landlord Spreadsheet | Multi Property Income Expense | Rent Payment Tracker | Bookkeeping

♥ The Rental Command Center — your entire rental portfolio, tracked in ONE Google Sheet ♥
Rental Property Tracker | Landlord Spreadsheet | Google Sheets | Income · Expenses · Tax · Returns | Up to 100 Properties | Fully Editable
─────────────────────
✨ Stop juggling a separate spreadsheet for every property.
If you own more than one rental, you already know the mess: one file for this unit, another for that building, a shoebox of receipts, and no real idea what you actually made this year. The Rental Command Center replaces all of it. One connected Google Sheet holds your whole portfolio — up to 100 properties and every unit inside them — and does the math for you. Log your rent and expenses, and watch your income, balances, mortgage payoff, deposits, taxes and true investor returns update themselves in real time.
Built for real landlords: whether you have 1 rental or 100, a single-family house or a multi-unit building, this tracks it all in one place — no accounting degree required.
22 connected tabs · up to 100 properties · everything automatic · Google Sheets (no Excel, nothing to install).
─────────────────────
✦ WHAT YOU GET ✦
📌 Instant access — a PDF with your private Google Sheets link (click, make a copy, done)
📌 22 fully-connected tabs — setup, data entry, tenant ledgers, 8 dashboards, a tax center and an alerts hub
📌 Room for up to 100 properties and all their units in ONE file — no duplicate spreadsheets, ever
📌 A step-by-step video walkthrough so you are up and running in minutes
📌 Pre-filled sample data you can explore, then clear with one click for your own portfolio
─────────────────────
✦ TRACK EVERYTHING THAT MATTERS ✦
🏠 PROPERTIES & UNITS — every building and every unit inside it, on a two-level system that keeps single-family and multi-unit rentals equally tidy.
📄 LEASES + TENANT PROFILES — lease dates, rent and deposit, plus the tenant behind it: contact details, pets and pet rent, vehicles, employer, emergency contact and renters-insurance dates.
💵 INCOME — log each payment and every unit automatically shows Paid, Partial, Unpaid or Overpaid, with late-day counts and pet rent rolled in.
🧾 EXPENSES — categorised the way your taxes need them, tagged to a whole building or a single unit.
🔧 REPAIRS & UPKEEP — a work-order board (reported → in progress → done) with priority, contractor and cost, so nothing sits forgotten.
🏗 CAPEX & DEPRECIATION — big improvements tracked separately from repairs, with straight-line depreciation worked out for you (the piece most landlords get wrong).
🚗 MILEAGE — log a trip, get the IRS deduction automatically, at the correct rate for that year.
🔐 DEPOSITS — every security deposit held, deducted and refunded, so nothing slips through.
🏦 LOANS & MORTGAGES — enter the loan once and see your monthly payment, current balance, interest paid and next due date, all calculated for you.
📇 CONTACTS — your trades, vendors and emergency numbers in one place, with a tenant directory that fills itself in.
📑 TENANT STATEMENTS — pick a unit and get a printable payment history you can send straight to your tenant.
─────────────────────
✦ 8 DASHBOARDS THAT DO THE THINKING ✦
📊 PORTFOLIO SNAPSHOT — every building's income, expenses and true profit at a glance, for any date range.
🏠 UNIT DETAIL — is THIS unit actually making money? A full profit and loss per unit, including its fair share of the building's costs.
📅 MONTHLY VIEW — your year month by month, with cumulative profit and a chart.
🗓 YEARLY VIEW — where every dollar went, ranked by category, plus rent billed against rent collected.
📈 5-YEAR TRENDS — five years side by side, so you can see whether the portfolio is actually growing.
🔎 CUSTOM RANGE — any period you like: a quarter, a tax year, or everything since you bought a building.
⚖ COMPARE — put two or three buildings, years or periods head to head and see the gap in percent.
💹 RETURNS DASHBOARD — the investor numbers a basic tracker never gives you: cap rate, cash-on-cash, ROI and equity.
🧮 TAX CENTER — your whole year mapped to IRS Schedule E, line by line: rents, every expense category, mortgage interest and depreciation.
🔔 ACTION CENTER — one live to-do list pulled from every tab: overdue rent, leases expiring, insurance lapses, mortgage payments due, deposits to return and open repairs.
─────────────────────
✦ WHY LANDLORDS CHOOSE THIS ✦
✓ ONE file for your whole portfolio — up to 100 properties, no duplicate spreadsheets to keep in sync
✓ It does the math — every total, balance, status and deduction calculates itself as you type
✓ Investor-grade returns — cap rate and cash-on-cash that most trackers simply do not include
✓ Tax-ready — your numbers organised straight onto Schedule E, so tax season is a copy-paste
✓ Never miss a thing — the Action Center surfaces every deadline before it bites
✓ Truly editable — add or rename anything; works on a free Google account, on any device
✓ Yours forever — one purchase, lifetime access, free updates
─────────────────────
✦ PERFECT FOR ✦
Landlords · Rental property investors · Multi-property and multi-unit owners · Airbnb and short-term-rental hosts · House hackers · Property managers · Anyone tired of a messy rental spreadsheet
─────────────────────
✦ HOW IT WORKS ✦
1️⃣ Buy and download the PDF from your Etsy orders.
2️⃣ Open the PDF and click your private Google Sheets link.
3️⃣ Click 'Make a copy' to save your own fully-editable version to your Google Drive.
4️⃣ Start on the Properties & Units tab, add your first property, and you are off.
5️⃣ Watch the included video if you would like a quick guided tour.
─────────────────────
✦ PLEASE NOTE ✦
• This is a digital download — nothing is shipped.
• You will need a free Google account; this works in Google Sheets and is not sent as an Excel file.
• Not tax advice — the Tax Center organises your numbers for Schedule E; always confirm with a qualified tax professional.
• Due to the instant-digital nature of this product, all sales are final. Questions before buying? Send a message — happy to help.
─────────────────────
For your own personal or business use only. Not for resale or redistribution.