Taxontips
No Result
View All Result
Wednesday, February 1, 2023
  • Home
  • Income Tax
    • Income Tax Return
    • Tax Notice/ Personal consultation
    • Compliance Notice
    • Faceless Assessment
  • GST
    • GST Registration
    • GST Consultation
  • News
    • Income Tax News
    • GST news
    • Budget News
    • Business & Other News
  • Q & A
  • About us
  • Contact us
Talk to an Expert
  • Home
  • Income Tax
    • Income Tax Return
    • Tax Notice/ Personal consultation
    • Compliance Notice
    • Faceless Assessment
  • GST
    • GST Registration
    • GST Consultation
  • News
    • Income Tax News
    • GST news
    • Budget News
    • Business & Other News
  • Q & A
  • About us
  • Contact us
No Result
View All Result
Taxontips
No Result
View All Result

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

GST expert by GST expert
February 23, 2020 - Updated on February 28, 2020
in GST news
0
GST registration
176
SHARES
2.2k
VIEWS
image_pdfPDFimage_printPrint

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.

 

Profile

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 office@jpmrs.com.

 

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.

image_pdfPDFimage_printPrint
Previous Post

TDS on income from mutual funds - Section 194K

Next Post

Individuals, company and trust are receiving notice u/s 143(1)(a) - This is the reason

Related Posts

Further clarification by CBIC for claiming 20% ITC on invoices not available in GSTR – 2A. Circular 123/42/2019 – GST
GST news

Clarification on entitlement of ITC where place of supply is determined in terms of proviso to sub-section (8) of section 12 of the IGST Act

January 27, 2023
GST Registration cancelled if GSTR 3B not filed for past 6 months or more. Want to know why?
GST news

Advisory on facility of ‘Initiating Drop Proceedings’ of Suspended GSTINs due to Non-filing of Returns – Update

January 24, 2023
Further clarification by CBIC for claiming 20% ITC on invoices not available in GSTR – 2A. Circular 123/42/2019 – GST
GST news

Clarification regarding the treatment of statutory dues under GST law [Read circular]

January 21, 2023 - Updated on January 27, 2023
Annual return optional for F.Y. 2017-18 and 2018-19 for Turnover below Rs. 2 crore
GST Returns

Clarifications regarding applicability of GST on certain services based on 48th GST council meeting

January 20, 2023
Data of GST website under comparison of liability declared and ITC claimed tab not available
GST news

Module wise new functionalities deployed on the GST Portal for taxpayers – December 2022

January 17, 2023
GST Registration cancelled if GSTR 3B not filed for past 6 months or more. Want to know why?
GST news

Advisory on “Initiating Drop Proceeding” by taxpayers for non-filing of GST returns

January 17, 2023
Next Post
Notice u/s 143(1)(a) for A.Y. 2019-20 for various reason such as Capital gain, Late fee etc:

Individuals, company and trust are receiving notice u/s 143(1)(a) - This is the reason

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Google Custom search

Recent Posts

  • CBDT instructs Income tax officer to complete 148/ 147 assessment before 31.05.2023
  • Final stage of Union Budget 2023-24 commences with Halwa Ceremony
  • Clarification on entitlement of ITC where place of supply is determined in terms of proviso to sub-section (8) of section 12 of the IGST Act
  • Consequences of Accepting cash while selling a Immovable property, land or house | 100% Penalty
  • How many articles can a Chartered Accountant register for articleship?

Recent Comments

  • CBDT instructs Income tax officer to complete 148/ 147 assessment before 31.05.2023 - Taxontips on Instructions issued by CBDT in response to judgement passed by Hon’ble Supreme court in case of notice issued u/s 148 after 01.04.2021
  • CBDT instructs Income tax officer to complete 148/ 147 assessment before 31.05.2023 - Taxontips on Supreme court Judgement on controversial issue of notice u/s 148 issued after 01.04.2021 passed in favor of Revenue | Detailed analysis of full judgement
  • Final stage of Union Budget 2023-24 commences with Halwa Ceremony - Taxontips on What is ‘Halwa ceremony’, performed before the budget at Ministry of Finance? What does it signify? | Pre budget facts
  • Leonard Linton on Clarification for the purposes of Section 269ST of the I.T. Act in respect of dealership/distributorship contract in case of Co-operative Societies
  • Advisory on facility of ‘Initiating Drop Proceedings’ of Suspended GSTINs due to Non-filing of Returns - Update - Taxontips on Advisory on “Initiating Drop Proceeding” by taxpayers for non-filing of GST returns

Categories

  • Budget News
  • Business & Other News
  • Case Laws
  • GST news
  • Income Tax News
  • News

Browse Topics by Date

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jan    
  • GSTR 9/ 9C due date to be extended to 31.10.2020 | E-invoicing will be voluntary in the beginning 79.3k views
  • How to pay Membership and COP fees of ICAI for 2020-21 | 77.8k views
  • Code/ Nature of payment 6CR updated by NSDL in challan 281 for paying TCS on sale of goods 68.1k views

Recent Notification

Guidelines for manual selection of returns for Complete Scrutiny during the financial-year 2019-20-

CBDT instructs Income tax officer to complete 148/ 147 assessment before 31.05.2023

January 30, 2023
Final stage of Union Budget 2023-24 commences with Halwa Ceremony

Final stage of Union Budget 2023-24 commences with Halwa Ceremony

January 28, 2023

RSS Taxontips

  • CBDT instructs Income tax officer to complete 148/ 147 assessment before 31.05.2023
  • Final stage of Union Budget 2023-24 commences with Halwa Ceremony
  • Clarification on entitlement of ITC where place of supply is determined in terms of proviso to sub-section (8) of section 12 of the IGST Act
  • Consequences of Accepting cash while selling a Immovable property, land or house | 100% Penalty
  • How many articles can a Chartered Accountant register for articleship?
  • Advisory on facility of ‘Initiating Drop Proceedings’ of Suspended GSTINs due to Non-filing of Returns – Update
  • ICAI has launched free task management or practice management software for members in Practice
  • Clarification regarding the treatment of statutory dues under GST law [Read circular]
  • Clarifications regarding applicability of GST on certain services based on 48th GST council meeting
  • Clarification regarding GST rates and classification of certain goods based on the recommendations of the GST Council in its 48th meeting held on 17th December, 2022

Categories

  • Budget News
  • Business & Other News
  • Case Laws
  • GST news
  • Income Tax News
  • News

Site menu

  • Home
  • Income Tax
    • Income Tax Return
    • Tax Notice/ Personal consultation
    • Compliance Notice
    • Faceless Assessment
  • GST
    • GST Registration
    • GST Consultation
  • News
    • Income Tax News
    • GST news
    • Budget News
    • Business & Other News
  • Q & A
  • About us
  • Contact us
Taxontips

TaxOnTips provides you all tax related solutions in easy way and update you with its regular updates & notifications Visit us for details.
We are based in Jaipur, India

© 2019-2021 Taxontips.com - Tax assistance at your Fingertips

No Result
View All Result
  • Login/Signup
  • Income Tax
    • Income Tax Return
    • Tax Notice/ Personal consultation
    • Compliance Notice
    • Faceless Assessment
  • GST
    • GST registration
    • GST Consultation
  • News
    • Income Tax News
    • GST news
    • Budget News
    • Business & Other News
  • Q & A
  • About us
  • Contact us
  • Ask an expert/ Talk to an expert
  • Privacy Policy
  • Terms of use

© 2019-2021 Taxontips.com - Tax assistance at your Fingertips

Login to your account below

Forgotten Password? Sign Up

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
Book Phone consultation with expert

Sitting home or at your office and don't have time to visit CA's office or don't know where to consult CA. Book your consultation with an expert practicing Chartered Accountant and get your query solved.

Book a phone consultation for 30 minutes with our expert at a very basic cost.

Book consultation

No thanks, I'm not interested!

ITR 1 to 7 now available for FY 2021-22!!File your ITR with an experienced Chartered Accountant

Now File your Income Tax return for F.Y. 2021-22 with an Experienced Practicing Chartered Accountant and not just with any person like other websites offer. Return filing starts at Rs. 500/-

Book ITR filing with Expert

Never see this message again.

Subscribe for Latest Tax Updates
You name
Yourname@email.com

Never see this message again.