{% extends '_include/base.html.twig' %} {% block title %}Bank Reconciliation - {{ reconciliation.bankAccount }}{% endblock %} {% block breadcrumbs %} {% endblock %} {% block page_title %}Bank Reconciliation — {{ reconciliation.bankAccount }}{% endblock %} {% block page_actions %} {% if reconciliation.status != 'finalized' %} Finalize {% endif %} PDF Back {% endblock %} {% block content %} {% set reconCurrency = reconciliation.bankAccount.currency %} {% set status_class = reconciliation.status == 'finalized' ? 'badge--success' : (reconciliation.status == 'in_progress' ? 'badge--warning' : 'badge--secondary') %}
Account: {{ reconciliation.bankAccount }}  |  Statement Date: {{ reconciliation.statementDate|date('F j, Y') }}  |  Status: {{ reconciliation.status|replace({'_':' '})|capitalize }}

Balance Summary

{% 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− {{ totals.outstanding_checks|format_currency(reconCurrency) }}
Bank Adjustments{{ totals.bank_adjustments|format_currency(reconCurrency) }}
Adjusted Bank Balance{{ totals.adjusted_bank_balance|format_currency(reconCurrency) }}

GL (Book) Ending 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 ? '✔ Balanced' : '✗ OUT OF BALANCE' }}
{% if reconciliation.status != 'finalized' %}

Import Bank Statement

Upload a CSV export from your bank to auto-match transactions.

Expected columns: Date, Description, Amount
{% endif %}
{% if reconciliation.items is defined and reconciliation.items|length > 0 %}

Reconciliation Items

{% for item in reconciliation.items %} {% endfor %}
Date Description Type Amount Status
{{ item.transactionDate|date('m/d/Y') }} {{ item.description }} {{ item.type|capitalize }} {{ item.amount|format_currency(reconCurrency) }} {% if item.matched %} Matched {% else %} Unmatched {% endif %}
{% else %}
No reconciliation items yet. Import a CSV bank statement to start matching transactions.
{% endif %} {% endblock %}