Launch sale: 20% off on Etsy through Oct 14 · Shop now
For busy chama treasurers

Keep the books without becoming the accountant

Still chasing payments in WhatsApp and a notebook? Chama Money Tracker is a ready-made treasurer ledger for chamas, sou-sous, tontines, savings circles and investment clubs — especially groups with members abroad. Record a payment once; the grid, balances, statements and share-out update themselves.

Excel + Google Sheets No macros · no subscription Instant download on Etsy Try before you buy WhatsApp-ready statements
Chama Money Tracker spreadsheet collage showing the dashboard, payment grid, member statement and receipt
Built for volunteer treasurers — not accountants. Phone apps work for quick entries.
Interactive demo

Click around with sample data

Open full screen

Demo uses fictional sample data for “Umoja Diaspora Chama”. Nothing is saved and nothing leaves your browser. Resets on reload.

The usual mess → one ledger

From WhatsApp chaos to books that balance

How many groups still do it

  • Payment screenshots scattered across WhatsApp chats
  • A notebook only the treasurer understands
  • Arguments every month about who paid, and at which exchange rate
  • Year-end share-out that takes a whole weekend (and still doesn’t add up)

With Chama Money Tracker

  • Record each payment once — the payment grid and balances update
  • See who is behind at a glance: paid, covered, partial, missed, paid ahead
  • One fixed monthly FX rate so diaspora payments are treated the same
  • Printable member statements and receipts you can send on WhatsApp
  • Handles refunds, savings brought forward from your old records, suspensions and members who leave
  • Built-in checks on the dashboard (bank + M-Pesa balance, entries to fix), and a clean year-end share-out
Example situations

Built for groups like yours

These are example situations — not customer quotes — based on how treasurers actually run chamas, sou-sous and investment clubs. Each one maps to a real tab in the ledger.

Example situation

Kenyan diaspora chama (US / UK)

Members send USD or GBP; the books are in KES. Every meeting someone argues about the rate they used.

Fixes it: FX Rates + Contributions — enter the amount as sent; it converts at your group’s fixed monthly rate.
Example situation

Family or friends merry-go-round

Who has received their payout, who’s next, and has everyone paid into this month’s pot?

Fixes it: Merry-Go-Round tab — track the rotation, recipients and amounts paid out each month.
Example situation

Chama that lends to members

Flat or reducing balance? Who guaranteed the loan? Which installment is overdue?

Fixes it: Loans, Repayments & Loan Schedule — interest, installments, guarantors and overdue status.
Example situation

Church, women’s or welfare group

Fines for late payments, welfare payouts when someone needs help, and members who never open a spreadsheet.

Fixes it: Fines, Income & Expenses, printable Member Statement & Receipt — share as PDF on WhatsApp.
Example situation

Investment club or RWF / UGX / NGN / GHS group

Your base isn’t KES. You hold investments, and at year-end everyone wants a fair share-out of interest and gains.

Fixes it: base currency in Settings (KES, USD, GBP, EUR, CAD, UGX, TZS, RWF, ZAR, NGN, GHS) · Investments · Share-Out.
What you get

Everything a treasurer actually needs

Plain language. Locked formulas. No macros to enable, no app to install, no monthly fee.

Payment grid

Members × 12 months, colour-coded paid / covered / partial / missed / paid ahead / suspended, with arrears, late months and fines triggered. Each member has an ID, plus suspension dates when needed.

Diaspora FX

USD, GBP, EUR or CAD in; your base currency out — at the rate your group fixed for that month.

Loans done properly

Flat or reducing-balance interest, guarantors and an eligibility check, installment schedule, interest vs principal split, amount overdue and a settle-today amount. Installments round to whole units or cents, with a small tolerance you set.

Statements & receipts

Printable one-page member statements, official receipts and payment vouchers for refunds and share-outs — save as PDF and send on WhatsApp.

Merry-go-round

Track who receives each month’s payout, how much was paid into the pot, and who has paid, member by member.

Year-end share-out

Interest, fines, fees, gains minus expenses — split by savings this year, all savings, or savings × months held. Tracks what has been paid out, with a check that it adds up.

Loans & investments consistent?

Dashboard check that what the group owns (cash + loans + investments) matches where the money came from. Plus a bank + M-Pesa balance check and a count of entries to fix.

Formulas locked

Totals stay accurate. Input cells, dropdowns and filters work as normal. No macros, VBA or add-ins.

Diaspora FX

One monthly rate. Fair for everyone.

Agree one exchange rate for the month on the FX Rates tab. Enter what each member sent. The ledger converts it so a $77.52 Zelle and a KES 10,000 M-Pesa both count as the same contribution.

Worked example (sample data)

Fictional “Umoja Diaspora Chama” · monthly savings KES 10,000 · October USD rate 129

$77.52 USDGrace (USA) sends via Zelle → 77.52 × 129 ≈ KES 10,000
£58.14 GBPAmina (UK) sends via Wise at 172 → ≈ KES 10,000
KES 10,000Peter (Kenya) pays on M-Pesa — same contribution, same books

Same month, same obligation, no rate arguments.

Multi-currency contributions converting USD, GBP, EUR and CAD to KES at a fixed monthly rate
How it works

From Etsy to your first month in four steps

Buy on Etsy

Instant download from your Etsy Purchases page. No account on this site — Etsy handles payment.

Open the file

Unzip. Open the .xlsx in Excel, or upload to Google Drive and open with Google Sheets.

Set up (~15 min)

On Settings: group name, currency, monthly contribution, due day, fine amount and loan rate.

Record as you go

Enter payments, loans and expenses. Everything else — grid, statements, share-out — updates.

Inside the ledger

What’s in the download

Two files from Etsy: a ZIP (sample workbook + blank workbook + Quick-Start Guide + Real-Life Situations Guide) and the 8-page Quick-Start Guide as a separate PDF.

19 connected tabs

  • Start Here
  • Dashboard
  • Settings
  • FX Rates
  • Members
  • Contributions
  • Payment Grid
  • Fines
  • Loans
  • Repayments
  • Loan Schedule
  • Income & Expenses
  • Investments
  • Merry-Go-Round
  • MGR by Member
  • Member Statement
  • Receipt
  • Share-Out
  • Lists
Capacity: 50 members 3,000 contributions 200 loans Sample data is fictional
Pricing

Simple prices. Sold only on Etsy.

No checkout on this site. No email capture. Etsy handles payment and delivery — you download from your Purchases page.

Chama Money Tracker treasurer ledger preview

Treasurer Ledger

$14.99
  • 19-tab Excel / Google Sheets workbook
  • Sample + blank copies
  • 8-page Quick-Start Guide
  • Real-Life Situations Guide
Buy on Etsy
Best value Chama Treasurer Bundle preview

Treasurer Bundle

$21.99 save 21%
  • Ledger + monthly checklist + constitution
  • Bought separately: $27.97
  • You save $5.98
Buy bundle on Etsy
Monthly Treasurer Close Checklist preview

Monthly Close Checklist

$4.99
  • 5-page fillable PDF
  • US Letter + A4
  • Pairs with the ledger
Buy on Etsy
Chama Constitution Template preview

Constitution Template

$7.99
  • Fillable group constitution
  • Contributions, loans, share-out
  • General template — not legal advice
Buy on Etsy
Free

1-page monthly treasurer checklist

A free starter checklist you can print or keep on your phone — no sign-up, no email.

Download free checklist (PDF)
FAQ

Common questions

Does it work in Excel, Google Sheets, on a Mac, and on a phone?

Yes. Microsoft Excel 2016 or later, Microsoft 365, Excel for Mac, and Google Sheets. Uses standard formulas only — no macros, VBA or external links.

A computer is recommended for setup and printing. The Excel and Google Sheets phone apps can open it for quick entries.

Does it work in Apple Numbers?

No. Apple Numbers is not supported. Use Excel or Google Sheets.

Are the formulas password-locked?

Yes. Formulas and layout are locked so nobody breaks a total by accident. Input cells, dropdowns and filters work as normal. You can rename dropdown options on the Lists tab.

Google Sheets note: formula cells are locked and hidden in Excel, but Sheets shows them to the file owner — keep to the white input cells.

Can I get a refund on a digital download?

Digital files can’t be returned, so sales are final. If a file won’t open or something doesn’t work as described, message the shop on Etsy and you’ll get a fix or a refund.

Which currencies does it support?

Base currency: KES, USD, GBP, EUR, CAD, UGX, TZS, RWF, ZAR, NGN or GHS. Members can pay in up to 6 currencies besides your base, which you set. Amounts convert at the fixed monthly rate on the FX Rates tab.

How many members can it handle?

Up to 50 members, 3,000 contributions, 200 loans (up to 60 months each), 1,500 repayments, 1,000 fines, 1,000 income/expense rows, 100 investments and 60 merry-go-round months.

What doesn’t it do (yet)?

Good to know before you buy:

  • One base currency per workbook. You can’t switch it partway through a year.
  • Members can pay in up to 6 currencies besides your base, each at one fixed rate per month (not daily bank rates).
  • A lump sum always fills the earliest unpaid months first. To mark a chosen month as paid ahead, enter one row per month.
  • No one-click buttons for loan write-offs or loan top-ups. The Real-Life Situations Guide shows the simple steps for each.
  • The share-out deducts unpaid fines automatically, but not loan balances. You deduct those yourself.
  • No separate welfare fund balance, and each investment keeps only its latest value.
  • Up to 50 members per workbook, and it doesn’t work in Apple Numbers.

Every download includes the Real-Life Situations Guide, with step-by-step fixes for leavers, suspensions, refunds, write-offs, top-ups, exchange-rate differences and more.

Is this financial advice?

No. Chama Money Tracker is a record-keeping tool, not financial, tax, legal or investment advice. Always check figures against your bank and mobile-money statements and follow your group’s own constitution.