KSA | Bahrain | UAE | India

FIFO vs AVCO in Odoo 19: Which Inventory Costing Method Is Right for Your Business?

FIFO vs AVCO in Odoo 19: Which Inventory Costing Method Is Right for Your Business?

Inventory costing is more than assigning a price to a product. It affects the value of your stock, the cost of goods sold, and the profit shown in your financial reports.

Imagine a business that purchases the same product several times at different prices. The first batch costs ₹100 per unit, the next costs ₹120, and a later batch costs ₹130. When the business sells one unit, which purchase cost should Odoo use?

The answer depends on the costing method configured for the product category.

The Three Main Costing Methods

  • Standard Price: Uses a manually maintained cost.
  • Average Cost (AVCO): Calculates the average cost of available inventory.
  • First In First Out (FIFO): Uses the cost of the earliest inventory layer first.

In this guide, we explore how these methods work in Odoo 19, compare them with practical examples, and explain how to choose the right method for your business.

What Is Inventory Costing in Odoo?

Inventory costing is the method used to determine the financial value of products held in stock and the cost assigned to products when they are sold or consumed.

For example, a wholesale business purchases 100 units of a product at ₹100 each. A week later, it purchases another 100 units at ₹120 each. The business now has 200 units, but they were not purchased at the same price.

When some of these units are sold, Odoo needs a method to calculate their cost. This is where Standard Cost, AVCO, and FIFO become important.

The selected costing method can influence:

  • Inventory valuation
  • Cost of goods sold (COGS)
  • Product profitability
  • Manufacturing costs
  • Financial reporting

Important: In Odoo, the costing method is configured at the product category level. Products assigned to that category follow its costing method.

Understanding the Three Costing Methods

A. Standard Price – A Fixed Cost for the Product

Standard Price uses a predefined cost for a product. The cost does not automatically change every time the business purchases the product at a different price.

Example: A company sets the standard cost of a product at ₹100 per unit.

 

Transaction

Purchase price

Standard cost

First purchase

₹100

₹100

Second purchase

₹120

₹100

Third purchase

₹130

₹100

 

Even if the supplier increases the purchase price, the product’s standard cost remains ₹100 until someone updates it.

When is Standard Price useful?

  • Businesses that work with relatively stable product costs.
  • Companies that want a predefined cost for planning.
  • Manufacturing businesses that use planned or estimated production costs.

Example: A furniture manufacturer may set a standard cost for a chair based on its expected material and production expenses. The actual cost may vary, but the standard cost provides a consistent reference.

B. Average Cost (AVCO) – Cost Based on Average Inventory Value

Average Cost, commonly called AVCO, calculates the average cost of the inventory currently available. When new stock is received at a different price, Odoo recalculates the average cost based on the existing inventory value and the incoming inventory value.

 

Purchase

Quantity

Unit price

Total value

First

100

₹100

₹10,000

Second

100

₹120

₹12,000

Third

100

₹130

₹13,000

Total

300

₹35,000

 

Average cost = ₹35,000 ÷ 300 = ₹116.67 per unit (approximately).

If the company sells 50 units, the cost assigned to those units is approximately ₹5,833.50.

When is AVCO useful?

  • Retail and wholesale businesses.
  • Businesses that purchase the same products at changing prices.
  • Companies that prefer a blended cost rather than tracking individual purchase layers.

Example: A grocery wholesaler purchases cooking oil from suppliers at different prices throughout the month. AVCO provides an average cost based on the inventory received and still available.

C. FIFO – First In First Out

FIFO stands for First In First Out. Under this method, the cost of the earliest received inventory is used first when calculating the cost of products leaving stock.

 

Purchase batch

Quantity

Unit cost

Batch 1

100

₹100

Batch 2

100

₹120

Batch 3

100

₹130

 

The company now has 300 units and sells 150 units. Under FIFO, the first 100 units are valued at ₹100 each and the next 50 units are valued at ₹120 each.

Cost of sale = (100 × ₹100) + (50 × ₹120) = ₹16,000.

 

Remaining batch

Quantity

Unit cost

Value

Batch 2

50

₹120

₹6,000

Batch 3

100

₹130

₹13,000

Total

150

₹19,000

 

When is FIFO useful?

  • Businesses dealing with products purchased at changing prices.
  • Companies that want inventory costs to follow receipt order.
  • Businesses that manage stock with batches or dated inventory.

Example: An electronics distributor purchases the same accessory at different prices over several months. FIFO helps calculate the cost of outgoing stock using the oldest cost layers first.

How to Configure Costing Methods in Odoo 19

Odoo allows you to configure the costing method from the product category. Follow these steps to set it up.

  1. Go to Inventory → Configuration → Product Categories.
  2. Open an existing category or create a new one. Locate the Inventory Valuation section.
  3. Select Standard Price, Average Cost (AVCO), or First In First Out (FIFO) as the costing method.
Figure 1. Choose Standard Price, First In First Out (FIFO), or Average Cost (AVCO) in the product category.

 

After saving the category, open the relevant product and assign it to that category. The second screenshot shows the TV product assigned to the Electronics category.

Figure 2. The TV product is assigned to the Electronics category and follows that category’s costing configuration.

Manual valuation updates inventory valuation through periodic accounting entries. Automated valuation creates relevant accounting entries when stock valuation changes. Automated valuation requires the appropriate stock valuation and accounting accounts to be configured.

The exact options visible can depend on installed applications and database configuration. Review the accounting implications before changing settings in a live database.

FIFO vs AVCO: A Practical Comparison

Using the same example, a business purchases 300 units: 100 at ₹100, 100 at ₹120, and 100 at ₹130. It then sells 150 units.

 

Costing method

Cost assigned to 150 units sold

Remaining stock value

Standard Price (₹100)

₹15,000

₹15,000

AVCO (₹116.67)

₹17,500.50*

₹17,500.50*

FIFO

₹16,000

₹19,000

 

Calculated using the average cost of ₹116.67 per unit, rounded to two decimal places. Actual Odoo valuation may retain greater precision.

The results differ because each costing method applies a different approach to assigning costs. Standard Price keeps the predefined cost, AVCO uses a blended average cost, and FIFO uses the oldest remaining cost layers first.

There is no single method that always produces the highest profit. The result depends on purchase prices, stock movements, and the method selected.

FIFO and Product Returns in Odoo

Returns are an important part of inventory management. Consider a business that sells a product and later receives some of those units back from the customer.

With FIFO, the cost associated with a return can matter because inventory valuation is based on cost layers. When a return is linked to the original delivery, Odoo can use the original movement’s valuation information when reversing the stock movement.

Practical recommendation: Process customer returns using the original delivery’s return action whenever appropriate. This helps keep the return linked to the original transaction.

Understanding Costing Methods in Manufacturing

Costing methods are also relevant to manufacturing businesses. Imagine a company that manufactures wooden tables using wooden boards, screws, paint, labour, and production operations.

The total manufacturing cost can include the cost of components and other production costs configured in the manufacturing workflow. The costing method determines how the cost of inventory is valued as products enter or leave stock.

This makes costing methods important for understanding the value of raw materials, the cost of finished products, the cost of products sold, and the value of remaining inventory.

The exact manufacturing valuation also depends on the Bill of Materials, component consumption, operations, and the manufacturing and accounting configuration.

FIFO Costing vs FIFO Stock Removal: What Is the Difference?

Both features use the term FIFO, but they serve different purposes.

FIFO Costing Method

FIFO costing determines how Odoo assigns costs to outgoing inventory and values the remaining stock.

FIFO Removal Strategy

The FIFO removal strategy determines which physical stock is selected for an outgoing transfer. It prioritises the stock that entered the location first.

For example, if Batch A was received on 1 November and Batch B on 10 November, FIFO removal prioritises Batch A when preparing an outgoing transfer.

Selecting FIFO as the costing method does not automatically mean that the FIFO removal strategy is configured for warehouse operations. These settings have different purposes.

Common Mistakes to Avoid

  • Confusing costing methods with removal strategies: FIFO costing and FIFO removal are separate configurations. One deals with financial valuation; the other deals with physical stock selection.
  • Changing the costing method without reviewing its impact: Changing a product category’s costing method can affect future inventory valuation. Review accounting and valuation implications before changing it in a live database.
  • Ignoring inventory valuation settings: Selecting a costing method alone does not complete the accounting configuration. Check manual or automated valuation and configure the necessary accounts.
  • Forgetting to review product categories: Products follow the costing method of their assigned category. An incorrect category can result in an unintended costing method.
  • Processing returns incorrectly: Use the appropriate return workflow and link the return to the original delivery whenever possible.

Which Costing Method Should Your Business Choose?

 

Business type

Possible choice

Why?

Retail business

AVCO or FIFO

Useful for products purchased at changing prices.

Wholesale distributor

AVCO or FIFO

Helps value inventory when purchase prices vary.

Manufacturing company

Standard Price, AVCO or FIFO

Depends on how material and production costs are managed.

Business with stable costs

Standard Price

Provides a consistent predefined cost.

Business handling dated stock

FIFO

Helps align cost layers with the order inventory is received.

 

These are general examples, not strict rules. Accounting policies, local requirements, and business operations should guide the final choice.

Frequently Asked Questions

Where can I configure FIFO in Odoo 19?

Go to Inventory → Configuration → Product Categories, open the relevant category, and select FIFO as the costing method.

Does AVCO change automatically when a new purchase is received?

Under AVCO, the average cost is recalculated when inventory is received at a different cost, based on existing inventory value and incoming stock value.

Does FIFO always mean the oldest physical product is delivered first?

No. FIFO costing determines how inventory costs are assigned. The FIFO removal strategy determines which physical stock is selected for outgoing transfers.

Can I use different costing methods for different products?

Yes. Assign products to different product categories, each with its own costing method. Products within a category follow that category’s configuration.

Which method is best for a manufacturing company?

There is no universal best method. The choice depends on whether the business uses predefined costs, prefers average material costs, or wants cost layers to follow receipt order.

Does the costing method affect the profit shown in Odoo?

Yes. The cost assigned to outgoing products affects cost of goods sold and therefore influences gross profit. Remaining stock value is also affected.

Conclusion

Choosing the right inventory costing method is an important part of setting up Odoo for accurate stock and financial management.

Standard Price is suitable when a business wants to maintain a predefined product cost. AVCO provides an average cost as new inventory is received. FIFO uses the earliest remaining inventory cost layers first.

Odoo 19 provides these methods to support different inventory and accounting requirements. Understanding how each one works helps businesses make better decisions about stock valuation, product profitability, and financial reporting.

Before selecting a method, consider how frequently your purchase prices change, how your warehouse manages stock, and how your accounting team wants inventory to be valued.

Check out our new blogs related to Odoo inventory

Leave a Reply

Your email address will not be published. Required fields are marked *