Plain Desk · Guide
Stokvel Spreadsheet Template South Africa
A stokvel spreadsheet template keeps contributions, members, and payouts in one place instead of scattered WhatsApp messages. South African treasurers usually need Excel or Google Sheets files they can own offline — not another login that holds the club’s money.
What a useful SA stokvel spreadsheet must include
Skip decorative dashboards. Cover these four ledgers:
1. Member register
Columns that actually get used:
- Member ID / number
- Full name
- Join date
- Phone (private — POPIA)
- Status (active / exited)
- Notes (beneficiary contact if your club uses one)
2. Contribution tracker
- Contribution amount and cycle (weekly / monthly)
- Due date
- Paid Y/N
- Amount received
- Method (cash / EFT) — recorded by you; the sheet is not a payment app
- Arrears flag
3. Fine & loan log
Many clubs mix “late fine” and small internal loans in chat. A separate log prevents silent debt:
- Date · member · type (fine / loan) · amount · due · settled Y/N
4. Payout calendar / year-end sheet
Especially for grocery and savings clubs aiming at December / January:
- Rotation order or share calculation
- Expected payout date
- Total pool vs deductions
- Sign-off initials at AGM
Excel vs Google Sheets (practical)
| Option | Best when | Watch-outs |
|---|---|---|
| Google Sheets | Shared view with secretary; phone access | Don’t paste the full sheet into a public WhatsApp group |
| Excel / LibreOffice | One laptop “master”; offline meetings | Backup weekly to Drive or email |
CSVs import into both. One treasurer owns the master; others get PDF exports for meetings.
Common mistakes that break trust
- Only recording totals — you cannot answer “Did Thabo pay March?”
- Editing in the WhatsApp group — no audit trail; privacy risk
- No exit column — exited members stay in the payout list by accident
- Mixing burial claims language into a savings sheet — burial societies need contribution records; claims and insurance are separate
- No backup — phone loss = lost season
Minimal setup in one evening
- Create four tabs (or four CSVs): Members, Contributions, FinesLoans, YearEnd.
- Freeze header rows; protect the “amount due” cell so it doesn’t drift.
- After each meeting, mark Paid Y/N the same day.
- Before payout season, copy contribution totals into the year-end sheet and reconcile with the bank statement you control.
- Store the master privately; share summaries only.
Free single trackers vs a full pack
Online you will find free or cheap “stokvel tracker” Excel files and WhatsApp bots. Many cover contributions only.
A fuller treasurer pack (constitution + register + tracker + fines + year-end) helps when:
- A new treasurer takes over mid-year
- Rules and books must match
- Burial society and savings club admins share the same workflow
Plain Desk Stokvel OS is that pack: ready CSVs/templates for SA clubs, one-time R199 download. Not a bank. Not SaaS. Not financial advice.
FAQ
What is the best stokvel spreadsheet template for South Africa?
The best one is the file your treasurer will update every cycle: member register + contribution tracker + payout sheet. Fancy charts are optional.
Can I use Google Sheets on my phone?
Yes. Keep the master link private. Export PDF for group announcements instead of sharing edit access widely.
Does a spreadsheet replace a constitution?
No. Rules belong in a constitution document; money movements belong in the spreadsheet. Many groups need both.
Is this the same as a stokvel banking app?
No. Spreadsheet templates organise records. Your group still uses its own bank account or cash process. Templates do not hold funds.
Where can I get constitution + spreadsheets together?
Plain Desk Stokvel OS bundles an adaptable constitution template with contribution, member, fine/loan, and year-end sheets.