SPOC-CO
Synthetic data prototype — no PHI. Numbers, names, and IDs are fabricated for design review only.

Billing & Revenue

Packet readiness, claim status, and revenue realization

Track TCM (99495/99496) and PCM (99426/99427) billing pipeline from encounter through payment, with exception flags blocking revenue.

Filters

Billing Ready Packets

44

TCM complete + PCM billable

Claims Submitted

36

5.5d svc → submit

Claims Paid

16

15.7d submit → pay

Claims Denied

8

3 reasons

Expected Allowed

$4,840

of $6,974 billed

Paid Amount

$2,563

Revenue Realization

53%

paid ÷ allowed

Blocked Revenue

$3,015

denied + pending

Claim Status Breakdown

Distribution across 40 billing records

Revenue: Expected vs Paid by Month

Allowed amount on claims vs amounts paid by payers

TCM vs PCM Revenue Split

Paid revenue by program

Denial Reasons

Count and blocked dollars by reason

Billing Cycle Timeline

Cohort progression from encounter → note completion → note sent → claim submit → payment

Stage 1

Encounter

100%

Stage 2

Note Completed

94%

Stage 3

Note Sent to USC

83%

Stage 4

Claim Submitted (5.5d avg)

90%

Stage 5

Payment (15.7d avg)

40%

Billing Readiness Exceptions

· 44 total flags blocking billing readiness
7

TCM billing-ready: false

2

Note missing

5

Note not sent to USC

29

PCM monthly minutes not met

1

PCM monthly note incomplete

0

Denied claims missing reason

TCM vs PCM Paid Revenue Trend

Billing Records (40)

Click a row to drill into the patient timeline

Billing IDPatient / EpisodeService / CPTSource RefDOSSubmit DateBilling EntityPayerAllowed / Billed / PaidClaimPaymentDenial Reason
BILL-0001Maria AlvarezPT-000001 · EPI-2026-0001
TCM

CPT 99495

TCM-0001Feb 04, 2026Feb 07, 2026USC Urology Clinical ServicesMedicare FFS$168 / $209 / $168PaidPaid
BILL-0002Thomas BennettPT-000002 · EPI-2026-0002
TCM

CPT 99496

TCM-0002Mar 17, 2026Mar 19, 2026USC Urology Clinical ServicesUnited Healthcare$220 / $281 / $0SubmittedPending
BILL-0003Linda ChenPT-000003 · EPI-2026-0003
TCM

CPT 99495

TCM-0003Feb 17, 2026Feb 20, 2026USC Urology Clinical ServicesHumana Medicare Advantage$164 / $209 / $164PaidPaid
BILL-0004Robert DavisPT-000004 · EPI-2026-0004
TCM

CPT 99495

TCM-0004Feb 25, 2026Mar 03, 2026USC Urology Clinical ServicesAnthem Blue Cross$174 / $209 / $174PaidPaid
BILL-0005George FloresPT-000006 · EPI-2026-0006
TCM

CPT 99495

TCM-0005Feb 07, 2026Feb 14, 2026USC Urology Clinical ServicesHumana Medicare Advantage$0 / $209 / $0DeniedDeniedEligibility issue
BILL-0006Ellen GreenePT-000007 · EPI-2026-0007
TCM

CPT 99495

TCM-0006Feb 15, 2026USC Urology Clinical ServicesAnthem Blue Cross$180 / $209 / $0DraftPending
BILL-0007Samuel HernandezPT-000008 · EPI-2026-0008
TCM

CPT 99495

TCM-0007Mar 04, 2026Mar 09, 2026USC Urology Clinical ServicesHumana Medicare Advantage$184 / $209 / $184PaidPaid
BILL-0008Barbara LawsonPT-000011 · EPI-2026-0011
TCM

CPT 99496

TCM-0008Mar 01, 2026Mar 08, 2026USC Urology Clinical ServicesAnthem Blue Cross$251 / $281 / $0SubmittedPending
BILL-0009Susan NguyenPT-000013 · EPI-2026-0013
TCM

CPT 99496

TCM-0009Mar 20, 2026Mar 26, 2026USC Urology Clinical ServicesMedicare FFS$0 / $281 / $0DeniedDeniedEligibility issue
BILL-0010Donald OwensPT-000014 · EPI-2026-0014
TCM

CPT 99495

TCM-0010Mar 01, 2026Mar 08, 2026USC Urology Clinical ServicesHumana Medicare Advantage$179 / $209 / $0SubmittedPending
BILL-0011Karen ParkPT-000015 · EPI-2026-0015
TCM

CPT 99495

TCM-0011Mar 24, 2026Mar 26, 2026USC Urology Clinical ServicesHumana Medicare Advantage$185 / $209 / $0SubmittedPending
BILL-0012Edward QuinnPT-000016 · EPI-2026-0016
TCM

CPT 99495

TCM-0012Feb 25, 2026Feb 27, 2026USC Urology Clinical ServicesMedicare FFS$186 / $209 / $186PaidPaid
BILL-0013Helen ReyesPT-000017 · EPI-2026-0017
TCM

CPT 99495

TCM-0013Feb 20, 2026Feb 24, 2026USC Urology Clinical ServicesUnited Healthcare$168 / $209 / $168PaidPaid
BILL-0014Kevin UnderwoodPT-000020 · EPI-2026-0020
TCM

CPT 99496

TCM-0014Mar 15, 2026Mar 19, 2026USC Urology Clinical ServicesMedicare FFS$238 / $281 / $238PaidPaid
BILL-0015Sandra VargasPT-000021 · EPI-2026-0021
TCM

CPT 99495

TCM-0015Jan 17, 2026Jan 22, 2026USC Urology Clinical ServicesAnthem Blue Cross$0 / $209 / $0DeniedDeniedTimely filing
BILL-0016Donna XuPT-000023 · EPI-2026-0023
TCM

CPT 99496

TCM-0016Feb 08, 2026Feb 14, 2026USC Urology Clinical ServicesHumana Medicare Advantage$221 / $281 / $221PaidPaid
BILL-0017Emily ZhangPT-000025 · EPI-2026-0025
TCM

CPT 99495

TCM-0017Mar 08, 2026Mar 14, 2026USC Urology Clinical ServicesMedicare FFS$0 / $209 / $0DeniedDeniedEligibility issue
BILL-0018Frank AdlerPT-000026 · EPI-2026-0026
TCM

CPT 99495

TCM-0018Jan 28, 2026Jan 31, 2026USC Urology Clinical ServicesHumana Medicare Advantage$186 / $209 / $186PaidPaid
BILL-0019Howard CarterPT-000028 · EPI-2026-0028
TCM

CPT 99495

TCM-0019Feb 16, 2026Feb 22, 2026USC Urology Clinical ServicesHumana Medicare Advantage$181 / $209 / $181PaidPaid
BILL-0020Janet FosterPT-000031 · EPI-2026-0031
TCM

CPT 99495

TCM-0021Mar 18, 2026USC Urology Clinical ServicesAetna$183 / $209 / $0DraftPending
BILL-0021Mark IversonPT-000034 · EPI-2026-0034
TCM

CPT 99496

TCM-0022Feb 09, 2026Feb 15, 2026USC Urology Clinical ServicesHumana Medicare Advantage$224 / $281 / $0SubmittedPending
BILL-0022Rachel NewmanPT-000039 · EPI-2026-0039
TCM

CPT 99496

TCM-0023Feb 22, 2026Feb 26, 2026USC Urology Clinical ServicesAetna$247 / $281 / $247PaidPaid
BILL-0023Steven OrtegaPT-000040 · EPI-2026-0040
TCM

CPT 99495

TCM-0024Mar 13, 2026Mar 19, 2026USC Urology Clinical ServicesHumana Medicare Advantage$176 / $209 / $0PendingPending
BILL-0024Teresa PruittPT-000041 · EPI-2026-0041
TCM

CPT 99495

TCM-0025Feb 06, 2026Feb 11, 2026USC Urology Clinical ServicesMedicare FFS$186 / $209 / $0PendingPending
BILL-0025Vincent RomeroPT-000042 · EPI-2026-0042
TCM

CPT 99495

TCM-0026Apr 02, 2026Apr 09, 2026USC Urology Clinical ServicesHumana Medicare Advantage$169 / $209 / $169PaidPaid
BILL-0026George FloresPT-000006 · EPI-2026-0006
PCM

CPT 99426

PMR-0004Apr 15, 2026Apr 18, 2026USC Urology Clinical ServicesHumana Medicare Advantage$72 / $83 / $0SubmittedPending
BILL-0027Susan NguyenPT-000013 · EPI-2026-0013
PCM

CPT 99426

PMR-0007Apr 15, 2026Apr 25, 2026USC Urology Clinical ServicesMedicare FFS$70 / $83 / $0SubmittedPending
BILL-0028Helen ReyesPT-000017 · EPI-2026-0017
PCM

CPT 99426

PMR-0010Apr 15, 2026Apr 25, 2026USC Urology Clinical ServicesUnited Healthcare$67 / $83 / $67PaidPaid
BILL-0029Janet FosterPT-000031 · EPI-2026-0031
PCM

CPT 99426

PMR-0016Apr 15, 2026Apr 22, 2026USC Urology Clinical ServicesAetna$67 / $83 / $67PaidPaid
BILL-0030Thomas BennettPT-000002 · EPI-2026-0002
PCM

CPT 99426

PMR-0020Apr 15, 2026Apr 23, 2026USC Urology Clinical ServicesUnited Healthcare$0 / $83 / $0DeniedDeniedEligibility issue
BILL-0031Ellen GreenePT-000007 · EPI-2026-0007
PCM

CPT 99426

PMR-0024Apr 15, 2026USC Urology Clinical ServicesAnthem Blue Cross$72 / $83 / $0DraftPending
BILL-0032Donald OwensPT-000014 · EPI-2026-0014
PCM

CPT 99426

PMR-0026Mar 15, 2026USC Urology Clinical ServicesHumana Medicare Advantage$67 / $83 / $0DraftPending
BILL-0033Karen ParkPT-000015 · EPI-2026-0015
PCM

CPT 99426

PMR-0027Apr 15, 2026Apr 22, 2026USC Urology Clinical ServicesHumana Medicare Advantage$0 / $83 / $0DeniedDeniedTime threshold not documented
BILL-0034Sandra VargasPT-000021 · EPI-2026-0021
PCM

CPT 99426

PMR-0028Mar 15, 2026Mar 21, 2026USC Urology Clinical ServicesAnthem Blue Cross$68 / $83 / $0SubmittedPending
BILL-0035George FloresPT-000006 · EPI-2026-0006
PCM

CPT 99426

PMR-0004Apr 15, 2026Apr 21, 2026USC Urology Clinical ServicesHumana Medicare Advantage$71 / $83 / $0PendingPending
BILL-0036Susan NguyenPT-000013 · EPI-2026-0013
PCM

CPT 99426

PMR-0007Apr 15, 2026Apr 25, 2026USC Urology Clinical ServicesMedicare FFS$69 / $83 / $69PaidPaid
BILL-0037Helen ReyesPT-000017 · EPI-2026-0017
PCM

CPT 99426

PMR-0010Apr 15, 2026Apr 19, 2026USC Urology Clinical ServicesUnited Healthcare$73 / $83 / $0PendingPending
BILL-0038Janet FosterPT-000031 · EPI-2026-0031
PCM

CPT 99426

PMR-0016Apr 15, 2026Apr 18, 2026USC Urology Clinical ServicesAetna$0 / $83 / $0DeniedDeniedEligibility issue
BILL-0039Thomas BennettPT-000002 · EPI-2026-0002
PCM

CPT 99426

PMR-0020Apr 15, 2026Apr 19, 2026USC Urology Clinical ServicesUnited Healthcare$74 / $83 / $74PaidPaid
BILL-0040Ellen GreenePT-000007 · EPI-2026-0007
PCM

CPT 99426

PMR-0024Apr 15, 2026Apr 22, 2026USC Urology Clinical ServicesAnthem Blue Cross$0 / $83 / $0DeniedDeniedEligibility issue