Paste a vendor master listing and pick the tests to run. The tool looks for vendors sharing a PAN or bank account, names that are the same once cleaned, and missing or badly formed PAN and GSTIN. Flags are leads for inquiry, not conclusions.
Paste from Excel or CSV. Columns are found by header names; if a name is not recognised the default position above is used.
The format tests check only the pattern of the number. They do not confirm that the PAN or GSTIN is real or active. Verify on the official portals. A GSTIN is not required for every vendor, so a blank GSTIN is a prompt to ask, not an error.
| Vendor | Name | PAN | Bank account | Flags |
|---|---|---|---|---|
| V001 | Asha Traders Pvt Ltd | AABCA1234F | 501002345678 | PAN shared with another vendor; Bank account shared with another vendor; Same name as another vendor after cleaning |
| V002 | Asha Traders Private Limited | AABCA1234F | 501002345678 | PAN shared with another vendor; Bank account shared with another vendor; Same name as another vendor after cleaning |
| V004 | Kiran Supplies | KIRAN1234 | 918020045671 | GSTIN missing; PAN format looks wrong; Bank account shared with another vendor |
| V003 | Northwind Logistics | 918020045671 | PAN missing; Bank account shared with another vendor |
Payments follow the vendor master, so a duplicate or fictitious vendor can be paid for years without a journal entry looking odd. Two vendors with one bank account, or the same name spelled two ways, are the classic signs. Missing tax numbers matter too, because they affect deduction of tax at source and input credit claims. Run these tests on the full master, then ask who created and approved each flagged vendor.
PAN and GSTIN values are upper-cased and stripped of spaces. Missing values are flagged. The format tests check the length and the pattern of letters and digits only.
The GSTIN contains the PAN of the holder in positions 3 to 12, so the tool compares that part with the PAN column when both are well formed.
Duplicates are found by counting PAN, bank account and cleaned name across the listing. Names are cleaned by removing punctuation and words such as Pvt, Ltd, LLP and Company.
Two vendors, "Asha Traders Pvt Ltd" and "Asha Traders Private Limited", with the same PAN and bank account.
