Rental Property + Landlord Tracker — Excel/Google Sheets Rent Roll, Late Rent Alerts, Expenses by Schedule E Category, Property P&L + 50 AI Prompts

Sold by Cygnix Digital Packs with secure USDC checkout.

Description

Know who has paid, who is late and what each rental actually earns. Rental property + landlord tracker for small landlords with 1-20 properties (single-family, duplex, small multi-family, condo, room rentals). One workbook for Excel, Google Sheets and LibreOffice, plus AI workflows. 11 tabs: Settings (any currency, as-of date, tax year, default rent due day, grace period, late fee, lease-alert window, editable expense categories based on US Schedule E line names, each marked in/out of the P&L), Properties for up to 20 properties (purchase price, est value, mortgage balance; auto units, occupancy %, scheduled rent, income, expenses, NOI, cash flow, equity, gross yield), Rent Roll for up to 100 units (tenant contacts, lease start/end or month-to-month, rent, prorated first month, due day, deposit; auto occupancy, lease status Active/Ending soon/Expired, rent due this month, paid, Paid/Due/Partial/LATE status, owed, suggested late fee, overdue rent for the year), Rent Ledger (3,000 rows: rent, late fees, other income, security deposits; each rent payment marked on time or late), 12-month Rent Tracker grid (collected + status per unit per month, collection rate), Expenses log by property and category, Maintenance log (priority, vendor, status, cost, days open, overdue flags), Property P&L (income + every expense category per property, NOI, other spending, cash flow), Monthly Summary and a Dashboard (occupancy, rent due/collected/owed, late tenants, leases ending soon, income, NOI, cash flow, equity, maintenance, data checks, 3 charts). Example portfolio with fictional tenants included. Also 4 AI workflows (SKILL.md) for ChatGPT, Claude, Cursor or any agent: rent collection + late notices, year-end tax prep pack, lease renewal + rent review, maintenance triage + vendor dispatch; and 50 copy-paste landlord prompts. Record-keeping tool only, not tax, legal or financial advice; check your lease and local law on late fees, notices and deposits. Cygnix Labs digital pack.