No worries if you have a lot of vendors records to import into the system in one shot, this tutorial is to assist you step by step on how to get your vendors records added into the system in just a minute!

NOTE

1. This function is currently a Beta feature.

2. Please make sure every email being imported is unique (including the ones already existed in the system), this is to ensure all vendors of the respective business are having different and unique emails for processing.

Step by step tutorial to import vendors data with Excel file

1. Proceed to Import Data located at the side menu.

2. Download the sample Excel file by clicking on the Download Sample button. The sample Excel file contains sample data for you to modify according to your needs.

3. Select or drag and drop your modified excel file into the field area.

4. Click Import button to import your data into the system.

Guidelines on the Excel file fields

1. msic_code - this is required by LHDN MyInvois Portal, referring to the vendor's business MSIC Code, you may refer to this link to obtain the list of MSIC Codes available and accepted by LHDN MyInvois Portal.
2. name - vendor's name
3. company_name - vendor's company name (optional)
4. email - vendor's email, should be unique across your vendors
5. password - optional
6. mobile - vendor's contact number
7. country - vendor's residing country, should be full name of the country with first letter capitalized, for example: Malaysia
8. currency - 3 letter currency code, for example: MYR
9. vat_id - vendor's TIN number, which refers to the income tax number found in MyTax portal
10. registration_no - vendor's business registration number, could leave it empty or fill in "NA" if registration number is not available
11. id_no - vendor's NRIC number
12. passport - vendor's passport number
13. city - vendor's residing city
14. state - vendor's residing state, should be full name of the state with first letter capitalized, for example: Perak, Johor, Selangor...
15. zip - postcode
16. address - vendor's residing address
17. remarks - optional
18. validate_type - determine whether vendor's TIN number should be validated via: NRIC, BRN or PASSPORT. NOTE that only 3 types of values are accepted: NRIC, BRN or PASSPORT.

NRIC: IC Number
BRN: Business Registration Number
PASSPORT: Passport Number