{% include "_head.html" %} {% include "_style.html" %}
{% include "_brand.html" %}

Reconciliation result

{{ kind }} · {% if created %}{{ created.strftime('%d %b %Y, %H:%M UTC') }}{% else %}just now{% endif %}

{# This URL is the credential — say so plainly, because there is no account to recover it from. #}
Bookmark this page.

It is the only route back to this run — there is no account to log into. It is deleted automatically after {{ footer.retention_days }} days. Treat the link as private: anyone who has it can read this reconciliation.

Summary

{{ result.matched | length }}Matched
{{ result.settlement_only | length }}In gateway, not in bank
{{ result.bank_only | length }}In bank, not in gateway
{{ exceptions | length }}Exceptions
SideTotal
Matched value{{ result.matched_total }}
Unmatched — gateway side{{ result.unmatched_settlement_total }}
Unmatched — bank side{{ result.unmatched_bank_total }}
{% if exceptions %}

Exceptions — these are the rows a person needs to look at

{% for e in exceptions %} {% endfor %}
CategoryAmountWhat it means
{{ e.category }} {{ e.amount }} {{ e.detail }}{% if e.utr %}
UTR {{ e.utr }}{% endif %}
{% else %}

Exceptions

None — every row on both sides either matched or belongs to a matched batch.

{% endif %} {% if result.matched %}

Matched ledger

{% for m in result.matched %} {% endfor %}
Gateway referenceBank UTRAmountHow
{{ m.settlement or '—' }} {{ m.bank or '—' }} {{ m.amount }} {{ m.status }}
{% endif %}

Workpapers

{% if exports %}

Download the files your accountant actually wants:

Tally CSV {% if 'gst.csv' in exports %}GST worksheet{% endif %} {% if 'tds1035.csv' in exports %}TDS code-1035{% endif %} Exceptions (JSON)

GST and TDS workpapers come from the line-item settlement file only — choose "Settlement Recon" on a batch-level run and those two stay empty.

{% else %}

No exports were generated for this run.

{% endif %}

Email me this workpaper pack

{% if saved %}

Saved — thanks. {% if not smtp_ready %}Note: email delivery is not wired up on this deployment yet, so nothing was sent; the address was recorded and the workpapers are in the buttons above.{% endif %}

{% else %} {% if form_error == 'email' %}

That does not look like an email address. Try again, or just use the download buttons above.

{% endif %}

Optional — the downloads above work either way. We use the address to send this pack and, at most, to tell you when a new bank format ships.

{% endif %}

What we read

FileColumns used
Settlement{{ kind }}
Bank statement UTR {{ mapping.utr or '—' }}, amount {{ mapping.amount or '—' }}, date {{ mapping.date or '—' }}

If those columns are wrong, the reconciliation is wrong — re-run it from the upload page and name the columns under Advanced.

{% include "_footer.html" %}