Bank Reconciliation Report

{{-- Standard PDF Header --}} @include('templates.pdf_header', [ 'organisation' => $organisation, 'asOfDate' => $reconciliation->as_of_date, 'currency' => $currency, 'title' => 'BANK RECONCILIATION' ]) {{-- Bank & Book Balances --}}

Bank & Book Balances

Bank Statement Closing Balance	{{ number_format($reconciliation->statement_closing_balance, 2) }}
Book (GL) Balance	{{ number_format($reconciliation->reconciled_balance, 2) }}

{{-- Bank Only Items --}} @if($bankOnlyItems->count())

Bank Only Items (Require Action)

@foreach($bankOnlyItems as $item) @endforeach

Date	Reference / Description	Amount	Action Needed
{{ optional($item->bankTransaction)->date ?? 'N/A' }}	{{ optional($item->bankTransaction)->description ?? 'N/A' }}	{{ number_format($item->matched_amount, 2) }}	Post to GL

@endif {{-- Book Only Items --}} @if($bookOnlyItems->count())

Book Only Items (Outstanding / Deposits in Transit)

@foreach($bookOnlyItems as $item) @endforeach

Date	Description	Amount
{{ optional($item->journalTransaction)->date ?? 'N/A' }}	{{ optional($item->journalTransaction)->description ?? 'N/A' }}	{{ number_format($item->matched_amount, 2) }}

@endif {{-- Matched Transactions --}} @if($matchedTransactions->count())

Matched Transactions

@foreach($matchedTransactions as $t) @endforeach

Bank Ref	Bank Date	GL Ref	GL Date	Amount
{{ optional($t->bankTransaction)->reference ?? 'N/A' }}	{{ optional($t->bankTransaction)->date ?? 'N/A' }}	{{ optional($t->journalTransaction)->reference ?? 'N/A' }}	{{ optional($t->journalTransaction)->date ?? 'N/A' }}	{{ number_format($t->matched_amount, 2) }}

@endif {{-- Totals Section --}}

Summary Totals

Bank Only Total	{{ number_format($totals['bank_only_total'], 2) }}
Book Only Total	{{ number_format($totals['book_only_total'], 2) }}
Matched Total	{{ number_format($totals['matched_total'], 2) }}
Reconciliation Total	{{ number_format($totals['reconciliation_total'], 2) }}
Difference	{{ number_format($totals['difference'], 2) }}

{{-- Totals by Match Type --}} @if($totalsByMatchType->count())

Totals by Match Type

@foreach($totalsByMatchType as $type => $amount) @endforeach

Match Type	Amount
{{ ucfirst($type) }}	{{ number_format($amount, 2) }}

@endif {{-- Notes --}}

Notes:

All transactions are matched as of the reconciliation date.
Outstanding items (Bank Only / Book Only) are carried forward to the next period.
This report is auto-generated and audit-ready.