Verify party GSTINs from Tally, Vyapar or Marg

TallyPrime: its help documents exporting existing party information to Excel through the Update Party GSTIN report, under GST Reports, and exporting a master such as the ledger list with Alt+E.

Marg ERP: its help documents Masters, Ease of GST, Party GST No./State Updation. On the Party Master window press F10 and choose Export to get the party list.

Vyapar: it exports its reports to Excel and can import parties from an Excel sheet. Its documentation we could read does not spell out the party-list export steps, so check Vyapar help for the current route in your version.

Menu names differ between versions of all three, so treat the paths above as pointers to the vendor help pages, not a script to follow blindly. What you need at the end is an .xlsx file with one column holding the GSTIN.

In the dashboard open Bulk GSTIN Check and upload the .xlsx file. It finds the GSTIN column from its header (a column named GST No., GSTIN, or anything containing GST) and fills in the legal name, trade name, registration date, constitution, status, taxpayer type, address, filing frequency and the GSTR-1 and GSTR-3B filed-till dates. Your other columns are left as they were.

It costs 1 credit per GSTIN that resolves with Search, or 2 credits with Profile (adds filing dates); malformed numbers and numbers the GST network has no record of are free. A file can hold up to 2,000 rows. If your party list is longer, split it.

Filter the status column. Cancelled and suspended registrations are the ones to deal with before you claim input tax credit on their invoices. Rows marked not found usually mean a typo in the GSTIN; correct them from the vendor’s invoice and run the file again.

Compare the returned legal name with the party name in your books. A GSTIN that is active but belongs to a different business is a data-entry error worth catching. The filed-till columns show which vendors are behind on GSTR-1 or GSTR-3B.

To correct GSTINs in your accounting program, both TallyPrime and Marg document importing party GSTINs from an Excel sheet; follow their help pages above, and review the changes before you import rather than loading the whole file blindly.

A clean party list goes stale: registrations get cancelled after you checked. Vendor monitoring re-checks a list you choose every day, week or month and emails you when a registration is cancelled, suspended or renamed. The first five vendors are free.