The problem
Three years ago this county updated its reserve investment policy to permit a small allocation of tokenized treasuries and stablecoin instruments managed by outside advisors. The allocation performed fine. The paperwork did not.
Positions lived with multiple custodians across different chains. Quarterly reports to the oversight board were assembled by hand. Each custodian exported differently. An analyst spent most of a week reconciling numbers that disagreed by rounding errors, and nobody could answer the board's simplest question quickly: what do we hold right now, in total, at market value?
During an external audit, reconciling one quarter took eleven days. The auditor noted it as a control weakness. That note made its way into the minutes and suddenly fixing it stopped being optional.
What they tried before
The office tested traditional portfolio accounting software built for banks. It simply had no concept of on chain positions, so those rows arrived as manual journal entries anyway, which recreated the entire problem at smaller scale.
A consultant proposed custom middleware with an implementation quote and timeline that made the county administrator laugh out loud in a budget meeting.
How Lumex helped
Lumex connected to every custodian account with read-only credentials, aggregated positions across chains, and priced the full portfolio nightly against market feeds.
Week 1: All custodian accounts linked. First complete single view of holdings. Week 2: Daily valuation snapshots configured, replacing quarterly guesswork. Week 4: Audit exports generated directly from Lumex matched custodian statements line by line. Month 3: The oversight board received its first live portfolio briefing instead of a packet assembled over a week.
The results after 3 months
- Quarterly reconciliation dropped from 11 days to under 2 hours
- The audit control weakness was closed and documented
- Analysts reclaimed roughly 30 hours per quarter
- The board can ask valuation questions mid meeting and get answers mid meeting
- Policy compliance limits are monitored automatically instead of annually
What didn't work
Initial adoption met resistance rooted in caution, which is fair for public money. The treasurer's office ran Lumex parallel with manual reconciliation for one full quarter before trusting it. Read-only access also mattered enormously. Custodians with write permissions would have been an immediate legal review.
What they'd do differently
"We treated a reporting problem as an accounting problem for two years. The moment we saw one screen with every position and a timestamp, we understood how much time the old process was burning."
Next steps
The office plans to extend coverage to the pension fund's alternative allocations, using the same daily snapshot infrastructure for year end statements.