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. #}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
| Side | Total |
|---|---|
| Matched value | {{ result.matched_total }} |
| Unmatched — gateway side | {{ result.unmatched_settlement_total }} |
| Unmatched — bank side | {{ result.unmatched_bank_total }} |
Exceptions — these are the rows a person needs to look at
| Category | Amount | What it means |
|---|---|---|
{{ e.category }} |
{{ e.amount }} | {{ e.detail }}{% if e.utr %} UTR {{ e.utr }}{% endif %} |
Exceptions
None — every row on both sides either matched or belongs to a matched batch.
{% endif %} {% if result.matched %}Matched ledger
| Gateway reference | Bank UTR | Amount | How |
|---|---|---|---|
| {{ m.settlement or '—' }} | {{ m.bank or '—' }} | {{ m.amount }} | {{ m.status }} |
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
| File | Columns 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.