@section('page-title', 'Financial Summary Report')

Financial Summary Report

Financial totals, monthly trends and benefit usage

← All Reports

Total Billed

${{ number_format($summary['total_billed'], 2) }}

Total Awarded

${{ number_format($summary['total_awarded'], 2) }}

Total Shortfall

${{ number_format($summary['total_shortfall'], 2) }}

Total Paid

${{ number_format($summary['total_paid'], 2) }}

Pending Payment

${{ number_format($summary['total_pending'], 2) }}

Savings Rate

{{ $summary['savings_rate'] }}%

Monthly Trends

@forelse($monthlyData as $month) @empty @endforelse

Month	Claims	Billed	Awarded	Shortfall
{{ $month->month }}	{{ number_format($month->claim_count) }}	${{ number_format($month->billed / 100, 2) }}	${{ number_format($month->awarded / 100, 2) }}	${{ number_format($month->shortfall / 100, 2) }}
No data for selected period.

Claims by Type

@forelse($byClaimType as $ct) @php $maxBilled = $byClaimType->max('billed'); $barWidth = $maxBilled > 0 ? round(($ct->billed / $maxBilled) * 100) : 0; @endphp

{{ $ct->claim_type }} {{ $ct->count }} claims

${{ number_format($ct->billed / 100, 2) }}

@empty

No data for selected period.

@endforelse

Top Benefit Utilization ({{ date('Y') }})

@forelse($topBenefitUsage as $usage) @empty @endforelse

Member	Category	Limit	Used	Utilization
{{ $usage->member->full_name ?? 'N/A' }}	{{ $usage->benefit_category }}	${{ number_format($usage->limit_cents / 100, 2) }}	${{ number_format($usage->used_cents / 100, 2) }}	{{ $usage->getUtilizationPercentage() }}%
No benefit usage data.