✅ Debt Recovery Kit
Stop Revenue Leakage with the ultimate SACCO Debt Recovery Kit
Is your loan recovery process buried under messy spreadsheets and forgotten follow -ups?
Recovering funds shouldn't be a guessing game. The Debt Recovery Kit is a professional - grade tracking system designed for SACCOs, Credit Unions, and Thrift organizations to regain control of their portfolio
What's Inside;
541 formulas · Zero errors · 3 laser-focused tabs
📋 Tab 1 — Loan Register 100 loan records. Auto-calculates interest, total repayable, due date and outstanding per loan. Status dropdown with 7 options. Status count bar at the bottom showing live counts per category.
⚠️ Tab 2 — Defaulter Tracker Every overdue and partially repaid loan pulled with live Days Overdue formula that updates every day you open the file. Auto-severity formula — 🟡 Mild (1–14 days), 🔴 Serious (15–30 days), ⛔ Critical (30+ days). Recovery Action dropdown with 7 actions including WhatsApp, Legal, Guarantor Contact. Notes column for follow-up logging.
📊 Tab 3 — Recovery Dashboard 5 KPI cards — Total Loans, Disbursed, Outstanding, Recovered, Active Defaulters. Full 12-row performance table with Recovery Rate % and Default Rate %. Severity breakdown table with recommended action per level. Print-ready for board reporting — landscape layout, fits one page.
PERFECT FOR
──────────────────────────────
• Ajo / Esusu / Adashe collectors — Nigeria, Ghana, Cameroon
• Cooperative society & SACCO managers across Africa and US
• Microfinance loan officers and credit agents globally
• Church and community savings groups
• Small credit unions looking for a simple digital system
──────────────────────────────
AFTER PURCHASE — 3 STEPS
──────────────────────────────
1. Download the .xlsx file from your receipt email
2. Upload to Google Drive → Open with Google Sheets
3. Go to the Setup tab → enter your organisation name and rates → done
Technical issues? Email me. Resolved within 24 hours, guaranteed.
All sales final — digital product.