{% extends "base.html" %}{% load i18n crm_tags %}
{% block title %}{% blocktranslate trimmed with month=first|date:"F Y" %}Accounting report, {{ month }}{% endblocktranslate %}{% endblock %}
{% block content %}
<div class="page-head">
  <div>
    <h1>{% translate "Monthly accounting report" %}</h1>
    <p><strong>{{ CHURCH_NAME }}</strong>, {{ APP_NAME }}. {{ first|date:"F Y" }}.</p>
  </div>
  <div class="actions">
    <a class="btn" href="?month={{ prev_month }}">{% translate "Previous" %}</a>
    {% if next_month %}<a class="btn" href="?month={{ next_month }}">{% translate "Next" %}</a>{% endif %}
    <button class="btn" type="button" data-print>{% translate "Print or save as PDF" %}</button>
    <a class="btn" href="?month={{ first|date:'Y-m' }}&amp;export=csv">{% translate "Download (CSV)" %}</a>
    <a class="btn btn-quiet" href="{% url 'book' %}?month={{ first|date:'Y-m' }}">{% translate "Back to the book" %}</a>
  </div>
</div>

{% if r.empty %}<div class="notice-line">{% translate "Nothing is recorded in the book for this month yet." %}</div>{% endif %}

<section class="report-block" aria-labelledby="bal-h">
  <h2 id="bal-h">{% translate "Balances" %}</h2>
  <div class="table-wrap">
    <table class="report">
      <thead><tr><th></th>{% for a in r.accounts %}<th class="right">{{ a }}</th>{% endfor %}<th class="right">{% translate "Total" %}</th></tr></thead>
      <tbody>
        <tr><td class="title">{% translate "Brought forward" %}</td>{% for v in r.summary.opening.values %}<td class="right money">{{ v|tzs }}</td>{% endfor %}<td class="right money">{{ r.summary.opening.total|tzs }}</td></tr>
        <tr><td class="title">{% translate "Collections" %}</td>{% for v in r.summary.collected.values %}<td class="right money in">{{ v|tzs_signed }}</td>{% endfor %}<td class="right money in">{{ r.summary.collected.total|tzs_signed }}</td></tr>
        <tr><td class="title">{% translate "Expenses" %}</td>{% for v in r.summary.spent.values %}<td class="right money out">{{ v|neg|tzs_signed }}</td>{% endfor %}<td class="right money out">{{ r.summary.spent.total|neg|tzs_signed }}</td></tr>
        <tr><td class="title">{% translate "Credited to bank" %}</td>{% for v in r.summary.moved.values %}<td class="right money">{{ v|tzs_signed }}</td>{% endfor %}<td class="right money muted">{{ r.summary.moved.total|tzs }}</td></tr>
        <tr class="sum"><td class="title">{% translate "Carried forward" %}</td>{% for v in r.summary.closing.values %}<td class="right money{% if v < 0 %} negative{% endif %}">{{ v|tzs }}</td>{% endfor %}<td class="right money">{{ r.summary.closing.total|tzs }}</td></tr>
      </tbody>
    </table>
  </div>
  <p class="net">{% if r.net >= 0 %}{% blocktranslate trimmed with amount=r.net|tzs %}Collections less expenses: <strong>{{ amount }}</strong> more came in than went out.{% endblocktranslate %}{% else %}{% blocktranslate trimmed with amount=r.net|neg|tzs %}Collections less expenses: <strong>{{ amount }}</strong> more went out than came in.{% endblocktranslate %}{% endif %}</p>
</section>

<section class="report-block" aria-labelledby="col-h">
    <h2 id="col-h">{% translate "Collections by source" %}</h2>
    {% if r.collections %}
    <div class="table-wrap">
      <table class="report">
        <thead><tr><th></th>{% for a in r.accounts %}<th class="right hide-sm">{{ a }}</th>{% endfor %}<th class="right">{% translate "Total" %}</th></tr></thead>
        <tbody>
        {% for c in r.collections %}<tr><td>{{ c.label }}</td>{% for v in c.values %}<td class="right money hide-sm">{{ v|tzs_or_dash }}</td>{% endfor %}<td class="right money">{{ c.total|tzs }}</td></tr>{% endfor %}
        <tr class="sum"><td class="title">{% translate "Total collections" %}</td>{% for v in r.summary.collected.values %}<td class="right money hide-sm">{{ v|tzs }}</td>{% endfor %}<td class="right money">{{ r.total_collected|tzs }}</td></tr>
        </tbody>
      </table>
    </div>
    {% else %}<p class="muted">{% translate "No collections recorded." %}</p>{% endif %}
</section>

<section class="report-block" aria-labelledby="exp-h">
    <h2 id="exp-h">{% translate "Expenses by category" %}</h2>
    {% if r.expenses %}
    <div class="table-wrap">
      <table class="report">
        <thead><tr><th></th>{% for a in r.accounts %}<th class="right hide-sm">{{ a }}</th>{% endfor %}<th class="right">{% translate "Total" %}</th></tr></thead>
        <tbody>
        {% for c in r.expenses %}<tr><td>{{ c.label }}</td>{% for v in c.values %}<td class="right money hide-sm">{{ v|tzs_or_dash }}</td>{% endfor %}<td class="right money">{{ c.total|tzs }}</td></tr>{% endfor %}
        <tr class="sum"><td class="title">{% translate "Total expenses" %}</td>{% for v in r.summary.spent.values %}<td class="right money hide-sm">{{ v|tzs }}</td>{% endfor %}<td class="right money">{{ r.total_spent|tzs }}</td></tr>
        </tbody>
      </table>
    </div>
    {% else %}<p class="muted">{% translate "No expenses recorded." %}</p>{% endif %}
</section>

<section class="report-block" aria-labelledby="bank-h">
  <h2 id="bank-h">{% translate "Money credited to the bank" %}</h2>
  {% if r.banked %}
  <div class="table-wrap">
    <table class="report">
      <thead><tr><th>{% translate "Date" %}</th><th>{% translate "From" %}</th><th>{% translate "Bank slip or transaction number" %}</th><th class="hide-sm">{% translate "Bank account" %}</th><th class="right">{% translate "Amount" %}</th></tr></thead>
      <tbody>
      {% for e in r.banked %}<tr><td class="num nowrap">{{ e.on|date:"j M" }}</td><td>{{ e.account_label }}</td><td class="num">{{ e.reference }}</td><td class="hide-sm">{{ e.party }}</td><td class="right money">{{ e.amount|tzs }}</td></tr>{% endfor %}
      <tr class="sum"><td class="title" colspan="4">{% translate "Total credited to the bank" %}</td><td class="right money">{{ r.banked_total|tzs }}</td></tr>
      </tbody>
    </table>
  </div>
  {% else %}<p class="muted">{% translate "Nothing was credited to the bank this month." %}</p>{% endif %}
</section>

<section class="report-block" aria-labelledby="cmp-h">
  <h2 id="cmp-h">{% translate "Compared with what agents recorded in the CRM" %}</h2>
  <p class="muted small">{% translate "Gifts and order payments agents recorded on calls this month, next to the collections in the book. A difference isn’t always a mistake (for example, money that didn’t come through a call), but check any you can’t explain." %}</p>
  <div class="table-wrap">
    <table class="report">
      <thead><tr><th></th><th class="right">{% translate "In the book" %}</th><th class="right hide-sm">{% translate "Gifts" %}</th><th class="right hide-sm">{% translate "Order payments" %}</th><th class="right">{% translate "Recorded by agents" %}</th><th class="right">{% translate "Difference" %}</th></tr></thead>
      <tbody>
      {% for c in r.compare %}<tr><td class="title">{{ c.label }}</td><td class="right money">{{ c.book|tzs }}</td><td class="right money hide-sm">{{ c.gifts|tzs }}</td><td class="right money hide-sm">{{ c.orders|tzs }}</td><td class="right money">{{ c.crm|tzs }}</td><td class="right money{% if c.difference %} diff{% endif %}">{{ c.difference|tzs_signed }}</td></tr>{% endfor %}
      <tr class="sum"><td class="title">{% translate "Total" %}</td><td class="right money">{{ r.compare_total.book|tzs }}</td><td class="hide-sm"></td><td class="hide-sm"></td><td class="right money">{{ r.compare_total.crm|tzs }}</td><td class="right money">{{ r.compare_total.difference|tzs_signed }}</td></tr>
      </tbody>
    </table>
  </div>
</section>

<section class="report-block" aria-labelledby="all-h">
  <h2 id="all-h">{% translate "Every entry this month" %}</h2>
  {% if r.entries %}
  <div class="table-wrap">
    <table class="report book">
      <thead><tr><th>{% translate "Date" %}</th><th>{% translate "What" %}</th><th class="hide-sm">{% translate "Account" %}</th><th class="hide-sm">{% translate "From or to" %}</th><th class="hide-sm">{% translate "Reference" %}</th><th class="right">{% translate "Amount" %}</th></tr></thead>
      <tbody>
      {% for e in r.entries %}<tr class="k-{{ e.kind }}"><td class="num nowrap">{{ e.on|date:"j M" }}</td><td>{{ e.what }}<div class="show-sm small muted">{{ e.account_label }}{% if e.kind == "banked" %} → {% translate "Bank" %}{% endif %}</div>{% if e.note %}<div class="small muted">{{ e.note }}</div>{% endif %}</td><td class="hide-sm">{{ e.account_label }}{% if e.kind == "banked" %} → {% translate "Bank" %}{% endif %}</td><td class="hide-sm">{{ e.party }}</td><td class="hide-sm num">{{ e.reference }}</td><td class="right money nowrap amount">{% if e.kind == "expense" %}−{% elif e.kind == "collection" %}+{% else %}⇄ {% endif %}{{ e.amount|tzs }}</td></tr>{% endfor %}
      </tbody>
    </table>
  </div>
  {% else %}<p class="muted">{% translate "No entries." %}</p>{% endif %}
  {% if r.cancelled %}<p class="muted small">{% blocktranslate trimmed count n=r.cancelled %}{{ n }} cancelled entry is left out.{% plural %}{{ n }} cancelled entries are left out.{% endblocktranslate %}</p>{% endif %}
</section>

<div class="sign-off">
  <p>{% blocktranslate trimmed with who=user.display_name when=made_at|date:"j M Y, H:i" %}Prepared by {{ who }} on {{ when }}.{% endblocktranslate %}</p>
  <div class="sign-lines"><span>{% translate "Checked by" %}</span><span>{% translate "Signature" %}</span><span>{% translate "Date" %}</span></div>
</div>
{% endblock %}