← All work
Prototype Reelledger
Production tax-credit lifecycle tracker
Tracks film and television production tax credits quarter by quarter across jurisdictions, through the multi-year tail after a production wraps.
The problem
Production accounting stops at wrap. Tax credits do not — application, certification, issuance, and monetization run for years afterward, across 39+ US jurisdictions whose rules change every 12 to 24 months. Studio tax teams run this in Excel.
My role
Product definition, architecture, and full implementation.
Decisions worth defending
- Calendar quarter stays the storage key and the FX rate-lookup key; fiscal period is a reporting lens computed from actual event dates on top of it.
- A full fiscal-calendar engine, because the target buyers run 52/53-week calendars whose quarters end mid-month — validated against real published anchors including a 53-week year.
- Multi-currency handled properly: store native, translate on read, and split realized from unrealized FX so consolidation reconciles.
Where it stands
Working prototype, not yet deployed: functional FX engine, fiscal-calendar engine, spreadsheet migration path, and multi-studio tenancy.