{% extends "django_program/manage/base.html" %} {% block title %}Reconciliation{% endblock %} {% block breadcrumb %}
Dashboard Reports Reconciliation
{% endblock %} {% block page_title %}

Reconciliation

Financial summary and payment reconciliation for {{ conference.name }}

{% endblock %} {% block page_actions %} {% if perms.program_conference.export_reports %} Export CSV {% endif %} {% endblock %} {% block content %} {% include "django_program/manage/charts/_chart_utils.html" %}
{% include "django_program/manage/charts/_waterfall.html" with chart_data=chart_waterfall_json %}
{% include "django_program/manage/charts/_payment_methods.html" with chart_data=chart_payments_json %} {% include "django_program/manage/charts/_order_status.html" with chart_data=chart_orders_json %}
${{ recon.sales_total|floatformat:2 }}
Total Sales
${{ recon.payments_total|floatformat:2 }}
Total Payments
${{ recon.refunds_total|floatformat:2 }}
Credits Issued
${{ recon.credits_outstanding|floatformat:2 }}
Credits Outstanding
${{ recon.discrepancy|floatformat:2 }}
Discrepancy

By Payment Method

{% if recon.by_payment_method %} {% for row in recon.by_payment_method %} {% endfor %}
Method Count Total
{{ row.method|title }} {{ row.count }} ${{ row.total|floatformat:2 }}
{% else %}

No payments recorded.

{% endif %}

By Order Status

{% if recon.by_order_status %} {% for row in recon.by_order_status %} {% endfor %}
Status Count Total
{% if row.status == "paid" %} Paid {% elif row.status == "pending" %} Pending {% elif row.status == "cancelled" %} Cancelled {% elif row.status == "refunded" %} Refunded {% elif row.status == "partially_refunded" %} Partially Refunded {% else %} {{ row.status|title }} {% endif %} {{ row.count }} ${{ row.total|floatformat:2 }}
{% else %}

No orders recorded.

{% endif %} {% endblock %}