Finance AI Skill

Inventory Accounting Valuation

Manage inventory accounting including valuation methods (FIFO, LIFO, weighted average, standard cost), lower of cost or market (LCM) / net realizable value assessments, inventory obsolescence reserves, cycle counting, and inventory roll-forward analysis. Use when setting up inventory accounting policies, performing inventory valuations, calculating obsolescence reserves, conducting inventory reconciliations, analyzing inventory turns, or preparing inventory disclosures. Triggers on phrases like "inventory accounting", "inventory valuation", "FIFO", "LIFO", "weighted average cost", "standard costing", "lower of cost or market", "LCM", "net realizable value", "NRV", "inventory reserve", "obsolescence reserve", "inventory turns", "cycle count".

Inventory Accounting & Valuation

Manage inventory valuation, costing methods, and write-down assessments to ensure accurate inventory balances and compliance with ASC 330 / IAS 2.

Workflow

1. Inventory Valuation Method Selection

INVENTORY VALUATION METHODS
═══════════════════════════════════════

SELECT METHOD BASED ON:
  → Nature of inventory (perishable, commodity, manufactured)
  → Industry norms
  → Tax implications (LIFO conformity rule in US)
  → Financial statement presentation preferences
  → System capability and data requirements

COMPARISON OF METHODS:
═══════════════════════════════════════

                  FIFO        LIFO          Weighted Avg    Standard Cost
─────────────────────────────────────────────────────────────────────────
Rising prices     Higher      Lower         Moderate      N/A (variance)
                  inventory   inventory
                  Lower COGS  Higher COGS
                  Higher      Lower
                  earnings    earnings
Tax impact        Higher      Lower*        Moderate      N/A
                  taxes       taxes*
Matching to       Older costs Recent        Blended       Budgeted
current costs     (less match) costs        costs         costs
Complexity        Moderate    Moderate      Simple        Higher
System needs      Moderate    Moderate      Low           Robust

*LIFO tax benefit in inflationary environment (US only; IRS requires
LIFO for tax if used for financial reporting — LIFO conformity rule)

RECOMMENDATION FRAMEWORK:
  → Retail/CPG with stable SKUs: Weighted Average or Standard Cost
  → Manufacturing with BOMs: Standard Cost with variance analysis
  → Commodities/energy: LIFO (if US, tax benefit desired)
  → Perishable goods: FIFO (most natural flow)
  → Technology/hardware: Standard Cost or FIFO

2. Standard Costing System

STANDARD COST CALCULATION
═══════════════════════════════════════

For each SKU/product, establish standard cost:

DIRECT MATERIALS:
  Component          Qty     Std Price    Std Cost
  ──────────────────────────────────────────────────
  Circuit Board      1       $12.50       $12.50
  Housing            1        $3.20        $3.20
  Battery Pack       2        $4.50        $9.00
  Connector Kit      1        $1.80        $1.80
  Packaging          1        $0.75        $0.75
  Total Materials:                              $27.25

DIRECT LABOR:
  Assembly:  0.25 hours × $25/hr = $6.25
  Testing:   0.10 hours × $30/hr = $3.00
  Total Labor:                                $9.25

MANUFACTURING OVERHEAD:
  Applied rate: $18.00 per direct labor hour
  DL hours: 0.25 + 0.10 = 0.35 hours
  Overhead: 0.35 × $18.00 = $6.30

TOTAL STANDARD COST PER UNIT:           $42.80

VARIANCE ANALYSIS (Monthly):
═══════════════════════════════════════

MATERIAL COST VARIANCE:
  = (Actual Price - Standard Price) × Actual Quantity
  Example: Circuit boards purchased at $13.00 vs $12.50 std
  = ($13.00 - $12.50) × 10,000 units = $5,000 UNFAVORABLE

MATERIAL USAGE VARIANCE:
  = (Actual Qty - Standard Qty) × Standard Price
  Example: Used 10,500 boards for 10,000 units (should be 1:1)
  = (10,500 - 10,000) × $12.50 = $6,250 UNFAVORABLE
  Root cause: Scrap rate increased from 1% to 5%

LABOR RATE VARIANCE:
  = (Actual Rate - Standard Rate) × Actual Hours
  Example: Paid $27/hr vs $25/hr std
  = ($27 - $25) × 2,500 hours = $5,000 UNFAVORABLE

LABOR EFFICIENCY VARIANCE:
  = (Actual Hours - Standard Hours) × Standard Rate
  Example: Used 2,800 hours for work requiring 2,500 std hours
  = (2,800 - 2,500) × $25 = $7,500 UNFAVORABLE

OVERHEAD VARIANCE:
  = Actual Overhead - Applied Overhead
  = (Actual DLH × Actual OH Rate) - (Actual DLH × Std OH Rate)
  + Volume variance (capacity utilization)

TOTAL VARIANCE: $24,250 UNFAVORABLE
  → If immaterial (<2% of COGS): Write off to COGS
  → If material: Prorate between COGS and ending inventory

3. Inventory Roll-Forward & Reconciliation

INVENTORY ROLLFORWARD
═══════════════════════════════════════

                              Raw Materials  WIP    Finished Goods  TOTAL
Beginning Balance            $2,500,000     $800K  $3,200,000     $6,500,000
  Purchases/Transfers In     +$1,800,000    —      —              +$1,800,000
  Production Transfers        —            +$1,200K  —            +$1,200,000
  Finished Goods Transfers    —            ($900K)  +$900,000        $0
  COGS/Shipments              —              —      ($2,100,000)  ($2,100,000)
  Adjustments:
    Scrap/Write-offs         ($50,000)      —      ($30,000)     ($80,000)
    Standard Cost Variance    —              —      ($15,000)     ($15,000)
    Cycle Count Adjustments   +$8,000      ($3,000) +$5,000      +$10,000
Ending Balance               $4,258,000     $1,097K  $1,960,000   $7,315,000

RECONCILIATION TO GL:
  Inventory per sub-ledger:              $7,315,000
  Inventory per GL (account 13000):      $7,320,000
  Difference:                                $5,000
  Resolution: Timing — 3 transfers in transit; JE posted but sub-ledger
               not updated. Will clear next day. Documenting.

4. Lower of Cost or Market / Net Realizable Value

LOWER OF COST OR NET REALIZABLE VALUE (LCM/NRV) TEST
═══════════════════════════════════════

Per ASC 330 (US GAAP): Inventory stated at lower of cost or market
Per IAS 2 (IFRS): Inventory stated at lower of cost or net realizable value

TEST PROCEDURE (per SKU or category):
═══════════════════════════════════════

STEP 1: Determine Cost
  → Standard cost or actual cost (FIFO/LIFO/weighted avg)

STEP 2: Determine Net Realizable Value (NRV)
  = Estimated selling price - Costs to complete - Costs to sell

STEP 3: Compare and Write Down (if needed)
  → If Cost > NRV: Write down to NRV
  → If Cost ≤ NRV: No write-down needed

EXAMPLE — SKU Analysis:
═══════════════════════════════════════

SKU         Qty     Cost/Unit  NRV/Unit   Total Cost   Total NRV    Write-Down
─────────────────────────────────────────────────────────────────────────────
A-100       500     $50.00     $55.00    $25,000      $27,500      $0
A-200       300     $45.00     $48.00    $13,500      $14,400      $0
B-100       200     $60.00     $52.00    $12,000      $10,400      $1,600  ⚠
B-200        50     $80.00     $65.00     $4,000       $3,250      $750    ⚠
C-100       100    $120.00    $110.00    $12,000      $11,000    $1,000   ⚠
D-100        75     $35.00     $20.00     $2,625       $1,500    $1,125   ⚠
─────────────────────────────────────────────────────────────────────────────
Total:                        $69,125      $68,050    $4,475

NRV CALCULATIONS:
  B-100: Selling price $65 - selling costs ($13) = NRV $52 < Cost $60
    → Reason: Newer model B-101 replaced; price discounting old model
  
  B-200: Selling price $80 - selling costs ($15) = NRV $65 < Cost $80
    → Reason: Discontinued product; clearance pricing
  
  C-100: Selling price $130 - completion costs $15 - selling $5 = NRV $110
    → Reason: Market price decline in raw material
  
  D-100: Selling price $30 - selling costs ($10) = NRV $20 < Cost $35
    → Reason: Obsolete — technology replaced; minimal salvage value

JOURNAL ENTRY:
  Dr COGS — Inventory Write-Down     $4,475
  Cr Inventory Reserve / Inventory       $4,475

5. Obsolescence Reserve Calculation

INVENTORY OBSOLESCENCE RESERVE
═══════════════════════════════════════

AGING-BASED RESERVE METHODOLOGY:
═══════════════════════════════════════

Age Bracket          Reserve %    Inventory $    Reserve $
──────────────────────────────────────────────────────────
0-90 days (current)      0%      $4,200,000         $0
91-180 days (aging)     25%        $800,000    $200,000
181-365 days (stale)    50%        $350,000    $175,000
>365 days (obsolete)   100%        $150,000    $150,000
──────────────────────────────────────────────────────────
Total Reserves:                          $6,500,000    $525,000

RESERVE ROLLFORWARD:
═══════════════════════════════════════

Beginning Reserve:                          $480,000
  Additions (provision this period):        +$120,000
  Write-offs (inventory disposed):           ($65,000)
  Reversals (inventory sold at NRV):         ($10,000)
Ending Reserve:                             $525,000

OBSOLESCENCE ANALYSIS BY CATEGORY:
═══════════════════════════════════════

Category            Inventory $   Reserve $   Reserve %   Action
─────────────────────────────────────────────────────────────────
Finished Goods     $3,200,000    $280,000       8.8%     Monitor
Raw Materials      $2,100,000    $180,000       8.6%     Review purchases
WIP                   $700,000     $40,000       5.7%     Normal
Packaging/MRO         $500,000     $25,000       5.0%     Normal
Total              $6,500,000    $525,000       8.1%     —

KEY METRICS:
  Inventory Turns = COGS / Average Inventory = $24M / $6.75M = 3.56x
  Days Inventory Outstanding = 365 / 3.56 = 103 days
  Obsolescence Rate = Reserve / Inventory = 8.1% (target: <5%)
  ⚠ Action needed: Obsolescence rate above target; review purchasing plans

6. Cycle Counting Program

CYCLE COUNTING PROGRAM
═══════════════════════════════════════

ABC CLASSIFICATION:
═══════════════════════════════════════

Class     Criteria                  Count Frequency   % of SKUs   % of Value
─────────────────────────────────────────────────────────────────────────────
A         Top 20% by value          Monthly           15%         70%
B         Next 30% by value         Quarterly         30%         20%
C         Bottom 50% by value       Semi-annually     55%         10%

CYCLE COUNT PROCEDURES:
  1. Generate count list (system pulls quantities)
  2. Counters blind-count (do NOT see system quantity)
  3. First count by counter A
  4. Second count by counter B (if variance > tolerance)
  5. Supervisor review for variances
  6. Investigate root cause (shipping error, receiving error, theft, damage)
  7. Post adjustment with supporting documentation
  8. Update system quantities

VARIANCE THRESHOLDS:
  → Unit variance: >3 units or >5% of on-hand (whichever triggers first)
  → Dollar variance: >$500 or >1% of category value
  → Variances within threshold: Auto-adjust
  → Variances above threshold: Investigation required

MONTHLY CYCLE COUNT RESULTS:
═══════════════════════════════════════

SKUs Scheduled: 450
SKUs Counted: 450 (100%)
Variances found: 23 (5.1%)
  Within tolerance: 18 (auto-adjusted)
  Above tolerance: 5 (under investigation)

Dollar Value of Variances:
  Favorable (found more):    +$2,800
  Unfavorable (found less):  ($4,200)
  Net variance:              ($1,400)
  Net / Inventory value:    -0.02% (within annual target of <0.1%)

TOP VARIANCE ITEMS:
  1. SKU D-100: Short 25 units ($875) — misplaced in warehouse (relocated)
  2. SKU C-200: Short 10 units ($1,200) — shipped without picking ticket
     → Root cause: Picking process bypassed; retraining required

Edge Cases

LIFO liquidation: When LIFO inventory layers are depleted, older (cheaper) costs flow to COGS, inflating earnings; disclose LIFO liquidation separately
Consignment inventory: Inventory owned by supplier but held by company; track separately; not on balance sheet
Work-in-progress valuation: Estimate % completion; apply partial material and labor costs; use engineering estimates
Inventory at off-site locations: Customer sites, third-party warehouses; coordinate counts; track ownership clearly
Perishable inventory: Frequent NRV testing; short aging brackets; high reserve percentages for near-expiry items

Integration Points

ERP Inventory Module: SAP MM, Oracle INV, NetSuite (inventory transactions, valuations)
WMS: Manhattan, Blue Yonder, Fishbowl (warehouse operations, cycle counts)
MRP/ERP: Production planning, BOM management
Costing systems: Standard cost maintenance, variance analysis
BI tools: Inventory aging reports, turns analysis, obsolescence dashboards

Output

Inventory Valuation Summary

INVENTORY VALUATION SUMMARY — March 2024
═══════════════════════════════════════

GROSS INVENTORY (at standard cost):       $7,315,000
Less: Inventory Reserve (LCM/NRV):         ($4,475)
Less: Obsolescence Reserve:              ($525,000)
NET INVENTORY (per balance sheet):         $6,785,525

KEY METRICS:
  Inventory turns: 3.56x (target: 4.0x) ⚠
  Days inventory: 103 days (target: 91) ⚠
  Obsolescence rate: 8.1% (target: <5%) ⚠
  Cycle count accuracy: 99.98% ✓
  Variance to GL: $0 (reconciled) ✓

ACTION ITEMS:
  1. Review purchasing plans for slow-moving SKUs
  2. Promote/clear B-200 and D-100 obsolete inventory
  3. Implement vendor-managed inventory for C materials
  4. Retrain warehouse on picking process compliance

Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.