1. Building a unified data foundation
We began by pulling cash-basis income statements from Pinnacle’s outsourced bookkeeping provider to establish a verified starting point. From there, we reviewed the full set of operational and financial data sources used across the clinics.
The underlying setup was fragmented. One center relied on a cloud-based EMR, another used an older on-premise platform, and a meaningful amount of billing and case data still lived in spreadsheets passed around internally. To address this, we designed a lightweight reconciliation process that integrated information from the multiple EMRs and spreadsheets into a single reporting structure.
We also worked with the team to standardise procedure naming and align key reporting categories so activity recorded in one system could be matched more reliably to activity recorded in another. This created a cleaner base from which to track collections and forecast cash.
2. Creating a clearer view of receivables and cash timing
Once the data foundation was in place, we built a consolidated view showing cash already collected, claims in process, and expected collection windows across the receivables book. The objective was not just to report balances, but to connect each surgery to a realistic expected cash-arrival timeline.
This gave management a more practical understanding of how different payer types affected liquidity. Instead of treating receivables as one static number, the team could now see how settlement timing varied across commercial insurers, workers’ compensation, government programs, and self-pay cases, and how those differences shaped the short- and medium-term cash outlook.
3. Identifying capacity for growth
The consolidated view revealed a stronger forward cash position than leadership had expected. Although slower-paying categories still represented a significant part of the ledger, growth in self-pay volumes was creating a steadier stream of near-term collections.
Using this, we built a twelve-month view of expected cash generation and obligations. That gave management a clearer basis for assessing whether the group could fund operating upgrades, maintain reserves, and expand into new services without placing unnecessary strain on liquidity.
