Skip to main content
Free Download · Excel kit

Payment Reconciliation Software Evaluation Kit

Evaluate payment gateway and marketplace settlement reconciliation software on your own payouts, not on a demo. A settlement-rebuild worksheet, fourteen scenario-file templates, a fee-and-tax line catalogue, ten month-end questions and a gated score sheet, in one Excel file. No product is named or ranked.

What's inside — 5 components
Settlement-rebuild worksheet
Rebuild a payout from sales captured, refunds, fees, GST on fees, chargebacks, adjustments, holds and marketplace tax lines, then tie the net to one or more bank credits. Pre-filled with the illustrative ₹1,84,300 settlement from the guide, split across two credits.
Fourteen scenario-file templates (S1 to S14)
Negative payouts, split and combined credits, month-end timing, partial refunds, chargebacks, mid-month fee changes, marketplace TCS and TDS lines, short COD remittances, holds, UPI keys and duplicate references. Write the expected result before each vendor run.
Fee-and-tax line catalogue
Every deduction line on a gateway or marketplace payout with its usual treatment on your side and the rule to check, including section 52 TCS and section 194-O TDS rates by period.
Ten month-end questions
The questions your first month-end output must answer, with a column per vendor for the screen or export that answers each one.
Gated and weighted score sheet
Five pass-or-fail gates, then nine weighted dimensions scored 0 to 5 for up to three vendors, with plain formulas and weights you can edit.
Templates, not data. The kit ships with empty result columns. Build each scenario file from last quarter's real payouts, mask customer details where needed, and write the expected result before any vendor run.

Get the Kit

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 kit really free?
Yes. There is no charge and no trial period. The download link appears immediately on this page after you submit the form. Every table in the kit is also printed in full in the evaluation guide, which needs no form.
Does the kit name or rank any product?
No. The kit is vendor-neutral. It gives you the tests and the score sheet; you run them on the products you shortlist, using your own payouts.
Are the weights an industry standard?
No. They are an example. Edit them to match your mix of gateways, marketplaces and cash-on-delivery before you score.
Disclaimer. This kit is a working template, not tax advice. Rules referenced were checked against RBI, CBIC, Income Tax Department and Department of Financial Services sources on 18 November 2026 and can change; verify current positions with your Chartered Accountant before acting.

Where Terra Insight fits today

Gateway and marketplace settlement reconciliation is on the TransactIG roadmap. Delivered today are TDS reconciliation and bank-to-books matching, with an exception queue, exports and presets, which covers matching each settlement credit in your bank statement to your books.