{% 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') %}
| 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' }} |
Upload a CSV export from your bank to auto-match transactions.
| 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 %} |