GSTR-2B Reconciliation for India
Match your GSTR-2B with your purchase books, see what is missing or different, and fix it before you claim input tax credit in GSTR-3B. Upload the GSTR-2B JSON or Excel from the GST portal and your purchase register from Tally, Busy or Excel. The tool finds matched, mismatched, probable, amended and missing invoices, builds the ITC reconciliation statement, flags section 17(5) items, shows section 16(4) deadlines and the Rule 37 180-day check, and drafts supplier follow-up messages. It works offline and your files never leave your browser.
What it does
- Reads GSTR-2B JSON and Excel, including credit and debit notes and amendments.
- Reads Tally, Busy and Excel purchase registers, with automatic column recognition.
- Matches by GSTIN and invoice number, number formats, GSTIN typos, tax-head differences, amended and duplicate documents and split invoices.
- Builds the ITC reconciliation statement and shows ITC not available in 2B.
- Flags section 17(5) items for review and remembers your decisions.
- Shows section 16(4) last dates and the Rule 37 180-day check.
- Lists ITC at risk by supplier with follow-up messages.
- Downloads Excel, PDF and Word reports; saves your session automatically.
Who it is for
Chartered accountants, tax practitioners, accounts and finance teams, and GST-registered businesses that claim input tax credit every month.
Questions
What is GSTR-2B reconciliation?
It is the comparison of the input tax credit shown in your GSTR-2B with the credit recorded in your purchase books, so that you claim only what the GST portal supports and fix the differences before filing GSTR-3B.
Can I reconcile GSTR-2B with Tally or Busy data?
Yes. Upload the GSTR-2B JSON or Excel from the GST portal and your purchase register as Excel or CSV from Tally, Busy or any other software. Columns are recognised automatically and can be changed.
Does it find mismatches such as a different invoice number or GSTIN typo?
Yes. It matches ignoring slashes, dashes and leading zeros, pairs numbers like VPM/26-27/0045 and 45, spots a GSTIN that differs by one character, tax-head differences, amended documents, duplicates and one invoice split across several entries.
Does it check section 17(5) blocked credit?
It flags entries whose supplier name, ledger or HSN suggests a blocked category and lets you record a decision for each bill or vendor. A flag is a prompt to review, not a finding.
Does it show the section 16(4) deadline and Rule 37 180-day check?
Yes. It lists booked credit not supported by 2B with the last date to claim, and if your books have a payment date it flags invoices unpaid or paid after 180 days.
Does it remember my work after a refresh?
Yes. Auto-save is on by default and keeps your files, column mapping, period and results in your browser for each client. Press Start fresh to clear them, or switch Auto-save off.
Can I send reminders to suppliers whose invoices are missing from GSTR-2B?
Yes. The vendor follow-up tab lists each supplier with the ITC at risk and a ready message you can edit and copy. Follow-up status is saved for the client from month to month.
Is my data safe?
Everything is processed in your browser. Your files are not uploaded to Techmin or anyone else, and the tool works offline after the first visit.
Loading the tool… If nothing appears, please enable JavaScript.