Choosing the wrong inventory valuation method can inflate your income tax, distort your balance sheet, or leave you out of regulatory compliance — and the DIAN does not forgive it. In Colombia and the Dominican Republic, where IFRS are mandatory, the decision on how to value stock is not a mere accounting technicality: it is a strategic lever that affects the profitability, tax burden, and financial credibility of the company.
This article covers the five recognized methods — FIFO, Weighted Average, Standard Cost, Specific Identification, and LIFO — with numerical examples, quantified tax comparisons, and a guide to choosing the right method for your type of business.
What is inventory valuation?
Inventory valuation is the process by which a monetary value is assigned to the stock available in a company, both at the close of an accounting period and in inflow and outflow movements. This process is used to:
- Calculate the cost of goods sold in the income statement.
- Determine the value of current assets in the balance sheet.
- Estimate gross margins and profitability by product.
- Comply with the International Financial Reporting Standards (IFRS), adopted in both countries.
A poor choice of method can distort accounting reports, affect the calculation of income tax, and generate imbalances in commercial or logistical decision-making. The reference regulatory framework is IAS 2 Inventories from the IASB, which prescribes the accounting treatment of inventories and establishes which inventory valuation methods are permitted at the international level.
Main inventory valuation methods
The methods recognized by IFRS and their practical application in the Latin American environment are as follows. Each one responds to a different logic of cost allocation and has direct implications on the accounting result, the tax burden, and operational decision-making. A thorough understanding of each inventory valuation approach is essential before choosing the one that best suits your business.
Characteristics of the main inventory valuation methods
| Criterion | FIFO | Weighted Average | Standard Cost | Specific Identification | LIFO (not permitted under IFRS) |
|---|---|---|---|---|---|
| Cost allocation basis | First entries | Moving average cost | Predefined fixed cost | Exact cost per unit | Last entries |
| Ending inventory value | Based on most recent costs | Cumulative average | Assigned standard cost | Actual unconsumed costs | Based on oldest costs |
| Cost of sales under inflation | Low (old prices) | Smoothed (average) | Constant (until revision) | Actual per unit sold | High (recent prices) |
| Operational complexity | Low | Low | Medium (requires revision) | High (full traceability) | Medium |
| IFRS compatibility | ✔ | ✔ | ✔ | ✔ | ❌ |
| Typical application | Retail, food, pharmacy | Wholesalers, chemicals, hardware | Manufacturing, free trade zones | Healthcare, luxury, automotive | Not permitted in Colombia/DR |
| Traceability requirement | Optional | Not required | Not required | Mandatory (lot or serial number) | Not required |
| Requires accounting adjustments | Yes, on liquidations | Yes, on adjustments and closings | Yes, on variances and revaluations | No (exact cost) | Yes |
| Variance control | No | No | Yes (cost variance accounts) | No | No |
| Tax relevance in LATAM | High and accepted | High and accepted | Accepted under control | Accepted in regulated sectors | Not permitted by DIAN or DGII |
Quantified tax impact: FIFO vs. Weighted Average in an inflationary scenario
The difference between inventory valuation methods is not only accounting-related: it translates directly into how much income tax your company pays. The following example demonstrates this with concrete figures in an environment of 9% annual inflation, representative of recent episodes in Colombia and the Dominican Republic.
Base scenario: distributor with 1,000 units sold
A distribution company starts the year with 500 units at $10,000 COP each and purchases another 500 at $10,900 COP (9% inflation). Throughout the year it sells 800 units at a selling price of $16,000 COP per unit. The applicable income tax rate is 35% (general rate in Colombia for 2024).
| Concept | FIFO | Weighted Average |
|---|---|---|
| Sales revenue (800 × $16,000) | $12,800,000 | $12,800,000 |
| Cost of goods sold | $8,360,000 * | $8,360,000 ** |
| Gross profit | $4,440,000 | $4,440,000 |
| Valued ending inventory | $2,180,000 (200 × $10,900) | $2,090,000 (200 × $10,450) |
| Estimated taxable base | $4,440,000 | $4,440,000 |
| Income tax (35%) | $1,554,000 | $1,554,000 |
* FIFO: 500 × $10,000 + 300 × $10,900 = $5,000,000 + $3,270,000 = $8,270,000. ** Weighted Average: average unit cost = (500 × $10,000 + 500 × $10,900) / 1,000 = $10,450; cost of goods sold = 800 × $10,450 = $8,360,000.
In this scenario with moderate inflation, the difference in cost of goods sold between FIFO and Weighted Average is $90,000 COP. In Dynamics 365 implementations with clients in the retail sector in Colombia, we have observed that companies with inventories exceeding $5,000 million COP can record taxable base differences of up to $200–400 million COP annually depending on the inventory valuation method chosen.
Decision guide: which inventory valuation method suits you?
This matrix helps identify the most appropriate option based on the type of product and the size or complexity of the company. There is no universally superior method: the right decision depends on the operational and regulatory context of each organization.
Decision matrix: optimal method by company and product type
| Product / company type | Small commercial or service company | Mid-sized company with multiple suppliers | Industrial / manufacturing company | Company with high unit-value products |
|---|---|---|---|---|
| Perishable products or products with expiration dates | FIFO | FIFO | FIFO | Specific Identification |
| Homogeneous products, high turnover | Weighted Average | Weighted Average | Standard Cost | Weighted Average |
| Products differentiated by lot or serial number | Specific Identification | Specific Identification | Specific Identification | Specific Identification |
| Repetitive production with controlled costs | Weighted Average | Standard Cost | Standard Cost | Standard Cost |
| Imports with volatile prices | Weighted Average | Weighted Average | Standard Cost (with frequent revision) | Specific Identification |
FIFO (First In, First Out): first entries, first exits
The FIFO method is widely adopted in Latin America for its simple logic, its consistency with the physical reality of inventory, and its full alignment with IFRS. Under this model, it is assumed that the first items to enter inventory are also the first to leave. The ending inventory is valued at the most recent costs, while the cost of goods sold reflects the oldest prices. Inventory valuation under FIFO is especially suitable when the physical flow of goods follows this same natural order.
Step-by-step numerical example: FIFO calculation
Let us assume a distribution company in Bogotá that buys and sells the same product during the month of March:
| Date | Movement | Units | Unit price | Total cost |
|---|---|---|---|---|
| 03/01 | Purchase (Entry 1) | 200 | $10,000 | $2,000,000 |
| 03/08 | Purchase (Entry 2) | 150 | $11,500 | $1,725,000 |
| 03/15 | Purchase (Entry 3) | 100 | $12,800 | $1,280,000 |
| 03/20 | Sale (Exit 1) | 250 | — | — |
| 03/28 | Sale (Exit 2) | 120 | — | — |
Calculation of cost of goods sold under FIFO:
- Exit 1 (250 units): The 200 units from Entry 1 are consumed first at $10,000 = $2,000,000, then 50 units from Entry 2 at $11,500 = $575,000. Subtotal: $2,575,000.
- Exit 2 (120 units): 100 remaining units from Entry 2 at $11,500 = $1,150,000, and 20 units from Entry 3 at $12,800 = $256,000. Subtotal: $1,406,000.
- Total cost of goods sold: $3,981,000
- Ending inventory: 80 units from Entry 3 × $12,800 = $1,024,000.
Advantages, applications, and operational recommendations for FIFO
- Reflects an inventory closer to replacement value: in economies with structural inflation, FIFO allows the ending inventory to reflect more current prices.
- Improves accounting comparability: by following an internationally accepted logic, financial reports are more easily interpretable.
- Favors management in perishable sectors: agro-industry, pharmaceuticals, and food naturally require a FIFO approach to minimize obsolescence.
- Increase in accounting profit under inflation: FIFO generates higher accounting profits by using older costs, which can increase the tax burden. This is a key factor to consider in the company’s inventory valuation policy.
Typical sectors in Colombia and DR: food and beverage distributors, pharmaceutical and cosmetics industry, mass consumer goods companies, and agro-industrial exporters.
Weighted Average: cost stability in highly volatile environments
The Weighted Average method — also called the moving average cost — is one of the most widely used in LATAM for inventory valuation, especially in companies with homogeneous products and high purchase frequency. Each time a new batch enters inventory, the average unit cost is recalculated by weighting the total value of existing stock plus the new entry, divided by the total units available.
How does the Weighted Average work? Numerical example
Let us take the same scenario of the Bogotá distributor:
| Date | Movement | Units | Unit price | Total stock (units) | Total stock value | Average unit cost |
|---|---|---|---|---|---|---|
| 03/01 | Purchase | 200 | $10,000 | 200 | $2,000,000 | $10,000 |
| 03/08 | Purchase | 150 | $11,500 | 350 | $3,725,000 | $10,643 |
| 03/15 | Purchase | 100 | $12,800 | 450 | $5,005,000 | $11,122 |
| 03/20 | Sale (250 units) | -250 | $11,122 | 200 | $2,222,200 | $11,122 |
| 03/28 | Sale (120 units) | -120 | $11,122 | 80 | $889,760 | $11,122 |
- Total cost of goods sold (Weighted Average): (250 + 120) × $11,122 = $4,115,140
- Ending inventory: 80 × $11,122 = $889,760
Compared to FIFO, the Weighted Average generates a slightly higher cost of goods sold ($4,115,140 vs. $3,981,000) and a lower ending inventory ($889,760 vs. $1,024,000). In tax terms, this means a lower gross profit and therefore a reduced taxable base. This difference in inventory valuation can be decisive when planning the annual tax burden.
Advantages, applications, and recommendations for the Weighted Average
- Stabilizes the cost of goods sold: eliminates cost spikes that generate volatility in margins.
- Operational simplicity: does not require lot-level traceability or tracking of entry order.
- Tax neutrality: offers an intermediate tax burden, fully accepted by the DIAN and the DGII.
- Requires continuous recalculation: demands an ERP with that logic built in to ensure accuracy in inventory valuation.
Typical sectors: wholesalers and distributors of hardware, construction materials, or chemical products; manufacturing companies with multiple suppliers; growing small and medium-sized commercial companies.
Standard Cost: variance control in structured industrial environments
Standard cost assigns a predetermined fixed value to each unit of product. Unlike FIFO or Weighted Average, which are based on the actual acquisition cost, the standard cost is defined in advance based on cost studies, operational projections, or budgets. It is especially useful in industrial environments where production processes are repetitive and controlled, and where a stable inventory valuation facilitates decision-making.
Advantages, applications, and recommendations for standard cost
- Clear visibility of operational performance: makes it easy to detect variances between planned and actual cost.
- Facilitates cost control and planning: stabilizes information for financial and budgetary analysis.
- Ideal for known and repetitive cost structures: inventory valuation is predictable and comparable over time.
- Need for periodic revision: if standards become outdated, inventory valuation may drift away from market reality.
Typical sectors in Colombia and DR: manufacturing industry in free trade zones, processed food and beverage companies, the pharmaceutical sector, and companies with centralized budget control.
Specific Identification: total precision in individual inventory valuation
The specific identification method assigns to each inventory unit its individual actual cost, that is, the exact acquisition or manufacturing value of that specific unit. It is recorded based on serial numbers, lots, or unique references. It is the most precise and transparent method for inventory valuation, especially indicated when each unit has a significant and differentiated value.
Advantages, applications, and recommendations for specific identification
- Complete traceability per unit: inventory valuation is as precise as possible, with robust support for audits and internal control.
- Regulatory compliance in critical sectors: required in sectors such as healthcare, defense, or high-precision equipment.
- Very high operational demand: requires adequate technology (scanning, ERP with serial or lot control) and team training.
Typical sectors in Colombia and DR: vehicle or heavy machinery sales, consumer technology and electronics distribution, medical and pharmaceutical sector companies, works of art, jewelry, and high-end musical instruments.
LIFO (Last In, First Out): a method incompatible with IFRS
The LIFO method is based on the premise that the last products to enter inventory are the first to leave. Despite its historical usefulness in specific contexts, IFRS expressly prohibit its use as an inventory valuation criterion, so it cannot be legally applied in countries such as Colombia and the Dominican Republic.
Prohibition under IFRS and the situation in Colombia and DR
IFRS for SMEs (Section 13) and IAS 2 (Inventories) establish that the use of the LIFO method will not be permitted. This is because LIFO distorts the real value of assets in the balance sheet and does not faithfully reflect the financial situation of the company.
Colombia: under the regulation of the DIAN and the full adoption of IFRS since 2015, the use of LIFO is not permitted either for accounting or tax purposes.
Dominican Republic: since the DGII‘s alignment with IFRS, the tax authority requires the application of methods permitted by IFRS. IFRS for SMEs in the DR require the FIFO or average cost method, aligned with IFRS, and prohibit LIFO.
Change of accounting method: what IAS 8 requires and how to communicate it to the DIAN and DGII
Many companies in Colombia and the Dominican Republic are in the process of migration: they have abandoned LIFO or are transitioning from a periodic to a perpetual system. Changing the inventory valuation method is not a minor formality: it triggers specific obligations under IAS 8 — Accounting Policies, Changes in Accounting Estimates and Errors.
Steps to document and execute the method change
- Technical justification for the change: document why the new inventory valuation method produces more reliable information.
- Retrospective application: IAS 8 requires, as a general rule, adjusting comparative financial statements as if the new method had always been in effect.
- Recording the retrospective adjustment: the difference between the inventory valued under the previous method and the new one is recorded against accumulated results (retained earnings).
- Disclosure in notes to the financial statements: the company must disclose the nature of the change, the reason justifying it, the amount of the adjustment in each period presented, and the effect on the current and prior periods.
- Communication to the DIAN (Colombia): although the DIAN does not require a formal prior notification of the method change, the income tax return must consistently reflect the method applied.
- Communication to the DGII (Dominican Republic): the DGII requires that taxpayers apply inventory valuation methods in accordance with IFRS. A method change must be documented in the audited financial statements.
Periodic vs. perpetual inventory: accounting and operational implications
The choice between a periodic inventory system and a perpetual (or continuous) system directly conditions the way in which inventory valuation methods are applied. This decision impacts both the quality of accounting information and operational efficiency.
Key differences between both systems
| Characteristic | Periodic inventory | Perpetual inventory |
| Data update | Only at the end of the period | In real time, with each movement |
| Compatible methods | Periodic FIFO, Periodic Average | All (FIFO, Moving Average, Standard, etc.) |
| Cost of goods sold | Calculated by difference | Automatically recorded per transaction |
| Technology requirements | Low (can be managed with Excel) | High (requires ERP or accounting software) |
| Accuracy and control | Lower, dependent on physical counts | High precision and continuous traceability |
| Suitable for | Small SMEs, low turnover | Medium and large companies, regulated sectors |
Recommendations for efficient inventory management in LATAM environments
A poorly structured inventory valuation policy can cause financial distortions, logistical inefficiencies, and unnecessary tax exposure. These are the five key levers for managing it correctly.
1. Choose a method suited to the type of product and business dynamics
Each inventory valuation method responds better to a different reality. There is no universal solution. Conduct a joint analysis between finance, logistics, and internal control before selecting or changing the method.
2. Automate inventory accounting with a reliable ERP
The manual application of any inventory valuation method is unsustainable and risky. A modern ERP system allows the valuation logic to be applied automatically, calculates cost variances in real time, and integrates inventory and accounting in a single data flow.
3. Periodically review the validity of the applied method in response to environmental changes
The inventory valuation policy should not be considered static. Changes in inflation, the supply chain, or regulation can render a previously useful method obsolete. An annual review of the adopted inventory valuation criterion is a recommended practice for any growing company.
4. Train the financial and logistics team in IFRS and cost control
Having an ERP is not enough. The correct implementation of inventory valuation requires personnel trained in accounting, logistics, and management who understand the implications of each cost decision.
5. Link the valuation policy to strategic pricing, purchasing, and turnover decisions
The inventory valuation method directly affects pricing policy, purchasing planning, and turnover decisions. Treating valuation as an isolated decision of the accounting department is a strategic mistake.
From theory to practice: implementation in Microsoft Dynamics 365
Understanding the accounting and operational fundamentals of the different inventory valuation methods is the first step. But the key to their correct application lies in how they are technically implemented in business management systems.
For many companies in Colombia and the Dominican Republic, Microsoft Dynamics 365 systems represent a comprehensive solution that allows inventory to be controlled and valued in an automated and IFRS-compliant manner, adapting the inventory valuation model to the operational and tax reality of each country, and integrating accounting, purchasing, sales, production, and warehousing in a single environment.
In the following articles in this series I will cover in detail:
- How inventory valuation is implemented in Dynamics 365 Finance & Operations (Supply Chain Management).
- How inventory valuation is managed in Dynamics 365 Business Central.
Frequently asked questions
What is the difference between PEPS and FIFO?
They are exactly the same method with different names. PEPS is the Spanish acronym for “Primeras Entradas, Primeras Salidas” (First Entries, First Exits), while FIFO comes from the English “First In, First Out”. In Latin American accounting, PEPS is used more frequently in regulatory and academic texts, although in ERPs and international business practice FIFO predominates. Both terms are interchangeable and designate the same inventory valuation criterion.
Why is the LIFO method prohibited in Colombia and the Dominican Republic?
Because IAS 2 from the IASB — the mandatory reference standard in both countries — expressly prohibits the use of the LIFO method for valuing inventories. The main reason is that LIFO distorts the real value of assets in the balance sheet, leaving the ending inventory valued at obsolete prices and making comparability between companies difficult. The DIAN in Colombia and the DGII in the Dominican Republic do not accept this method for either accounting or tax purposes, instead requiring inventory valuation methods that comply with IFRS.
When is it better to use the Weighted Average instead of FIFO?
The Weighted Average is preferable when the company works with homogeneous products, buys from multiple suppliers at different prices, and needs to stabilize the cost of goods sold month by month. FIFO, on the other hand, is more appropriate when products have expiration dates or when the ending inventory is required to reflect the most recent prices. In high-inflation environments, FIFO generates higher accounting profit (and higher taxes), while the Weighted Average offers an intermediate result. The choice between the two is a key decision within the company’s inventory valuation policy.
Can a company apply different methods to different product groups?
Yes. IAS 2 allows different methods to be applied to groups of inventories with different nature or use. For example, a company can use specific identification for high-value equipment and Weighted Average for consumable materials. The essential thing is that the inventory valuation policy is clearly documented, is consistent over time, and is reflected in the notes to the financial statements, as required by the DIAN and the DGII.
What inventory valuation method is best for a small business in Colombia?
It depends on the sector and the operation. For most small commercial companies, the Weighted Average offers the best balance between operational simplicity, acceptance by the DIAN, and stability of the cost of goods sold. If the company works with perishable products or requires reports for international investors, FIFO is the most appropriate option. Standard cost and specific identification are more typical of industrial environments or high unit-value products. In any case, inventory valuation must be documented and applied consistently.