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.