# Monthly savings circle (gamaeya) tracker (free Excel)

> Savings circle (gamaeya) sheet: members, shares, collection order, instalment log, arrears, monthly payout, summary and a printable monthly statement.

Source: https://softwiro.com/templates/gamaeya-savings-circle
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Monthly savings circle (gamaeya) tracker

A free Excel sheet for running a monthly savings circle, known in Egypt as a gamaeya (a coworkers' or family rotating savings group). You enter the members, each member's number of shares and the share value, set the order in which members collect, and log every instalment paid. The sheet calculates each member's monthly instalment, their arrears, what they collect in their month, what has been collected this month and what remains. It gives you a print-ready monthly statement. The sheet records and shows the figures to everyone. It does not itself guarantee that any instalment is collected.

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

Excel file (.xlsx) · 83 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

| الكود | اسم العضو | عدد الأسهم | القسط الشهري | إجمالي المدفوع | المتأخر | إجمالي ما يقبضه | الحالة |
| --- | --- | --- | --- | --- | --- | --- | --- |
| G01 | أحمد سالم | 2 | 2,000.00 | 10,000.00 | 0.00 | 20,000.00 | مدفوع هذا الشهر |
| G02 | منى حسن | 1 | 1,000.00 | 3,000.00 | 1,000.00 | 10,000.00 | متأخر |
| G03 | خالد عمر | 1 | 1,000.00 | 6,000.00 | 0.00 | 10,000.00 | مدفوع هذا الشهر |
| G04 | سارة يوسف | 2 | 2,000.00 | 10,000.00 | 0.00 | 20,000.00 | مدفوع هذا الشهر |
| G05 | طارق مجدي | 1 | 1,000.00 | 3,500.00 | 500.00 | 10,000.00 | متأخر |
| G06 | هبة سمير | 1 | 1,000.00 | 4,500.00 | 0.00 | 10,000.00 | لم يدفع هذا الشهر |
| G07 | ياسر فؤاد | 1 | 1,000.00 | 3,000.00 | 1,000.00 | 10,000.00 | متأخر |
| G08 | نادية رشاد | 1 | 1,000.00 | 5,000.00 | 0.00 | 10,000.00 | مدفوع هذا الشهر |

Example from the “الأعضاء” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "الإعدادات" (Settings): The circle's name, the monthly share value, the start date of the first month, the number of months and today's date. The sheet calculates total shares, the monthly payout and the current month number, and warns you if the number of months differs from total shares.
- "الأعضاء" (Members): For each member: code, name, phone and number of shares. The sheet then calculates the monthly instalment, total paid, amount due for previous months, arrears, paid and remaining this month, number of payouts, total they collect and their status.
- "الشهور" (Months): Each month's number and the code of the member who collects in it, then the month's date, the collector's name, the payout, what was actually collected, the remainder, the month's status (past, current or upcoming) and a "payout handed over?" cell.
- "الدفعات" (Payments): Each instalment with its date, member code, the month number it pays for, amount, payment method and a note, plus the member's name, which appears automatically.
- "المتابعة" (Tracking): A matrix with members in the rows and months in the columns showing what each member paid in each month. It colors any cell below the instalment in months whose due date has arrived.
- "كشف الشهر" (Monthly statement): A print-ready statement for any month you choose (or the current month if you leave the cell empty): the collector, payout, amount collected and remainder, and for each member their instalment, amount paid, arrears, remaining balance and a signature cell.
- "الملخص" (Summary): The number of members, shares and the payout; the current month, its collector, what was collected, what remains and the collection rate; total arrears and the number of late members; total collected since the start, the number of payouts handed over and who collects next month.

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

## What makes it different

Open the "كشف الشهر" (Monthly statement), print it and post it or send it, so every member sees what they owe and what they have paid. The "الملخص" (Summary) shows how much of this month's payout has been collected, how much remains and who is late. You do not go through the instalment notebook member by member.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter the circle's name, the monthly share value, the start date of the first month, the number of months (usually equal to total shares) and today's date.
2. In the "الأعضاء" (Members) sheet, enter for each member: code, name, phone and number of shares. The sheet calculates their monthly instalment and what they will collect.
3. In the "الشهور" (Months) sheet, enter each month's number and the code of the member who collects in it. A member with two shares appears in two months.
4. In the "الدفعات" (Payments) sheet, log every instalment you receive: date, member code, the month number it pays for and the amount.
5. The "المتابعة" (Tracking) sheet shows a matrix of members and months with what each member paid in each month, and colors any short cell.
6. The "كشف الشهر" (Monthly statement) sheet is ready to print for any month you choose, and the "الملخص" (Summary) sheet shows what has been collected and what remains in the current month, and total arrears.

**Before you start:**

- Each share pays the share value every month, and the collector receives the sum of the instalments of all shares: monthly payout = total shares x share value.
- The current month is calculated from today's date and the start date of the first month. It does not go beyond the circle's number of months.
- Arrears = what the member should have paid for the months before the current month, minus everything they paid toward those months. It is a net balance: anything paid in excess is deducted from the arrears.
- In Payments, enter the month number the instalment pays for, not the month of the payment date. A late instalment for month 2 is entered as month 2 even if it was paid in month 4.
- In an ordinary circle, the number of months equals the total shares. The Settings sheet warns you if they differ.
- The sheet holds up to 40 members, 24 months and 1,500 payments. It records the figures only and does not guarantee the collection of any instalment.

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

Excel file (.xlsx) · 83 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: monthly savings circle (1/3)](https://softwiro.com/uploads/cheatsheets/gamaeya-savings-circle/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/gamaeya-savings-circle/en-1.jpg)[![Cheat sheet: monthly savings circle (2/3)](https://softwiro.com/uploads/cheatsheets/gamaeya-savings-circle/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/gamaeya-savings-circle/en-2.jpg)[![Cheat sheet: monthly savings circle (3/3)](https://softwiro.com/uploads/cheatsheets/gamaeya-savings-circle/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/gamaeya-savings-circle/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 is the monthly payout calculated?

Each share pays the share value every month, and the payout = total shares x share value. In the example, 10 shares at 1,000 give a payout of 10,000 every month.

### How do I handle a member who holds two shares?

Enter 2 as their number of shares in the Members sheet. Their monthly instalment becomes double the share value, and you enter their code in two months in the Months sheet, so they collect twice.

### How are arrears calculated?

Arrears = what the member should have paid for the months before the current month, minus everything they paid toward those months. It is a net balance: anything a member paid in excess is deducted from their arrears.

### How do I record a late instalment paid in a later month?

Record it in Payments with the month number it pays for, not the month it was paid in. It is then counted for that month and reduces the arrears.

### 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)

More free templates for: Personal finance

## More free templates

- Household budget and savings sheet
- Simple daily expense sheet (phone-first)
- Clinic appointments tracker (Excel)
- Recipe costing for restaurants and cafes (Excel)
- Finishing and contracting projects tracker
- 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

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