# Enter Opening Stock

**YouTube:** [How to Enter Opening Stock Manually or via Excel?](https://www.youtube.com/watch?v=3nrIJJkN4kE)

## 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**.

***

### **Open the Opening Stock Window**

* 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.

<figure><img src="/files/bGnyvphhitclCTDVEx4x" alt=""><figcaption></figcaption></figure>

**Method 2: Opening Stock Import via Excel / Text File**

* Click on **Enter from Text File**.

<figure><img src="/files/dN1xGHz67CIERy0DAsax" alt=""><figcaption></figcaption></figure>

* Browse and select the required **Excel or Text file** from your system.
* Choose the correct **Sheet Name**.
* Set **Header Row = 1**&#x20;

<figure><img src="/files/I7QGhoRWkrAYPMG4va4j" alt=""><figcaption></figcaption></figure>

* Click to **Refresh**.

<figure><img src="/files/ZXJpR8Y8v7JAHL9AeZgZ" alt=""><figcaption></figcaption></figure>

* Click **OK** to import the data.

***

### **Post-Import Configuration**

* Enter mandatory details such as:
  * **Godown Name**
  * **Rates**
* Verify all imported records carefully.

<figure><img src="/files/LZwU1fqIAkFND6F42eN4" alt=""><figcaption></figcaption></figure>

**Save the Entry**

* Click on **Save**.
* A confirmation message will appear—click **Yes** to proceed.

<figure><img src="/files/4A6DBTs0LFQNRThtY3Q7" alt=""><figcaption></figcaption></figure>

***

### V**erify Imported Opening Stock**

* 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.

<figure><img src="/files/i3mwoZYTHn2liJpAyg1z" alt=""><figcaption></figcaption></figure>

***

### **Conclusion:**

By following these steps, you can efficiently manage opening stock either manually or by importing bulk data through Excel—saving time and ensuring accuracy.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/inventory/enter-opening-stock.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.