Monthly NAV pack, 146 funds
Before. Each month, GL exports were manually pivoted into balance-sheet format one fund at a time, manual section assignment, subtotals and formatting across 146 funds. The process stretched over two full days and carried version-control risk every cycle.
What we built. A universal processing engine driven entirely by spreadsheet configuration, section rules, aggregation logic and GL mappings all maintained by the team, not a developer. Every row is validated in three directions before output: NAV to units × price, units to settled plus unsettled, NAV-before-fees to net assets. Adding a fund is a config row, not a development task.
| Metric | Before | After |
|---|---|---|
| Production time | 2 days | 18 min |
| Manual effort | Full-time | ~99% out |
| Rows validated | Spot-check | 100% |