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.
Your Proof Pack is ready
Download ai-reconciliation-vendor-proof-pack.xlsx →Submission failed. You can still download the Proof Pack directly.
Where this workbook fits
The workbook is the packaged form of the evaluation guide. Read the guide first, then use the workbook to run and record each vendor test.
AI Reconciliation Software in India: What to Make a Vendor Prove
The full guide this workbook packages, with every table printed in the article.
Bank Statement Test Pack Before a Software Demo
The basic test pack this workbook extends with AI-specific cases.
Deterministic Reconciliation and Audit Reproducibility
Why the repeatability gate matters to an Indian statutory auditor.
Reconciliation Software India
How TransactIG approaches bank-to-books matching and TDS reconciliation.
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.