Enable Dark Mode!
By: Faslu Rahman

# Costing Methods In Odoo

## Functional Warehouse

In this blog, we are going to discuss different costing methods available in Odoo.
Odoo provides three methods.
1. Standard
2. Average
3. Real-time(FIFO, LIFO)
- You can configure this on the Product category form.

Let’s discuss how they differ from each other.
> Standard Costing:
- This method is very basic and easy. What we have to do is, just put the cost price on product master.
- The inventory valuation will not consider the amount for which you bought this item. It directly takes the cost price you provided on product master.
> Here, Cost of Product A is set as 7\$

> Making a purchase with unit cost 10\$
> Let’s check the inventory value of Product A
Valuation says that value is 70\$. No matter how much we spend on that item.
> Average Costing:
-In average costing method, cost of items in inventory is calculated based on the average cost of all available similar items in inventory.
- i.e cost of an item in inventory divided by the number of items available in stock.
Here, I have created a new product category ‘Average’ with the costing method ‘Average Cost’
- Now I am going to create a new product ‘Product B’ under this category ‘Product B’
- Now let’s try making some purchases of this item.
- We bought 10 Kg of Product B for 100\$. So, 10\$/Kg
then,
- Again we bought Product B 10 kg for 140\$. So 14\$/Kg
- Now we have 20Kg of Product B in our inventory. Let’s check the inventory value.
- You can see Valuation says the Inventory value of Product B is 240\$
Ie, 12\$/Kg (240\$/20Kg)
-Now you know what is the difference between Standard and Average costing methods.
Let’s go through the last one,
3. Real-Time Costing:
- In the real-time inventory valuation method, Odoo keeps the track of the cost of each incoming and outgoing item. The real-time costing method works along with the stock removal strategy.
Ie (FIFO, LIFO, FEFO). So we have to select one of them in the product category form
Otherwise, Odoo will take FIFO as default.
We can go with an example.
We are creating a new product ‘Product C’ with category ‘RealTime’. You can see the configuration of ‘Real-Time’ in above picture. Costing method is ‘First In First Out (FIFO)’
(In Odoo v11 Real-time is named as First In First Out) And force removal strategy is ‘First in First Out (FIFO)’
- Let’s make two purchases for this product
> We bought 10 Kg of Product C for 100\$. So, 10\$/Kg
> Again we bought Product C 10 kg for 140\$. So 14\$/Kg
> Now, we have 20kg of Product C, let’s have a look at inventory valuation.

> You can see Valuation says the Inventory value of Product C is 240\$

> You may think that it is the same as Average costing. But it is not

The computation is ;

10\$*10kg = 100\$

14\$8*10kg=140\$

Total = 240\$

>
You may have noticed a small symbol next to the value. You’ll get more information about how that 240\$ by clicking on that
- So, if you sell an item with an inventory costing method Real-Time and force removal strategy is FIFO, the cost of goods sold will be updated with the cost of the item coming to the stock at first.
- In this case, the cost will be 10\$.
- If the force removal strategy is LIFO system will take the cost of the last came item.
- Here that is 14\$.
This is how different costing method works in Odoo.

If you need any assistance in odoo, we are online, please chat with us.

Informative

27/06/2018

-

5:01AM

### Recent Posts

#### An Overview of Accounting Localization for Denmark in Odoo 17

Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Kochi, India - 682030.

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,