This excel utility is only for Maharashtra VAT TIN Holders.
Enter a list of TINS in A column. Copy paste the formula in column B till the cell you have entered the TIN. It will show True or False.
True signifies it is structurally valid and false signifies it is structurally invalid.
For more details of TIN you can use Know your TIN from mahavat.gov.in
THIS EXCEL UTILITY ONLY SHOWS CORRECT TIN ON THE BASIS OF STRUCTURE
THIS CAN HELP TO VALIDATE TINS GIVEN BY CLIENT. IN CASE OF ANY MISTAKE BY CLIENT IN PUTTING TIN IT WILL BE TRACED EASILY AND THEN THE SAME CAN BE COPY PASTED TO J1 AND J2.
Download Maharashtra TIN validation Utility in excel (Structural Validation)
(Submitted by -Anish Gandhi-A CA Student from Mumbai)
what does structur comprised of of for validation ?
Its Not working properly……
We cant trust on it….