For trading and manufacturing companies, inventory is often the largest asset on the balance sheet and cost of goods sold the largest expense. Both depend on one setting chosen when products are created: the costing method. Choose well and connect stock to accounting, and margins are right every day. Choose badly, or leave valuation manual, and every month ends with an argument between the warehouse and finance.
FlexCode Middle East is part of FlexCode Systems GmbH, an Odoo Silver Partner. We implement Odoo, so Odoo is the system we describe, next to an honest look at the topic itself.
Key points
- Three methods. Standard price, average cost and FIFO, set per product category.
- Automated valuation. With automated valuation, every stock move posts an accounting entry, so stock in the books equals stock in the warehouse.
- No LIFO. IFRS and Egyptian standards do not allow LIFO; FIFO or weighted average are the usual choices.
- Decide before go-live. Changing method later is possible but requires a revaluation and careful cut-off.
The three costing methods
In Odoo the costing method is set on the product category, so all products in a category share it. Each method answers one question differently: what did the unit we just sold cost us?
| Method | How cost is set | Best for |
|---|---|---|
| Standard price | A fixed cost you set; differences go to a price difference account | Manufacturers with stable, known costs |
| Average cost (AVCO) | Recalculated after every receipt as a weighted average | Distributors and retailers with frequent purchases at changing prices |
| FIFO | Each sale consumes the oldest stock layer at its own cost | Perishables, batch-tracked goods, high inflation periods |
LIFO, last in first out, is not permitted under IFRS or Egyptian Accounting Standards, and Odoo does not offer it for valuation.
A worked example
A distributor buys the same product twice and then sells some. Prices rose between the two purchases, as they often have in recent years.
| Step | FIFO | Average cost |
|---|---|---|
| Buy 100 units at 50 | Layer 1: 100 at 50 | 100 at 50 = 5,000 |
| Buy 100 units at 70 | Layer 2: 100 at 70 | 200 at 60 = 12,000 |
| Sell 120 units | Cost: 100 x 50 + 20 x 70 = 6,400 | Cost: 120 x 60 = 7,200 |
| Stock remaining | 80 at 70 = 5,600 | 80 at 60 = 4,800 |
With rising prices, FIFO shows a lower cost of sales and a higher closing stock than average cost. Neither is wrong; they tell different stories. What matters is that the method is consistent and that the stock value in the accounts equals the stock valuation report.
6,400
Cost of sales under FIFO
7,200
Cost of sales under average cost
5,600
Closing stock under FIFO
4,800
Closing stock under average cost
Manual or automated valuation
The second setting on the product category is the valuation mode. With manual valuation, stock moves do not create accounting entries, and the accountant books stock adjustments periodically. With automated valuation, every receipt, delivery, scrap and adjustment posts a journal entry at the product's cost, keeping the inventory account and cost of goods sold current at all times.
- Goods received
- Stock valuation debited
- Vendor bill matched
- Goods delivered
- Cost of goods sold posted
Automated valuation makes margins visible daily, not after the stock count.
We recommend automated valuation for almost every trading and manufacturing company. It needs three accounts per category, stock valuation, stock input and stock output, which the localization usually provides.

What breaks valuation
- Selling before receiving, which creates negative stock valued at the wrong cost and corrected later.
- Receiving goods but billing them at a different price without updating the receipt, which leaves price differences unexplained.
- Forgetting import costs, so products are valued at the supplier price only.
- Mixing products with different methods in the same category.
- Manual journal entries to stock accounts, which break the link with the valuation report.
Import costs belong in product cost through landed costs in Odoo, and exchange rate movements on foreign purchases are covered in multi-currency and revaluation. To trace a single product's movements and value, use the stock card report.
Reconciling stock to the general ledger
Every month, compare the stock valuation report with the balance of the stock valuation accounts. With automated valuation and no manual entries, they agree. When they do not, the usual causes are manual journal entries, products moved between categories with different accounts, or valuation layers created before a configuration change.
- Run the stock valuation report at month end.
- Compare it with the stock valuation account balances.
- Check the stock input and output accounts: received not billed, billed not received.
- Investigate any manual entries on stock accounts.
- Document the reconciliation for the auditor.
The year-end count and cut-off are covered in our year-end closing checklist.
FlexCode sets up inventory valuation you can trust
We choose costing methods with your finance team, configure automated valuation and landed costs, and reconcile stock to the ledger.
Frequently asked questions
Which costing method should I use?
Average cost suits most distributors and retailers; FIFO suits perishables and batch-tracked goods; standard price suits manufacturers with stable costs.
Does Odoo support LIFO?
No. LIFO is not permitted under IFRS or Egyptian standards.
What is automated valuation?
A setting where every stock move posts an accounting entry, keeping inventory and cost of goods sold current.
Can I change the costing method later?
Yes, but it revalues existing stock and should be done at a period end with your accountant.
Why does my stock report differ from the balance sheet?
Usually manual journal entries to stock accounts, category changes or old valuation layers. Reconcile monthly to catch them early.
Talk to us about how Odoo fits your business. Book a free call
Run invoicing, stock and accounts from one system.
FlexCode Middle East implements Odoo in Arabic and English for companies in Egypt, Saudi Arabia and the UAE.