⚠️ Payment Reconciliation Alert

Discrepancies Detected

Reconciliation Date: {{ $date }}

Total Discrepancies Found: {{ $totalDiscrepancies }}

Gateways Affected: {{ count($reconciliations) }}

@foreach($reconciliations as $reconciliation)
{{ strtoupper($reconciliation->payment_gateway) }} Gateway
Metric Database Gateway Difference
Transaction Count {{ number_format($reconciliation->total_database_transactions) }} {{ number_format($reconciliation->total_gateway_transactions) }} {{ $reconciliation->transaction_count_difference > 0 ? '+' : '' }}{{ number_format($reconciliation->transaction_count_difference) }}
Total Amount (EUR) €{{ number_format($reconciliation->total_database_amount, 2) }} €{{ number_format($reconciliation->total_gateway_amount, 2) }} {{ $reconciliation->amount_difference > 0 ? '+' : '' }}€{{ number_format(abs($reconciliation->amount_difference), 2) }}
@if(!empty($reconciliation->discrepancies_details))

Detailed Discrepancies:

@foreach($reconciliation->discrepancies_details as $discrepancy)
[{{ strtoupper($discrepancy['severity'] ?? 'MEDIUM') }}] {{ $discrepancy['type'] ?? 'Unknown Type' }}

{{ $discrepancy['description'] ?? 'No description available' }}

@if(isset($discrepancy['order_id'])) Order ID: {{ $discrepancy['order_id'] }} @endif @if(isset($discrepancy['amount'])) Amount: €{{ number_format($discrepancy['amount'], 2) }} @endif
@endforeach @endif
@endforeach

Action Required: Please review the reconciliation reports and investigate the discrepancies.

{{-- Uncomment when admin URL is available --}} {{-- View in Admin Dashboard --}}

This is an automated alert from the Global Gala Payment Reconciliation System.

Generated on: {{ now()->format('Y-m-d H:i:s') }}

If you have questions about this alert, please contact the finance team.