Rent Payment Tracker Template
Track rent payments with the exact columns RentGuard auto-detects: Unit, Tenant, Amount, Due Date, Status. Color-coded. Summary formulas included.
⬇ Download Free Template (.xlsx)Works in Excel, Google Sheets, and LibreOffice. No signup required.
Pre-formatted for RentGuard
This template uses the exact column headers RentGuard auto-detects — Unit, Tenant, Amount, Due Date, Status, Last Paid Date, and Occupied. Connect it and monitoring starts immediately.
What's Inside
✓ RentGuard-compatible columns
✓ Paid / Unpaid / Overdue / Partial / Pending status
✓ Conditional formatting by status
✓ Summary formulas: collected vs. outstanding
Ready to download?
Free. No signup. Opens in Excel, Google Sheets, or LibreOffice.
⬇ Download Rent Payment Tracker (.xlsx)Want this automated?
RentGuard monitors your spreadsheet and sends you alerts when rent is overdue or maintenance goes stale. This template is pre-formatted to work with RentGuard — connect it in under 10 minutes and get automatic alerts.
$29/mo flat. 10-minute setup. 30 days free.
Start Free Monitoring →