PivotChart

$487K

Total Revenue (QTR)

↑ 12% vs Q1

$143K

A/R Balance

38.5 days outstanding

96.2%

Clean Claim Rate

Goal: ≥95%

3.8%

Denial Rate

Goal: <5% ✓

21.4d

Days to Payment

Medicare avg: 14d

💰 Overview

📋 A/R Aging

❌ Denials

📄 Claim Log

Monthly Revenue

Last 6 months

Revenue by Payer

${[['Medicare A',68,'#1b3a5c'],['Medicare Adv.',14,'#2563eb'],['Medicaid',11,'#7c3aed'],['Private Pay',5,'#c8923a'],['Other',2,'#94a3b8']].map(([l,v,c])=>`

${l}

${v}%

`).join('')}

Revenue by Service Line

${[['Hospice',58,'#1b3a5c','$282K'],['Home Health',32,'#16a34a','$156K'],['Palliative',6,'#6d28d9','$29K'],['Assisted Living',4,'#92400e','$20K']].map(([l,v,c,amt])=>`

${l}

${amt}

`).join('')}

Key Performance Indicators

${[['Clean claim rate','96.2%',96,'#16a34a','Goal: 95%'],['Collection rate','98.1%',98,'#16a34a','Goal: 97%'],['First-pass rate','92.4%',92,'#c8923a','Goal: 95%'],['Appeal success','71%',71,'#c8923a','Industry: 65%'],['Void / rebill rate','1.2%',88,'#16a34a','Goal: <2%']].map(([l,v,pct,c,bm])=>`

${l}

${v}

${bm}

`).join('')}

$51K

0–30 Days

36% of A/R

$43K

31–60 Days

30% of A/R

$28K

61–90 Days

20% of A/R

$21K

90+ Days

14% — Escalate

A/R Aging by Payer

${[ ['Medicare A — 0-30d',36,'#16a34a','$18,360'], ['Medicare A — 31-60d',28,'#c8923a','$14,280'], ['Medicare A — 61-90d',14,'#dc2626','$7,140'], ['Medicare A — 90+d',8,'#dc2626','$4,080'], ['Medicare Adv — 0-30d',22,'#16a34a','$11,220'], ['Medicare Adv — 31-60d',34,'#c8923a','$17,340'], ['Medicaid — 0-30d',18,'#16a34a','$9,180'], ['Private Pay — 90+d',45,'#dc2626','$9,180'], ].map(([l,v,c,amt])=>`

${l}

${amt}

`).join('')}

⚠️ Action Required — 90+ Day A/R

${[ ['Eleanor Voss','CLM-20240189','Medicare Adv','$4,240','98d','Appeal filed 5/12','appeal'], ['Robert Chen','CLM-20240201','Private Pay','$3,180','112d','Invoice resent 5/20','open'], ['James K. (discharged)','CLM-20240098','Medicaid','$2,890','134d','Sent to collections 6/1','open'], ['Dorothy Harmon','CLM-20240312','Medicare Adv','$5,820','91d','Pending auth review','appeal'], ['William Torres','CLM-20240288','Private Pay','$4,180','95d','Family contacted','open'], ].map(([pt,cl,py,amt,age,act,st])=>` `).join('')}

Patient	Claim #	Payer	Amount	Age	Last Action	Status
${pt}	${cl}	${py}	${amt}	${age}	${act}	${st}

Total Denials (QTR)

$52K

Denied Value

71%

Appeal Success Rate

$37K

Recovered via Appeal

Denial Reasons

${[['Medical necessity',38,'#dc2626'],['Missing/incorrect info',22,'#c8923a'],['Authorization required',18,'#f59e0b'],['Timely filing',11,'#94a3b8'],['Duplicate claim',6,'#16a34a'],['Other',5,'#94a3b8']].map(([l,v,c])=>`

${l}

${v}%

`).join('')}

Denials by Payer

${[['Medicare Advantage',44,'#dc2626'],['Medicaid',28,'#c8923a'],['Private Pay',17,'#f59e0b'],['Medicare FFS',11,'#16a34a']].map(([l,v,c])=>`

${l}

${v}%

`).join('')}

Open Denial Log

${[ ['Eleanor Voss','Hospice','Medicare Adv','Medical necessity','$4,240','05/12/24','appeal'], ['Dorothy Harmon','Home Health','Medicare Adv','Authorization','$5,820','05/28/24','appeal'], ['Grace Kim','Palliative','Medicaid','Missing info','$1,800','06/01/24','open'], ['Harold Jenkins','AL','Private Pay','Timely filing','$3,400','05/15/24','open'], ['Robert Chen','Hospice','Medicare A','Duplicate claim','$2,100','06/03/24','resolved'], ['William Torres','Home Health','Medicare A','Medical necessity','$3,750','04/22/24','resolved'], ].map(([pt,sl,py,reason,amt,dt,st])=>` `).join('')}

Patient	Service Line	Payer	Denial Reason	Amount	Denial Date	Status
${pt}	${sl}	${py}	${reason}	${amt}	${dt}	${st}

Recent Claims

Claim #	Patient	Service Line	Payer	Amount	Service Date	Submitted	Status

📈 Revenue Cycle Analytics