YouTube: How to Enter Opening Stock Manually or via Excel?
In this tutorial, we’ll learn how to enter Opening Stock in the system using two simple methods: Manual Entry and Excel/Text File Import.
Navigate to the Main Menu and open the Inventory Module.
Click on Enter Opening Stock to proceed.
Method 1: Manual Opening Stock Entry
Select the Item manually.
Define the Lot Number.
Enter the Opening Stock Quantity in the Total Quantity column.
Specify the applicable Rate.
Repeat the steps for other items as required.
Method 2: Opening Stock Import via Excel / Text File
Click on Enter from Text File.
Browse and select the required Excel or Text file from your system.
Choose the correct Sheet Name.
Set Header Row = 1
Click to Refresh.
Click OK to import the data.
Enter mandatory details such as:
Godown Name
Rates
Verify all imported records carefully.
Save the Entry
Click on Save.
A confirmation message will appear—click Yes to proceed.
Open the Purchase Voucher window and create a New Entry to review the lots.
You can also verify stock by opening the Stock Query Report.
Select the required Items/Articles and generate the report.
The imported quantity will be visible under the Opening Stock column.
By following these steps, you can efficiently manage opening stock either manually or by importing bulk data through Excel—saving time and ensuring accuracy.
Last updated
