GSTR-2A Converter, Vendor Wise Reconciliation, Invoice wise Reconciliation and Rule 36(4) Utilities

• 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.

GSTR-2A Convertor

Utility

• 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.

Party wise Reconciliation

Utility

GSTR-2A Converter, Vendor & Invoice wise Reconciliation and Rule 36(4) Utilities

• 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.

Invoice wise Reconciliation

Utility

• 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.

Utility

These utilities are meant to ease of working of GST reconciliation and give desired reports in less than a minute.

Developed by CA Jatan Jain

Presently CA Jatan Jain 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.