• May include: A digital Real Estate & Rent Management Excel template dashboard featuring data tables, a monthly bar chart, and a pie chart. The interface displays property metrics, lease schedules, payment tracking, and tenant arrears in a structured layout.
  • May include: A digital real estate and rent management dashboard template in Excel format. The interface displays key performance indicators, occupancy rates, rent due versus collected data, a monthly bar chart, and a list of tenants in arrears.
  • May include: A digital spreadsheet template titled Units & Leases featuring two main tables: Tenants & Leases Register and Properties & Units Register. The layout includes columns for lease numbers, tenant names, contact details, dates, and financial data.
  • May include: A digital spreadsheet titled Rent Schedule & Payments featuring columns for lease numbers, tenant names, due dates, rent amounts, and payment statuses. It includes sections for automatic rent schedules and cheque tracking.
  • May include: A digital Tenant Statement spreadsheet template featuring sections for lease details, account summaries, and payment schedules. The document includes columns for lease status, rent schedules, and payments received, with text labels in English and a sample property management header.
  • May include: A digital Real Estate & Rent Management Excel template dashboard featuring data tables, a monthly bar chart, and a pie chart. The interface displays property metrics, lease schedules, payment tracking, and tenant arrears in a structured layout.
  • May include: A digital real estate and rent management dashboard template in Excel format. The interface displays key performance indicators, occupancy rates, rent due versus collected data, a monthly bar chart, and a list of tenants in arrears.
  • May include: A digital spreadsheet template titled Units & Leases featuring two main tables: Tenants & Leases Register and Properties & Units Register. The layout includes columns for lease numbers, tenant names, contact details, dates, and financial data.
  • May include: A digital spreadsheet titled Rent Schedule & Payments featuring columns for lease numbers, tenant names, due dates, rent amounts, and payment statuses. It includes sections for automatic rent schedules and cheque tracking.
  • May include: A digital Tenant Statement spreadsheet template featuring sections for lease details, account summaries, and payment schedules. The document includes columns for lease status, rent schedules, and payments received, with text labels in English and a sample property management header.
Report this item to Etsy

Rental Property Management Excel Template, Landlord Rent Tracker, Lease & Tenant Tracker, Rent Schedule, Arrears and Net Income Spreadsheet

Item highlights

  • Digital download
  • Digital file type(s): 1 ZIP

Seller's description

Manage your rental properties in one Excel workbook.
Enter each unit and lease once – the template builds the rent schedule and calculates payments, arrears, occupancy and net income for you.

WHAT'S INCLUDED
• Properties & units: a unique code for every unit; status is calculated from the leases (Let / Reserved / Vacant / Maintenance).
• Tenants & leases: tenant details, ID / company no., phone, start and end dates, monthly rent, deposit, lease registration / ref. and early move-out.
• Payment cycle per lease: Monthly, Quarterly, Semi-annual or Annual – with an automatic rent schedule.
• Optional VAT for commercial units (rate editable, or set to 0%).
• Payments received: several payments per instalment; each payment is allocated automatically to the oldest unpaid instalment.
• Arrears include part payments after the grace period, with days overdue and arrears ageing.
• Cheques / post-dated payments: number, bank, date, amount and status (Pending / Cleared / Bounced) with alerts.
• Leases expiring within 30 / 60 / 90 days.
• Expenses & maintenance per property or unit, and net income per property for any period.
• Printable A4 tenant statement.
• Dashboard: occupancy, rent due vs collected for the last 12 months, arrears, deposits held, cheques and the top 10 tenants in arrears.
• Editable currency (€ by default; £, CHF, kr, zł, $ …).
• Protected formulas to prevent mistakes, no macros, works with any regional settings.

WHO IS IT FOR?
Landlords, property managers and small letting agencies who want to track leases, rent collection and arrears without a monthly software subscription.

WHAT YOU GET
• A demo file with sample data + an empty file for your own data.
• README file with step-by-step quick start.
• Sheets are protected; the password to unprotect and customise is in the README.
• Works in Microsoft Excel 2010 or later / Microsoft 365 (Windows and Mac).

PLEASE NOTE
• This template is a tracking tool. It is not a tax invoice and not a legal lease agreement, and it does not replace any official lease registration.
• Digital product: nothing will be shipped. You receive an Excel file, not software.
• Designed for Microsoft Excel. Google Sheets and Numbers are not supported.

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$5.76

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

May include: A digital Real Estate & Rent Management Excel template dashboard featuring data tables, a monthly bar chart, and a pie chart. The interface displays property metrics, lease schedules, payment tracking, and tenant arrears in a structured layout.

Manage your rental properties in one Excel workbook.
Enter each unit and lease once – the template builds the rent schedule and calculates payments, arrears, occupancy and net income for you.

WHAT'S INCLUDED
• Properties & units: a unique code for every unit; status is calculated from the leases (Let / Reserved / Vacant / Maintenance).
• Tenants & leases: tenant details, ID / company no., phone, start and end dates, monthly rent, deposit, lease registration / ref. and early move-out.
• Payment cycle per lease: Monthly, Quarterly, Semi-annual or Annual – with an automatic rent schedule.
• Optional VAT for commercial units (rate editable, or set to 0%).
• Payments received: several payments per instalment; each payment is allocated automatically to the oldest unpaid instalment.
• Arrears include part payments after the grace period, with days overdue and arrears ageing.
• Cheques / post-dated payments: number, bank, date, amount and status (Pending / Cleared / Bounced) with alerts.
• Leases expiring within 30 / 60 / 90 days.
• Expenses & maintenance per property or unit, and net income per property for any period.
• Printable A4 tenant statement.
• Dashboard: occupancy, rent due vs collected for the last 12 months, arrears, deposits held, cheques and the top 10 tenants in arrears.
• Editable currency (€ by default; £, CHF, kr, zł, $ …).
• Protected formulas to prevent mistakes, no macros, works with any regional settings.

WHO IS IT FOR?
Landlords, property managers and small letting agencies who want to track leases, rent collection and arrears without a monthly software subscription.

WHAT YOU GET
• A demo file with sample data + an empty file for your own data.
• README file with step-by-step quick start.
• Sheets are protected; the password to unprotect and customise is in the README.
• Works in Microsoft Excel 2010 or later / Microsoft 365 (Windows and Mac).

PLEASE NOTE
• This template is a tracking tool. It is not a tax invoice and not a legal lease agreement, and it does not replace any official lease registration.
• Digital product: nothing will be shipped. You receive an Excel file, not software.
• Designed for Microsoft Excel. Google Sheets and Numbers are not supported.

  • Item type
    Digital download
  • Digital file type(s)
    1 ZIP
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Landlord Planner

Landlord

Property Planner

Landlord Starter Kit

Landlord Template

Rental Property Planner

Landlord Tracker Uk

Listed on Oct 24, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates