Rental Property Income & Expense Tracker | Landlord Spreadsheet + Printable Pack (Excel, Google Sheets, PDF)

Do you actually know what each rental made last month?

Rent lands in one app, the plumber gets paid from another, and the receipts live in a shoebox and a glovebox. When someone asks "is that duplex worth keeping?" you guess. That guess costs money: a repair receipt you never find is a deduction you never claim, a lease that quietly expires is a month of vacancy, and every spring you lose a weekend rebuilding twelve months of numbers from bank statements.

The Rental Property Income & Expense Tracker v2 is one spreadsheet that does the adding for you. Log rent and costs as they happen (about 30 seconds each) and the Dashboard tells you, in plain English, how every property is doing: "You've collected $2,850 of $4,700 expected rent this month, so $1,850 is still outstanding." "1 lease ends within 60 days: start the renewal conversation now."

WHAT IT DOES- Per-property P&L: rent, expenses and net cash flow this month and year to date, average monthly net, annualized net and cap rate from the purchase price you enter in Settings.- Rent Log with expected vs received: late, short and unpaid payments flag themselves in red using your grace days; balance due calculates.- Properties & Units: tenant, rent, deposit and lease dates with a live "lease ends in N days" countdown and renewal alerts.- Expenses with property and Schedule E style category dropdowns, deductible and receipt-saved flags.- Tax Summary: Schedule E style totals by property for the year, ready to hand to your preparer (planning tool, not tax advice).- Maintenance Log (request, priority, vendor, cost, status, days open) and a Vendors tab that fills in jobs, total paid and last used.- Mortgage & Loans: payment split, months to payoff, payoff date, equity, LTV and an extra-payment what-if.- 12-month trend with text bar charts, expenses by category, occupancy, open maintenance and late-rent counts.- Personal: type your first name once and every tab greets you. My Why & Goals tab with progress bars. Monthly Review tab with auto numbers and three honest prompts.- 15 realistic sample rows marked "delete me" so you can see it working before you type a thing.

THE PRINTABLE PACK (16 pages, PDF, Letter / A4, plus a low-ink print-friendly twin)Property Fact Sheet, Tenant & Lease Record, Rent Receipts (3 per page), Rent Collection Log, Expense Log, Maintenance Request Form, Maintenance Log, Vendor Contact List, Move-In / Move-Out Inspection (2 pages), Tenant Turnover Checklist, Year-End Tax Prep Checklist, Year-End Summary Worksheet, Monthly Review.

WORKS WITH- Microsoft Excel (desktop or free Excel online)- Google Sheets (upload to Google Drive, then Open with Google Sheets). Every formula is Excel + Sheets safe; no macros.

WHAT YOU GET1 Excel file (.xlsx) with 12 tabs: Welcome, Dashboard, Properties & Units, Rent Log, Expenses, Maintenance Log, Vendors, Mortgage & Loans, Tax Summary, My Why & Goals, Monthly Review, Settings. Room for 500 rent rows, 500 expenses, 300 maintenance requests, 30 units, 50 vendors and 10 loans. Plus 2 PDFs (printable pack + print-friendly version).

QUESTIONS- I only have one unit. Still worth it? Yes: one unit is where a missed $200 receipt hurts most.- Not a spreadsheet person? You type only in white and yellow cells. A Welcome tab walks you through a 5-step setup in about 10 minutes.- Phone? Log rent and expenses in the free Google Sheets or Excel app.- Next year? Save a copy, clear the logs, keep your properties, vendors and loans.

PLEASE NOTE- Digital download. Nothing will be shipped.- Planning tool only, not tax, legal or financial advice. Confirm deductions with a tax professional.- All sales are final because of the nature of digital files, but message me if you have any trouble and I'll help.

Made with AI assistance and checked by a human.