Rent Payment Tracker for Google Sheets

Track rental payments with this free Google Sheets rent payment tracker. Log tenant payments, due dates, and outstanding balances. Download Excel and CSV. No signup required.

Google SheetsExcelCSV

Copy Google Sheets Download Excel Download CSV

Cost

Free

Signup

No signup

Formats

Sheets, Excel, CSV

Best for

Finance

Updated

2026-06-19

What Is This Rent Tracker GS Template?

This Google Sheets 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 Google Drive.

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

Google Sheets — Copy the template directly to your Google Drive. You can edit, share, and use it online from any device.

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

Copy Google Sheets Download Excel Download CSV

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 copy or download.

Yes. Each tenant has their own row.

Yes. Outstanding balances are calculated automatically.

Yes. Download as CSV for tax preparation.

Related Templates

Real Estate Excel Template

Manage rental properties with this free real estate Excel template. Track income, expenses, tenants, and property performance. Also works in Google Sheets. No signup required.

finance

ExcelGoogle SheetsCSV

View Template

Bill Tracker Template for Google Sheets

Never miss a payment with this free Google Sheets bill tracker. Track due dates, amounts, payment status, and recurring bills all in one place. Download Excel and CSV. No signup required.

finance

Google SheetsExcelCSV

View Template

Budget Planner Template for Google Sheets

Plan and manage your monthly finances with this free budget planner for Google Sheets. No signup required — copy or download. Track income, fixed and variable expenses, savings goals, and net balance.

finance

Google SheetsExcelCSV

View Template

Expense Tracker Template for Google Sheets

Track every expense with this free Google Sheets expense tracker. Log daily spending, categorize transactions, and review monthly summaries. Download Excel and CSV versions. No signup required.

finance

Google SheetsExcelCSV

View Template

Invoice Tracker Template for Google Sheets

Track all your invoices in one place with this free Google Sheets invoice tracker. Monitor payment status, due dates, client payments, and outstanding balances. No signup required.

business

Google SheetsExcelCSV

View Template

Last updated: 2026-06-19

Copy Google Sheets