GSTR-2B Reconciler
Upload your Purchase Register and GSTR-2B exports to quickly find missing invoices, suggested matches, mismatches and duplicates. Download an Excel report and follow up vendors — all locally in your browser.
GSTR-2B Reconciler Tool
Upload Books + 2B exports, reconcile, open row details, and export a report. Works with Excel or CSV.
Upload Purchase Register (Books)
Upload CSV or .xlsx. We auto-detect headers/sheets.
Upload GSTR-2B Export(s)
Upload one or more CSV or .xlsx files (multiple months supported).
What you’ll get after reconciliation
Invoices in your purchase register that are not reflecting in GSTR-2B — follow up vendor.
Same GSTIN + invoice no, but minor value/tax differences — verify and correct if needed.
Material differences in tax/value/date — investigate invoice fields and vendor uploads.
Invoices in 2B that are not present in your books — verify booking/period/GSTIN.
Clean matches within tolerance — still verify document-level compliance for final ITC decisions.
Download an Excel report and copy a vendor email draft to chase missing/mismatch invoices.
How to export the right files
- Export Purchase Register (or Inward Supplies) for the period you want to reconcile.
- Ensure it includes Supplier GSTIN and Invoice No.
- Include Invoice Date, Taxable/Invoice Value and GST Tax if possible.
- CSV is usually fastest for large files.
- Download GSTR-2B for the same period (monthly or multiple months).
- You can upload multiple 2B files together (useful for a quarter/year catch-up).
- If your 2B export has multiple sheets, the tool auto-detects the correct sheet & header row.
Required columns (minimum)
The tool can work with many export formats, but these columns give the most reliable results.
| Column | Why it matters | Required? |
|---|---|---|
| Supplier GSTIN | Primary match key (part 1). | Yes |
| Invoice No | Primary match key (part 2). Normalized automatically. | Yes |
| Invoice Date | Helps validate period/date mismatches. | Recommended |
| Taxable/Invoice Value | Useful for value validation & suggested matches. | Recommended |
| IGST/CGST/SGST or Total Tax | Most important validation (tax diff). | Recommended |
Recommended tolerance settings
Start strict, then loosen only if you’re seeing many near-misses due to rounding or export differences.
- Tax tolerance: ₹5
- Value tolerance: ₹10
- Suggested band: automatic (wider “minor diffs” bucket)
- Strip leading zeros: ON (helps match 000123 vs 123)
- Your books export uses invoice value but 2B uses taxable value (or vice versa).
- Large volume with frequent rounding differences.
- Tax split varies due to reporting format (components vs total tax).
Common reasons invoices don’t match
- Slashes/hyphens/spaces (tool normalizes most formats)
- Leading zeros (try enabling “strip leading zeros”)
- Credit/Debit notes using a different document number format
- Invoice booked in a different month than the vendor’s upload
- Taxable value vs invoice value mismatch
- Rounding / component tax split differences
- Wrong GSTIN or wrong invoice no/date uploaded
- Amendment done in a later period (shows later in 2B)
- Duplicate uploads (tool flags as “Needs review”)
- Invoice not booked yet (shows “Missing in Books”)
- Booked under wrong supplier GSTIN
- Tax posted incorrectly in ledger (affects totals)
What to do next (bucket-wise playbook)
- Follow up vendor (use the built-in email copy).
- Verify invoice belongs to the reconciliation period.
- Keep proof of follow-up; track until reflected in 2B.
- Open row details and compare invoice value/tax.
- Often caused by rounding or taxable vs invoice value differences.
- Fix in books or ask vendor to amend if needed.
- Confirm GSTIN + invoice no + date correctness.
- Check if it’s a credit/debit note or amended invoice.
- Escalate to vendor with invoice evidence.
- Verify if invoice is genuinely missing or booked in another period.
- If missing: book it, then re-run reconciliation.
- If wrong supplier/period: correct in books.
- Open row details and compare invoice-level fields to identify the correct one.
- Duplicates may indicate multiple uploads or amendments.
- Resolve and keep notes for audit trail.
Troubleshooting
It says “Could not detect header row/sheet”.
Try a CSV export (often cleaner). Ensure GSTIN and Invoice No columns exist and the file has a single header row. If the workbook has multiple tables, export only the purchase register section.
Dates look blank or mismatched.
Date formats vary across exports. Prefer YYYY-MM-DD or DD/MM/YYYY. If your ERP exports Excel serial dates, keep it as .xlsx; the tool can parse serials.
Too many mismatches.
First confirm the period alignment and whether “value” means taxable vs invoice value. Then increase tolerances slightly if the differences are truly minor (rounding).
My invoice numbers differ due to formatting.
The tool normalizes separators. If you have numeric invoice numbers with leading zeros, enable “strip leading zeros”.
Privacy & limitations
Runs locally in your browser. We don’t store your invoices and you don’t need to sign in.
Designed for fast triage. Always verify results against source invoices and portal data before final ITC decisions.
Sources & verification
- Period mapping: invoice month vs 2B reflection month.
- Value definition: taxable value vs invoice value in your exports.
- Credit/debit notes and amendments (may appear later).
- Final ITC eligibility should be validated with invoice + portal data.
- GST Portal: GSTR-2B download and statement sections (official portal).
- CBIC updates / advisories that impact ITC reflection timing.
- Your ERP/Tally export definitions (taxable vs invoice value columns).
FAQs
Does this tool upload my data?
No. It processes files locally in your browser. Nothing is uploaded to our servers.
Can I upload multiple months of GSTR-2B?
Yes. Upload multiple 2B exports and reconcile them together against your purchase register.
What is “Suggested match”?
It means the invoice key matched but values differ slightly within a minor-difference band. Open row details to verify.
Why do I see “Needs review”?
Usually duplicates or ambiguous matches (same GSTIN + invoice no appears multiple times). Compare invoice-level details.
What if my invoice no has slashes or hyphens?
The tool normalizes invoice numbers by removing separators in matching.
What if invoice numbers have leading zeros?
Enable “strip leading zeros” for numeric invoice numbers to match 000123 with 123.
Can I export the report?
Yes. Export the current tab or a full Excel report with all buckets and a Summary sheet.
Does this work with Tally/Zoho exports?
Yes. Ensure Supplier GSTIN + Invoice No are present. CSV exports often parse fastest for big datasets.
Can it reconcile credit/debit notes?
If your exports contain document number and GSTIN, the tool can match. Differences in document numbering may require review.
Is the output final for ITC claim?
Treat it as a reconciliation assistant. Verify against source invoices and portal data for final ITC decisions.
Related GST tools
Helpful tools for ITC checks, vendor validation, and filing impact estimates.