← All work

Nonprofit · biomedical research funding

Budgeting and FP&A platform that replaced an Excel package

An internal app for finance and department heads covering budgeting, headcount and payroll planning, FP&A reporting and pledge insight. It replaced 11 department workbooks and a consolidated rollup.

  1. Department budgets
  2. Headcount engine
  3. NetSuite GL
  4. SharePoint reports
Budgeting and FP&A platform that replaced an Excel package
IllustrativeIllustrative: department budget with the headcount engine.
Client
Alzheimer's Drug Discovery Foundation ↗
Nonprofit · biomedical research funding
Stack
Next.js 16, React 19, TypeScript, Postgres, DynamoDB, SuiteQL, Microsoft Graph, Entra ID, Gemini, Railway

Results

  • Replaced 11 department budget workbooks and their rollup
  • Headcount engine matches the payroll workbook to the cent

What I built

  • Budget planner. Department budgets with GL mapping, analysis and consolidated reports, and admin screens.
  • Headcount planner whose engine reproduces the payroll workbook to the cent. It pushes payroll cost into the budget by NetSuite GL account, and salary data is visible only to Finance.
  • FP&A and pledge insight. Donor pledge schedules are joined to NetSuite by gift number.
  • Excel reports published automatically to SharePoint whenever the data changes. The app uses Microsoft sign-in and includes an AI chat assistant.