Signals

53% claims curve

Peak receipts stack in the week ending 05/15.

Projected inflow reaches $914.0k before easing to the 13-week low of $355.4k in the week ending 05/22.

Claims deposits still carry just over half of the forward curve.

The modeled claims line contributes $3.80M, or 53% of the 13-week total, using the recent eight-week deposit pattern.

HCA holds the largest client-side exposure.

HCA clients represent $974.7k of open A/R and $1.77M of projected non-claims receipts inside the published output.

The slow-pay tail is concentrated in a short list of accounts.

HCA Good Samaritan leads at 78.0 days, followed by HCA TriStar at 63.7 days.

13-week deposit forecast

Projected cash receipts

Peak week: $914.0k
ClientsClaims
$384.2kBase
04/24
$690.1k+80%
05/01
$738.6k+7%
05/08
$914.0k+24%
05/15
$355.4k-61%
05/22
$557.4k+57%
05/29
$563.6k+1%
06/05
$548.7k-3%
06/12
$558.4k+2%
06/19
$472.9k-15%
06/26
$451.0k-5%
07/03
$491.3k+9%
07/10
$438.0k-11%
07/17

Client timing

Largest projected accounts

13-week receipts
HCA Mid-AmericaHCA · Open A/R $354.8k
$525.3k
HCA MethodistHCA · Open A/R $130.2k
$244.2k
HCA CWT AustinHCA · Open A/R $65.5k
$219.7k
HCA TriStarHCA · Open A/R $109.5k
$211.8k
HCA Riverside Community HospitalHCA · Open A/R $73.5k
$207.9k
DLP Conemaugh Physician Practices, LLCOther · Open A/R $189.4k
$189.4k

Longest DSO accounts

Current timing
HCA Good SamaritanHCA · Open A/R $71.6k
78.0 days
HCA TriStarHCA · Open A/R $109.5k
63.7 days
CFG Health Systems, LLCOther · Open A/R $24.5k
61.0 days
UCLA Health SystemOther · Open A/R $33.8k
57.7 days
HCA - NTX - Rapides Regional Medical CenterHCA · Open A/R $34.4k
51.0 days
Signature San AntonioOther · Open A/R $9.1k
49.0 days

Client outlook

57 clients in scope
ClientOpen A/RCurrent DSO04/2405/0105/0805/1505/2205/2906/0506/1206/1906/2607/0307/1007/17
HCA
HCA Mid-America$354.8k37.0 days--$156.9k$198.0k--------$170.4k----------
HCA Methodist$130.2k43.7 days----$285$130.0k--------$114.0k--------
HCA CWT Austin$65.5k43.3 days------$75.5k--------$72.1k------$72.1k
HCA TriStar$109.5k63.7 days------------$109.5k--------$102.3k--
HCA Riverside Community Hospital$73.5k23.3 days$73.5k--------$67.2k------$67.2k------
HCA Continental$89.7k31.7 days----$90.7k------$30.3k------------
HCA Mountain$31.4k31.3 days--$31.4k--------$24.9k------$24.9k----
HCA Good Samaritan$71.6k78.0 days--------$39.1k------$32.5k--------
HCA - NTX - Rapides Regional Medical Center$34.4k51.0 days------$15.5k$18.9k--------$17.9k------
HCA CWT El Paso and Gila$14.0k40.7 days------$14.0k------$12.2k--------$12.2k
HCA subtotal$974.7k44.4 days$73.5k$188.3k$288.9k$234.9k$58.0k$67.2k$164.6k$182.6k$218.7k$85.1k$24.9k$102.3k$84.3k
Advent
Advent North - Deland$34.6k27.7 days--$34.6k------$37.0k--------$37.0k----
Advent North - Fish$32.4k38.0 days----$32.4k--------$31.2k------$31.2k--
Advent North - Waterman$50.0k40.7 days----$29.1k$20.8k------$30.3k----------
Advent North - Palm Parkway$19.2k25.0 days--$19.2k------$16.2k------$16.2k------
Advent North - Palm Coast$15.6k24.7 days--$15.8k------$17.1k------$17.1k------
Advent North - New Smyrna--24.3 days----------$11.7k------$11.7k------
Advent North - Daytona$-36041.0 days--------------------------
Advent subtotal$151.4k31.6 days--$69.6k$61.5k$20.8k--$82.0k--$61.5k--$45.0k$37.0k$31.2k--
Other clients
DLP Conemaugh Physician Practices, LLC$189.4k40.3 days------$189.4k------------------
BrentCare Family First$39.0k45.0 days------$39.0k--------$38.9k------$38.9k
Core Civic - Otay Mesa Detention Center$39.7k34.7 days----$39.7k------$37.7k--------$37.7k--
Indiana Regional Medical Center$41.0k25.0 days--$41.0k------$35.6k------$35.6k------
Long-Term Care (Aggregated)$95.6k13.3 days------$84.0k------------------
MTC - Graceville Correctional Facility$25.1k27.5 days--$25.1k------$21.0k--------$21.0k----
MTC - Bay Correctional Facility$66.6k39.6 days--$38.1k--$28.5k------------------
MTC - Imperial Regional Detention Facility$20.5k32.3 days----$20.5k------$21.9k------$21.9k----
UCLA Health System$33.8k57.7 days----------$33.8k--------$23.7k----
Goodall Witcher$16.0k34.7 days----$16.0k------$16.7k--------$16.7k--
AltaMed$13.4k23.3 days$13.4k--------$13.8k------$13.8k------
Acadia Rio Vista--12.0 days------$13.4k------$13.4k--------$13.4k
CFG Health Systems, LLC$24.5k61.0 days--$12.9k--------$11.6k------$12.9k----
THR Huguley$12.4k33.0 days----$12.4k------$12.0k--------$12.0k--
BrentCare Roots$9.1k31.0 days--$9.1k--------$9.3k------$9.3k----
Step by Step, Inc. LTSR Allentown$5.3k40.3 days------$5.3k------$6.0k--------$6.0k
Signature San Antonio$9.1k49.0 days------$3.7k$5.3k------$5.0k--------
Nell J$4.0k44.0 days------$4.0k--------$3.3k------$3.3k
Cactus Health$3.3k26.7 days--$3.3k------$2.9k--------$2.9k----
Caribou Medical Center$2.4k26.7 days--$2.4k------$3.1k--------$3.1k----
Moffat County Jail$-3.9k27.7 days----------$2.8k--------$2.8k----
Cordova$2.8k26.7 days--$2.8k------$1.6k--------------
Bear Valley Community Healthcare District$1.1k23.7 days$1.1k--------$1.3k------$1.3k------
Ilanka$90034.7 days----$900------$825--------$825--
Optum/Episource, LLC on behalf of CareSource$63025.5 days--------$900--------------$1.6k
LCMC Health--27.3 days--------------------------
Strategic BH - Palms$-3.2k23.7 days--------------------------
Other clients subtotal$648.5k32.8 days$14.4k$134.7k$89.5k$367.5k$6.2k$115.9k$109.9k$19.5k$47.1k$50.7k$97.6k$67.2k$63.2k
Deposit rollup
Client deposits subtotal$1.77M36.7 days$87.9k$392.5k$439.9k$623.3k$64.2k$265.2k$274.6k$263.6k$265.8k$180.8k$159.5k$200.7k$147.5k
Claims deposits----$296.3k$297.6k$298.7k$290.8k$291.2k$292.2k$289.1k$285.1k$292.6k$292.1k$291.5k$290.6k$290.5k
Total all deposits$1.77M--$384.2k$690.1k$738.6k$914.0k$355.4k$557.4k$563.6k$548.7k$558.4k$472.9k$451.0k$491.3k$438.0k

Pipeline notes

Source notes

Apr 22, 2026
  • Published artifact date: Apr 22, 2026
  • Projection job: transform.quickbooks.dso_cashflow_projections
  • Follow-on normalization: transform.finance.cash_receipts_inputs
  • Scope mode: acute corrections
  • Inputs fetched: 1534 invoices, 3156 payments, 6096 deposits
  • Projection detail rows: 277

Next modules

Finance roadmap
Collections by clientScenario overridesA/R aging exceptionsCash receipts bridge