Executive Summary
{{ $data['school_info']['currency'] }} {{ number_format($data['summary']['total_revenue'], 2) }}
Total Revenue
{{ number_format($data['summary']['collection_rate'], 1) }}%
Collection Rate
{{ number_format($data['summary']['financial_health_score'], 0) }}/100
Health Score
{{ $data['summary']['status'] }}
Overall Status
Revenue Analysis
| Metric |
Count |
Amount ({{ $data['school_info']['currency'] }}) |
| Bills Generated |
{{ $data['revenue_analysis']['bills_generated']['count'] }} |
{{ number_format($data['revenue_analysis']['bills_generated']['amount'], 2) }} |
| Payments Received |
{{ $data['revenue_analysis']['payments_received']['count'] }} |
{{ number_format($data['revenue_analysis']['payments_received']['amount'], 2) }} |
| Outstanding Bills |
{{ $data['revenue_analysis']['outstanding_bills']['count'] }} |
{{ number_format($data['revenue_analysis']['outstanding_bills']['amount'], 2) }} |
Payment Method Analysis
@if(count($data['payment_analysis']['payment_methods']) > 0)
| Payment Method |
Count |
Amount ({{ $data['school_info']['currency'] }}) |
Percentage |
@php $totalAmount = $data['payment_analysis']['payment_methods']->sum('total_amount'); @endphp
@foreach($data['payment_analysis']['payment_methods'] as $method)
| {{ ucfirst($method->payment_method) }} |
{{ $method->count }} |
{{ number_format($method->total_amount, 2) }} |
{{ $totalAmount > 0 ? number_format(($method->total_amount / $totalAmount) * 100, 1) : 0 }}% |
@endforeach
@endif
@if($data['payment_analysis']['cash_analysis']['count'] > 0)
Cash Payment Alert:
{{ $data['payment_analysis']['cash_analysis']['count'] }} cash payments totaling
{{ $data['school_info']['currency'] }} {{ number_format($data['payment_analysis']['cash_analysis']['total_amount'], 2) }}
(Average: {{ $data['school_info']['currency'] }} {{ number_format($data['payment_analysis']['cash_analysis']['average_amount'], 2) }} per transaction)
@endif
@if(count($data['fraud_indicators']) > 0)
🚨 Fraud Risk Indicators
@foreach($data['fraud_indicators'] as $indicator)
{{ strtoupper($indicator['severity']) }} RISK:
{{ $indicator['description'] }}
Value: {{ $indicator['value'] }}
@endforeach
@endif
@php $discrepancies = $data['cash_discrepancies']; @endphp
@if($discrepancies['risk_score'] > 10)
⚠️ Cash Transaction Discrepancies
Risk Score: {{ $discrepancies['risk_score'] }}/100
@if(count($discrepancies['cash_not_deposited']) > 0)
{{ count($discrepancies['cash_not_deposited']) }} cash payments have no corresponding bank deposit record.
@endif
@if(count($discrepancies['potential_duplicates']) > 0)
{{ count($discrepancies['potential_duplicates']) }} potential duplicate payments detected (same amount on same day).
@endif
@if(count($discrepancies['round_number_payments']) > 0)
{{ count($discrepancies['round_number_payments']) }} round number cash payments detected (may warrant review).
@endif
@endif
@php $integrity = $data['billing_integrity']; @endphp
@if($integrity['integrity_score'] < 95)
📊 Billing System Integrity
Integrity Score: {{ $integrity['integrity_score'] }}/100
@if(count($integrity['bills_without_transactions']) > 0)
{{ count($integrity['bills_without_transactions']) }} bills have no corresponding accounting transactions.
@endif
@if(count($integrity['payments_without_bills']) > 0)
{{ count($integrity['payments_without_bills']) }} payments have no corresponding bills.
@endif
@endif
@if(count($data['recommendations']) > 0)
💡 Recommendations
@foreach($data['recommendations'] as $rec)
{{ strtoupper($rec['priority']) }} PRIORITY - {{ ucwords(str_replace('_', ' ', $rec['category'])) }}:
{{ $rec['recommendation'] }}
@endforeach
@endif
Account Reconciliation
| Account |
Debits |
Credits |
Net Change |
Transactions |
@foreach($data['account_reconciliation'] as $account)
| {{ $account['account_name'] }} ({{ $account['account_code'] }}) |
{{ number_format($account['debits'], 2) }} |
{{ number_format($account['credits'], 2) }} |
{{ number_format($account['net_change'], 2) }}
|
{{ $account['transaction_count'] }} |
@endforeach