Reconciliation

PR ↔ GSTR-2B matching engine

PR Template 2B Template

Client Details

Files

Purchase Register (Excel)
Click or Drag file

GSTR-2B File (Excel)
Click or Drag file

Please wait...

✅ Reconciliation Complete!

Your analysis sheets are ready.

Column combinations for PR ↔ GSTR-2B (top = highest priority)

On	Label	Columns (comma separated)	Remark

Positive+negative pairs that cancel out are removed before matching

On	Label	Columns (comma separated)	Tax Head	Max

Switch individual matching steps on or off

User Knock-Off Skip rows marked YES in Is Bank / Knock Off col

PR Internal Knockout Find +/- pairs in PR that cancel

2B Internal Knockout Find +/- pairs in 2B that cancel

Rule-Based Match Exact matching based on Match Rules

Fuzzy Invoice Logic Normalize strings, strip zeros for match

Month/Year Match Match by aggregate month values

Bank MAX Match (v2) Advanced subset sum for bank aggregates

Configure tolerances and output delivery

Global Tolerances

Amount Tolerance (₹)

Percentage Tolerance (%)

Email Delivery

Real-time output from the matching engine

Logs will appear here once reconciliation starts...