Reimbursement Visibility for Charter Schools

From Hidden Folders to Full Transparency

The Challenge

Charter Schools USA was managing millions in grant reimbursements across 80 schools—but using SharePoint folders.
There was no way to track status, identify delays, or hold teams accountable. This lack of visibility was putting grant dollars at risk and creating confusion across school, state, and national levels.

The Solution

DataGenie built a centralized reimbursement management system using the Microsoft Power Platform:

  • Power Apps with role-based access
  • Dataverse + SharePoint Lists to store and unify data
  • Automated alerts via Teams and email
  • Power BI dashboards to track reimbursement lifecycle, risks, and aging

Each stakeholder—school leaders, area directors, executives—received real-time insights relevant to their role.

Results

100% of eligible grant funds utilized

MVP launched in 1 month

Streamlined cross-team communication

100% of eligible grant funds utilized

Tools Used

Power BI
PowerApps
Power Automate
SharePoint
Dataverse
Excel
Typebot