Managing multi-warehouse stock with accounting valuation means tracking quantities per warehouse while computing, at each movement, the stock value at weighted average cost (WAC) — so that your inventory value on the balance sheet (class 3 accounts) always reflects physical reality. This is what separates simple “quantity tracking” from real commercial management integrated with accounting. Here is the mechanic, and how mobile scanning and accounting hold together.

WAC: the right valuation method

When you buy the same item at different prices over time, at what value does it leave stock on a sale? SYSCOHADA favors the weighted average cost (WAC): at each inbound movement, a new average unit cost is recomputed.

WAC formula after an inbound movement:

WAC = (value of existing stock + value of the inbound)
      ÷ (existing quantity + inbound quantity)

Example:

  • Opening stock: 100 units at 1,000 XAF → value 100,000 XAF.
  • Inbound: 50 units at 1,300 XAF → value 65,000 XAF.
  • New stock: 150 units, value 165,000 XAF → WAC = 1,100 XAF/unit.
  • An outbound of 30 units is valued at 30 × 1,100 = 33,000 XAF.

WAC smooths purchase-price variations and gives a stable and defensible valuation in an audit — unlike an approximate “latest price” valuation.

Multi-warehouse: quantities per site, consistent value

A trading SME often has several storage points: central warehouse, shop, secondary depot. The challenge is to track where each unit is, without losing overall accounting consistency.

The necessary building blocks:

  • Identified warehouses (name, code, address, main warehouse, responsible keeper), enable/disable.
  • Stock per warehouse: quantities and valuation split by site.
  • Typed movements: inbound, outbound, adjustment, inventory — each attached to a warehouse and, ideally, to an accounting document/entry.
  • Per-item thresholds (minimum, reorder point, maximum) to steer replenishment and detect stockouts.

Inter-warehouse transfers

Moving stock from one warehouse to another must never be a manual double entry “out here / in there”: that is the door to variances.

A clean transfer is a single operation with:

  • A source warehouse and a destination warehouse.
  • One or more lines of items with quantities.
  • A workflow (draft → validated), validation by the keeper, a possible return, a cancellation.
  • A transfer note (PDF) for physical traceability.

Valuation follows the goods: value leaves the source warehouse and arrives at the destination at the same WAC, with no creation or destruction of value.

Inventory and valued variances

Periodically, you physically count the stock and compare it to the theoretical stock. The variance must be:

  • Valued in XAF (variance quantity × WAC), not just in units.
  • Booked via an inventory-variance entry (adjustment of the balance sheet stock value and recognition of the corresponding expense/income).

Without this step, the stock value on the balance sheet diverges from reality — and the inspector notices. Multi-product inventory campaigns (with line-by-line entry and validation) make the exercise manageable even on wide catalogues.

The bridge with SYSCOHADA accounting

Stock is not just a quantity table: it is an asset on the balance sheet (class 3). Each physical flow must find its accounting counterpart:

  • Stock inbound → class 3 movement, linked to the purchase (class 6 / supplier 401).
  • Outbound on sale → recognition of the cost of goods sold.
  • Inventory variance → valued adjustment entry.

It is this stock ↔ accounting integration that distinguishes serious commercial-management software from a mere product-sheet manager.

Mobile scanning: stock in the field

The most rigorous valuation is worthless if field entry is painful. Hence the value of barcode scanning (EAN-13, EAN-8, Code 128) on mobile:

  • Scan an item to find or update it instantly.
  • Run a mass inventory by scan during a campaign.
  • Mass-create catalogue products by scanning a list of items.
  • Correct the warehouse of an item from its sheet (traced transfer), manage expiry and thresholds.

The field scans, the accounting stays correct.

How SynkriaOps does it

SynkriaOps embeds ERP-grade multi-warehouse stock management, tied to SYSCOHADA accounting:

  • Warehouses and stock per warehouse (quantities + valuation split), warehouse optional or mandatory depending on your configuration.
  • WAC valuation recomputed at each movement, with total valuation and a stock dashboard (dormant, stockouts, below-minimum).
  • Inter-warehouse transfers with workflow, keeper validation, return and a PDF transfer note.
  • Inventory sessions and campaigns with variance valued in XAF and variance-entry generation.
  • Mobile app: barcode scan, quantity capture, default VAT by regime, mass inventory by scan, transfer from the sheet — currently in internal pilot distribution.
  • Accounting integration: stock movements feed class 3 accounts and link to documents.

Stock steering indicators

A correct valuation also serves to steer. A few indicators to track:

  • Value tied up at WAC — how much cash “sleeps” in stock.
  • Dormant items — references with no movement for a long time, candidates for impairment or clearance.
  • Stockouts and below-minimum — items under their threshold, to replenish.
  • Turnover rate — how fast stock moves: a low rate signals overstock, a high rate a stockout risk.
  • Expiry — for dated products, expired or soon-to-expire lots, which weigh on real value.

These indicators link operational management (what to order, what to clear) to accounting reality (the value on the balance sheet). Without a reliable valuation, they mislead; with WAC recomputed at each movement, they become decision levers.

In summary

Well-kept multi-warehouse stock is three things together: quantities per warehouse, a WAC valuation recomputed at each movement, and an accounting bridge to class 3 accounts. Add mobile scanning for field entry, and you get commercial management that never drifts from the accounting.

To manage your multi-warehouse stock with integrated accounting valuation, start free on SynkriaOps.