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.
