Skip to main content
Free Download · Excel workbook

AI Reconciliation Vendor Proof Pack

A vendor-neutral Excel workbook for testing AI reconciliation software on your own Indian bank, UPI, TDS and ledger data: twelve claims and their tests, a 14-case India edge pack, a sealed answer key, a score sheet with four gates, and a vendor-response log.

What's inside — 5 components
Twelve-claim test log
Each common vendor claim ("Matching done by AI", "95 to 99 percent auto-match", "learns from your corrections" and nine more) with the question to ask, the test on your own data, the evidence to keep and the red-flag answer, plus result columns for two vendors.
14-case India edge pack
UPI credits with only a handle and reference, truncated NEFT UTRs, TDS-net receipts, duplicate UTRs, returned transfers, own-account transfers, name variants and instruction-like narration text, each with what a sound tool should do and a pass column.
Sealed answer-key sheet
Line ID, amount, masked narration, correct counterpart or EXCEPTION, reason and edge-case ID, so the vendor run can be scored against a month you have already reconciled by hand.
Score sheet with gates
Auto-match rate, precision, recall, value precision, rupee value in wrong matches and flip rate computed from your counts; four PASS/FAIL gates (repeatability, human approval, reasons, data handling); 100-point weights and a shortlist, review or drop decision.
Vendor-response log
The six red-flag questions with columns for the answer given, whether it was good or weak, and who follows up.
Illustrative data included. The score sheet ships with the worked example from the guide so every formula is visibly wired up. Replace the sample counts with your own hold-out month before scoring a vendor.

Get the Proof Pack

The download appears immediately below — no wait, no follow-up call.

Occasional email on Indian reconciliation. Unsubscribe any time — the download stays yours either way.

Frequently Asked Questions

Is the workbook really free?
Yes. There is no charge and no trial period. The download link appears immediately on this page after you submit the form; nothing is emailed to you first.
Do I need the workbook to use the guide?
No. Every table in the workbook is printed in full in the guide. The workbook is the same material arranged for filling in, with the score formulas already wired up.
Does the workbook name or rank any vendor?
No. It is vendor-neutral. The claims are generic, and you fill in the vendor names and results yourself.
Are the numbers in the score sheet real?
No. The pre-filled counts (1,200 lines, ₹605.0 lakh auto-matched and so on) are the illustrative worked example from the guide. Replace them with your own hold-out month.
Disclaimer. The gates and weights are a starting point, not an industry standard. Regulatory references in the guide are summaries; confirm obligations with your auditor and counsel.

Reproducible matching, a recorded reason per decision

TransactIG delivers TDS reconciliation and bank-to-books matching with an exception queue, exports and presets. ISO 27001:2022 certified.