Advanced Offline Excel Utility 2.0 to find Wrong GST Number- No VBA/No Macro..

Discussion in 'Free Source Codes' started by Devendra_Rawat, Dec 28, 2021.

    
  1. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Dear Friends..
    Free Advanced Excel Utility 2.00 to find Wrong GST Number here
    By using this Excel File, you can know :
    1. Whether is GST Number is Valid or not.
    2. Type of GST Registration .
    3. Income Tax PAN Status of the Assessee.

    Offline Excel Utility to Validate any GSTN Number- No VBA/No Macro.. therefore you can
    freely use it and share through mails/gmail.



    This is a free utility useful for CA Staff/Accounts professionals who have to deal with a
    lot of GST numbers while working on GST returns..

    This file comes with built in formulas to validate the pattern of GST number as per GST portal
    specification.

    In a nutshell it will alert you about the wrong GSTN number in your data, therefore we thought
    it worth sharing with you.
    Use the following formulas:

    1.
    Type "=gstin_Is_Ok" for Validating the GSTIN

    2. Type "=gstin_Type" for knowing the type of organization for which GSTIN is issued e .g.
    "Govt. Department", "NRI", "TDS-GSTIN", "TCS-GSTIN", "UN Body GSTIN"", "OIDAR
    GSTIN".

    3. Type "=gstin_PAN_Type" for knowing the type of Income Tax assessee for which GSTIN
    is issued e.g. "Govt. Department", "Person", "Firm", "Company", "AOP", "Trust", "Artificial
    Juridical Person" .

    For Detailed Information on how to use this excel sheet watch:




    Regards
     

    Attached Files:

    Last edited: Dec 28, 2021
    sekharchana and naren1234 like this.


Share This Page