Update the quantity stock on hand or opening stock balances, buying or purchasing price (cost or price that used to value your stock) into your items. If you have existing data, you can import all stock balance into Localizebook system by using the Import Stock Balance function. This below is the procedure and steps of the import stock balance.

Go to Import Stock Balance into Localizebook system:

1.Go to the Accounting menu.

2.Click on Import > Import Stock Balance.

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

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

1. ITEM_NAME: Name of product that you set in the system to open balance.
2. BASE_QTY: Total stock on hand of your product.
3. AMOUNT: Total asset value of your product.
4. MEMO: Other comments or marks that are related to your item.

Note:

1. You can use only one column among ITEM_CODE and ITEM_NAME.
2. You can’t import the negative amount in the Import Stock Balance function.

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

1. Click on Browse File and select the template with your stock balance data and preview your stock balance details. If data is loaded, you are ready to import. But if there is any error, messages will be shown.
2. Click on Import to import your stock balance into Localize.