Home › Rental & Property › Rental Property Tracker for Multi-Family Landlords (50 Units)

The Rental Record, a rental property spreadsheet for Excel and Google Sheets with up to 50 units, shown with its dashboard.

Rental Property Tracker for Multi-Family Landlords (50 Units)

A larger portfolio needs a record that stays clear as it grows. The Rental Record Pro has the same layout as the 10-unit version, with room for up to 50 residential units and years of payment history.

Track rent, payments, unpaid balances, expenses, tenants, leases and maintenance across many units and properties. The Dashboard, the By Property view and the Annual Summary update as you enter your information, and the property totals show income, costs, occupancy and unpaid rent for each building.

It is a digital download for Excel and Google Sheets, made for US landlords.

Digital download. Works in Excel and Google Sheets. Nothing is shipped.

What this spreadsheet tracks

Up to 50 units grouped into properties, with automatic occupancy
Up to 200 lease records, with deposits and leases ending within 60 days
600 monthly rent charges that fill in from your leases
Up to 3,500 receipts and 1,500 expenses
Up to 300 maintenance work orders
Property-level totals for portfolios with many buildings, and an annual summary

Who it's for

Landlords and small property managers with many units
Owners of several properties who want a rent roll in one file
Landlords who have outgrown the 10-unit version

How it works

Choose the reporting year and rent due day on Start Here.
Add your units grouped by property, then your leases.
Record payments, expenses and maintenance.
Review the Dashboard, By Property and the Annual Summary.

See inside

Rental property dashboard with rent billed, rent received, uncollected rent, other income, operating expenses, operating surplus, occupancy and charts.

Rent ledger of the rental property spreadsheet showing monthly rent charges with paid, partial, overdue and vacant status and days late.

Payments and expenses tabs of the rental property spreadsheet, with rent receipts, late fees and categorized expenses.

Properties and units tab of the rental property spreadsheet, with units grouped into properties and automatic occupancy.

How the rental property spreadsheet works: add your units and leases, record payments and expenses, then review the dashboard.

What is included with the rental property spreadsheet: the Excel workbook, the Google Sheets link and a quick start guide.

Frequently asked questions

Does it work in Excel and Google Sheets?

Yes. You get an Excel workbook and a PDF guide with a link to make your own copy in Google Sheets. The two versions are separate files.

Do I need this version for fewer than 10 units?

No. The 10-unit version has the same layout with smaller limits.

Is this accounting or tax software?

No. It is a record-keeping and tracking spreadsheet. It does not replace an accountant or give tax advice.

More in Rental & Property

Rent payment ledger spreadsheet for Excel and Google Sheets, shown with its dashboard

Rent Payment Ledger Spreadsheet for Excel & Google SheetsRecord every rent payment, see each tenant's balance and spot late payments month by month.

The Rental Record, a rental property spreadsheet for Excel and Google Sheets with up to 10 units, shown with its dashboard.

Rental Property Spreadsheet for LandlordsTrack rent and expenses for your rental property.

Ready to get organized?