Junior Payment Reconciliation

Balances calculated by matching Google Sheet payments against junior 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 }} [i]	{{ cell.text }} {% if cell.status == 'unpaid' or cell.status == 'partial' %} {% endif %}	{{ "%+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 %}

{% for item in debts %}

{{ item.name }} {{ item.amount }} CZK

{% endfor %}

{% endif %} {% if unmatched %}

Date Amount Sender Message

{% for tx in unmatched %}

{% endfor %}

{% endif %}

Tier: -

Month	Att.	Expected	Paid	Status

{% set rt = get_render_time() %} ```