Revenue Cycle Management

From Cash Risk to Recovery Execution

Revenue Cycle Management board pack showing where hospital revenue is trapped, how much is recoverable, and what operational actions must be worked first.

Hospitals deliver care every day, but clinical activity does not automatically become cash. In the current reporting scope, the platform identifies SAR 997K of revenue exposure and SAR 542K of recoverable queue value. Cash Command diagnoses the exposure; Recovery Queue converts it into ranked operational recovery work.

Generated 18 Sept 2026, 17:10 Currency SAR Default live scope Enhanced narrative view

Executive Storyline

The business problem is cash conversion, not dashboard reporting

The board pack moves from financial exposure to operational action and then into governed decision maturity.

1

Care creates value

SAR 956K

Net patient revenue

Clinical activity creates financial value only when the reporting platform can trace it through billing, insurer review, and collection.

2

Cash gets trapped

Collection 44.2% | Average payment days 454 days | Rejected claim rate 33.3%

Cash conversion pressure

Working-capital pressure appears first in slower payment, weaker collection, and rising rejected-claim behaviour.

3

Risk becomes work

SAR 542K recoverable | SAR 441K expected

Recovery queue

Once risk is quantified, the operating question becomes which work items should be handled first for the greatest cash return per effort hour.

4

Work becomes decisions

90 governed decisions are currently in review, with 66 requiring formal approval.

Decision maturity

Execution ranking is the first maturity layer. Governed approval, dispatch, and measured outcome review are the next layer.

Screen 1 - CFO Position

Cash Command - where is hospital revenue stuck?

CFO position: cash conversion is critical. Average payment days are 454 days against Target <= 40 days, rejected claim rate is 33.3%, and SAR 997.1K is exposed through aged receivables, rejected claims, billing backlog, and underpayments.

Critical
Main message
Cash Command diagnoses the financial problem. SAR 956.1K of net patient revenue has generated only SAR 422.9K of collected cash in the visible scope. The finance team should focus on aged receivables, rejected claims, billing backlog, and underpayments before they become permanent cash loss.

Net Patient Revenue

Healthy
SAR 956.1K

Contract value baseline

Booked contracted cash value for the filtered claim cohort.

Cash Collected

Critical
SAR 422.9K

Posted against the same claim cohort

Posted cash is measured on the same cohort as the journey to avoid period-definition drift.

Collection Rate

Critical
44.2%

Healthy >= 80%

Immediate CFO attention required

Average Payment Days

Critical
454 days

Target <= 40 days

Immediate CFO attention required

Rejected Claim Rate

Critical
33.3%

Healthy <= 5%

Immediate CFO attention required

Revenue at Risk

Critical
SAR 997.1K

Healthy < 10% of NPR

Composite exposure from rejected claims, balances overdue by 90+ days, billing backlog proxy, and underpayments.

Collections vs Charges

Monthly charges, posted cash, and expected collections

The financial story starts with the gap between what was billed, what posted, and what is still expected to arrive.

AprMayJunJulAugSepOctNovDecJanFebMar
Charges Cash collected Expected collections

Aging Buckets

Where unpaid balances are getting older

Average payment days are 454 days and rejected claim rate is 33.3%.

0-30 31-60 61-90 91-180 180+

Rejected Claims and Recovery Pipeline

Rejected claim value versus expected recovery

Collection rate is 44.2%, so converting rejected claims into recovery matters immediately.

Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Revenue Risk Concentration

Where financial exposure is concentrated

Balances overdue 90+ days SAR 533.5K
144 claims | Older unpaid balances create the biggest drag on average payment days.
Rejected claim value SAR 273.8K
72 claims | Rejected balances need appeal or write-off governance.
Underpayments SAR 116.1K
54 claims | Paid below contract value and still recoverable.
Billing backlog proxy SAR 73.7K
18 claims | Open claims are acting as the discharge-to-bill backlog proxy.
Demo script: "Cash Command shows that this is not simply a reporting issue. The hospital has SAR 956.1K net patient revenue, but only SAR 422.9K has converted into cash. Average payment days are 454 days and rejected claim rate is 33.3%. The CFO now knows the cash risk is concentrated in aged receivables, rejected claims, billing backlog, and underpayments."

Screen 2 - Recovery Execution

Recovery Queue - what should the team work first?

Cash Command diagnoses the financial risk. Recovery Queue operationalises it by creating a ranked operating list with expected recovery, effort, due window, owner, insurer, and status.

Watch
Main message
The recovery opportunity is real, and execution pressure is building this week. The recovery opportunity is SAR 542K, expected recovery is SAR 441K, 110 items, 0 items, and 558h effort hours are required.

Recoverable Queue Value

Watch
SAR 542K

Lower is better as actions are worked down.

Total recoverable value across visible queue items.

Expected Recovery

Healthy
SAR 441K

Expected recovery should stay close to recoverable value.

Expected cash recovery after applying row-level expected recovery values.

Due This Week

Critical
110

Target: keep weekly due pressure below 10 items.

Actions due within the next 7 days including today.

Overdue Items

Healthy
0

Target: 0 overdue items.

Items with a due date before today and no terminal status.

High Priority Items

Healthy
0

Use with due pressure to sequence work first.

Rows marked Critical or High by the priority thresholds.

Recovery Effort Hours

Watch
558h

Higher expected cash per hour indicates better queue quality.

Estimated work effort required across visible queue items.

Recovery Mix by Issue

Which issue types hold the most value

Aged Ar Escalation SAR 251.6K
54 items
Denial Appeal Priority SAR 208.1K
54 items
Payer Underpayment Review SAR 82.1K
36 items

Recovery Value by Insurer

Where expected recovery is concentrated

Payer A SAR 134K
39 items
Payer C SAR 139K
40 items
Payer D SAR 97K
40 items
Payer B SAR 71K
25 items

Workload by Owner

Effort concentration by team

Payer.Relations 261h
90 items
Denials.Lead 297h
54 items

Due Window / SLA Risk

Operational urgency mix

Due This Week SAR 407K
110 items
Future SAR 135K
34 items

Ranked Action Table

Top queue items to work first

Claim Insurer Issue Priority Recoverable Expected Effort Score Owner Due Deadline Risk Status
CLM-00151 Payer D Payer Underpayment Review Medium SAR 5,054 SAR 4,549 2h 2,274.48 Payer.Relations 20 Sept 2026 Due This Week Awaiting Review
CLM-00043 Payer D Payer Underpayment Review Medium SAR 5,054 SAR 4,549 2h 2,274.48 Payer.Relations 22 Sept 2026 Due This Week Awaiting Review
CLM-00115 Payer D Payer Underpayment Review Medium SAR 5,054 SAR 4,549 2h 2,274.48 Payer.Relations 24 Sept 2026 Due This Week Awaiting Review
CLM-00187 Payer D Payer Underpayment Review Medium SAR 5,054 SAR 4,549 2h 2,274.48 Payer.Relations 26 Sept 2026 Future Awaiting Review
CLM-00007 Payer D Payer Underpayment Review Medium SAR 5,054 SAR 4,549 2h 2,274.48 Payer.Relations 26 Sept 2026 Future Awaiting Review
CLM-00079 Payer D Payer Underpayment Review Medium SAR 5,054 SAR 4,549 2h 2,274.48 Payer.Relations 28 Sept 2026 Future Awaiting Review
CLM-00031 Payer D Payer Underpayment Review Medium SAR 3,650 SAR 3,285 2h 1,642.68 Payer.Relations 20 Sept 2026 Due This Week Awaiting Review
CLM-00211 Payer D Payer Underpayment Review Medium SAR 3,650 SAR 3,285 2h 1,642.68 Payer.Relations 20 Sept 2026 Due This Week Awaiting Review
CLM-00103 Payer D Payer Underpayment Review Medium SAR 3,650 SAR 3,285 2h 1,642.68 Payer.Relations 22 Sept 2026 Due This Week Awaiting Review
CLM-00175 Payer D Payer Underpayment Review Medium SAR 3,650 SAR 3,285 2h 1,642.68 Payer.Relations 24 Sept 2026 Due This Week Awaiting Review
CLM-00067 Payer D Payer Underpayment Review Medium SAR 3,650 SAR 3,285 2h 1,642.68 Payer.Relations 26 Sept 2026 Future Awaiting Review
CLM-00139 Payer D Payer Underpayment Review Medium SAR 3,650 SAR 3,285 2h 1,642.68 Payer.Relations 28 Sept 2026 Future Awaiting Review
Demo script: "Recovery Queue converts the cash problem into action. The queue contains SAR 542K recoverable value and SAR 441K expected recovery. Nothing is overdue today, but 110 items and 558h are required. This means the queue is controlled now, while execution pressure is building."

Product Maturity Layer

Decision Queue - the next layer after execution ranking

The current recovery queue is an execution queue. Governed approval, dispatch, audit trail, and outcome measurement are not yet fully configured.

Critical

Decisions requiring review

Critical
90

Approval required

Critical
66

Expected recovery under decision

Watch
SAR 350K

Dispatched decisions

Healthy
0

Observation Queue

Recovery Work Queue currently holds SAR 542K across 144 visible work items.

Decision Review Queue

90 governed decisions are currently in review, with 66 requiring formal approval.

Outcome Review

Outcome measurement structure exists but production RCM actual-recovery measurement is deferred.

Positioning
Demo this release as cash recovery execution. Position the decision queue as the next release: governed intervention, approval, and outcome measurement.

Board Talk Track

One-minute executive narrative

This script is generated from the same live board-pack payload used for the sections above.

This use case solves a real CFO problem: hospitals create revenue through care delivery, but that revenue often gets trapped before it becomes cash. Cash Command shows where the money is stuck across rejected claims, aged balances, billing backlog, underpayments, and collections. In the current reporting scope, net patient revenue is SAR 956K, cash collected is SAR 423K, collection rate is 44.2%, average payment days are 454 days, and revenue at risk is SAR 997K. Recovery Queue then converts that financial risk into ranked recovery work: SAR 542K recoverable value, SAR 441K expected recovery, 110 items due this week, and 558h effort hours required. This shifts revenue cycle management from passive reporting to active cash recovery execution.

Data Trust

Source coverage, freshness, and metric conditions

Data-trust details appear only here so the board story stays executive-first while still exposing coverage, freshness, definitions, and known limitations.

Generation Scope

What this report used

Generated 18 Sept 2026, 17:10 | Currency SAR | Default live scope

  • No scope filters were applied.

Source Freshness

Section freshness signals

  • Cash Command: fresh
  • Recovery Queue: fresh
  • Decision Queue: fresh

Source Tables and Views

Technical lineage at report time

analytics.fct_revenue_cycle Gross charges, contracted value, posted cash, and claim states. loaded
analytics.fct_claim_aging Current unpaid-balance snapshot and aging buckets. loaded
analytics.fct_denials Rejected-claim recovery queue mix and comparable rejected-claim pipeline trends. loaded
analytics.fct_cash_recovery_opportunity Recovery backlog source loaded
analytics.fct_revenue_leakage Underpayments, late submissions, and leakage categorization. loaded
decision.decision_queue Persisted governed decisions loaded
decision.decision_outcomes Measured recovery outcomes for completed actions when available. loaded
decision.notification_log Dispatch and notification evidence loaded
decision.decision_log Decision audit trail loaded

Metric Definitions

Live calculation rules

  • Collection Rate: Cash collected divided by net patient revenue in the current reporting scope.
  • Rejected Claim Rate: Rejected claim value divided by submitted claim value in the current reporting scope.
  • Revenue at Risk: Composite exposure from rejected claims, balances overdue by more than 90 days, billing backlog proxy value, and underpayments.
  • Recoverable Queue Value: Sum of recoverable value across live recovery work items.
  • Expected Recovery: Sum of expected recovery across live recovery work items.
  • Priority Score: Expected recovery per effort hour, adjusted by backend urgency multipliers and approval logic.

Unavailable or Missing Metrics

Safe fallbacks only

  • Clean claim rate
  • Coding completion rate
  • Recovery probability by payer cohort

Warnings and Limitations

Known caveats

  • Claim created and claim submitted are inferred from claim status because separate workflow timestamps are not modeled.
  • Cash collected uses posted cash attached to the filtered claim cohort to preserve payer and department consistency.
  • Comparable-case support uses seeded benchmarks until RCM outcome history accumulates.
  • Dispatch persists audit evidence but remains a manual downstream handoff until workqueue integration is connected.
  • Facility, specialty, and patient type filters are accepted but ignored because those dimensions are not present on the live marts.
  • Billing backlog is proxied with open-claim contractual value rather than a discharge-specific queue table.
  • Cash collected is measured on the filtered claim cohort instead of a standalone posting-period ledger slice so KPI cards and journey totals stay reconciled.
  • Facility, specialty, patient type, and claim status filters are accepted for contract compatibility but are not available on the current recovery queue mart.
  • The queue is ranked with existing backend priority_score when present; otherwise the fallback score uses expected recovery per effort hour adjusted by due-date urgency.
  • Outcome review structure exists but RCM measurement is not yet populated from production recovery outcomes.

Scoring Logic

How queue ranking is explained

  • Total recoverable amount across visible queue items.
  • Visible queue value adjusted by row-level expected recovery estimates.
  • Existing backend score when present, otherwise expected recovery per effort hour adjusted by due-date urgency.
  • decision_score = expected_recovery_value * recoverability_probability * urgency_multiplier * policy_weight * confidence_weight / effort_hours
  • Urgency multiplier reuses the Recovery Work Queue due-date pressure bands.
  • Critical / High / Medium priority thresholds reuse the existing recovery priority score breakpoints.

OpenCare Revenue Cycle Management board pack ยท Generated 18 Sept 2026, 17:10