Reports • reference

Inventory Valuation Report

Asset valuation reporting reconciling inventory subledger quantities and unit costs with General Ledger Asset account 12000 under FIFO or Moving Average costing.

Reviewed on 2026-10-07

Set the valuation date#

Confirm the warehouse you are valuing and the company's inventory account.

Read stock value#

  1. 1
    Open Reports and select Inventory Valuation.
  2. 2
    Choose a warehouse in Select warehouse, then click Search.
  3. 3
    Compare remaining layer quantities and costs with the total value.
  4. 4
    Open an unusual product or cost layer and compare it with its receipt and later stock movements.
  5. 5
    Run the inventory account in General Ledger at the same cutoff and compare the total.

Remaining layer quantity multiplied by unit cost contributes to the reported value. A later receipt or adjustment can change a different cutoff.

Reconcile cost layers#

The product's costing choice can be FIFO, FEFO, LIFO, or Average. Check that choice before comparing values; Standard costing is not offered in the product form.

WARNING: Reconcile transit, backdated movements and manual journals before concluding the valuation equals the GL.

Before changing accounts#

Finance should compare this value with the inventory account at the same date and in the company currency.

Trace the product and movement before changing a cost or posting a manual journal.

Have a question about this workflow?

Subscribed customers can ask questions about this guide inside the authenticated dashboard.

Ask about Inventory Valuation Report in Dashboard