{% extends "base.html" %}
{% block title %}Statements{% endblock %}
{% block body %}
<h1>Month-End Statements</h1>
<p class="sub">A statement file is the source document. Upload a CSV (columns: date, description, amount — signed, dollars), review its lines, then reconcile the ledger to the ending balance.</p>

<h2>Upload statement</h2>
<form method="post" action="/statements/upload" enctype="multipart/form-data">
  <table>
  <tr>
    <td>Account
      <select name="bank_account_id" required>{% for b in banks %}<option value="{{ b.id }}">{{ b.name }} ({{ b.kind }})</option>{% endfor %}</select>
    </td>
    <td>Period <input name="period_label" value="2026-08" size="7" required></td>
    <td>Start <input type="date" name="start" value="2026-08-01" required></td>
    <td>End <input type="date" name="end" value="2026-08-31" required></td>
    <td>Opening balance <input name="opening" size="10" value="0" required></td>
    <td>File <input type="file" name="file" accept=".csv" required></td>
    <td><button type="submit">Upload</button></td>
  </tr>
  </table>
</form>

<h2>Imported statements</h2>
<table>
<tr><th>#</th><th>Account</th><th>Period</th><th class="n">Opening</th><th class="n">Closing</th><th>Status</th><th class="n">Recon diff</th><th></th></tr>
{% for s in stmts %}
<tr>
  <td>{{ s.id }}</td><td>{{ s.ba_name }} ({{ s.kind }})</td><td>{{ s.period_label }}</td>
  <td class="n">{{ s.opening_balance_cents|c }}</td><td class="n">{{ s.closing_balance_cents|c }}</td>
  <td>{% if s.recon==1 %}<span class="pill ok">reconciled</span>{% elif s.recon==0 %}<span class="pill bad">out of balance</span>{% else %}<span class="pill mut">not reconciled</span>{% endif %}</td>
  <td class="n">{{ (s.diff or 0)|c }}</td>
  <td>
    <form class="inline" method="post" action="/statements/{{ s.id }}/reconcile"><button class="sec">Reconcile</button></form>
    <a href="/review">review</a>
  </td>
</tr>
{% endfor %}
</table>
{% endblock %}