Rent Payment Tracker for Excel
Track rental payments with this free Excel rent payment tracker. Log tenant payments, due dates, and outstanding balances. Download Excel and CSV. No signup required.
ExcelCSV
Cost
Free
Signup
No signup
Formats
Excel, CSV
Best for
Finance
Updated
2026-06-19
What Is This Rent Tracker GS Template?
This Excel rent payment tracker template helps landlords and property managers track tenant payments, due dates, and outstanding balances.
Why Use a Google Sheets Rent Tracker GS Template?
When Should You Use This Rent Tracker GS Template?
What's Included
- ✓Tenant name & unit
- ✓Monthly rent amount
- ✓Due date
- ✓Payment date
- ✓Amount paid
- ✓Balance due
- ✓Payment method
- ✓Lease end date
How to Use This Template
1Copy the template to your your device.
2Add tenants with rent amounts and due dates.
3Log payments as they are received.
4Outstanding balances calculate automatically.
5Track lease end dates for renewals.
6Export for tax reporting.
Who This Template Is For
LandlordsProperty ManagersReal Estate InvestorsTenants
Available Formats
Excel (.xlsx) — Download the file and open it in Microsoft Excel, Apple Numbers, or any compatible spreadsheet application.
CSV — Download the comma-separated values file for use in data applications, databases, or legacy spreadsheet software.
Customization Tips
- 💡Create separate tabs for each property.
- 💡Use conditional formatting for overdue payments.
- 💡Export annual data for tax preparation.
Use Cases
- Landlord rent collection tracking
- Property income management
- Tenant payment monitoring
Download or Copy
Disclaimer: This template is for tracking and educational purposes only. It does not provide financial, investment, tax, or legal advice.
Frequently Asked Questions
Yes. Free to download.
Yes. Each tenant has their own row.
Yes. Outstanding balances are calculated automatically.
Yes. Download as CSV for tax preparation.
Related Templates
Last updated: 2026-06-19