Softwiro
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.

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

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
As of46344Change the as-of date, amounts and number of rounds on the Settings sheet.
Members10
Rounds in the cycle11
Pot per round550.00
Total expected, whole cycle6,050.00
Total collected3,775.00
Collected vs whole cycle62.4%
Expected from past-due rounds3,850.00
Collected for past-due rounds3,575.00
Collection rate, past-due rounds92.9%
Overdue now (late + missing)275.00
Member-rounds by statusCount
Paid67
Late3
Missing3
Upcoming37
Total110

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 and the 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.

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 sheetIn 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 · Ask for a demo

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, 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

More free templates for: Personal finance

More free templates

All templates · Free tools