Bank: {{ $bank_name }} ({{ $bank_account_number }})
Period: {{ $start_date }} to {{ $end_date }}
Status: {{ ucfirst($reconciliation->status) }}
Prepared by: {{ $reconciliation->createdBy->name ?? 'N/A' }} | Approved by: {{ $reconciliation->approvedBy->name ?? 'Pending' }}
| Bank Statement Closing Balance | {{ number_format($reconciliation->statement_closing_balance,2) }} |
| Book (GL) Balance | {{ number_format($reconciliation->reconciled_balance,2) }} |
| Date | Description | Amount | Action |
|---|---|---|---|
| {{ $item->date }} | {{ $item->description }} | {{ number_format($item->amount,2) }} | Post to GL |
| Total | {{ number_format($totalBankOnly,2) }} | ||
| Date | Description | Amount |
|---|---|---|
| {{ $item->date }} | {{ $item->description }} | {{ number_format($item->amount,2) }} |
| Total | {{ number_format($totalBookOnly,2) }} | |
| Bank Ref | Bank Date | GL Ref | GL Date | Amount |
|---|---|---|---|---|
| {{ $t->bank_ref }} | {{ $t->bank_date }} | {{ $t->gl_ref }} | {{ $t->gl_date }} | {{ number_format($t->amount,2) }} |
| Total Reconciling Items | {{ number_format($totalReconcilingItems,2) }} |
| Difference | {{ number_format($reconciliation->difference,2) }} |
Notes: This reconciliation reflects all transactions matched as of the reconciliation date. Outstanding items are carried forward.