# Rotating Savings Club Tracker Excel (Susu, Tanda)

> Free Excel tracker for a susu, tanda or ROSCA: members, payout order, schedule, contributions, paid, late and missing alerts, statements and a dashboard.

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

---

Free Excel template

# Rotating Savings Club Tracker for Excel (Susu, Tanda, ROSCA)

A free Excel workbook for friends, family or a community group that pools money in turns. Everyone pays the same amount each round and one member takes the whole pot, until every member has had a turn. People call this a susu, tanda, ROSCA, chit fund, committee, hui, paluwagan, sou-sou or a savings circle. Whatever your group calls it, the hard part is the same: who has paid this round, who is late, who has already received and who is still waiting. List your members and payout order, type the amount, how often you pay and the start date, and the sheet builds the whole schedule for you. Log each payment as it arrives and it shows paid, late or missing for every member in every round. It works in Excel, LibreOffice and Google Sheets and in any currency.

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

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

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

| As of | 46344 | Change the as-of date, amounts and number of rounds on the Settings sheet. |
| --- | --- | --- |
|  |  |  |
| Members | 10 |  |
| Rounds in the cycle | 11 |  |
| Pot per round | 550.00 |  |
| Total expected, whole cycle | 6,050.00 |  |
| Total collected | 3,775.00 |  |
| Collected vs whole cycle | 62.4% |  |
| Expected from past-due rounds | 3,850.00 |  |
| Collected for past-due rounds | 3,575.00 |  |
| Collection rate, past-due rounds | 92.9% |  |
| Overdue now (late + missing) | 275.00 |  |
| Member-rounds by status | Count |  |
| Paid | 67 |  |
| Late | 3 |  |
| Missing | 3 |  |
| Upcoming | 37 |  |
| Total | 110 |  |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Members, rounds, pot per round, total collected against the whole cycle, collected against what was due so far, the amount overdue, payouts made and still to make, member-rounds by status, the members who owe money, and the payout order with expected and collected per round. Three charts.
- Settings: Group name, currency symbol, as-of date, contribution per share, how often you pay, first due date, number of rounds, an optional organiser fee (a percentage of the pot or a fixed amount) and how many days overdue before a round counts as Missing.
- Members: Name, phone, optional share count and payout position (plus a second position for a member with two shares). It adds what each member pays per round, what they paid, what they owe, rounds late and missing, an alert, and whether they have received, are due to receive or are still to receive. Room for 30 members.
- Schedule: One row per round, built by formulas: due date, who receives, pot size, organiser fee, net payout, collected, still to collect and members paid. Type the payout date when the money is handed over and the round shows Paid out. Room for 30 rounds.
- Contributions: The payment log: date, member, round and amount, with a check column that flags an unknown member, a missing round or amount, or a date after the as-of date. Room for 1,000 payments.
- Status Grid: Every member against every round, marked Paid, Late, Missing or Upcoming in colour.
- Owed Grid: The amount each member still owes for each round, and the total owed for rounds that are past due.
- Statement: Pick one member and see what they pay, owe, paid and received, round by round, ready to show them or send as a screenshot.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Most susu sheets are a grid of ticks. This one is a small ledger: the schedule is built from your start date, every payment carries a round number, and the status, the amount owed and the payout state are worked out from them. In the sample club of 10 members and 11 rounds (50.00 a share, weekly), the pot is 550.00, the organiser fee 11.00 and the net payout 539.00. By the as-of date 7 rounds are past due, 3,575.00 of the 3,850.00 due has come in (92.9%), 275.00 is overdue, and 6 payouts have been made.

## How do I track a susu, tanda or ROSCA in Excel?

Keep four things: the members with their payout order, the settings (amount, how often, start date), a log of payments and a schedule. Build the schedule by formula so a change to the start date or the amount moves every round. Give each payment a round number, and each member's status for each round follows from the log.

Add a payment on the Contributions sheet and the Status Grid, the member's alert, the round's collected figure and the dashboard all update. Nothing else needs typing.

## What happens when a member pays late or misses a round?

Groups handle this in different ways: some pay the receiver from the other members' money and chase the late payer, some pay out later, some charge a fee. Write your group's rule down and follow it. The sheet does not decide for you or add fees or interest. It shows the facts: in the sample, a round is Late for the first 7 days after its due date and Missing after that (you can change the 7), and the alert list shows who owes what.

If your group charges a late fee, record it as your group agrees. Check your local rules about running a savings group, as they differ from place to place.

## Who receives first, and how do I set the payout order?

The group usually agrees the order at the start: by draw, by need, or by the date people joined. Type each member's position on the Members sheet (1 receives in the first round, 2 in the second). A member who joins with two shares pays double and gets a second position. The Schedule sheet then shows who receives each round, and the Members sheet shows who has received, who is due to receive and who is still to receive.

The sheet is a record of what your group agrees. It is not a loan or a financial product, and it charges no interest. For money beyond the club, see the [household budget](https://softwiro.com/templates/household-budget-savings) and the [cash book template](https://softwiro.com/templates/cash-book-template).

## How to use it

1. On the Settings sheet type the group name, the as-of date, the contribution per share, how often you pay (weekly, every 2 weeks or monthly), the first due date and the number of rounds. Add an organiser fee as a percentage of the pot or as a fixed amount if your group uses one.
2. On the Members sheet list every member with a phone number and a payout position (1 for the first to receive, 2 for the next, and so on). A member with two shares types 2 under Shares and a second position.
3. Open the Schedule sheet: it builds every round by formula (due date, who receives, pot size, organiser fee, net payout). When a payout is handed over, type the date in the Payout date column.
4. On the Contributions sheet add one row for each payment received: date, member (pick from the list), round number and amount.
5. Open Status Grid to see paid, late or missing for every member and every round. A round is Late for the first days after its due date and Missing after the number of days you set on Settings.
6. Use Statement to pick one member and see what they owe, paid and received, round by round. Open Dashboard for totals, alerts, who has received, who is still to receive and the charts.

**Before you start:**

- Capacity: 30 members, 30 rounds and 1,000 contribution rows.
- This sheet is a record of what your group agrees. It does not move money, charges no interest and is not a financial product. Check your local rules about running a savings group.
- The sheet does not use TODAY(): type the as-of date on Settings. A round is past due when its due date is before the as-of date.
- The pot for each round is the contribution per share times the total number of shares. Rounds should equal total shares (the Settings sheet checks this).
- Paid means that member paid at least their share for that round. Money paid for a later round does not cover an earlier one: give each payment the right round number.
- Use one currency in one workbook. The currency symbol on Settings is only a label.

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

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

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

## 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 and a copy on WhatsApp | A shared system with a login for each organiser and member |
| You type each payment and check the status | Payments are matched to rounds and statuses update on their own |
| Reminders are your own phone calls | Automatic reminders before and after the due date |
| One cycle per file | Many clubs and cycles in one place |
| Fixed columns | Rules, fees and reports built to your group |

### Extra features in the app

- Members see their own balance and payout date in an app
- Automatic reminders by message before a due date
- Several organisers recording payments at the same time
- A full history of every cycle in one place
- Online payment links and receipts
- Permissions, so only the organiser can edit

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

## Frequently asked questions

### Is this savings club tracker really free?

Yes. Download it, use it for your group and change anything you like. There is nothing to sign up for to open the file.

### Does it work for a tanda, a susu, a chit fund or a paluwagan?

Yes. The idea is the same under every name: equal contributions, one member takes the pot each round. Set the amount, how often you pay and the number of rounds. Rules that differ, such as bids or draws in a chit fund, are not calculated: type the agreed payout order on the Members sheet.

### How many members and rounds can it hold?

30 members, 30 rounds and 1,000 payments. Rounds should equal total shares, and the Settings sheet shows a warning if they do not.

### Can the organiser take a fee?

Yes, if your group agrees one. Type a percentage of the pot, or a fixed amount that is used instead. It is taken from each round's pot to give the net payout. Leave both empty for no fee.

### Does it work weekly, every 2 weeks and monthly?

Yes. Pick the frequency on Settings. For monthly rounds the due date stays on the same day each month, or the last day of a shorter month.

### 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)
- College Application Tracker Spreadsheet for Excel (Deadlines, Checklist, Aid)
- Weighted Grade Calculator for Excel (Gradebook with Categories)
- Breakeven ROAS Calculator for Excel
- Small Business Budget Template for Excel (Monthly)
- Annual Department Budget Template for Excel (Budget vs Actual)
- Construction Project Tracker for Excel
- Production tracking sheet for home textiles factories
- Fabric requirements and marker sheet

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