Free template · Purchase

Vendor Registration Form Format: Free Excel + Example

A vendor registration form is the record a factory fills in before it buys from a new supplier. In India it should capture the supplier's legal name, GSTIN, PAN, Udyam (MSME) status, contacts, items supplied, payment terms and bank details with IFSC. Attach a cancelled cheque and signed declaration. Our free Excel below works as a blank form and a vendor master list, with a filled example.

Download the Excel template

What is a vendor registration form?

A vendor registration form is one supplier's full record, filled in before your first purchase order. The supplier fills it in and signs it. Your purchase head approves it, and accounts checks the tax and bank details.

Without it, a PO can go out with a wrong GSTIN, or a payment can reach the wrong account.

What each field in the vendor registration form means

The form has eight sections, A to H.

A. Company details

FieldWhat to writeWhy it matters
Vendor codeYour internal code, e.g. V-0101Used on every PO and GRN
Legal name and constitutionAs on the GST certificate; Pvt Ltd, LLP, partnership or proprietorshipOne name on every document; sets the TDS rate
Address and stateFull address, PIN and state codeDecides CGST + SGST or IGST

B. Contacts

FieldWhat to writeWhy it matters
Sales contactName, mobile and emailWhere RFQs and POs go
Accounts emailFor invoices and payment advicePayment queries reach the right person

C. Tax and registrations

FieldWhat to writeWhy it matters
GST registration typeRegular, composition or unregisteredComposition and unregistered suppliers charge no GST, so no input tax credit
GSTIN15 characters: state code, PAN, then 3 moreCheck it on the GST portal before the first PO
PAN10 characters; the 4th shows the type (C company, F firm or LLP, P individual)Needed for TDS; matches characters 3 to 12 of the GSTIN
Udyam number and MSME categoryUDYAM-XX-00-0000000; micro, small, medium or not registeredSets your payment deadline for micro and small suppliers

D. What they supply

FieldWhat to writeWhy it matters
Item categoryRaw material, bought-out part, job work or serviceKeeps job workers and services in their own list
Items and HSN/SACHSN for goods, SAC for servicesLets you check the tax rate on their invoice
Lead time, MOQ and capacityDays to deliver; smallest order; monthly maximumYour purchase planning depends on it

E. Commercial terms

FieldWhat to writeWhy it matters
Payment termsDays of credit from accepting the goodsWithin 45 days for micro and small suppliers
Delivery termsEx-works or delivered; who pays freightChanges your landed cost

F. Bank details

FieldWhat to writeWhy it matters
Account name and numberCopied from the cancelled chequeName must match the legal name
Bank, branch and IFSCIFSC has 11 characters; the 5th is always zeroA wrong IFSC makes the payment fail

G. Documents attached

List each document received. The checklist is further down this page.

H. Declaration and internal approval

FieldWhat to writeWhy it matters
Declaration signedDate the supplier signed and stamped itConfirms the details; changes come in writing
GSTIN checked and approvedWho checked, who approved (purchase head and accounts), with datesNo PO before both sign

How to fill it, step by step

  1. Send the form. Email the blank format to the supplier.
  2. Collect documents. See the list further down this page.
  3. Check the GSTIN. Use Search Taxpayer on the GST portal. Confirm it is Active and the legal name matches.
  4. Check Udyam status. Verify it on the Udyam Registration portal.
  5. Approve and give a vendor code. Purchase and accounts both sign.
  6. Add to the vendor master list. Your team picks vendors from it for every RFQ and purchase order.

How to write the email to a vendor

Subject: Vendor registration – [Your company name]

Dear [Name],
Before we raise our first purchase order, please fill in the attached vendor registration form.
Please return it by [date] with your GST certificate, PAN, a cancelled cheque and Udyam certificate, if registered. Please sign and stamp the declaration.
Regards,
[Your name], Purchase

[[IMAGE {"type":"checklist","title":"Check before you approve a new vendor","items":["GSTIN shows Active on the GST portal","Same legal name on GST, PAN and bank","PAN matches GSTIN characters 3 to 12","Udyam category recorded, even if none","Bank details match the cancelled cheque","Purchase head and accounts both signed"]}]]

Where TranZact takes over after registration

A vendor form records a supplier once. After that, every PO, GRN and payment sits in a different file. The owner connects them by hand.

TranZact is manufacturing AI software that runs sales, purchase, inventory, production and planning for 10,000+ manufacturers. The MRP engine runs through your orders and BOMs, then tells you what to buy and when. Vendor coordination sits in the same purchase module.

Accounting stays in Tally, with one-way sync and no double entry. Zoho Books syncs the same way, and TranZact also integrates with Busy; see how the Tally integration works. One honest limit: TranZact runs operations, not your books.

TranZact purchase facts (as of 18 Nov 2026)

FactDetail
Purchase flowMRP report → indent → RFQ → PO → GRN → payment
PlanningPlanning (MRP + Indent); check the plan on pricing
Accounting syncTally and Zoho Books: one-way, no double entry. Busy: integrated
Other integrationsGmail, Excel / Google Sheets, and any tool that offers an API
Go-liveLive in 2–3 weeks
DataStored in India, on AWS servers in Mumbai
SupportChat, 10:00–19:00, Monday to Saturday; first response within 1 hour

Book a demo →

Worked example: registering a castor-wheel supplier for a steel trolley maker

This is the same trolley maker as our bill of materials format. It needs a second castor-wheel supplier. All names, numbers and IDs are illustrative, not real.

Table 1 (Example): the filled form

FieldExample entry
Vendor codeV-0101
Legal nameSample Castor Wheels Pvt Ltd
GST type and stateRegular, Maharashtra (27)
GSTIN and PAN27AAACS1234K1Z5; AAACS1234K
Udyam and categoryUDYAM-MH-26-0012345, Small
Items and HSN100 mm swivel castor with brake; 100 mm fixed castor (HSN 8302)
Lead time, MOQ, payment10 days; 200 pcs; 45 days from acceptance
Bank detailsExample Bank Ltd, A/c 000123456789, IFSC EXMP0001234
Checked and approvedGSTIN Active 12-11-2026; approved by Purchase head and Accounts, 13-11-2026

The sheet's example adds two more suppliers. Demo Steel Tubes LLP is a medium enterprise, outside the 45-day limit, so it gets 60 days. Trial Powder Coaters, a micro job worker, gets 30 days.

Documents to collect with the form

DocumentWho needs itNote
GST certificate (Form REG-06)GST-registered suppliersName and address match the form
PAN card copyEvery supplierMatches the PAN inside the GSTIN
Cancelled cheque or bank letterEvery supplierName matches the legal name
Udyam certificateMSME suppliers, if registeredSets payment deadlines for micro and small
Signed declarationEvery supplierAuthorised signatory, with stamp

MSME suppliers: why the Udyam field matters

Udyam registration is not mandatory to become your vendor. But collect it whenever the supplier has it, because it changes when you must pay.

Under the MSMED Act, pay a micro or small supplier by the agreed date, at most 45 days from accepting the goods. With no written agreement, the limit is 15 days. Pay late and you owe compound interest at three times the RBI bank rate, with monthly rests.

Section 43B(h) of the Income-tax Act, 1961 covers years up to 2025-26. Under it, dues unpaid past that limit count as an expense only in the year you pay. From 1 April 2026, the Income-tax Act, 2025 applies, with a matching rule under a new section number.

Medium enterprises are not covered by either rule. Check the current rule with your CA.

Common vendor registration mistakes

  1. Taking the GSTIN on trust. A cancelled or suspended GSTIN can cost you input tax credit. Fix: check it on the GST portal and record the date.
  2. Names that don't match. Fix: use the GST certificate's legal name everywhere, and match PAN and bank to it.
  3. Bank details from an email alone. Fake "our bank details have changed" emails are a common fraud. Fix: match a cancelled cheque and confirm changes by phone.
  4. Wrong state. It decides CGST + SGST or IGST. Fix: take the code from the GSTIN's first two digits; see our GST state code list.

Don't be the bottleneck. Become the AI-Run Factory.

Your vendor form is where the purchase flow starts. See how 10,000+ manufacturers run purchase, inventory and production in one system, with accounts still in Tally.

Book a demo →

Frequently asked questions

Is Udyam (MSME) registration mandatory to register a vendor?

No. A supplier without Udyam can still be your vendor. Collect the Udyam number whenever they have one, because it sets your payment deadline for micro and small suppliers.

Can I use this format for job workers and service providers?

Yes. Choose 'Job work' or 'Service' in Item category and enter SAC instead of HSN. The rest of the form stays the same.

Should an unregistered (non-GST) supplier fill this form?

Yes. Select 'Unregistered' as GST registration type and leave GSTIN blank. PAN and bank details are still needed.

How often should vendor details be updated?

Whenever the vendor tells you of a change in writing, and at least once a year. Re-check GST status and bank details before large payments.

What is the difference between a vendor registration form and a vendor master list?

The form is one supplier's full record, signed by them. The master list is one row per approved supplier, which your purchase team uses every day. In the Excel, each row holds one supplier's key details, so it works as both.

Who should approve a new vendor?

Usually the purchase head, with accounts checking GSTIN, PAN and bank details. Record both approvals on the form before the first PO.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.