Skip to main contentSkip to navigation
SeniorCRE Logo
Financial Workflow 08 of 10

How does the platform produce a rolling 13-week cash forecast operators trust?

Designed · Expected outcomeEvidence: Expected outcomePrimary decision maker: CFOAlso: CEOLast updated:

Design target · Expected outcome

±15% → ±5% accuracy

Design target modeled from workflow design. No operator community has been measured, no approved Evidence Record supports it, and business outcomes remain contributory — figures are targets, not results. See Industry Findings for methodology.

Incumbents this workflow touches

Proposed in-platform scope: Manual 13-week cash model in Excel

Roadmap integration targets (not live): Treasury Prime · Bank reporting (BAI2) · Cash positioning tools

The operator may retain existing systems or select SeniorCRE for defined functions. Alongside existing systems, this workflow would depend on approved source access, implementation and operator acceptance. Named vendor integrations are roadmap targets, not completed connections.

The problem

Cash forecasts are built in Excel from a snapshot of AR and a guess at payroll. When the actual lands at the end of the week, it bears little resemblance to the forecast, and capital decisions are made on stale data.

How the platform is designed to run it

A rolling 13-week cash forecast is built from accepted source evidence reconciled to the operator-approved ledger definition: AR collections by payer with historical lag, payroll from the schedule, AP from approved invoices and recurring commitments, debt service, and capex commitments. Variance to forecast is reported weekly with explanations.

Proposed operating behavior, not a live deployment. Source access, implementation and operator acceptance must be established before this workflow can operate in a community.

On the shift (illustrative)

Illustrative example on synthetic data. Names, figures, and events are not from any operator community.

The CFO opens the rolling 13-week forecast on Monday morning. AR collections by payer use historical lag — Medicare pays in 18 days, this Medicaid plan in 47, private-pay in 33. Payroll comes from the live schedule, not last year’s average. AP commitments include the three large vendor invoices approved last week. Variance to last week’s forecast is +$118K, explained by a faster-than-expected Medicare batch payment. The capex draw on Friday is sized to the actual position, not a guess.

Design target

Design target, not measured in any community: Forecast accuracy moves from ±15% to inside ±5%. Treasury decisions — line-of-credit draws, distributions, capex timing — are made on data instead of intuition.

Design target only: not measured or validated in any community. Actual results require an operator baseline and pilot acceptance.

What goes wrong without it

On Excel cash forecasts, the AR pull is a static snapshot, payroll is the prior-period average, and AP is whatever the controller remembers. Variance to forecast is routinely 15%. The line-of-credit draw is sized large to be safe; the unnecessary interest is real money. Capital decisions — distributions, capex timing, hold-or-buy on a property — get made on a forecast everyone privately distrusts.

Show me the evidence

Operators do not buy claims. They buy proof. If anything on this page reads as aspirational, ask us to walk you through exactly what is built, what is designed, and what is not yet in production in any community.

Where this connects in the platform

Every financial workflow runs on the same record. These are the feature pages, head-to-head comparisons, and pillar articles that go deeper on the surfaces this workflow touches.

Regulatory and accounting references

Financial workflows on this page reflect CMS PDPM and PDGM payment rules, GAAP revenue recognition (ASC 606), and the state Medicaid case-mix programs that drive reimbursement.

Stay up to date

The Senior Housing Journal, in your inbox

Perspectives on operator-governed operating information, capital and operating developments across senior housing & care, and platform updates from SeniorCRE.

By subscribing, you agree to receive the Senior Housing Journal newsletter. Unsubscribe at any time. See our Privacy Policy.