{% extends "base.html" %}
{% block title %}{{ t('Reconciliation Report') }}{% endblock %}
{% block content %}
<div class="page-head"><div><small><a href="{{ url_for('bank.index') }}">{{ t('Bank Reconciliation') }}</a></small><h1>{{ t('Bank Reconciliation Statement') }}</h1></div></div>
<form class="filters" method="get">
  <select name="journal_id">{% for j in journals %}<option value="{{ j.id }}" {{ 'selected' if j.id == jid }}>{{ j.bcode }} · {{ j.code }} — {{ nm(j) }}</option>{% endfor %}</select>
  <label>{{ t('As of') }} <input type="date" name="date" value="{{ as_of }}"></label>
  <button class="btn">{{ t('Apply') }}</button>
  <button class="btn ghost" type="button" onclick="window.print()">{{ t('Print') }}</button>
</form>
{% if d %}
<div class="card flush">
  <table class="report">
    <tbody>
      <tr class="section"><td colspan="3">{{ t('Balance per bank statement') }}{% if d.statement %} <small class="muted">({{ d.statement.number }}, {{ d.statement.date }})</small>{% endif %}</td></tr>
      <tr class="total"><td colspan="2">{{ t('Ending balance on the statement') }}</td><td class="num">{{ d.bank|money(cur) }}</td></tr>
      <tr class="section"><td colspan="3">{{ t('Add: deposits in transit') }} <small class="muted">({{ t('in the books, not yet on a statement') }})</small></td></tr>
      {% for r in d.deposits %}<tr><td class="lvl-2 num" style="width:120px">{{ r.date }}</td><td>{{ r.move_name }} · {{ nm({'name_en': r.pname_en, 'name_ar': r.pname_ar}) if r.pname_en else '' }} <small class="muted">{{ r.label or '' }}</small></td><td class="num">{{ (r.debit - r.credit)|money(cur) }}</td></tr>{% endfor %}
      <tr class="subtotal"><td colspan="2">{{ t('Total deposits in transit') }}</td><td class="num">{{ d.dep_total|money(cur) }}</td></tr>
      <tr class="section"><td colspan="3">{{ t('Less: outstanding payments') }} <small class="muted">({{ t('cheques and transfers not yet cleared') }})</small></td></tr>
      {% for r in d.payments %}<tr><td class="lvl-2 num">{{ r.date }}</td><td>{{ r.move_name }} · {{ nm({'name_en': r.pname_en, 'name_ar': r.pname_ar}) if r.pname_en else '' }} <small class="muted">{{ r.label or '' }}</small></td><td class="num">{{ (r.credit - r.debit)|money(cur) }}</td></tr>{% endfor %}
      <tr class="subtotal"><td colspan="2">{{ t('Total outstanding payments') }}</td><td class="num">({{ d.pay_total|money(cur) }})</td></tr>
      <tr class="grand"><td colspan="2">{{ t('Adjusted bank balance') }}</td><td class="num">{{ d.adjusted_bank|money(cur) }}</td></tr>

      <tr class="section"><td colspan="3">{{ t('Balance per books') }}</td></tr>
      <tr class="total"><td colspan="2">{{ t('Bank account balance in the general ledger') }}</td><td class="num">{{ d.book|money(cur) }}</td></tr>
      <tr class="section"><td colspan="3">{{ t('Bank items not yet booked') }} <small class="muted">({{ t('charges, interest, receipts on the statement') }})</small></td></tr>
      {% for r in d.unbooked %}<tr><td class="lvl-2 num">{{ r.date }}</td><td>{{ r.description or '' }} <small class="muted">{{ r.reference or '' }}</small></td><td class="num">{{ r.amount|money(cur) }}</td></tr>{% endfor %}
      <tr class="subtotal"><td colspan="2">{{ t('Total') }}</td><td class="num">{{ d.unbooked_total|money(cur) }}</td></tr>
      <tr class="grand"><td colspan="2">{{ t('Adjusted book balance') }}</td><td class="num">{{ d.adjusted_book|money(cur) }}</td></tr>
      <tr class="{{ 'grand' if not d.difference else 'total' }}"><td colspan="2">{{ t('Unexplained difference') }}</td><td class="num {{ 'neg' if d.difference }}">{{ d.difference|money(cur) }}</td></tr>
    </tbody>
  </table>
  <div class="notes">{{ t('When every statement up to this date is entered and matched, the unexplained difference is zero.') }}</div>
</div>
{% else %}<div class="card empty">{{ t('No bank journals.') }}</div>{% endif %}
{% endblock %}