@section('page-title', 'Financial Reconciliation')

Financial Reconciliation

Premiums collected vs claims paid analysis

Premiums Collected

${{ number_format($premiumsCollected / 100, 2) }}

Claims Paid

${{ number_format($claimsPaid / 100, 2) }}

Net Position

${{ number_format($netPosition / 100, 2) }}

Loss Ratio

{{ $lossRatio }}%

Pending Liabilities

${{ number_format($claimsPending / 100, 2) }}

@if($periodData->count() > 0)

Premiums vs Claims by Period

@foreach($periodData as $pd) @endforeach
Period Premiums Claims Paid Net Loss Ratio Status
{{ $pd['label'] }} ${{ number_format($pd['premiums'] / 100, 2) }} ${{ number_format($pd['claims'] / 100, 2) }} ${{ number_format($pd['net'] / 100, 2) }} {{ $pd['loss_ratio'] }}% @if($pd['loss_ratio'] > 100) Deficit @elseif($pd['loss_ratio'] > 80) Warning @else Healthy @endif
@endif

Provider Payment Reconciliation

@if($providerReconciliation->count() > 0)
@foreach($providerReconciliation as $pr) @endforeach
Provider Claims Billed Awarded Shortfall
{{ $pr->provider->name ?? 'Unknown' }} {{ $pr->claim_count }} ${{ number_format($pr->total_billed / 100, 2) }} ${{ number_format($pr->total_awarded / 100, 2) }} ${{ number_format($pr->total_shortfall / 100, 2) }}
@else

No provider payments in selected period.

@endif

Pending Provider Liabilities

@if($pendingByProvider->count() > 0)
@foreach($pendingByProvider as $pp) @endforeach
Provider Pending Claims Amount Owed
{{ $pp->provider->name ?? 'Unknown' }} {{ $pp->claim_count }} ${{ number_format($pp->total_awarded / 100, 2) }}
@else

No pending provider liabilities.

@endif
@if($unallocatedPayments > 0)

Unallocated Payments

${{ number_format($unallocatedPayments / 100, 2) }}

Premium payments received but not yet confirmed/allocated

@endif