Rent Payment Ledger Spreadsheet | Landlord Tracker (Excel, Google Sheets)

🏠 ELDON-Digital Rent Payment Ledger & Landlord Management Suite
📊 The ultimate all-in-one rental property management spreadsheet — built for landlords, property managers, and real estate investors who want a professional, organised, and stress-free way to manage their rental income, tenants, and expenses.
✨ Available in Microsoft Excel AND Google Sheets — both fully functional versions included in your download!
WHAT'S INCLUDED — 20 FULLY BUILT SHEETS
🗂️ Dashboard — Navigation hub with live KPI cards & alerts
👤 Tenant Ledger — Full tenant profiles & payment standing
💳 Rent Payment Tracker — Log every payment with auto-balance
🏢 Property Tracker — All properties, occupancy & income overview
🏠 Unit Management — Track every unit, tenant & lease status
📄 Lease Tracker — Lease dates, renewals & expiry alerts
⚠️ Late Payment & Arrears Tracker — Overdue rent monitoring
💰 Income Summary — Monthly & annual income breakdown
💸 Expense Tracker — Log all property expenses by category
📊 Profit & Loss Summary — Full NOI & cash flow analysis
🔧 Maintenance & Repairs Log — Track vendors, costs & status
🔒 Security Deposit Tracker — Deposits collected & returned
📞 Tenant Contact Database — Full directory with emergency contacts
📒 Bookkeeping Sheet — Complete income & expense ledger
🧾 Tax Summary — Deductible expenses & net taxable income
🏚️ Vacancy Tracker — Vacant units & lost income monitoring
🔔 Reminders & Task Planner — Never miss a deadline again
📈 Charts & Analytics Dashboard — Visual performance insights
⚙️ Settings & Lists — Customisable dropdowns & property names
📘 User Guide — Step-by-step instructions for instant setup
🌟 KEY FEATURES
✅ Ready-to-use on day one — includes realistic mock data so you can see exactly how it works
✅ Live KPI dashboard — Total rent due, collected, outstanding balances, occupancy rate & net cash flow auto-calculated
✅ Smart navigation — Click any button to jump directly to any sheet, and return to the Dashboard instantly
✅ Dropdown menus — Payment methods, tenant status, expense categories, lease status & more
✅ Conditional formatting — Overdue payments highlight red, paid turns green, expiring leases flagged automatically
✅ IFERROR protection — Zero formula errors, zero broken calculations
✅ Charts & graphs — Bar chart, line chart, and pie chart included for visual reporting
✅ Print-friendly layout — Designed for clean landscape printing
✅ 100% formula-driven — No manual calculations, everything auto-updates as you enter data
🎨 DESIGN & BRANDING
Crafted by ELDON-Digital with a premium, professional look — dark navy and gold header, coordinated color-coded sheets, clean typography, and an Etsy-ready polished finish. This template looks as good as it works.
📥 WHAT YOU'LL RECEIVE
📁 1 × Microsoft Excel file (.xlsx) — fully functional with navigation
📁 1 × Google Sheets version — identical structure & features
📘 1 × Built-in User Guide sheet — instructions included inside the file
💡 PERFECT FOR
🏠 Individual landlords managing 1–20+ rental units
🏢 Property managers tracking multiple tenants & properties
💼 Real estate investors monitoring rental income & ROI
📋 Airbnb & short-term rental hosts tracking bookings & income
🧾 Anyone needing a simple, organised rental bookkeeping system
⚡ INSTANT DOWNLOAD
Your files are available immediately after purchase. No waiting, no shipping. Simply download, open in Excel or Google Sheets, and start managing your properties today.
🛠️ HOW TO USE IN GOOGLE SHEETS
Download the Excel file → Go to Google Drive → Upload → Right-click → Open with Google Sheets. All formulas and dropdowns are Google Sheets compatible and will work instantly.
📩 QUESTIONS?
We're here to help! Message ELDON-Digital through Etsy and we'll respond promptly. Custom modifications are available — just ask!
─────────────────────────────
© ELDON-Digital | This template is for personal and commercial use by the purchaser. Not for redistribution or resale.