If you have existing data of the vendor list or outstanding balance of your vendor, you can import your vendor with outstanding balance into the Localizebook system by using the Import Vendor function. This below is the procedure and steps of the Import vendor list and A/P balance.

Go to Import Vendor into Localizebook system:

1.Go to the Accounting menu.

2.Click on Import.

3.Click on Import Vendor

4.Click on Click this link to download the working template.

5.Fill in the information for each function and save your excel file.

1. VENDOR_CODE: A unique identifier for each vendor in the system. This code is the primary key and should never be duplicated.
2. VENDOR_NAME: The official, legal name of the vendor (in English).
3. LOCAL_VENDOR_NAME: The vendor’s name written in the local language (e.g., Khmer).
4. EMAIL: The primary email address for the vendor, preferably for their accounting or sales department.
5. PHONE: The main contact phone number for the vendor.
6. CURRENCY: The currency in which you transact with and pay the vendor (e.g., USD, KHR). This is critical for multi-currency accounting.
7. VATTIN: The vendor’s Value Added Tax Identification Number.
8. Address Details: The system allows for both English and Local language addresses for clarity and compliance.
9. ADDRESS: A consolidated address field, often used for quick reference or on reports. It may be automatically combined from the fields above or entered manually.
10. MEMO: A free-text field for any other important notes about the vendor.
11. BRANCHES: Use this to note if the vendor has multiple branches, and which one you primarily deal with.

6.After filling all the information please back to the system:

1. Click on Browse File and select the template with your vendor’s data. If data is loaded, you are ready to import. But if there is any error, messages will be shown.
2. Click on Import to take all your vendor’s data into Localize.