The finance function that shapes clinical decisions vs the one that reports on them after.
The finance function that shapes clinical decisions vs the one that reports on them after.
August 11, 2026
Welcome back to Bridging the Deficit, your go-to resource for financial planning insights — the kind you can actually use, not just theory.
This week: the healthcare and human-services close, and where the extra week actually goes.
If you run FP&A across more than one healthcare or human-services entity, you already know the specific shape of it.
Your operating co closed on day 4. Your 501(c)(3) foundation didn't have grant transfers reconciled until day 8. Your HUD-adjacent housing entity has its own audit cadence and its own separate books. Somewhere in the middle is a payroll accrual that has to cross-allocate agency premiums across three sites, plus a shift-differential adjustment your CNO signed off on last Wednesday. And you have an audit committee on Friday.
Excel doesn't fail on healthcare and human-services orgs. It suffocates them, one workbook rebuild at a time.
In this issue:
- What actually breaks
- How to know if the workbook has become the tax
- Recognize your shape
What actually breaks
Three mechanical realities every healthcare and human-services CFO knows, and most FP&A vendors get wrong:
- Labor is 50 to 65% of your P&L and 40 to 60% of your close cycle. Payroll accrual across sites, agency-timing mismatches, shift differentials, credential-driven pay bands, and grant-funded FTE splits all layer into the same accrual. Miss one layer and total-comp lands 8 to 12% wrong. That's enough that your operating-margin projection loses credibility with the board.
- Multi-entity in healthcare is three problems overlapping. Consolidation between clinical operating cos. Allocation from the foundation into the programs it funds. Compliance-driven separate books for HUD-adjacent housing or 340B carve-outs. Excel treats all three as the same intercompany worksheet.
- Variance defense is manual dig, not drill-through. When the board asks why nursing came in $340K over budget last quarter, the answer lives at the intersection of site × role × pay period × wage-mix. In Excel, finding it takes four hours. Explaining it under audit-committee time pressure is worse.
"It is 9:47 pm on a Sunday. Your board packet goes out at 8 am. Nursing came in $340K over the site-level budget for Q3, and the audit committee will ask why. You already know the fix. Three of your sites hit 45% agency mix in July when you had budgeted 20%. Rebuild the position-level roster, layer the agency-timing accrual across each site, reconcile the intercompany grant flow from the foundation (four hours). Footnote the $340K as "wage-mix drift, see appendix" (twelve minutes). Wake your senior analyst (unknowable relationship cost). If you have ever picked the footnote, this piece is for you."
How to know if the workbook has become the tax
The benchmark most healthcare Controllers never see, for the monthly consolidation close in a labor-heavy multi-entity shop: top-quartile teams close in 5 to 7 days. Median is 10 to 14. Distressed is 20 or more.
Above the median, here is where the extra 5 to 9 days actually go:
- 35% is payroll accrual and wage-mix reconciliation. Agency-timing mismatch, cross-site allocation, benefit-tier layers, shift-differential adjustments. Every extra pay tier compounds.
- 30% is intercompany between operating co, foundation, and separate-books entities. Three different reconciliation patterns running in parallel through one workbook.
- 25% is variance defense. Manual dig backward from consolidated variance to per-site, per-role, per-pay-period.
- 10%, at most, is the strategic judgment work you were hired to do.
Look at the ratio, not the total. Fourteen days is fine if six of them are strategy work. Fourteen days with twelve in payroll accrual and intercompany reconciliation means the workbook has become the tax. Not you. Not your team. The mistakes it forces are the workbook's, not yours.
Recognize your shape
Three flavors of multi-entity healthcare and human services, and the same trap sits under all of them:
- Consolidation-driven. You roll multiple clinical operating cos into one P&L.
- Allocation-driven. One org, dozens of grants and funding sources with real allocation math.
- Compliance-driven separate books. HUD-adjacent housing, 340B carve-outs, VA contract lines that must stay on separate books and still roll up.
Whichever you are, Excel is the same trap. The exit is a system built to hold the shape of your business.
Our customer said it this way
Kyle Raeder is Director of Reimbursement and Financial Planning at Community Care, Inc., a non-profit health-services org spanning community health, hospice, and behavioral care.
"Centage gave us the flexibility we knew we needed, but thought we couldn't achieve. It allowed us to totally change our approach to the budgeting process."
Finance-led. No IT project. A finance team that spends its calendar on judgment instead of assembly, with a seat at the strategy table before the clinical staffing decision, not after.
Monday morning: time-map your close by activity category, bring the ratio to your next CFO one-on-one, and name the specific bottleneck. That is the conversation that ends the tax.
Take the next step
👉 See what the exit looks like: Get a Personalized Demo
4 to 6 week implementation · Onshore FP&A support
See what the exit looks like for a labor-heavy multi-entity health-services org → centage.com/healthcare-workforce-planning
About Centage
Centage delivers the complete FP&A platform—budgeting, forecasting, reporting, and scenario planning—designed to free finance teams from spreadsheet chaos.
For organizations where strategic finance matters, Centage replaces manual processes with automated workflows, real-time collaboration, and seamless integrations—so finance leaders can stop maintaining spreadsheets and start driving decisions.