Stock Balance

Stock Balance is the inventory statement: for each item in each warehouse it shows opening quantity and value, quantity and value received, quantity and value issued, and the closing quantity, value and valuation rate for the dates you choose. Everything is summed from Stock Ledger Entries, so it agrees with the documents to the paisa and the closing value for All Warehouses - YFF must equal Stock In Hand - YFF in the Trial Balance. Nepali businesses use it to value closing stock for the annual accounts, to check a physical count, and to answer an IRD query on inventory. A mismatch with the ledger usually means a Journal Entry hit the stock account directly or a repost failed.

Closing qty = opening qty + in qty - out qty; closing value likewise; valuation rate = closing value / closing qty

1. 01Go to Stock > Stock Balance, or type it in the search bar.
2. 02Set Company, From Date and To Date; leave Warehouse blank for all or pick one.
3. 03Filter by Item, Item Group or Warehouse to narrow the list, and tick Include UOM if needed.
4. 04Read Bal Qty and Bal Val per row; the total row is company inventory at the To Date.
5. 05Compare Bal Val for All Warehouses - YFF with Stock In Hand - YFF in the Trial Balance.
6. 06Export with Menu > Export for the count sheet or the year end file.

Open at month end to value inventory and to check physical count against books.

100 items across 5 warehouses with opening stock valued at Rs 4,50,000.