{% set reconCurrency = reconciliation.bankAccount.currency %} Bank Reconciliation Report — {{ reconciliation.bankAccount }}

Bank Reconciliation Report

{{ profile.companyName }} — {{ reconciliation.bankAccount }}

Statement Date: {{ reconciliation.statementDate|date('F j, Y') }} Status: {{ reconciliation.status|replace({'_':' '})|upper }} Prepared: {{ "now"|date('m/d/Y') }}

Balance Reconciliation

{% set diff = totals.adjusted_bank_balance - totals.adjusted_book_balance %}

Bank Statement Ending Balance	{{ totals.statement_ending_balance\|format_currency(reconCurrency) }}
Add: Deposits in Transit	+ {{ totals.deposits_in_transit\|format_currency(reconCurrency) }}
Less: Outstanding Checks / Payments	− {{ totals.outstanding_checks\|format_currency(reconCurrency) }}
Other Bank Adjustments	{{ totals.bank_adjustments\|format_currency(reconCurrency) }}
Adjusted Bank Balance	{{ totals.adjusted_bank_balance\|format_currency(reconCurrency) }}
GL Book Balance	{{ totals.gl_ending_balance\|format_currency(reconCurrency) }}
GL Adjustments	{{ totals.gl_adjustments\|format_currency(reconCurrency) }}
Adjusted Book Balance	{{ totals.adjusted_book_balance\|format_currency(reconCurrency) }}
Difference	{{ diff\|abs\|format_currency(reconCurrency) }} {{ diff == 0 ? '✔ IN BALANCE' : '✗ OUT OF BALANCE' }}

{% if reconciliation.items is defined and reconciliation.items|length > 0 %}

Unmatched Items

{% for item in reconciliation.items %} {% if not item.matched %} {% endif %} {% endfor %}

Date	Description	Type	Amount	Status
{{ item.transactionDate\|date('m/d/Y') }}	{{ item.description }}	{{ item.type\|capitalize }}	{{ item.amount\|format_currency(reconCurrency) }}	Unmatched

{% endif %}