Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Sr. No

*Name

*Permanent Address

Correspondence Address

*Supplier Code

Contact Person

*Email ID

*Mobile No.

PAN No.

GST No.

Bank Name

Bank Account No.

IFSC Code

*Status (Active/Inactive)

1

ABC Supplies

#5 6th main cross opp to ICICI bank Punjab

NIL

ABC134

Ramesh

abcsupplies@gmail.com

98XXXXXX21

APRFN9561B

22AAAAA0000A1Z5

ICICI

2XXXX1234XX4

ICICI00XXXX7

Active

2

Suresh Traders

10 main road Punjab

#62 5th main road ITPL Punjab

MB0099

Rakesh

sureshtraders@xyz.com

98XXXXXXX95

ARIZG9874C

22BBBBA0000A1Z5

HDFC

98XXXXX5X4

HDFC00XXX51

Active

Procedure

Data Definition

  • Sr No: Defines the serial no of the line item.

  • Name: Company Name or a Individual Person Name

  • Permanent Address: Company permanent address or a Individual Person permanent address

  • Correspondence Address: Alternative address of a Company or a Individual Person Alternative address

  • Supplier Code: A unique code that identifies the supplier of the goods

  • Contact Person: Details of a contact person of a individual or a Company.

  • Email ID: Company email Id or a individual person email Id

  • Mobile No: Company Mobile number or a individual person mobile number

  • PAN No: Company registered PAN number or a individual person PAN number

  • GST/TIN No: Company registered GST/TIN number is a Tax Identification Number is a unique 15-digit number.

  • Bank Name: Company Bank Name in which they hold the account or a individual person Bank account name which he/she holds the account

  • Bank Account No: Company Bank Account number or a individual person Bank Account number.

  • IFSC Code: The Bank IFSC code pertaining to the bank Account of the Company or a Individual person holding a bank account

  • Status: Active/Inactive status to be mentioned for the individual supplier

Steps to fill data

  • Identify all the “Contractor” details which exists at State and ULB Level.

  • Collect all the information and feed into the respective columns accordingly.

...

  • Refer to “Suppliers Tab” in the uploaded template.

  • For sample data reference, refer to the uploaded “sample date” file.

View file
nameTemplate Sample Data - Supplier.xlsx
View file
nameSample Data Template - Supplier.xlsx