We share with you, following very helpful Excel Utilities prepared by CA Jatan Jain, partner JPRMS & Co., Delhi, as follows:
- GSTR-2A Convertor – When documents are downloaded from GSTN portal (i.e. 2A), it is not compatible for further analysis/scrutiny. This utility helps in making it compatible, comparable with books and convert in single line item with all credit notes prefixed by minus (-) sign. It is very useful for the a person not using any software/tool and depends on 2A downloaded from GSTN. This is pertinent to note that the desired reports can be obtained within a minute.
- Party wise Reconciliation – While reconciling ITC as per 2A and ITC (B2B) as per books of accounts with the criteria of invoice number only, there are several problems being faced. Firstly, mismatch of invoice number due to minor clerical error in entering the invoice number in books, which led to mismatch of large number of invoices which is otherwise in match. Secondly, due to increasing compliances and time limitations, it is practically difficult to do this tedious task. Thus, this utility is developed which matches the ITC as per 2A and ITC (B2B) as per books of accounts with the criteria of GST number. This is an easy method to match the ITC in totality where the conditions of Sec. 16(2) are satisfied. This utility ignores invoice number and give reports on entire detail up to 10,000 line items, party-wise (supplier wise) and gives various reports like match cases, only at portal, only in books and summary report on book vs portal. Moreover, the interface of this utility is made in such a manner that no expert knowledge required to use this utility. Additionally, it is a very useful tool for the GST auditors as well as for the compliance of Rule 36(4) with the help of graphics too. This is pertinent to note that the desired reports can be obtained within a minute.
- Invoice wise Reconciliation – Although the purpose is fulfilled through Party wise utility but to be more precise this utility is developed. It works on the criteria of Invoice number + GST number and the respective tax amount. As an additional feature, the user may ignore the desired amount (i.e., rounding up) in the process of matching the ITC. The various types of reports provided by this utility are – 1. Complete report of party wise/invoice wise/Match or Mismatch, 2. Separate report for GSTN specific, 3. Match Cases, 4. Excess in Books/Portal and the like. Face of the utility has a feature of graphics also which helps to view match and mismatch at a glance. This is pertinent to note that the desired reports can be obtained within a minute.
- Utility for compliance of Rule 36(4) – This utility is prepared in view of notification regarding new rule 36(4) and circular no. 123 to determined maximum ITC (B2B) that can be availed while filing GSTR 3B.
These utilities are meant to ease of working of GST reconciliation and give desired reports in less than a minute.
Though CA. Jatan Jain and his team devoted good amount of time in developing these tools, he has decided not to charge anything from any user. He needs your valuable support to widespread these utilities in the interest of all concerned.
All the utilities can be downloaded from the following link: Download Utilities Detailed flyer on how to use these utilities can also be downloaded from the above link.
CA Jatan Jain acquired membership of ICAI (The Institute of Chartered Accountants of India) in the year 1994 after completion of his graduation.
Presently he is associated with the firm M/s J P R M S & Co. as a senior partner and practicing in the field of direct and indirect taxes for 25 years. He is well versed with the handling of assessment and litigation. He is known for his practical approach towards the implementation of law harmoniously. He made various utilities to ease the working of professionals. He is regularly conducting the seminars and workshop on GST as a speaker.
In case of any clarification/suggestion, CA Jatan Jain can be contacted at firstname.lastname@example.org.
This article is just for information purpose it is always advisable to hire a professional for practical execution. If you need assistance you can ask a question to our expert and get the answer within an hour or post a comment about your views on the post and also subscribe to our newsletter for latest weekly updates.