GSTIN Offline Check – AdarshGSTINCheck
A simple and easy to use Excel Utility to identify whether GSTIN is correct
Amidst all the buzz surrounding GST, here comes another offering from Madrecha Group – ‘GSTIN Offline Check’.
GSTIN Offline Validation Tool
Number of Downloads
As on 29 Sept 2017
Using the tool is super easy. It is just an Excel Formula. Copy paste your data in excel file (Download Link Above) & use the formula = AdarshGSTINCheck(A1). That’s it.
The Most important Validation provided by GSTIN Offline Validation Tool is “Check Sum” Validation. This is the heart of this Tool. The geniuses of the tool lie in the fact that first 14 digits of GSTIN are mathematically related to the last digit. Hence we can check offline whether the GSTIN number is correct or not.
This Mathematical relation was closely guarded secret until recently. To know more about how this works, watch the video below.
Apart from the positional validations (mentioned below) and Check Sum Validation mentioned Above, GSTIN Offline Check also provides following validations
- Length of the Number should be 15 Digits
- State Code should be between 01 to 37 or 98
Following is the list of Positional Validations performed by =AdarshGSTINCheck() Formula
- First 2 (1st, 2nd) Characters Should be Number
- Next 5 (3,4,5,6,7th) Characters should be Letter
- Next 4 (8,9,10,11th) Characters should be Number
- Next 1 (12th) Character should be Letter
- Next 1 (13th) Character can be Number or Letter
- Next 1 (14th) Character should be “Z”
- Next 1 (15th) Character can be either a Number or a Letter
Purpose of this GSTIN validation Tool / Utility
For Tax Consultants / CA Firm
To file GST return, we upload the CSV files / Excel file to GSTN Portal. We need to then wait for approx 20 mins for the portal to generate the error file. Once error file is generated, we need to download the zip file and load it into the GST Offline Utility. This entire process is very time consuming and can hamper the productivity of the user filing GST returns. Myself, being a Chartered Accountant, I developed this tool primarily for the benefit of the fraternity.
Businesses who will generate data for GST return filing, need to make sure the data is accurate before sharing it with their GST Consultants / CA. This utility will provide them with a degree of assurance that the GSTIN numbers are accurate. This will reduce back and forth between the businessmen and their CA. Thus, saving time for businessmen as well as tax consultnats.
For Software Vendors
If you are a software vendor and looking to implement this in your software, feel free to contact me. We can easily incorporate this into your software. I already have .net and java code available.
Androd App to check GSTIN
For Businessmen on the move
Not every businessman may have a PC handy every time he needs to check GSTIN. Also, many times, having access to the internet is not a guarantee. Hence, we also launched an android app for checking GSTIN. Go to Play Store and search for “GSTIN Offline Check”. The app is listed as from “Madrecha Solutions”. Special thanks goes to Rohit Targe for designing and developing the app. Few of the screenshots of the app are shown below.
The focus of development was to have a super easy app to check GSTIN.
Search for “GSTIN Offline Check” on play store.
Learn How to calculate GSTIN Check Sum Value
Version History of Excel GSTIN Validation Tool
v1.2 - 02 Aug 2017
Fixed a bug where GSTIN starting with 36,37 was shown incorrectly as Error.
v1.1 - 02 Aug 2017
A public launch of the Tool.
- Fixed Some Bugs.
- Error Description is more meaningful. Thanks to CA Priya Madrecha.
v1.0 - 01 Aug 2017
Initial Version. Shared Internally for testing.
v0.1 - 31 July 2017
Thanks to Harsh Mehta & Shweccha Jain