Stock is often your largest asset. Reyuko shows stock value by warehouse in two places, and they use different cost bases. This lesson shows how to read each one, why they can differ, and how to check them.
Key takeaways
- Reyuko has an Inventory value by location report, a Stock Value column in Stock List, and an Inventory Value dashboard widget.
- Stock List values each row at quantity times the product's current unit cost.
- The by-location report adds up the cost recorded on each stock movement in that location, up to the To date. From does not change the value.
- Moving stock between warehouses moves value, but the total does not change.
- Opening stock goes to the default location only, so split it with adjustments if you need to.
- Count each warehouse with Stock Opname before you trust its value.
Where to read the value
| Menu | View | What you see |
|---|---|---|
| Inventory > Stock List | One row per product per location | On Hand, Stock Value, Status |
| Inventory > Reports (Intermediate) | Inventory value by location | Qty and Value for each location |
| Dashboard (Intermediate, off by default) | Inventory Value widget | Stock value summary; turn it on under Customize |
Illustration: Harbor Wholesale is a fictional business; numbers are examples.
Harbor holds 450 units of Wholesale Item A. Warehouse 1 has 320 units and Warehouse 2 has 130. Every receipt was at 200,000 per unit, and the cost has not changed since.
| Location | Qty | Value |
|---|---|---|
| Warehouse 1 | 320 | 64,000,000 |
| Warehouse 2 | 130 | 26,000,000 |
| Total | 450 | 90,000,000 |
Harbor then transfers 50 units from Warehouse 1 to Warehouse 2. The split becomes 270 and 180 units, worth 54,000,000 and 36,000,000. The total stays at 90,000,000, because a transfer moves value without changing it. For the steps, see Transferring Stock Between Warehouses.
Two cost bases
Stock List multiplies On Hand by the product's current unit cost. That is one figure per product, set by its costing method (Weighted Average or FIFO). If Warehouse 2 received the same product at a higher price, Stock List still values its stock at the current unit cost.
The by-location report adds up the cost recorded on each stock movement in each location, up to the To date. Stock bought at a higher price keeps that cost here.
- Go to Inventory > Reports and choose Inventory value by location. Set To to the month-end date. The report values stock as of that date.
- Click Export to save the figures.
- Go to Inventory > Stock List, click Filter, choose the location, and read the Stock Value column.
- Click Export on the Stock List to save a CSV that includes Stock Value.
Settings > Initial Setup > Opening Balances posts all opening stock to the default location only. To split it, post a Surplus adjustment per location with the unit cost filled in.
Checking the number
Count each warehouse before month-end with Inventory > Stock Opname. While an opname is open, Reyuko blocks new postings to that location, so the count stays stable. Click Finish & Post to post the variance as one journal.
Then compare Inventory value by location with the balance of account 1-1201 Inventory in Accounting > Ledger for the same date. This lesson has not verified that the two totals always match. If they differ, look for the cause rather than forcing a fix.
Check yourself: what a transfer does to value
Harbor has 450 units at 200,000 each, valued at 90,000,000. It moves 50 units from Warehouse 1 to Warehouse 2. What is the total value after the transfer? Answer: 90,000,000. The split changes to 54,000,000 and 36,000,000, but the total does not change.
Reyuko