Skip to main content
Try for free

Value the stock on hand

Determine what stock is on hand and what it is worth.

Updated Nov 5 2026

Who this is for

Accounting reports the value of inventory at month and year end. Warehouse leads use the same reports to see what is where, and to answer "why did this quantity change?"

Who can see what: cost and value columns need permission to see cost; Parts > Reports is in the menu for the Manager role; the ledger check is for Accounting Admin. Without them you still see quantities and a part's own history.

Applies to
Inventory
Accounting

Why it matters: inventory is often the biggest number on the balance sheet. If the inventory report and the general ledger disagree, one of them is wrong, and the auditors will want to know which.

  1. Run the inventory report

    1. Open Parts > Lists > List By Bin. The screen is headed Part List By Bin.
    2. Click Filters, pick the Location (warehouse), and narrow by Prcpart, Bin or Lot Code if you need to. Pick a part from the suggestions; typed text alone is ignored.
    3. Click Apply. Each row is one bin of one part, so a part in three bins shows three times. Bin Qty counts everything in the bin, including parts already picked to orders. Pick Qty is the picked part, and Shelf Qty is what is physically on the shelf.
    4. Read the total value at the foot of the Bin Ext Value column.
    5. Click Export to keep a copy for the period.
  2. Trace a change in stock

    1. Open Parts > Reports > Inventory Activity.
    2. Click Filters and filter by Location, Prcpart, Bin and dates, and by Reason to see one kind of change, such as Receipt, Shipment or Miscount.
    3. Click Apply. Each row shows the quantity change, the new bin quantity, the user and the reason, and the old and new cost if you can see cost.
  3. Check it against the ledger

    1. Open Accounting > Audit > Inventory Activity Vs Ledger.
    2. Set the From Date, To Date and Location, and run it.
    3. Look into any day where inventory activity and the general ledger differ.

Other ways to do this

One row per part

For one row per part instead of per bin, use Parts > Reports > Inventory Value.

Trace one part's changes without the Reports menu

From a part, Activity > History opens the same Inventory Activity report for that part only, from about 30 days back. This works without the Reports menu.