The AI Accountant™ Part VI · Inventory, Retail & Production
Chapter 13 of 17

Inventory Valuation & Production

Perpetual versus periodic inventory, practical FIFO and weighted-average valuation (and why IFRS forbids LIFO), semi-finished and finished goods WIP for production businesses, and accounting for wastage, damage and physical stock adjustments.

Inventory Valuation Methods Production WIP Wastage & Stock Adjustment
16 min read Part VI of VIII The AI Accountant™

Inventory — The Largest Hidden Asset

For trading, manufacturing, construction, retail, food processing, pharmaceuticals, FMCG, automotive, and industrial businesses, inventory is often the largest current asset after cash. Yet inventory is also one of the most misunderstood accounting areas.

Many businesses know how much inventory they purchased but cannot accurately determine the true value of inventory today, the actual production cost of finished goods, which products are profitable, which inventory is obsolete, which warehouse is losing stock, how much wastage occurs during production, or whether shortages result from theft, process inefficiencies, or poor planning.

Modern ERP systems combined with AI, barcode technology, RFID, IoT devices, warehouse automation, and Business Intelligence provide complete visibility over inventory from procurement to production, sales, and financial reporting — opening Part VI of the book.

Inventory Categories

Every ERP should distinguish inventory into logical categories:

Raw Materials Consumables Work-in-Progress Semi-Finished Goods Finished Goods Spare Parts

Raw materials (steel, cement, flour, chemicals, fabric) are purchased for manufacturing; consumables (lubricants, cleaning materials, packaging tape, welding electrodes) are used during production but never become part of the finished product; semi-finished goods have completed one production stage but need further processing — for example, a cake base moves through decoration before it becomes a finished cake.

Inventory Systems

Periodic Inventory

Inventory updated only after physical stock counts

  • Simple, low cost
  • No real-time inventory visibility
  • Difficult loss detection
  • Poor operational control

Perpetual Inventory

Every transaction updates inventory immediately

  • Real-time stock and accurate valuation
  • Better forecasting
  • Improved internal control
  • Standard for most medium/large UAE organizations

The perpetual flow runs Purchase → Goods Receipt → Production → Sales → Transfer → Adjustment → Inventory Updated Instantly.

Sample Accounting Entries — Purchase to Production

Inventory Purchase (Raw Materials, AED 250,000)
Dr Raw Material InventoryAED 250,000
Cr Accounts PayableAED 250,000
VAT (if recoverable) is recorded separately in accordance with VAT accounting requirements.
Inventory Issue to Production (AED 80,000)
Dr Production Work in ProgressAED 80,000
Cr Raw Material InventoryAED 80,000
Labour Cost to Production (Factory Wages AED 35,000)
Dr Production Work in ProgressAED 35,000
Cr Payroll PayableAED 35,000
Factory Overhead Allocation (Electricity AED 12,000)
Dr Production Work in ProgressAED 12,000
Cr Utilities Payable / BankAED 12,000
Other factory overheads — depreciation, factory rent, machine maintenance, indirect labour — may also be allocated to WIP per the organization's costing methodology.

Production Work in Progress (WIP)

Production WIP represents products still being manufactured, and remains an asset because the production process has not yet been completed. Typical WIP costs include:

Raw MaterialsDirect LabourMachine HoursElectricityFactory RentDepreciationQuality InspectionProduction Overheads
Finished Goods (Total Production Cost AED 127,000)
Dr Finished Goods InventoryAED 127,000
Cr Production WIPAED 127,000
The production cost moves from WIP into finished goods inventory once production is completed.
Cost of Goods Sold (Finished Goods Sold, Cost AED 70,000)
Dr Cost of Goods SoldAED 70,000
Cr Finished Goods InventoryAED 70,000
The inventory asset becomes an expense only when the goods are sold.

Inventory Valuation Methods

One of the most important accounting decisions concerns how inventory costs are assigned when identical items were purchased at different prices.

FIFO (First-In, First-Out)
Purchase 100 units @ AED 10AED 1,000
Purchase 100 units @ AED 12AED 1,200
Sale of 150 units100 @ 10 + 50 @ 12
AED 1,600 COGS
AED 600 Remaining Inventory (50 @ AED 12)
The oldest inventory is assumed sold first. FIFO closely reflects the physical flow of inventory in many industries and is widely used under IFRS.
Weighted Average Cost
100 units @ AED 10, 100 units @ AED 12Avg AED 11
Sale of 150 units @ AED 11=
AED 1,650 COGS
AED 550 Remaining Inventory (50 @ AED 11)
ERP systems automatically calculate the average cost after each purchase. Particularly useful where inventory items are interchangeable.

Moving Weighted Average

Recalculates the average cost after every inventory receipt, rather than periodically. Widely supported by modern ERP systems and gives more accurate valuation for businesses with frequent purchases at changing prices.

LIFO (Last-In, First-Out)

Assumes the most recently purchased inventory is sold first. IFRS does not permit LIFO because it can distort inventory valuation and reduce comparability between financial statements. Organizations reporting under IFRS should use FIFO or Weighted Average.

Inventory Cost Components

The actual inventory cost may include:

Purchase PriceFreightInsuranceCustoms DutyImport ChargesHandlingQuality InspectionLanded CostDirect LabourProduction Overhead

Modern ERP systems automatically allocate these costs to inventory.

Semi-Finished Goods

Example — Furniture Manufacturer:

Stage 1: Wood Cutting Stage 2: Assembly Stage 3: Painting Finished Product
After Stage 2 — Move to Semi-Finished Goods (AED 200,000)
Dr Semi-Finished Goods InventoryAED 200,000
Cr Production WIPAED 200,000
Stage 3 Begins — Return to WIP
Dr Production WIPAED 200,000
Cr Semi-Finished Goods InventoryAED 200,000
This enables management to monitor inventory value at each production stage rather than only at the start and end.

Manufacturing Scrap and Wastage

Production inevitably generates losses — cutting loss, evaporation, breakage, packaging waste, production scrap, and damaged goods. Organizations should establish acceptable wastage percentages for each product.

Normal Wastage (AED 5,000)

Forms part of the production cost

Dr Production Overhead / WIPAED 5,000
Cr Raw Material InventoryAED 5,000

Abnormal Wastage (Fire Damage AED 15,000)

Recorded separately for management review

Dr Inventory Loss ExpenseAED 15,000
Cr InventoryAED 15,000

Separating abnormal losses helps management identify operational problems instead of letting them hide inside "normal" cost of production.

Damaged Inventory

Inventory may become expired, broken, obsolete, water damaged, rusted, or returned by customers.

Inventory Write-Off (AED 25,000)
Dr Inventory Write-off ExpenseAED 25,000
Cr InventoryAED 25,000
If the inventory can instead be sold at a reduced price, it may need to be written down to net realizable value rather than written off entirely, in accordance with applicable accounting standards.

Physical Stock Count

Physical verification remains essential even with modern ERP systems. Differences may arise because of theft, data entry errors, damaged goods, production errors, incorrect unit of measure, barcode mistakes, or warehouse transfers.

Inventory Shortage

Physical Count 950 vs ERP 1,000 — 50 units, AED 4,000

Dr Inventory Adjustment ExpenseAED 4,000
Cr InventoryAED 4,000

Inventory Surplus

ERP 950 vs Physical Count 1,000 — 50 units, AED 4,000

Dr InventoryAED 4,000
Cr Inventory Adjustment IncomeAED 4,000

Every adjustment should be investigated and approved before posting.

Inventory Transfers

Warehouse A Transfers Inventory to Warehouse B (AED 20,000)
Dr Inventory — Warehouse BAED 20,000
Cr Inventory — Warehouse AAED 20,000
The total inventory remains unchanged while warehouse balances are updated.

Inventory Dashboards

Modern ERP systems provide real-time dashboards showing:

Inventory ValueStock AvailabilitySlow-Moving InventoryDead StockFast-Moving ItemsInventory TurnoverNegative StockProduction EfficiencyScrap PercentageWIP ValueFinished Goods ValueRaw Material AvailabilityInventory AgeingWarehouse Utilization

Finance managers no longer wait until month-end to assess inventory performance.

AI in Inventory Management

Artificial Intelligence continuously analyzes inventory data to predict stock shortages, forecast future demand, detect unusual inventory movements, identify obsolete inventory, recommend reorder quantities, monitor supplier performance, detect duplicate inventory records, identify abnormal production wastage, forecast production requirements, optimize warehouse utilization, and predict machine downtime affecting production.

Instead of reacting to inventory problems after they occur, organizations can prevent them.

Internal Controls

Strong inventory governance requires controls over purchase approvals, goods receipt, warehouse access, production issues, inventory transfers, physical counts, inventory adjustments, scrap approval, standard cost updates, cost allocation, unit of measure management, and barcode/RFID integrity.

Best Practices

Organizations Should

  • Operate a perpetual inventory system wherever possible
  • Use barcode or RFID technology for inventory tracking
  • Perform regular cycle counts in addition to annual stocktakes
  • Maintain separate ledgers for Raw Materials, WIP, Semi-Finished Goods, and Finished Goods
  • Use FIFO or Weighted Average methods in accordance with IFRS and business requirements
  • Record normal and abnormal wastage separately
  • Investigate all inventory adjustments before posting
  • Integrate production, procurement, warehouse, and finance modules within the ERP
  • Leverage AI for inventory forecasting and anomaly detection

Looking Ahead

Inventory management is no longer limited to counting stock or calculating the cost of goods sold. It has become an integrated discipline combining accounting, production, procurement, warehousing, logistics, quality control, and advanced analytics.

Key Takeaways

  • Perpetual inventory (real-time updates on every transaction) has replaced periodic counting as the standard for most UAE medium/large organizations.
  • FIFO and Weighted Average are the two IFRS-compliant valuation methods — LIFO is prohibited under IFRS entirely.
  • Production cost flows in one direction: Raw Materials → WIP → Semi-Finished Goods → Finished Goods → COGS (only on sale).
  • Separate normal wastage (part of production cost) from abnormal wastage (a management-review expense) — conflating them hides operational problems.
  • Physical stock counts will always surface differences versus the ERP — investigate and approve every adjustment rather than posting it automatically.
  • Inventory cost isn't just purchase price — freight, insurance, customs duty, handling and production overhead all belong in the landed/production cost.

In the age of intelligent manufacturing and digital finance, inventory is not simply an asset recorded on the balance sheet — it is a strategic resource whose value depends on accurate accounting, disciplined production processes, robust internal controls, and data-driven decision-making.

🧠 Who Should Read The AI Accountant

CFOs & Finance Controllers Practicing Accountants Auditors ERP Consultants Real Estate & Construction Finance Teams Tax & Compliance Managers Business Owners Finance Students & Researchers

🤝 Published by Professionals Lobby — an independent, UAE-based advisory helping businesses design modern accounting processes and select the right ERP, AI and automation partners to run them.

Structuring inventory valuation or production costing?

Professionals Lobby advises UAE and GCC manufacturers, traders and distributors as an independent, vendor-neutral partner — from process design and ERP selection through implementation and compliance oversight.

Schedule an Advisory Call Continue to Chapter 14