Odoo Inventory Valuation: FIFO vs AVCO vs LIFO Explained with Real Examples

What Is Inventory Valuation?

Inventory valuation assigns monetary value to unsold inventory and determines cost of goods sold (COGS). The method you choose affects both balance sheet and income statement.

Why It Matters

• COGS Calculation: Directly impacts gross profit on income statement
• Ending Inventory: Appears as current asset on balance sheet
• Tax Implications: Different methods yield different taxable income
• Financial Analysis: Affects key ratios investors and lenders review

FIFO (First In, First Out)

Oldest inventory items are sold first. Remaining inventory reflects most recent purchase costs.

How FIFO Works

• First items purchased are first items sold
• Ending inventory valued at most recent costs
• COGS reflects older, often lower costs in inflationary periods

FIFO Example

Jan 1: Purchase 100 units @ $10 = $1,000
Jan 15: Purchase 100 units @ $12 = $1,200
Jan 20: Purchase 100 units @ $14 = $1,400
Jan 25: Sell 150 units

FIFO COGS: (100 × $10) + (50 × $12) = $1,600
Ending Inventory: (50 × $12) + (100 × $14) = $2,000

When to Use FIFO

• Perishable goods: Food, pharmaceuticals with expiration dates
• Inflationary environments: Shows higher profit (older lower costs in COGS)
• Physical flow matches: When actual goods flow follows FIFO pattern
• IFRS compliance: Required in many jurisdictions

FIFO Pros and Cons

• Pros: Higher reported profit, matches physical flow for perishables, IFRS compliant
• Cons: Higher taxes in inflation, may not reflect actual cost flow

AVCO (Average Cost)

Also called weighted average. All units valued at average cost of all purchases.

How AVCO Works

• Calculate total cost of goods available for sale
• Divide by total units available
• Apply average cost to both COGS and ending inventory

AVCO Example

Jan 1: Purchase 100 units @ $10 = $1,000
Jan 15: Purchase 100 units @ $12 = $1,200
Jan 20: Purchase 100 units @ $14 = $1,400
Total: 300 units, $3,600
Average Cost: $3,600 ÷ 300 = $12/unit

Sell 150 units:
COGS: 150 × $12 = $1,800
Ending Inventory: 150 × $12 = $1,800

When to Use AVCO

• Similar items: Fungible goods like fuel, grain, chemicals
• Volatile prices: Smooths out price fluctuations
• Simplicity needed: Easiest method to calculate and maintain
• No physical flow pattern: When items are interchangeable

AVCO Pros and Cons

• Pros: Smooths price volatility, simple to calculate, middle-ground profit reporting
• Cons: Doesn't match specific item costs, may lag current market prices

LIFO (Last In, First Out)

Most recently purchased items are sold first. Oldest costs remain in inventory.

How LIFO Works

• Last items purchased are first items sold
• Ending inventory valued at oldest costs
• COGS reflects most recent, often higher costs in inflation

LIFO Example

Jan 1: Purchase 100 units @ $10 = $1,000
Jan 15: Purchase 100 units @ $12 = $1,200
Jan 20: Purchase 100 units @ $14 = $1,400
Jan 25: Sell 150 units

LIFO COGS: (100 × $14) + (50 × $12) = $2,000
Ending Inventory: (50 × $12) + (100 × $10) = $1,600

When to Use LIFO

• US GAAP only: Not permitted under IFRS
• High inflation: Reduces taxable income with higher COGS
• Non-perishable goods: Bulk materials like coal, lumber
• Tax strategy: Defers tax payments in inflationary periods

LIFO Pros and Cons

• Pros: Lower taxes in inflation, matches current costs to revenue
• Cons: Lower reported profit, not IFRS compliant, can understate inventory value

Comparison: FIFO vs AVCO vs LIFO

Configuring Valuation in Odoo

Step 1: Enable Accounting Features

Settings → Accounting → Enable "Inventory Valuation" and "Automated Inventory Valuation".

Step 2: Set Product Category

Inventory → Configuration → Product Categories → Select or Create Category

Step 3: Configure Costing Method

• Costing Method: Choose FIFO, Average Cost (AVCO), or Standard Price
• Inventory Valuation: Select "Automated" for real-time valuation
• Stock Valuation Account: Balance sheet account for inventory asset
• Stock Output Account: COGS account for inventory out
• Stock Input Account: Inventory receipt account

Step 4: Assign Products to Category

Products inherit valuation method from category. Cannot change after transactions exist.

Important Considerations

Cannot Change After Transactions

Once a product has stock moves, valuation method is locked. Create new product/category if change needed.

Perpetual vs Periodic

• Perpetual (Automated): Real-time valuation with every stock move
• Periodic (Manual): Valuation at period end via inventory counts

Multi-Company Considerations

Different companies can use different methods. Set at product category level per company.

Impact on Financial Reports

• Balance Sheet: Inventory asset value varies by method
• Income Statement: COGS and gross profit differ
• Cash Flow: Tax payments affected by reported profit

FAQ

Can I change valuation method after setup?

No. Once a product has stock transactions, the valuation method is locked. Create a new product or category.

Which method is best for inflation?

LIFO minimizes taxes (higher COGS), FIFO maximizes reported profit. AVCO smooths fluctuations.

Is LIFO allowed everywhere?

No. LIFO is only permitted under US GAAP. IFRS prohibits LIFO.

Does Odoo support all three methods?

Odoo supports FIFO and Average Cost (AVCO) natively. LIFO requires customization.

How does valuation affect taxes?

Higher COGS means lower profit, which means lower taxable income. LIFO reduces taxes in inflation.

References

1. Odoo SA: "Inventory Valuation Configuration" (2026). Odoo Documentation
2. Investopedia: "Inventory Valuation Methods Explained" (2025). Investopedia
3. AccountingTools: "FIFO vs LIFO vs AVCO Comparison" (2026). AccountingTools
4. Odoo Mates: "Odoo Inventory Accounting Guide" (2025). Odoo Mates Blog
5. Cybrosys: "Automated Inventory Valuation in Odoo" (2026). Cybrosys Blog