GSTIN TRACKER – Make your own ☑️


In VAT time we were search for TIN number, and there  also available lots of websites to search correct TIN number with address. But now we use GST. And we track GSTIN in
 In GST website you must have PAN or GST number to track it correctly. 
But now we can track GST details with our Excel sheet. Just make your parties GST List, It will show you the State and GST type instantly. To make this GST tracker sheet you need to put some simple formula with your GST list.


We can use below formulas : 
1. As we know the GST total characters are 15, so we can calculate number of characters with this formula : =IF(B3=””,””,LEN(B3))
There B3 is Cell address of your GST number.  
2. We can create GST State and there codes in second sheet  and put this formula to calculate GST state : =IF(B3=””,””,IFERROR(VLOOKUP(MID(B3,1,2),STATE!$A$2:$B$38,2,FALSE),FALSE))
There B3 is GST Cell address. It search in State sheet with range from A2 to B38.
3. Also we can create a list of GST Type in State sheet  Like :
A — Association of Persons (AOP)
B — Body of Individuals (BOI)
C — Company
F — Firm
G — Government
H — HUF(Hindu Undivided Family)
J — Artificial Juridical Person
L — Local Authority
P — Person
T — AOP (Trust)

And we use =IF(B3=””,””,IFERROR(VLOOKUP(MID(B3,6,1),STATE!$C$1:$D$38,2,FALSE),FALSE)) formula to track GST type.

You can see above video for more details.

Also can download GST tracker with below download Link :

Leave a Comment