Skip to main content
Adding a product database (NI001)
Updated over a year ago

The methods for adding a product database and recording forward balances can be done in 2 methods as follows :

  • Method 1 : Adding directly to the program interface

  • Method 2 : Adding by import an Excel file

Method 1 : Adding directly to the program interface.

Step 1.1 : Go to the "Products" menu and select '+Add Product'

Step 1.2 : When you click the '+Add Product' button, a popup will appear.

In the 'Add New Product' page, you can select basic or advance option . If you choose the advance option, you will be able to enter the standard price information and accounting entry setting.

Product Information

Product Name : Fill in the product name.

Product Description : Provide a description of the product.

Barcode : Check and enter the barcode (if any). This will allow you to search for the product using the barcode in the future.

Unit : For example, crate, pack, piece, year. If there aren't the units you want, you can add them from here.

Product Image : If you want to add an image of the product/service, you can attach it. The image should be in square dimensions, and the file size can't exceed 5 MB.

If you choose the advance option, you can input the following additional information :

Standard Price Information

Standard Sale Price/Unit : The selling price per unit of the product.

Standard Purchase Price/Unit : The purchase price per unit of the product.

VAT rate : Select whether the product/service includes VAT at 7%, VAT at 0%, or Non-VAT

Accounting Entry Setting

Sales Account : You can select the required revenue account.

Purchase Account : In the case of purchasing or selling products, you can link it to various accounting accounts, such as finished goods or work-in-process.

Cost Calculation : Open this option if you want PEAK to automatically record the cost of goods sold (Dr. Cost of Goods Sold, Cr. Purchase Account that you select above).

Product Beginning : If there are carry-forward balances for the product inventory, you can add lot beginning. Once all information is entered, click 'Save' to save the data.

Method 2 : Adding by Import an Excel File

Step 2.1 : Click the 'Import Product' button.

Step 2.2 : Click" Download this form (.xlsx)." to get an excel file

Then, the excel file will be displayed. There is a description sheet to guide you in filling out the information.

Example for New PEAK template for import product file

Step 2.3 : After entering the information and saving the file, locate the file by either dragging and dropping it or clicking on the file 'Search' button. When you have selected the file, click the 'Confirm' button to proceed."

-End of Adding a product database-

Did this answer your question?