[Attendance/Fees] [Payment Reconciliation] [Payments Ledger]

Payment Reconciliation

Balances calculated by matching Google Sheet payments against attendance fees.
Source: Attendance Sheet | Payments Ledger
{% for m in months %} {% endfor %} {% for row in results %} {% for cell in row.months %} {% endfor %} {% endfor %}
Member{{ m }}Balance
{{ row.name }} {{ cell }} {{ "%+d"|format(row.balance) if row.balance != 0 else "0" }}
{% if credits %}

Credits (Advance Payments / Surplus)

{% for item in credits %}
{{ item.name }} {{ item.amount }} CZK
{% endfor %}
{% endif %} {% if debts %}

Debts (Missing Payments)

{% for item in debts %}
{{ item.name }} {{ item.amount }} CZK
{% endfor %}
{% endif %} {% if unmatched %}

Unmatched Transactions

Date Amount Sender Message
{% for tx in unmatched %}
{{ tx.date }} {{ tx.amount }} {{ tx.sender }} {{ tx.message }}
{% endfor %}
{% endif %}