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)Add alerts to this template
If you already use this Google Sheets template, RentGuard can watch it and email you when something needs attention.
Connect this sheet to RentGuard →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. Install the Google Sheets add-on or connect via the web app — setup takes under 60 seconds.
Free forever for 1 property. Pro at $15/mo for unlimited. 60-second setup.
Start Free Monitoring →