In this article:

Free Rental Property Template for Google Sheets (2024 Update)

December 5, 2024

Free Google Sheets Rental Property Template

You can make a copy of this rental property spreadsheet template in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.

google sheets rental property template

How to Use the Rental Property Spreadsheet Template in Google Sheets

Below we explain how to use our rental property spreadsheet template in Google Sheets:

Property Address & Unit Number

Fill in the full address of the rental property. If the property has multiple units, specify the unit number.

rental property spreadsheet template google sheets

Tenant Name

Enter the name of the tenant occupying the unit.

free google sheets rental property template

Lease Start Date & Lease End Date

Enter the start and end dates of the lease agreement in the format YYYY-MM-DD.

rental property template in google sheets

Monthly Rent

Enter the amount of rent the tenant is required to pay each month.

rental property spreadsheet template in google sheets

Security Deposit

Enter the amount of the security deposit collected at the start of the lease.

free google sheets rental property spreadsheet template

Rent Due Date

Specify the day of the month by which the rent is due (e.g., 1st).

google sheets free rental property template

Last Payment Date

Enter the date when the last rent payment was received in the format YYYY-MM-DD.

rental property spreadsheet template for google sheets

Last Payment Amount

Enter the amount of the last payment received from the tenant.

rental property template for google sheets

Outstanding Balance

If the tenant owes any past due rent, enter the amount here. Otherwise, enter $0.

rental property template in google sheets

Notes

Use this column to add any relevant notes about the tenant, unit, or lease agreement (e.g., repair needs, lease violations, etc.).

google sheets rental property free template

We hope that this article has helped you and given you a better understanding of how to use our free Google Sheets rental property template. If you enjoyed this article, you might also want to check out our Google Sheets mileage log template and call sheet template in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->