Excel Transactions can automatically create the inventory products while importing your transactions.


Please follow below steps to create Inventory Products automatically.


1. Navigate to Import Settings >> Products / Services


2. Select "Auto Created Product Type " as Inventory.


3. Provide "Auto Created Product / Service Expense Account" . "Account" should be the type of "Cost of Goods Sold".


4.Provide "Inventory Account Name for auto created products" .


5. Provide "Inventory Start Date" if needed. You can leave it blank if you want to have the current date.


6. Provide "Initial Quantity of Inventory Product ".