RCFI ERP Preview

RCFI: from Excel sheets to one system for 10,000+ charity applications a year

01About the project

About the project

The Relief and Charitable Foundation of India (RCFI) receives thousands of requests for help every year, from orphan education to new wells and livelihood support, and funds them through donors in India and the Gulf. Until 2024, every application, donor and rupee was tracked in Excel. Digibeat built RCFI a web-based ERP that now runs the whole operation: applications, donors, fund allocation, reporting, orphan care and staff management.

10,000+
applications managed each year
8,000+
orphan records
100+
projects and 100+ staff each year
₹100+ crore
in project funds tracked each year

02Facts

Project facts

Client
Relief and Charitable Foundation of India (RCFI)
Working together since
2024
About RCFI
Non-denominational charity founded in 2000, ISO 9001:2015 certified, working in 23 states and 4 Union Territories
Office
Karanthur, Kozhikode
Type
Custom web application (ERP)
What we built
  • Application management
  • Donor management
  • Fund allocation
  • Reporting
  • Orphan management
  • HR
Technology
  • ReactReact (front end)
  • LaravelLaravel (back end)
  • MySQLMySQL (database)

03Organisation

The client

RCFI was founded in 2000 by Sheikh Aboobacker Ahmed, the Indian Islamic scholar known for representing India in national and international peace and interfaith dialogues. The foundation works with underserved communities at the grassroots, in education, safe water, food security, health, livelihoods, disaster relief, support for people with disabilities, and the environment. Since 2000, its work has reached nearly 4.84 million people across 23 states and 4 Union Territories.

rcfi.org/mis
RCFI MIS Dashboard Overview

04Challenge

The problem

RCFI is a registered non-profit, and much of its funding comes from donors in the Gulf under FCRA rules. Every year, thousands of applications arrive from across India: sponsorship for orphans’ education, new masjids and community centres, open wells and borewells, and support to start a livelihood.

Each application had to be checked, matched to a suitable donor, allocated funds, followed through to completion and reported back to that donor. All of it lived in Excel sheets. Finding one application’s history meant searching several files. Preparing a donor report meant copying figures by hand. Only the people who built each sheet fully understood it.

05Modules

What we built

rcfi.org/erp
RCFI ERP System

Every request is logged with its type (orphan sponsorship, masjid, community centre, well, livelihood), location, documents and status. Staff can see where each application stands, from received and verified to approved, funded, in progress and completed.

One record for each donor, with contact details, country, giving history and the projects they’ve funded. Staff can quickly find a donor who has funded a similar project before.

Funds are allocated from donors to approved projects, so RCFI always knows how much each donor has given, where it went, and what’s still unallocated. Foreign contributions are tracked separately from domestic ones, as FCRA requires.

Reports on each project, donor and region come straight from the data staff already enter, instead of being rebuilt in Excel. [CONFIRM: e.g. donor reports with progress photos and fund use, or year-end summaries]

A module for more than 8,000 sponsored children: profiles, education progress, sponsor links and support history, with access limited to authorised staff.

An HR module for more than 100 staff: records, roles,: attendance, leave, payroll or field assignments.

06Security

Keeping sensitive data safe

The system holds personal details of donors, applicants and more than 8,000 children, so data protection was part of the design:

  • Role-based logins, so each staff member sees only the records their work needs
  • activity logs showing who changed what and when
  • daily encrypted backups
  • Hosted on secure servers with SSL

07Impact

The results

RCFI now runs its whole operation from one system: more than 10,000 applications, 100+ projects, 8,000+ orphan records and 100+ staff each year, with ₹100+ crore in project funds tracked from donor to project.

Before
Now, with the system
Preparing a donor report meant filtering Excel data by hand, which took 1 to 2 days
The same report is ready in a few clicks, using filters for donor, project type, region or period
Applications arrived as paper forms kept in files. Finding one meant searching through the files by hand
Reception enters each application into the system when it arrives, so anyone on the team can find any application by name, place or type in seconds
To find deserving applicants for a donor, staff had to read through every application in detail
Staff filter applications by the donor’s requirements (project type, location, need) and see every matching applicant’s full details on one screen

08Engineering Challenges

What was hard

Each type of project needed different information. A borewell application has nothing in common with an orphan sponsorship, yet both had to flow through the same approval, funding and reporting steps. We designed one shared workflow with fields specific to each project type, and moved years of existing Excel data into the new system without losing records.

09Client feedback

What RCFI says

Our experience working with DigiBeats for the development and implementation of the Management Information System (MIS) for our organization has been extremely positive and satisfactory.

As an organization managing multiple projects, programmes, beneficiaries, and operational activities, we required a comprehensive, reliable, and user-friendly MIS solution. DigiBeats has played an important role in streamlining our organizational processes through its customized MIS solutions.

The team has developed and delivered various modules tailored to our specific organizational requirements, helping us improve project management, data management, monitoring, reporting, and overall operational efficiency. Their ability to understand our complex workflows and translate them into practical digital solutions has been particularly impressive.

One of the most appreciable aspects of DigiBeats is their professional approach, technical expertise, commitment, and willingness to understand our requirements in detail. The team has been responsive to our feedback and consistently worked towards improving the system to meet our evolving organizational needs.

Their solutions have significantly enhanced our ability to manage information, monitor project progress, maintain accurate records, and make informed decisions. We particularly appreciate their attention to detail, timely support, and dedication to delivering quality solutions.

We highly recommend DigiBeats to organizations looking for reliable, customized software development, MIS solutions, and digital transformation services. We look forward to continuing our association with them.

Swadeque EK
Swadeque EK
Chief Operating Officer (COO),
Relief and Charitable Foundation of India

10Stack

Built with

React · Laravel · MySQL · Role-based access ·

ReactReact LaravelLaravel MySQLMySQL Role-based access

Running a charity, trust or NGO or business on spreadsheets?

Tell us how your applications, donors and funds move today. We’ll show you what a system built around your workflow could look like, and send a fixed quote.