# Rental portfolio tracker

> For owners with several buildings: properties, units, tenants, contracts and payments, overdue tenants by name and phone, renewals and a monthly report.

Source: https://softwiro.com/templates/rental-portfolio
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Rental portfolio tracker: properties, units, tenants and contracts

A free Excel sheet for owners with more than one property and several units in each. You enter your properties, their units, the tenants, their contracts and their payments. The sheet shows the status of each unit (rented or vacant), who is in arrears by name and phone, which contracts will end soon so you can renew them, and a monthly report for each property with expected rent, collected rent, expenses and net income. It differs from a property rent collection sheet in that it links each property to its units and to tenant contracts, so it holds more than one property and more than one contract per unit over the years.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-rental-portfolio.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-rental-portfolio-blank.xlsx)

Excel file (.xlsx) · 323 KB · 13 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| كود العقار | اسم العقار | الوحدات | مؤجرة | الإشغال | الإيجار الشهري الحالي | المتأخر | الصافي (محصّل − مصروفات) |
| --- | --- | --- | --- | --- | --- | --- | --- |
| P01 | عمارة النيل | 3 | 2 | 66.7% | 10,500.00 | 10,000.00 | 103,500.00 |
| P02 | برج الياسمين | 2 | 1 | 50.0% | 6,000.00 | 19,500.00 | 117,850.00 |
| P03 | مجمع الورود التجاري | 3 | 2 | 66.7% | 17,000.00 | 8,000.00 | 57,000.00 |

Example from the “العقارات” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "الإعدادات" (Settings): Today's date, the number of days before a contract ends at which you get an alert (60 days in the example), and the month you want reported.
- "العقارات" (Properties): For each property: number of units, rented and vacant units, occupancy rate, current monthly rent, and amounts due, collected, overdue, expenses and net.
- "الوحدات" (Units): For each unit: its property, type, area and suggested rent, then its status (rented or vacant), current tenant name and rent.
- "المستأجرون" (Tenants): Each tenant's name, phone and ID, with the number of their contracts and what they owe in arrears.
- "العقود" (Contracts): One contract per unit and tenant with start and end dates, monthly rent and deposit, then its status (active, ending soon, expired or not started) and installments due, paid and overdue.
- "الدفعات" (Payments): A record of each payment with the contract number, amount and the month it covers. The property, unit and tenant appear automatically.
- "المصروفات" (Expenses): Expenses for each property (maintenance, electricity, water, taxes and security) with date and type.
- "المتأخرون" (Overdue tenants): An automatic list of every contract in arrears, largest first, with the tenant's name, phone, property, unit, months overdue and amount.
- "التجديدات" (Renewals): A list of contracts that will end within the alert period, soonest first, with the tenant, phone, end date and days remaining.
- "التقرير الشهري" (Monthly report): For each property in the month you choose: expected rent, collected rent, collection rate, expenses and net, with a total for all properties.
- "الملخص" (Summary): Rented and vacant units and occupancy, contracts by status, monthly rent, collected, overdue, expenses and net, and the property with the highest net.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

You open the "المتأخرون" (Overdue tenants) sheet and see who is in arrears by name and phone, without adding up payments and subtracting them from rents. You open "التجديدات" (Renewals) and know which contract is ending before it surprises you. From "التقرير الشهري" (Monthly report) you see how much each property earned and how much was spent on it, and which vacant unit is costing you lost rent.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter today's date (or =TODAY() so it updates by itself), the number of days before contract end for an alert, and the month you want reported.
2. In the "العقارات" (Properties) sheet, enter each property once with a unique code (such as P01), its name and address.
3. In the "الوحدات" (Units) sheet, enter each unit with its code (such as P01-01) and choose its property from the list, with its type, area and suggested rent.
4. In the "المستأجرون" (Tenants) sheet, enter each tenant once with a code (such as T001), name, phone and ID number.
5. In the "العقود" (Contracts) sheet, open a row for each contract: choose the unit and the tenant, and enter the start and end dates, monthly rent and deposit.
6. In the "الدفعات" (Payments) sheet, record each payment you receive: its date, the contract number, the amount and the month it covers.
7. Open "المتأخرون" (Overdue tenants) to see who is in arrears by name and phone, "التجديدات" (Renewals) to see contracts about to end, "التقرير الشهري" (Monthly report) for each property, and "الملخص" (Summary) for the full picture.

**Before you start:**

- Rent falls due monthly on the contract's start day. A contract that starts on January 15 has its first installment due on January 15 and the second on February 15, and so on up to today or the contract end, whichever is earlier.
- Overdue = installments due up to today - total contract payments. If a tenant pays in advance the figure is negative and is not counted as arrears.
- Contract status: "active", or "ending soon" if the days left until its end are the number in the settings or fewer, or "expired", or "not started". A unit is "rented" while it has an active or ending-soon contract, otherwise "vacant".
- The monthly report calculates expected rent from contracts that cover the chosen month, collected rent from payments dated in that same month (which may include arrears from earlier months), and expenses by their date.
- The sheet holds 50 properties, 500 units, 500 tenants, 500 contracts, 2000 payments and 1000 expenses, and the "المتأخرون" (Overdue tenants) and "التجديدات" (Renewals) lists show the first 50 rows.
- The sheet does not calculate late fees or annual rent increases; enter the new rent in a new contract when you renew.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-rental-portfolio.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-rental-portfolio-blank.xlsx)

Excel file (.xlsx) · 323 KB · 13 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: rental portfolio management (1/3)](https://softwiro.com/uploads/cheatsheets/rental-portfolio/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/rental-portfolio/en-1.jpg)[![Cheat sheet: rental portfolio management (2/3)](https://softwiro.com/uploads/cheatsheets/rental-portfolio/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/rental-portfolio/en-2.jpg)[![Cheat sheet: rental portfolio management (3/3)](https://softwiro.com/uploads/cheatsheets/rental-portfolio/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/rental-portfolio/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### How are the due installments calculated?

An installment falls due on the contract's start day each month. A contract that starts on January 15 has its first installment due on January 15 and its second on February 15. The sheet counts the installments whose date has come, up to today or the contract end, whichever is earlier, then multiplies them by the monthly rent.

### What if a tenant pays in advance?

The overdue amount becomes negative (a credit for the tenant) and it is not included in the "المتأخرون" (Overdue tenants) list or in the total overdue.

### What happens when a contract is renewed?

Add a new contract row for the same unit and tenant with its date and the new rent. The old contract stays "expired" with its dates and payments, and the unit shows as rented under the new contract.

### How many properties and units does the sheet hold?

50 properties, 500 units, 500 tenants, 500 contracts, 2000 payments and 1000 expenses. The overdue and renewals lists show the first 50 rows.

### Does it calculate late fees or annual rent increases?

No. Enter the annual increase in a new contract when you renew, and record any late fee outside the sheet.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Compound and owners' association sheets: dues, maintenance and property](https://softwiro.com/templates/for-compound)

More free templates for: Real estate

## More free templates

- Real estate leads and units tracker
- Rent collection tracker for properties
- Serviced apartments and short-stay bookings sheet
- Pharmacy expiry and stock tracking sheet
- Business expenses and monthly budget sheet
- Lead and deal pipeline tracker
- Employee attendance sheet
- Employee payroll and attendance
- General shop inventory tracker (stock in/out, reorder, slow movers)
- Monthly savings circle (gamaeya) tracker
- Clinic appointments tracker (Excel)

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
