Home › Rental & Property › Rental Property Spreadsheet for Landlords (10 Units)

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 Landlords (10 Units)

If you rent out a few units, a clear record of rent, expenses and maintenance saves time at tax season and every month before it. The Rental Record keeps them in one connected workbook for up to 10 residential units.

Add your units and leases, record payments, expenses and maintenance, and the Dashboard, the By Property view and the Annual Summary update by themselves. The rent ledger fills in monthly charges from your leases and shows paid, partial, overdue and vacant months.

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

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

What this spreadsheet tracks

Up to 10 units grouped into properties, with automatic occupancy
Up to 40 lease records, with deposits and leases ending within 60 days
A rent ledger with paid, partial, overdue and vacant status and days late
Up to 800 receipts: rent, late fees, pet rent and other income
Up to 400 expenses with categories and an Operating, Capital or Financing class
Maintenance work orders, a By Property view and an annual summary

Who it's for

Landlords with up to 10 rental units
Owners who want income, expenses and maintenance in one file
Small landlords who prefer a spreadsheet to property management software

How it works

Choose the reporting year and rent due day on Start Here.
Add your units, then your leases.
Record payments, expenses and maintenance as they happen.
Review the Dashboard and the By Property sheet.

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.

What if I have more than 10 units?

Choose the 50-unit version, The Rental Record Pro.

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.

For larger portfolios, see the 50-unit version of this spreadsheet below.

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 50 units, shown with its dashboard.

Rental Property Tracker for Multi-Family Landlords (50 Units)Manage rent and records for up to 50 units in one workbook.

Ready to get organized?