The verdict in three sentences
A New York headquartered NGO delivering cash transfers to 120,000 people across several country programmes cannot run beneficiary lists in spreadsheets anymore: every point of duplicate payment costs tens of thousands of dollars and donor trust. A beneficiary management system with offline tablet registration, QR code cards, deduplication and reports in ECHO and US government donor formats can be built for USD 35,000 to 80,000 as a 2026 order of magnitude. It goes live in 3 to 5 months, compared with USD 15,000 to 40,000 a year in licences or free tools that stop at data collection.
The real cost of spreadsheet lists
From headquarters in Manhattan, the flow looks tidy. In the field, it rarely is: targeting survey on a mobile form, export to a spreadsheet, manual cleaning, upload to the payment provider (mobile money operator, bank or cash agent), then reconciliation after the cycle. Every export creates a new version of the list, and errors settle between files. HQ then spends weeks consolidating country data for donors.
| Risk | Typical rate with spreadsheets | With dedicated software | Impact for 120,000 people |
|---|---|---|---|
| Duplicates (same person, two records) | 1 to 2 % | under 0.2 % | 1,200 to 2,400 extra payments per cycle |
| Payment to someone who exited the programme | 0.5 to 1 % | near zero (live status) | 600 to 1,200 undue payments |
| Wrong amount (household size) | 1 % | rule-checked | USD 10 to 40 gaps per household |
| Post-cycle reconciliation | 10 to 15 days | 1 to 2 days | finance team freed |
| Untracked complaint | frequent | ticket number | accountability risk |
| Personal data leak | file emailed to providers | role-based access, encryption | legal and protection risk |
Data protection is not a detail. Lists hold names, locations, household composition and sometimes displacement or protection status. Emailing a spreadsheet to a payment provider exposes vulnerable people, and institutional donors now expect a data protection impact assessment and a retention policy.
Functions and budget of a custom build
| Module | Function | Budget share | 2026 order of magnitude |
|---|---|---|---|
| Offline registration | Android tablet app, photo, optional fingerprint, delayed sync | 20 % | USD 7k to 16k |
| Targeting and eligibility | Vulnerability scoring, per-programme rules, community validation | 15 % | USD 5k to 12k |
| Deduplication and QR cards | Duplicate detection, card printing, verification at distribution | 20 % | USD 7k to 16k |
| Payments | Lists to mobile money, banks or agents, automatic reconciliation | 20 % | USD 7k to 16k |
| Complaints and accountability | Hotline, tickets, response times | 10 % | USD 3.5k to 8k |
| Donor reporting | ECHO indicators, US government formats, multi-country dashboards | 15 % | USD 5k to 12k |
Multi-country programmes add a twist: each country has different payment operators and currencies. The system must produce one file per operator and read back payment confirmations to mark each transfer as successful, failed or to retry, then roll everything up in USD for HQ.
Free tool, licence or custom build
| Option | Initial cost | Annual cost | Built-in payments | Main limit |
|---|---|---|---|---|
| KoboToolbox or ODK alone | 0 | 0 to a few thousand USD hosting | no | collection only, lists rebuilt in spreadsheets |
| Licensed humanitarian platform | USD 5k to 15k set-up | USD 15k to 40k | yes | recurring cost, limited adaptation |
| Self-hosted open source platform | USD 10k to 30k | USD 8k to 20k operations | partial | needs in-house technical skills |
| Custom build | USD 35k to 80k | 10 to 15 % of build | yes, per operator | 3 to 5 month lead time |
KoboToolbox remains excellent for collection and can feed a custom system. The gap starts after collection: status management, cycles and payments. Over three years, a USD 25,000 annual licence costs USD 75,000, close to a custom build the NGO owns outright.
At Kolonell, this project falls under our complex application grid, 7,000,000 to 15,000,000+ FCFA (10,670 to 22,870+ EUR), priced on quote depending on the number of programmes and operators. Maintenance follows our 35,000, 75,000 or 120,000 FCFA monthly plans (53, 114 or 183 EUR).
Mini case study
Rachel, Director of Cash Programming at an NGO in New York, oversees 120,000 recipients receiving USD 60 a month for 6 cycles across three countries. An internal audit found 1.5 % duplicates and undue payments.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- Current overpayments: 1,800 × 60 × 6 = USD 648,000 per programme
- With deduplication and live status: 0.2 %, or USD 86,400
- Saving: USD 561,600 per 6-month programme
- Cost: USD 65,000 software, USD 12,000 tablets and cards, USD 9,000 a year operations
- The project pays for itself in the first payment cycle
Even if the audit overstated duplicates by half, the saving would still exceed USD 200,000.
FAQ
Does it work without connectivity at distribution sites?
Yes, tablets register people and verify QR cards offline for several days using an encrypted local list. Sync happens back at base, usually in under 10 minutes for 2,000 records.
Can we keep KoboToolbox for surveys?
Yes. Existing Kobo forms feed the beneficiary database through an integration, so 50 to 100 enumerators need no retraining. Only list management and payments move to the new system.
How is beneficiary data protected?
Encryption on tablet and server, role-based access, a log of every view and pseudonymised files for payment operators. Retention is set per programme, for example 24 months after close.
Do reports match donor formats?
Key indicators (households reached, amounts paid, sex and age disaggregation, complaints closed) are produced automatically. An interim report that took 5 days of consolidation is ready in half a day.
How long before the first payment cycle?
Plan 3 to 5 months: 3 to 4 weeks of scoping, 2 to 3 months of build and a pilot cycle with 2,000 to 5,000 recipients before scale-up.
Let's scope your project. We define registration, deduplication, operator payments and donor reporting with you, with a first pilot cycle in 3 to 5 months. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.