Inventory Valuation

By Nupur Mittal

Co-founder at OCTA — works with accounting firms on month-end close and reconciliation automation.

Inventory valuation is the process of confirming that a company's inventory balance is stated at the lower of cost or net realizable value (LCNRV). It reconciles the physical count to the perpetual records, applies the specified costing method — weighted average, FIFO, or (under US GAAP only) LIFO — to price the units on hand, and tests whether any items need to be written down below cost. This page walks through the full process step by step, a worked FIFO and NRV example, the red flags a careful reviewer watches for, and how accounting firms run inventory valuation faster with OCTA Flow while a human approves every entry.

Why inventory valuation matters, and where it goes wrong

Inventory is often the largest and least liquid asset on a balance sheet, and it's uniquely exposed to two kinds of error at once: the count can be wrong (units that were stolen, damaged, miscounted, or never existed on the shelf) and the price can be wrong (costs that don't reflect what was actually paid, or a carrying value that no longer reflects what the item is worth in the market). Getting either one wrong overstates assets and overstates profit — which is exactly why inventory draws close audit attention and why lenders and investors scrutinize it hard.

For a firm, the mechanical burden is real: tying hundreds of SKUs from a physical count to the books, rebuilding FIFO cost layers by hand, and running a net realizable value test against current selling prices is slow, repetitive, and easy to get subtly wrong — a single mis-keyed purchase invoice or an overlooked slow-moving SKU can misstate the balance without anyone noticing until the auditor asks. The goal is a valuation that's fully reconciled to the physical count, priced consistently with the client's stated costing policy, and tested for write-downs every single period — not a number that's simply "close enough" to last quarter.

The inventory valuation process, step by step

A proper inventory valuation follows a consistent sequence. The steps below are the full procedure OCTA Flow executes; they also stand alone as a best-practice process any firm can follow.

1. Determine the costing method and framework. Confirm which costing method the client uses — weighted average or FIFO — and which accounting framework applies. This matters because LIFO is permitted under US GAAP but prohibited under IFRS; weighted average and FIFO are acceptable under both.

2. Reconcile the physical count to the perpetual records. Compare the quantities from the physical count to the perpetual inventory records item by item. Compute the variance (physical minus perpetual) in both units and dollars for every item, and classify each as an overage (positive) or a shortage (negative). Flag any item with a variance greater than ±2% of units or $500 — whichever threshold is breached first.

3. Adopt the physical count as the valuation basis. The count supersedes the perpetual record for period-end purposes. Document the resulting shrinkage or overage as an adjusting entry — this is what brings the books in line with what's actually on the shelf.

4. Apply the costing method.

• Weighted average: unit cost = total cost of available units ÷ total available units, applied to the ending quantity.
• FIFO: the ending quantity is costed using the most recent purchase layers first, working backward through purchase invoices in reverse chronological order until every unit on hand has a cost assigned.
• Either way, verify unit costs against the underlying purchase invoices and flag any item where the book cost differs from the most recently invoiced cost — a common source of hidden costing errors.

5. Test net realizable value (NRV). Where current selling price data is available, calculate NRV per unit as the estimated selling price less the estimated costs to complete and sell. If NRV is below cost, the item must be written down to NRV and the shortfall recorded as a loss. Apply the lower of cost or net realizable value (LCNRV) test item by item, or by category if that's the client's stated policy.

6. Produce the inventory valuation summary. Compile ending quantities, unit costs, total cost, NRV (where tested), and the resulting carrying value — the lower of cost or NRV — for every item.

7. Compare to the prior period. Where a prior-period valuation is available, compare total inventory value, gross margin percentage, and write-down amounts period over period. A large swing in the write-down amount is worth investigating before it's accepted.

FIFO vs. weighted average: a worked example

Costing method matters because it changes the number. Here's a worked example for a single SKU that walks through a count variance, a FIFO valuation, and an NRV write-down together — the three pieces that make up a complete inventory valuation.

Step 1 — Count reconciliation. SKU-1120 ("16 oz Aluminum Bottle") shows 5,000 units on the perpetual record at a book value of $42,750. The physical count comes back at 4,850 units.

The variance is 3.0% of units — above the 2% threshold — so it's flagged for review regardless of the dollar amount.

Step 2 — FIFO costing of the physical count. The client's costing method is FIFO. Working back through the purchase invoices from most recent to oldest:

Step 3 — NRV test. Selling price data shows this item sells for $9.50 per unit with estimated selling costs of $1.20 per unit, for an NRV of $8.30 per unit.

Cost exceeds NRV, so the item is written down. Two adjusting entries come out of this single SKU: a shrinkage entry for the 150-unit count variance at book cost, and an impairment entry for the $1,715 NRV write-down.

Key controls and red flags

The difference between a spreadsheet that ties and a reliable valuation is what you watch for. A careful reviewer flags:

• Physical count variances greater than ±2% of units or $500 — the count doesn't match the perpetual record closely enough to accept without explanation
• Book unit cost that differs from the most recent purchase invoice — a costing error that understates or overstates every unit valued at that cost
• Items where NRV is below cost — a write-down is required under LCNRV
• Slow-moving items with no sales activity in 6+ months — these need a closer NRV assessment; the stated selling price may no longer be realistic
• Zero quantity on hand with a non-zero book value — phantom inventory, often a sign of an unrecorded write-off or a data error
• Negative inventory quantities — a system or process error that needs to be resolved before the count can be relied on
• A large year-over-year change in the total write-down amount — worth questioning before it's accepted as a trend

Catching these consistently, every SKU and every period, is what turns a count-and-price exercise into a genuine control over the inventory balance.

What a completed inventory valuation produces

A finished inventory valuation isn't just a priced spreadsheet — it's a documented workpaper a reviewer can sign off on and an auditor can follow. A complete inventory valuation package includes:

How OCTA Flow automates inventory valuation

OCTA Flow does the mechanical counting, costing, and testing for you and leaves the judgment — and the sign-off — with your team. The workflow mirrors the process above:

1. Pick the Inventory Valuation Skill. Flow already knows the full procedure: reconcile the count, apply the costing method, test NRV, and flag exceptions.
2. Connect your data. Point Flow at the client's accounting or ERP system, or upload the period's files — the perpetual inventory records, the physical count results, a sample of purchase invoices, the stated costing method, and current selling price data if it's available.
3. Run. Flow reconciles the physical count to the perpetual records, builds the FIFO layers or weighted-average cost as specified, tests NRV against selling price data, and compiles the valuation summary.
4. Review findings by severity. Instead of a full SKU-by-SKU listing, Flow surfaces only the exceptions — ranked by severity, each with a plain-English explanation and a recommended action: post the write-down, escalate a material count variance, request cost support, or accept an item with a documented reason. Your team works the exceptions, not every line item.
5. Sign off. Once the valuation is complete and the entries are approved, Flow assembles the workpaper with the full audit trail intact.

The result: the count tie-out and cost-layer rebuild are done in a fraction of the time, and your people spend their hours on the SKUs that actually need a judgment call.

Control and trust: Flow proposes, you approve

This is what matters most to a firm putting its name on an asset as material as inventory: OCTA Flow never writes to your books on its own. Every write-down, shrinkage entry, and costing correction is a proposal that a human reviews and confirms before anything is posted. Flow does the reconciliation and the costing math and shows its reasoning; a person makes the call.

That control model runs through the whole valuation:

• Findings, not silent changes. Flow raises what it found and what it recommends — you decide.
• Severity and escalation built in. A material count variance or a cost-method inconsistency is flagged and can be escalated to a manager or controller rather than quietly absorbed.
• A complete audit trail. Every count comparison, cost calculation, proposed entry, approval, and override is logged, so the valuation is fully traceable end to end.

You get the speed of automation with the accountability of human sign-off — exactly what a balance this material requires.

What the inventory valuation draws on

To run an inventory valuation, Flow uses the same sources a preparer already works from:

• Perpetual inventory records — the inventory system's quantities and book values for the period (required)
• Physical count results — the count quantities used to test the perpetual records (required)
• Purchase invoices — a sample used to verify unit costs (required)
• Costing method and framework — weighted average, FIFO, or LIFO (US GAAP only), and whether the entity reports under GAAP or IFRS (required)
• Selling price data — current selling prices and costs to sell, needed to test net realizable value (optional)
• Prior-period inventory values — for comparing total value, margin, and write-downs period over period (optional)

Flow works from whatever your client has connected — it matches each input by its purpose, so it doesn't matter what the files are named or which ERP or accounting system they came from.

Related skills and terms

Frequently Asked Questions

What is inventory valuation? Inventory valuation is the process of confirming that inventory is recorded at the correct amount — reconciling the physical count to the books, pricing the units on hand using a consistent costing method, and testing whether any items need to be written down to net realizable value. The result should be the lower of cost or NRV for every item.

What's the difference between FIFO and weighted average costing? FIFO (first-in, first-out) values the ending inventory using the cost of the most recently purchased units, assuming the oldest units were sold first. Weighted average blends the cost of all available units into a single average unit cost and applies that average to the ending quantity. Both are acceptable under US GAAP and IFRS; the choice affects the reported cost of inventory and cost of goods sold, especially when purchase prices are moving.

Can you use LIFO for inventory valuation? LIFO (last-in, first-out) is permitted under US GAAP but is prohibited under IFRS. A company reporting under IFRS, or a US company that also reports under IFRS, cannot use LIFO for those financial statements.

What is lower of cost or net realizable value (LCNRV)? LCNRV is the rule that inventory can't be carried on the books above what it can actually be sold for. Net realizable value is the estimated selling price less the estimated costs to complete and sell the item. If NRV falls below cost, the inventory is written down to NRV and the difference is recorded as a loss.

What causes an inventory count to not tie to the books? Common causes include theft or shrinkage, receiving or shipping errors, miscounted or mislabeled SKUs, timing differences between when goods are received and when they're recorded, and data entry errors in the perpetual system. Any variance above roughly 2% of units or $500 should be investigated rather than accepted.

Can inventory valuation be automated? The count reconciliation, cost-layer calculation, and NRV testing can be automated and reviewed, while judgment calls — like whether a slow-moving item should be written off entirely — stay with your team. That's the model OCTA Flow uses.

See how firms run faster, fully-tested inventory valuations with human sign-off → start a 30-day OCTA Flow trial.