Landlord Rent Roll Spreadsheet | Excel + Google Sheets | Lease, Maintenance & Rent Review Tracker

Which leases are ending soon, and how does current rent compare with your market-rent estimates? This editable Excel + Google Sheets rent roll organizes up to 100 rental units, lease dates, maintenance spending, and rent-review notes in one workbook. Includes 5 linked tabs and space for 300 maintenance entries. Instant digital download: one blank .xlsx workbook plus a PDF with a clickable link to make your own Google Sheets copy.

Use Microsoft Excel or a Google account for Google Sheets; software is not included.

WHAT YOU GET

• 1 blank, editable Excel workbook (.xlsx) with 5 linked tabs
• Google Sheets Access PDF with template-copy link and setup instructions
• Rent Roll: space for 100 units, including property, unit, resident, resident-since date, lease dates and status, current rent, market rent, deposit, market gap, and lease alerts
• Maintenance Log: space for 300 dated entries with property, unit, category, description, cost, optional responsibility status, and notes
• Rent Review: current and market rent, last raise date and amount, lease end, maintenance totals, proposed rent, and decision notes
• Owner Summary: current property and portfolio rent totals, plus maintenance spending for a selected year, with no resident names
• Start Here instructions inside the workbook

HOW IT WORKS

Enter one row per unit. Log maintenance using the same property and unit names. The workbook calculates monthly and annual rent gaps, maintenance spending by unit for your selected year and during the current tenancy, and lease alerts. Use Rent Review to record your proposed rent and notes.

PLEASE NOTE

This is an instant digital download. No physical item will be shipped. Both spreadsheet versions start blank; the sample data in listing photos is for preview only. Market rent is entered by you; the workbook does not estimate it. Maintenance spending during a tenancy does not mean the resident caused the expense. This is an organizational tool, not legal or accounting advice. © Keys & Keep Property.

For your own business use; please do not resell or redistribute the file.

Device compatibility

Download to your phone, tablet, or computer. Open the Excel workbook with a compatible spreadsheet app, such as Microsoft Excel. If Google Sheets is included, use the separate access PDF to make your own editable copy. A larger screen may be helpful for detailed spreadsheets and printing. ZIP files must be extracted before opening their contents.

Available features, layout, and printing options can vary by device and app. Software is not included.