Adults Dashboard

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 %} {% for t in totals %} {% endfor %}

Member	{{ m }}	Balance
{{ row.name }} [i]	{{ cell.text }} {% if (cell.status == 'unpaid' or cell.status == 'partial') and cell.raw_month < current_month %} {% endif %}	{{ "%+d"\|format(row.balance) if row.balance != 0 else "0" }} {% if row.payable_amount > 0 %} {% endif %}
TOTAL	received / expected {{ t.text }}

{% 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() %} ```