Excel utility for GSTR 2A Reconciliation

Download

Description:

This is an excel utility for GSTR 2A reconciliation with books #zip

Submitted By:

Rajat solanki

on 27 March 2019

Other files by the user

Downloaded:

5959 times

File size:

564 KB

Rating:

Download Other files in GST category

Share Report

Comments

17 September 2021 KANJI

Sir it not work properly the matter cames out do you want replace the contents of the destination cell please re send excel 2a utility on kanji _maruti@yahoo.com this email id

22 March 2020 Karthik Arya MG'z

Please watch this video this utility can reconcil 10,000 transactions I just 2 minutes. It also gives the invoice wise breakup of unreconcilled transactions in single click. For demonstration video on YouTube please click the below link https://youtu.be/BfsvRETbtFc

17 February 2020 Mith's Parihar

Dear Sir, please add one more remark field in the utility format, Like "Taken" Or "Not Taken" in same & other month

22 January 2020 devalaksa

Kindly send me updated reconciliation excel format its my id sathish7254@yahoo.com

22 January 2020 devalaksa

Sir kindly send updated reconciliation excel format?

27 December 2019 Saurabh Punmia

Can you share the code that you used for building this macro/ share file without password protection. Need it to learn more on how to build macros.

22 September 2019 Annayan Das

Thank u sir

30 April 2019 Srinivas Ch

Please make a tool for Supplierwise summery in separate sheet (books vs 2A -taxable value, igst, cgst,sgst columns)

06 May 2019 Rajat solanki
sir put the gstin number in invoice number then it will calculate supplierwise summary

19 May 2019 Srinivas Ch
Sir give me your mail id sir. I will send a reconciliation file. It may useful to you for better reconciliation.

08 June 2019 Subhankar Roy
can you send me excel format for reconciliation of GSTR 2A my mail id is roysubhankar4@gmail.com

12 August 2019 Divyesh Kumar Jain
SIR PLEASE SEND ME ALSO THE RECONCILIATON EXCEL IN MY MAIL ID DIVYESHJAINACS@GMAIL.COM. IT WILL BE VERY MUCH THANKFULL

30 December 2019 Front Office
Please send the same to Frontoffice.acd@gmail.com

01 April 2019 mumtaz ahmad

Very Nice

08 April 2019 gargee
hello Sir, I don't know how to add comment so , putting my comment here .. it's awesome tool for reco . saving lot of time . Thanks a lot .

29 March 2019 Saurabh Sanwal

One more correction required Suppose Vendor Charged IGST 100 (in 2A) & credit availed as CGST+ SGST= 50+50. This is availment in wrong head whereas the utility is showing it as Matched.

29 March 2019 Saurabh Sanwal

It seems you are magician in Excel. Great utility however would suggest if it could highlight probable mis-match case for e.g 1- Inv No 01 & Inv #01 for same GSTIN and date. 2- Typo error in GSTIN

06 May 2019 Rajat solanki
thank you for feedback and the feature would require heavy coding

03 June 2019 Jay Savla
Saurabh, excel has its own limitations. There are softwares which help is addressing these concern. One such software is provided by Firmway Services (https://firmway.in/) which reconciles the data in spit of invoice / GSTN mismatch.