How is a tenant's debt calculated?

The amount charged for started months from the lease start date minus the amount paid; an overpayment is shown with a minus sign.

When is a lease considered "Ending soon"?

When no more than the set number of days remain until the end; the default is 60.

How does the spreadsheet know a property is rented?

If there is an active lease for that property as of today.

Can I track deposits?

Yes. The deposit amount is entered in the lease and stored in the spreadsheet.

← All templates

Rental Property Management in Excel — Tenants, Leases and Payments Template

Properties, tenants, leases and payments: amounts charged and paid, arrears, lease expiry, occupancy and monthly income.

590 ₽

≈ 7 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Do you rent out apartments, offices or garages? The spreadsheet shows, for each lease, how much has been charged to date, how much has been paid and the outstanding debt, which properties are vacant and which leases are close to ending.

What is inside

"Properties": up to 100 properties, with the status "Rented" or "Vacant", tenant and rate.
"Tenants": contact details.
"Leases": up to 300 leases with dates, rent amount, payment day, deposit, amount charged, paid, debt and status.
"Payments": a log of receipts by lease number.
"Summary": occupancy, monthly income, arrears, upcoming expiries and a chart.

Who it is for

Property owners and managers, landlords of apartments, offices, garages and warehouses, and small property management companies.

What you get

The download includes a blank template and a filled-in sample with fictitious data, so you can see how the formulas and checks work. It is an Excel spreadsheet with ordinary formulas, not an accounting program. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The file is in English. Thresholds are set in the settings: adjust them to your needs. Calculations are approximate.

Questions and answers

How is a tenant's debt calculated?: The amount charged for started months from the lease start date minus the amount paid; an overpayment is shown with a minus sign.
When is a lease considered "Ending soon"?: When no more than the set number of days remain until the end; the default is 60.
How does the spreadsheet know a property is rented?: If there is an active lease for that property as of today.
Can I track deposits?: Yes. The deposit amount is entered in the lease and stored in the spreadsheet.