RECONCILIATION OF GSTR 2B Vs BOOKS WITH VBA

Great job :-)...............................

Hi, This is not working............

Please share screenshot I will let u know how it will be fixed 

After downloading the excel sheet please save as excel sheet as " Excel Macro-Enabled Template" . it will work

Hello Sir. 

Really Appreciate this.

But what if the entries are entered as journal type and not in Purchase ?

Please Export total input from Gateway of tally-> Display more reports-> Statutory Reports-> Gstr 3B in same format. 

Dear Sir, before opening the file, you need to right-click the file, go to the Properties section, check the "Unlock file," click Apply, and then Save. Then it will work.

Hi

there was some problem while importing GSTR 2B ( in B2B-CDNR tab) which is resolve d now. So Please download again before use

Hi, Sir,

Its working now.

Thank you.

Reconciling GSTR-2B against your books every month matters a lot more now that the portal hard-locks ITC from April 2026. For the VBA approach, most CAs build a lookup that matches invoice-by-invoice on supplier GSTIN, invoice number, and tax amount, then flags mismatches and groups them by supplier for bulk follow-up. If a mismatch persists after the supplier corrects their GSTR-1, you claim only the matched amount in GSTR-3B to avoid blocking.

 Our [GST compliance checklist for FY 2026-27](https://taxgarden.in/resources/gst-compliance-checklist-india-2026-27) has the reconciliation steps with monthly timelines if useful.