...
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 | ||
---|---|---|
|
View file | ||
---|---|---|
|