Project Title: Enhancing Financial Tracking and Reporting for CiC for Prevention and Recovery

CiC for Prevention and Recovery

Details
Project Title Enhancing Financial Tracking and Reporting for CiC for Prevention and Recovery
Project Topics Budgeting, Forecasting, and Cost Optimization Data Management Operations Reporting, Financial Planning & Analysis Research, Analysis, Evaluation Strategic Planning
Skills & Expertise AI Workflows Compliance Monitoring Dashboard Development Data Management Expense Tracking financial analysis Financial Planning Grant Tracking Systems Nonprofit Management Process Improvement QuickBooks Reporting Automation stakeholder communication Strategic Planning System Integration
Project Synopsis: Challenge/Opportunity
CiC for Prevention and Recovery is a small nonprofit organization committed to supporting prevention and recovery efforts in its community. The organization is adept at using its resources to deliver impactful programs and services. However, as CiC has expanded and diversified its revenue streams, it faces increasing complexity in managing financial tracking and reporting. This challenge is primarily due to the varied reporting structures, fiscal calendars, and budget categories dictated by different funders.

The specific business challenge lies in the administrative difficulty of aligning these diverse requirements with CiC's internal financial systems. This complexity is compounded by the lean nature of the finance team, which struggles to efficiently track grant budgets, ensure compliance, and meet reporting obligations without undue administrative burden. As a result, there is a heightened risk of financial mismanagement, such as underspending, overspending, or the need to return funds.

This project addresses these challenges by offering students the opportunity to design a more streamlined and effective financial tracking and reporting framework. By analyzing CiC's current practices and exploring potential tools and systems, students will identify areas for improvement and recommend solutions that can help the organization better manage its financial operations.

The project is divided into several key phases, including an initial analysis of existing processes, research into potential tools and systems, and the development of recommendations for a new framework. Each phase provides students with the opportunity to apply their skills in financial analysis, data management, and strategic planning.

For students, this project is ideal as it allows them to apply their academic knowledge in a practical setting, addressing real-world challenges faced by nonprofit organizations. It offers a chance to develop skills in consulting, financial analysis, and operations management, all of which are highly relevant to careers in public and nonprofit finance. The project is designed to be engaging and meaningful, offering students a chance to make a tangible impact on an organization's financial sustainability.

Project Synopsis: Activities/Actions Required
  1. Conduct an initial assessment of CiC's current financial tracking and reporting processes.
  2. Identify key challenges and inefficiencies in aligning funder-specific requirements with internal systems.
  3. Research nonprofit financial management tools and grant tracking systems that could benefit CiC.
  4. Explore reporting automation practices and AI-enabled workflows to reduce manual reconciliation.
  5. Evaluate different grant calendars, budget categories, and reporting portals used by funders.
  6. Develop a framework for mapping funder categories to internal accounting categories.
  7. Standardize tagging practices to improve expense tracking and reporting consistency.
  8. Create dashboards or templates to help staff monitor grant spending against budgets.
  9. Present findings and recommendations to CiC leadership for feedback.
  10. Finalize recommendations and develop an implementation plan for the new framework.
Project Synopsis: Expected Results
  • Enhanced understanding of nonprofit financial management and grant tracking systems.
  • Improved alignment of funder-specific requirements with internal financial systems.
  • Clear identification of operational inefficiencies and potential solutions.
  • Development of a practical financial tracking and reporting framework.
  • Reduced administrative burden on CiC's finance team.
  • Strengthened compliance with funder reporting requirements.
  • Improved visibility and oversight of grant spending and budgets.
  • Tangible recommendations and tools that CiC can implement to improve financial management.

Project Timeline

Touchpoints & Assignments Date Type

Program Kickoff

Sep 12 2025 Event

Program Managers

Name Organization
Tiffany Charbonier New York University (NYU)

Teams

Team Name  Project Name  Team Members 
No Teams Available