RECONCILIATION OF GSTR 2B Vs BOOKS WITH VBA

ITC / Input 796 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)

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