Savings Club Manager Excel Template

Who paid? Who borrowed? What’s my share?
Most savings clubs run on a notebook and a WhatsApp group. When someone asks how much they have saved, what they still owe on a loan, or what they’ll get at share-out, the treasurer has to dig through pages of records. Mistakes creep in and trust wears thin. The Savings Club Manager puts the whole club in one Excel workbook, so everyone sees the same numbers.

How it works

1. Set your rules once. Enter the contribution per share, the due date, the late fine, the loan interest rate and the share-out date.
2. Add your members. Up to 50, each with their shares and join date.
3. Record each payment as it happens. Savings, loan repayments, fines, payouts and expenses all go on one sheet, in USD or ZiG. A Check column tells you if anything is missing.
4. Let the workbook do the rest. Arrears, fines, loan balances, interest, the share-out and member statements all update automatically.

What’s inside (12 sheets)

• Setup: your club’s rules in one place.
• Members: up to 50 members, with each person’s standing (up to date, in arrears, fines owed, loan overdue).
• Transactions: a cash book with up to 1,000 entries, with automatic USD/ZiG conversion.
• Contributions: a month-by-month grid. Green means paid, amber means part paid, red means missed. Arrears and late fines are worked out for you.
• Loans: up to 100 loans with flat monthly interest, due dates, balances, overdue alerts and a borrowing-limit check.
• Rotation (optional): who receives the pot each month, what has been collected, and what has been paid out.
• Share-Out: each member’s savings plus their share of the profit, minus anything they still owe, with a cash check that confirms the payouts match the money the club holds.
• Member Statement: pick a name and get a one-page statement to print or save as PDF.
• Dashboard: total saved, cash on hand, loans outstanding, collection rate, biggest arrears and overdue loans, with charts.
• Exchange Rates, How to Use and Lists: supporting sheets.

Why clubs like it

• Settles disputes quickly. Every member can see their own statement.
• Saves the treasurer hours of manual adding up every month.
• Fair share-out. Profit is shared in proportion to savings, worked out to the cent.
• Built for how clubs here really work: USD and ZiG, shares, fines and rotation.
• Easy to change. Your club’s rules are settings you can edit, not fixed formulas.
• No macros, so the file opens safely and is easy to share.

Who it’s for
Treasurers, secretaries and chairpersons of savings clubs, grocery clubs, investment clubs, church and workplace groups, and burial societies.

What you get

• A blank workbook ready for your club.
• A sample workbook with a fictional club, so you can see how it all works. All names, phone numbers and amounts in the sample are made up. Any resemblance to real people is coincidental.

Requirements
Microsoft Excel 2010 or later for desktop. Also works in LibreOffice.

Disclaimer
A record-keeping toolkit for your club. It does not hold or move money and is not financial advice. Your club’s own constitution and rules apply. It is not affiliated with any bank, regulator or savings group association.

A eunoiadata.com Productivity Toolkit