Free Rent Payment Tracker Spreadsheet (Excel, Google Sheets)

This free, editable, and printable rental property tracker is designed for DIY landlords, real estate agents, and investors. It’s a powerful tool for property owners and real estate investors to track monthly rent payments, organize each property address, and stay on top of property maintenance.

I like to keep things simple. Managing rental properties has many elements, especially ensuring any outstanding balance on rent is paid. This free rental property payment tracker is designed to keep you organized, streamline tracking rent payments, and give you a clear overview of your income and expenses. If you need a more detailed log, I also have a rent ledger spreadsheet template available for free.

For each separate rental property you have, I would recommend having this spreadsheet. It will help you better understand how accounting works for your rentals and could save you money on tax return preparation.

How to Use the Rental Property Tracker Spreadsheet

This simple spreadsheet template is designed to be intuitive. Follow these steps to get started:

1. Enter Property and Tenant Details: Fill in the basic information for each property and the corresponding tenant.
2. Input Monthly Rent and Due Dates: Log the rent amount and the date it’s due each month.
3. Mark Payments and Method Used: When a payment is received, update the status, date paid, and the method (e.g., bank transfer, check).
4. Review Profit/Loss in the Summary: The spreadsheet automatically calculates your income, expenses, and net profit for a clear financial overview.
5. Print Reports at Tax Time: Use the organized data to easily prepare your financial records for tax season.

FAQs About the Rent Tracker Spreadsheet