Friday · July 17, 2026 · 4:05 PM · Finance Office

Nadia Rahman, CPA

Billing ManagerDay Shift · 9:00 AM – 6:00 PMCounters Settling · Closes 6 PM

Pending Collections: $5,140
Outstanding: $2,680
Refund Requests: 3 open

Revenue Today

$24,685

171 transactions · +9.2% vs yesterday

Day closing blocked — 2 overdue invoices

$1,100 must be collected, written off or escalated before the 6 PM reconciliation.

Revenue Flow Pipeline

Payment Processing — 18 pending

Patient Registration
214 tx
$3,210
100% flowClear
Consultation
186 tx
$14,880
92% flow6 pending
Invoice Generated
162 tx
$41,350
84% flow12 pending
Payment Processing
128 tx
$28,940
71% flow18 pending
Insurance Verification
44 tx
$19,230
58% flow9 pending
Completed
119 tx
$26,180
66% flowClear

Live Billing Queue

8 open · $16,010 in play

Draft

2 · $1,420

INV-9218VIP$1,240

Amelia Hartley

Radiology

Card Jul 17Not covered

INV-9219$180

Dmitri Volkov

OPD

Cash Jul 17

Pending Payment

2 · $5,140

INV-9214High$4,820

Harold Nakamura

IPD · Cardiology

Insurance Jul 19Verifying

INV-9215$320

Sofia Marino

Laboratory

UPI Jul 17

Insurance Review

2 · $8,350

INV-9211High$6,140

Rosa Delgado

IPD · Med-Surg

Insurance Jul 21Claim filed

INV-9208Urgent$2,210

Fatima Al-Rashid

Emergency

Insurance Jul 20Pre-auth OK

Paid

2 · $405

INV-9209$260

Johan Petersen

OPD · Cardiology

Card Paid 2:40 PM

Settled · receipt emailed

INV-9206$145

Hana Suzuki

Laboratory

UPI Paid 1:15 PM

Settled · receipt emailed

Overdue

2 · $1,100

INV-9187High$890

Bruno Silva

Orthopedics

Card Jul 10Rejected

INV-9171$210

George Mensah

Pharmacy

Cash Jul 5

Revenue Analytics

7-day trend in each tile

Today's Revenue

$26,180

+9.2%

Weekly Revenue

$148,420

+6.4%

Monthly Revenue

$512,090

+11.8%

Outstanding Balance

$38,660

-4.1%

Collection Rate

93.4%

+1.2 pts

Avg Invoice Value

$318

+$14

Payment Center

101 tx today

Cash Payments

$4,120

38 transactions16% of mix

Card Payments

$7,860

41 transactions30% of mix

Online Payments

$3,340

22 transactions13% of mix

Insurance Claims Center

Pending

Approved

Rejected

Reimbursed

CLM-4471Under Review$6,140

Rosa Delgado

MediShield Plus

CLM-4468Pending$4,820

Harold Nakamura

HealthFirst

CLM-4462Approved$2,210

Fatima Al-Rashid

CarePlus Assurance

CLM-4455Rejected$890

Bruno Silva

MediShield Plus

CLM-4449Reimbursed$3,480

Emmett Sandoval

HealthFirst

CLM-4431Expiring$1,750

Miriam Adeyemi

CarePlus Assurance

Outstanding Collections

$2,680 overdue

Bruno Silva

$890

Due Jul 10 · 2 reminders sent

+1 555-0142

days

George Mensah

$210

Due Jul 5 · Final notice sent

+1 555-0177

days

Peter Kowalski

$460

Due Jul 14 · 1 reminder sent

+1 555-0129

days

Selma Björk

$1,120

Due Jul 16 · Not reminded yet

+1 555-0158

days

Department Revenue

Today

OPD

$6,840

96 collections+8% vs yesterday

IPD

$8,920

21 collections+12% vs yesterday

Pharmacy

$4,310

87 collections+5% vs yesterday

Laboratory

$3,150

64 collections-2% vs yesterday

Refund Management

3 in workflow

RFD-312Pending Approval$85

Sofia Marino

Duplicate lab charge

RFD-311Approved$220

Amelia Hartley

Cancelled radiology slot

RFD-309Completed$60

Johan Petersen

Overpayment at counter

RFD-308Requested$145

Hana Suzuki

Test not performed

Financial Performance

MTD

93%

Collection Efficiency

87%

Insurance Success

2.1d

Avg Payment Time

1.8%

Refund Ratio

+11.8%

Revenue Growth

24.6%

Profit Margin

Recent Transactions

Payments4:02 PM

Payment received — $260 card settlement for INV-9209

Invoices3:55 PM

INV-9219 created — OPD consultation for Dmitri Volkov

Insurance3:48 PM

CLM-4462 approved — CarePlus pre-auth for $2,210

Reminders3:30 PM

Collection reminder sent to Bruno Silva — $890, 7 days overdue

Refunds3:12 PM

RFD-309 processed — $60 refunded to Johan Petersen

Invoices2:58 PM

INV-9201 cancelled — duplicate registration charge voided

Payments2:40 PM

UPI payment — $145 for INV-9206, receipt auto-emailed

Insurance2:15 PM

CLM-4471 filed with MediShield Plus — $6,140 inpatient stay

Reminders1:50 PM

Final notice issued to George Mensah — $210, 12 days overdue

Refunds1:20 PM

RFD-312 requested — duplicate lab charge flagged by front desk