Opening Stock Balance Process
If your organization has inventory before starting ERPNext, you need to upload your opening stock quantities and values.
Steps:
Step 1: Ensure Items Are Created
- Go to Stock → Item
- Create all inventory items
Step 2:
- Go to Stock > Stock Reconciliation > New.
- Select Purpose = Opening Stock
- Enter: Item, Warehouse, Qty, Valuation Rate
- Ensure:
- Posting Date and Posting Time are correct
- Should be the first entry of the company, usually at 00:00 hrs
- Save and Submit.
Benefits:
- Updates opening quantity
- Updates opening valuation
- Maintains FIFO/LIFO consistency
Reports to Verify Balances
- Balance Sheet: Confirm stock valuation appears under Current Assets → Stock in Hand.
- Stock Ledger: Verify each Opening Stock entry is reflected with correct posting time and ensure no negative stock appears.
- Stock Balance Report: Check Qty and Value for each item and confirm warehouse-wise balances.