Drishti Netra Seva runs free cataract surgery camps across 6 districts in western Maharashtra. The organisation receives funding from three corporate CSR partners, individual donors, and a small government grant. Each CSR partner requires quarterly utilisation reports showing exactly how their funds were used, down to per-surgery cost breakdowns.
The NGO was managing donor data in one Excel file, beneficiary (patient) records in another, surgery logs in a third, and expenses in a fourth. Preparing a single quarterly report for one CSR partner took the programme coordinator 4-5 days of manual data reconciliation. When two partners requested mid-year impact audits simultaneously, the coordinator worked weekends for three weeks straight to compile the data.
The disconnect between systems also meant that 80G receipts were generated from a separate template and often had small discrepancies with the donation records, causing confusion during the annual audit.