banner_ad

RECONCILIATION OF GSTR 2B Vs BOOKS WITH VBA

ITC / Input 1315 views 10 replies

Through this excel GSTR 2B Vs BOOKS reconciliation can be done within few seconds through using VBA. 

Video link : https://youtu.be/gwsCn3A4qPU?si=Z4Y8pPvhdrsHO3q-

 

 

Replies (10)
Quick Summary
An Excel VBA tool enables quick GSTR 2B vs books reconciliation. Users faced issues with macros, import errors, and data formats, resolved by enabling macro settings, unlocking files, re-downloading updates, and exporting correct Tally reports.

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.

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details