Rental Property Spreadsheet, Landlord Income Expense Tracker, Rent Roll, Schedule E, Rental Income Tracker, Excel Google Sheets

Rental Property Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Manage up to 10 rental properties in one spreadsheet. Log rent and expenses, track every lease, and get your cash flow, cash-on-cash return and a tax-time summary automatically. ✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition. ★ WHAT'S INCLUDED ★ • 16 tabs: Start Here, Dashboard, Properties, Units, Rent Roll, Rent Payments, Rent Tracker, Transactions, Maintenance, Mortgage & Escrow, Monthly P&L, Annual P&L, Tax Summary, Deal Analyzer, Setup, How To Use • Clickable Start Here cover page with quick-start steps and a color key (yellow = you type) • Landlord Dashboard: rent collected, NOI, cash flow, occupancy, monthly rent roll, portfolio value, total equity, past-due rent, cap rate, cash-on-cash, DSCR, vacancy loss, leases ending soon, open repairs, deposits held and capital items, plus month by month results, a property scoreboard, a Needs Attention panel, where the money goes, your next lease expirations and 5 charts • Properties (up to 10): purchase price, closing costs, rehab, down payment, land value and value now; cash invested, units, occupied units, rent roll, loan balance, equity and an estimated depreciation figure are calculated • Units (up to 40): current tenant, rent, lease end, status (occupied, notice given, vacant), days vacant, vacancy % and rent lost to vacancy, rent vs market and rent per sq ft • Rent Roll (60 leases): tenant, rent, deposit and lease dates; lease status (active, expiring soon, month-to-month, notice given, upcoming, moved out), days left, this month's rent status and balance owed update automatically • Rent Payments (1,000 rows): pick the lease and type the amount; due date, days late and on time / late / partial status are calculated • Rent Tracker: every lease across 12 months, color-coded paid, partial, late and no rent due, with paid, due, balance, collection % and late count per tenant • Transactions (1,500 rows) for all other income and expenses, with receipt tracking; each category maps to its Schedule E line and to operating or capital • Maintenance (300 rows): priority, status, vendor, cost and who paid, with fix-by deadlines from Setup, overdue alerts, a repair summary and a cost by category chart • Mortgage & Escrow: payment, balance, interest and principal this year, escrow for property tax, insurance and PMI, payoff date, loan to value and equity for each loan, plus a 30-year payoff schedule with a balance vs equity chart. Mortgage and escrow flow into your P&L and Schedule E automatically • Monthly P&L for one property or the whole portfolio: rent scheduled and collected, other income, operating costs, escrow, NOI, interest, principal, cash flow and capital items, with KPI tiles and 2 charts • Annual P&L & Returns: every property side by side with NOI, cas