# Owners association meetings and decisions tracker

> Owners and shares, a meetings log, attendance in person, by proxy or absent, quorum check against your set percentage, votes by shares, and open decisions.

Source: https://softwiro.com/templates/hoa-meetings-decisions
Language: English
Softwiro, softwiro.com

---

Free Excel template

A free Excel sheet for homeowners' association (HOA) general assembly meetings. You record the owners and each owner's share, then the meetings and whether each owner attended in person, by proxy or was absent. The sheet calculates the attendance percentage by shares and compares it with the quorum percentage you type in the settings. Then you record decisions and the owners' votes by shares, and the sheet gives you the result of each decision and lists the approved decisions that have not been carried out yet.

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

Excel file (.xlsx) · 206 KB · 9 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

| رقم الاجتماع | التاريخ | الموضوع | حصص الحاضرين | نسبة الحضور | النصاب |
| --- | --- | --- | --- | --- | --- |
| M01 | 46091 | اعتماد الميزانية السنوية | 670 | 54.5% | مكتمل |
| M02 | 46188 | مناقشة عقود الخدمات | 450 | 36.6% | غير مكتمل |
| M03 | 46300 | إصلاح المصعد وتجديد عقد الحراسة | 1,050 | 85.4% | مكتمل |
| M04 | 46346 | اجتماع قادم: متابعة تنفيذ القرارات | 0 |  | لم يُسجَّل حضور |

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

## What is inside

- "الإعدادات" (Settings): The quorum percentage, the approval percentage required for a decision, and today's date. The two percentages in the example are for trial only; enter what your association's bylaws state.
- "الملاك" (Owners): For each unit: code, owner, mobile, unit area and share, then the owner's percentage of the total and the number of times they attended and were absent.
- "الاجتماعات" (Meetings): Meeting number, date and subject, then the number attending in person, by proxy and absent, the shares present and the attendance percentage of shares, and whether the quorum is met against the percentage you set.
- "الحضور" (Attendance): For each meeting, the status of each owner: in person, by proxy or absent, with a note such as the proxy's name. The owner's name and share appear automatically, with a warning for a duplicate row or a code that does not exist.
- "القرارات" (Decisions): Decision number, its meeting, its text, the shares voting yes, no and abstaining, the person responsible, the due date and the status. It then shows the meeting quorum, the approval percentage and the result (approved, rejected, not valid or not voted) and follow-up on execution.
- "غير المنفذة" (Not carried out): An automatic list of approved decisions that have not been carried out or cancelled, nearest due date first, with overdue ones highlighted.
- "الملخص" (Summary): The number of owners and total shares, the number of meetings with and without a quorum, the number of decisions by result, the execution rate of approved decisions, and the number not carried out and overdue.

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

## What makes it different

Instead of adding up the shares present at each meeting on a calculator, you enter attendance and see at once whether the quorum was met. You enter the votes by shares and see the result of each decision. Open "غير المنفذة" (Not carried out) to see what the owners decided that has not been done, who is responsible and when it is due.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter the quorum percentage, the required approval percentage as your bylaws state them, and today's date. The numbers already there are examples only.
2. In the "الملاك" (Owners) sheet, record for each unit: code, owner, mobile, unit area and share (number of shares, or the share your bylaws define).
3. In the "الاجتماعات" (Meetings) sheet, record each meeting with its number, date and subject.
4. In the "الحضور" (Attendance) sheet, record for each meeting the status of each owner: in person, by proxy or absent. The "الاجتماعات" (Meetings) sheet then calculates the attendance percentage by shares and whether the quorum is met.
5. In the "القرارات" (Decisions) sheet, record each decision with its number, meeting, text, the shares voting yes, no and abstaining, the person responsible, the due date and the status.
6. The sheet calculates the result of each decision, "غير المنفذة" (Not carried out) lists approved decisions not yet carried out, and "الملخص" (Summary) pulls the whole picture together.

**Before you start:**

- The quorum and approval percentages in the settings are trial numbers only, not a legal reference. Check your association's bylaws, enter the percentage they state, and change it whenever it changes.
- Attendance percentage = shares present (in person or by proxy) ÷ total shares of all owners. The quorum is met when the percentage reaches the quorum percentage or exceeds it.
- Approval percentage of a decision = shares voting yes ÷ (yes + no + abstain). A decision is approved if the approval percentage reaches the required percentage and its meeting's quorum is met.
- An owner with no row in "الحضور" (Attendance) for a meeting is not counted as present. Record absent owners too if you want a complete record.
- A share can equal unit area, number of shares or any basis your bylaws define; enter it the same way for all owners.
- The sheet holds 200 owners, 200 meetings, 2000 attendance rows and 500 decisions, and "غير المنفذة" (Not carried out) shows the first 50 decisions.

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

Excel file (.xlsx) · 206 KB · 9 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: HOA meetings and decisions (1/3)](https://softwiro.com/uploads/cheatsheets/hoa-meetings-decisions/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/hoa-meetings-decisions/en-1.jpg)[![Cheat sheet: HOA meetings and decisions (2/3)](https://softwiro.com/uploads/cheatsheets/hoa-meetings-decisions/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/hoa-meetings-decisions/en-2.jpg)[![Cheat sheet: HOA meetings and decisions (3/3)](https://softwiro.com/uploads/cheatsheets/hoa-meetings-decisions/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/hoa-meetings-decisions/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

### Where do the quorum and approval percentages come from?

The sheet does not assume a legal percentage. You type both in the "الإعدادات" (Settings) sheet as your association's bylaws state them; the numbers in the example are for trial only. Change them whenever the bylaws change and all results update immediately.

### How is the attendance percentage calculated?

Attendance percentage is the total shares of those who attended in person or by proxy, divided by the total shares of all owners. An owner with no row in "الحضور" (Attendance) for that meeting is not counted as present.

### How is the result of a decision calculated?

If the quorum of the decision's meeting is met, the approval percentage = shares voting yes ÷ (yes + no + abstain). The decision is approved if that percentage reaches the required percentage or exceeds it; otherwise it is rejected. If the quorum is not met, the result is "not valid".

### What is a share? Is it the same as area?

A share is a field where you enter whatever your bylaws define, whether number of shares, unit area or something else. The sheet calculates each owner's percentage of the total you entered. Use the same basis for all owners.

### 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: Owners associations and compounds

## More free templates

- Owners' association dues collection tracker
- Owners' association budget and expenses sheet
- Reserve and emergency fund sheet for owners' associations
- Maintenance requests and complaints log for owners' associations
- Service contracts and suppliers tracker for owners' associations
- Shared electricity and water bill splitter for building units
- Residents, units and vehicles register for an owners' association
- Monthly transparency report for owners' associations
- Compound assets and periodic maintenance sheet
- Gate and security sheet
- Compound shared facilities booking sheet
- Building maintenance sheet: flat fees, expenses, elevator and pump
- Gym memberships tracker (Excel)
- Beauty salon bookings tracker (Excel)
- Car workshop job orders tracker (Excel)
- Nursery and school fees tracker (Excel)
- Tutoring center manager (Excel)
- Poultry farm cycle tracker (Excel)
- Crop season expenses and revenue tracker (Excel)
- Racing pigeon loft sheet

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