How to Apply Inventory Valuation Methods: Weighted Average, FIFO, Additional Costs, and the Effect on Profit Training
How do you apply inventory valuation methods? Cost of goods sold, inventory value, additional costs, and the effect on profit with weighted average and FIFO: an 8-lesson guide.
Contents 15 sections
- What will you be able to do by the end of this training?
- Lesson 1: Why is inventory valuation necessary?
- Lesson 2: What are the example purchases?
- Lesson 3: How does the weighted average method work?
- Lesson 4: How does first in, first out (FIFO) work?
- Lesson 5: How does the method affect profit and inventory value?
- Lesson 6: How are additional costs included in inventory value?
- Lesson 7: What happens if inventory value falls below cost?
- Lesson 8: How do you monitor valuation regularly?
- Which method suits which business?
- What are the most common mistakes in inventory valuation?
- How does NetKasam make inventory tracking easier?
- Mini quiz: Test what you have learned
- Conclusion: Choose the method deliberately, apply it consistently
- Frequently Asked Questions About Inventory Valuation
You bought the same product at three different prices. What is the inventory value of the 150 units on the shelf? The answer depends on which valuation method you use, and as the method changes, both the inventory amount on the balance sheet and the cost of goods sold, and therefore profit, change. Many businesses do not make this choice deliberately; they continue with whichever method the system works with and wonder at month-end why profit differs from what they expected.
This article is not a lecture; it is an 8-lesson hands-on training. We will answer the question how to apply inventory valuation methods using an example product whose price rises from purchase to purchase: why inventory valuation is necessary, the weighted average method, first in, first out (FIFO), the effect of the two on profit, including additional costs, impairment, and method selection. At the end there is a mini quiz with an answer key. All figures are example values chosen to demonstrate the method. Which method may be used and how it is applied depend on regulation and your business's situation; settle the choice with your certified public accountant (mali müşavir).
What will you be able to do by the end of this training?
In short: You will be able to calculate the cost of goods sold and inventory value with two methods, understand the reason for the difference, include additional costs correctly, and discuss the method choice with your certified public accountant (mali müşavir).
- 01Gather the purchasesWrite down the date, quantity, and unit price of each purchase.
- 02Add the extra costInclude costs tied to the purchase, such as freight.
- 03Choose the methodWeighted average or FIFO.
- 04CalculateFind the cost of goods sold and the remaining inventory value.
- 05CompareSee the profit difference by method.
- 06CheckReview impairment and consistency.
The 8 lessons of the training: (1) what inventory valuation is, (2) example purchases, (3) weighted average, (4) FIFO, (5) effect on profit, (6) additional costs, (7) impairment, (8) routine and monitoring.
Recommended ReadingHow to Plan a Product Price Increase: Cost Increase, Acceptable Sales Loss, Increase Scenarios, Gradual Rollout, and Post-Increase Tracking TrainingLesson 1: Why is inventory valuation necessary?
In short: The cost of the product sold and the value of the remaining inventory directly affect profit and the balance sheet; the two must be consistent with each other.
When you sell a product, the revenue is the selling price; the cost is determined by which purchase you assume it came from. If purchase prices are constant there is no problem; as prices change, two units on the same shelf have different costs, and with each sale you have to choose which one was sold. Inventory valuation is the rule for this choice. The rule produces both the cost of goods sold and the value of the remaining inventory, and the sum of the two must equal the total purchase cost.
Correct valuation also affects per-product profit margin; for margin calculation, see how to calculate profit margin, and for profitability by product, see how to analyze profitability by product. To see the total cost of inventory and the carrying cost, the article how to calculate inventory cost is helpful.
Lesson 2: What are the example purchases?
In short: We will compare the two methods using a single product, three purchases, rising prices, and a sale of 150 units.
| Date | Purchase quantity | Unit price | Purchase amount |
|---|---|---|---|
| November 1 | 100 units | 50 ₺ | 5.000 ₺ |
| November 10 | 100 units | 60 ₺ | 6.000 ₺ |
| November 20 | 100 units | 70 ₺ | 7.000 ₺ |
| Total | 300 units | 18.000 ₺ |
During the month 150 units were sold at a selling price of ₺100; sales revenue is 150 × 100 = ₺15,000. At month-end, 150 units remain in stock. How the cost is split between the sale and the remaining inventory depends on the chosen method. The rising prices were chosen deliberately in the example: in an environment of price increases or inflation, the gap between the two methods widens.
Lesson 3: How does the weighted average method work?
In short: The total purchase amount is divided by the total quantity; the resulting average unit cost is applied to both sold and remaining products.
- Weighted average unit cost = Total purchase amount ÷ Total purchase quantity
- Cost of goods sold (average) = Quantity sold × Average unit cost
- Remaining inventory (average) = Remaining quantity × Average unit cost
- Cost of goods sold (FIFO) = The amount of the units sold, starting from the oldest purchases
In the example the average unit cost is 18,000 ÷ 300 = ₺60. The cost of goods sold is 150 × 60 = ₺9,000, the remaining inventory is 150 × 60 = ₺9,000, total ₺18,000. Gross profit is 15,000 − 9,000 = ₺6,000 and the margin is 6,000 ÷ 15,000 = 40%. The method's popularity comes from the simplicity of the calculation: there is a single unit cost and purchase order does not matter. In a moving average implementation, this average is updated with every new purchase.
Lesson 4: How does first in, first out (FIFO) work?
In short: The first products purchased are assumed to be sold first; the cost of goods sold consists of the oldest purchases, and the remaining inventory consists of the newest purchases.
| Item | Account | Amount |
|---|---|---|
| Sale: 100 units from purchase 1 | 100 × 50 ₺ | 5.000 ₺ |
| Sale: 50 units from purchase 2 | 50 × 60 ₺ | 3.000 ₺ |
| Cost of goods sold | 5.000 + 3.000 | 8.000 ₺ |
| Remaining: 50 units from purchase 2 | 50 × 60 ₺ | 3.000 ₺ |
| Remaining: 100 units from purchase 3 | 100 × 70 ₺ | 7.000 ₺ |
| Remaining inventory value | 3.000 + 7.000 | 10.000 ₺ |
The cost of goods sold is ₺8,000, the remaining inventory is ₺10,000, and the total is again ₺18,000. Gross profit is 15,000 − 8,000 = ₺7,000 and the margin is 7,000 ÷ 15,000 ≈ 46.7%. FIFO's logic is close to the physical flow of the product (the older product leaves first), and it leaves the cost of the latest purchases in inventory, so the value of the remaining inventory is closer to current prices. For physical inventory management, you can look at how to do an inventory aging analysis.
Lesson 5: How does the method affect profit and inventory value?
In short: When prices rise, FIFO gives a lower cost of goods sold, higher profit, and higher inventory value; the total cost stays the same, only the distribution changes.
| Criterion | Weighted average | FIFO | Difference |
|---|---|---|---|
| Sales revenue | 15.000 ₺ | 15.000 ₺ | 0 |
| Cost of goods sold | 9.000 ₺ | 8.000 ₺ | 1.000 ₺ |
| Gross profit | 6.000 ₺ | 7.000 ₺ | 1.000 ₺ |
| Remaining inventory value | 9.000 ₺ | 10.000 ₺ | 1.000 ₺ |
- Weighted average₺6,000
- FIFO₺7,000
- Total purchase cost₺18,000
- Cost of goods sold (150 units)−₺8,000
- Remaining inventory value (150 units)₺10,000
Prepared with example values. Calculation: 18,000 − 8,000 = ₺10,000. Under weighted average, the same total is split as 9,000 + 9,000.
The ₺1,000 between the two methods is not a real profit difference; it is a timing difference: under FIFO this amount sits in inventory (at a higher cost) and shows up as profit when the inventory is sold. When prices fall, the opposite happens. For this reason, choose the method not to steer profit but according to regulation and the business's needs, and apply it consistently. Evaluate the consequences of a method change in financial closing periods with your certified public accountant (mali müşavir); for the month-end routine, see how to do the month-end close.
Lesson 6: How are additional costs included in inventory value?
In short: Costs tied to the purchase to bring the product into the warehouse (such as freight) are added to the purchase cost; if they are not, inventory value looks low and profit looks high.
Suppose the 20 November purchase has a related ₺900 freight invoice. Total purchase cost becomes 18,000 + 900 = ₺18,900 and the weighted average unit cost rises to 18,900 ÷ 300 = ₺63. The cost of goods sold is 150 × 63 = ₺9,450, the remaining inventory is ₺9,450, and gross profit is 15,000 − 9,450 = ₺5,550 (37%).
| Situation | Unit cost | Cost of goods sold | Gross profit |
|---|---|---|---|
| Freight not included | 60 ₺ | 9.000 ₺ | 6.000 ₺ |
| Freight included | 63 ₺ | 9.450 ₺ | 5.550 ₺ |
| Difference | 3 ₺ | 450 ₺ | −450 ₺ |
Not including freight makes profit look ₺450 higher than it is; the error grows as purchase volume grows. Which expenses can be added to purchase cost depends on regulation and accounting practice; consult your certified public accountant (mali müşavir). For recording and checking purchase invoices, see how to record and check an incoming invoice.
Lesson 7: What happens if inventory value falls below cost?
In short: When a product's realizable selling value falls below its cost (for example through obsolescence, damage, or a price drop), inventory value must be shown lower; dead stock is a typical example.
Suppose the average unit cost of the 150 remaining units is ₺60. If the market selling price falls to ₺55 and there is no additional selling cost, each unit means a loss of ₺5: 150 × 5 = ₺750. In accounting practice, an inventory impairment comes into play in this case; how and when it is recorded depends on regulation, so settle it with your certified public accountant (mali müşavir).
- Dead and slow-moving stock. Unsold product can eventually be sold below its cost; for early detection, see how to sell off dead stock.
- Count difference. A product found missing in the physical count lowers inventory value; for details, see how to find and close an inventory discrepancy and how to do an inventory count.
- Turnover rate. This risk grows in slow-turning inventory; to measure it, the article how to calculate inventory turnover is helpful.
Lesson 8: How do you monitor valuation regularly?
In short: Keep the method fixed, record every purchase with its additional costs, and reconcile inventory value with the physical count at month-end.
| Frequency | What happens |
|---|---|
| Every purchase | Enter the invoice amount and related additional costs in the purchase record |
| Every month | Check inventory value against the quantity and unit cost in the system; examine the count difference |
| At every period end | Identify products that require an impairment and evaluate them with your certified public accountant (mali müşavir) |
| When changing the method | Calculate the effect in advance and settle it with your certified public accountant (mali müşavir) |
| Indicator | How it is calculated | Sample value |
|---|---|---|
| Weighted average cost | Total purchases ÷ Total quantity | ₺60 (₺63 with additional cost) |
| Method profit difference | FIFO profit − Average profit | 1.000 ₺ |
| Additional cost effect | Profit with − without inclusion | −450 ₺ |
| Impairment candidate | (Cost − Selling value) × Quantity | 750 ₺ |
- ₺60weighted average unit cost
- ₺1,000difference in cost of goods sold between the two methods
- ₺10,000remaining inventory value under FIFO
- ₺450profit difference when freight is not included
To add the result to a management report, you can use the layout in how to prepare a weekly management report. For sharing documents with your accountant, see how to deliver monthly documents to your accountant.
Which method suits which business?
In short: The choice depends on regulation, product characteristics, and management needs; weighted average is considered for a simple calculation, and FIFO for products that follow a physical flow.
- Many fast-moving products. Tracking which purchase left with each sale is hard; a single average cost is practical.
- Products with an expiry date or that go out of fashion. The older product is sold first; FIFO reflects the physical flow.
- Products whose price changes often. The choice of method affects profit fluctuation; use a single method for consistency.
- Accounting system. Choose the method that the software you use supports and your certified public accountant (mali müşavir) approves.
Before choosing a method, do the two calculations side by side with a small example product; a table like the one in this article clearly shows how each method carries profit and inventory value. Then tie your chosen method to a written note and apply it the same way every period; changing the method breaks comparability.
Recommended ReadingHow to Set Up Branches and Warehouses for a New Store Opening: Opening Inventory, Transfers, User Permissions, and Branch Comparison TrainingWhat are the most common mistakes in inventory valuation?
- Not knowing the method. Work continues with the system default and the profit difference is not understood.
- Not including additional costs. Unit cost looks low and profit looks high.
- Changing the method between periods. Comparability breaks.
- Not doing a count. The inventory value in the system does not match physical inventory.
- Not processing returns and cancellations. Inventory quantity and value stay wrong.
- Skipping impairment. Old inventory is valued higher than it should be.
- Mistaking the difference for profit. The method difference is a timing difference, not a real gain.
How does NetKasam make inventory tracking easier?
- Inventory management. Inventory is tracked by product, variant, and warehouse (inventory management).
- Expense management. You record purchase-related freight and similar expenses (expense management).
- Invoice tracking. You follow purchase and sales invoices in a single list (invoice tracking).
- Branch and warehouse management. You track inventory in multiple warehouses separately (branch and warehouse management).
- Saved reports. You save inventory and sales reports with their criteria and export them to Excel; you can prepare your valuation table from this data (reports).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If 300 units were bought for a total of ₺18,000, what is the weighted average unit cost?
- If 150 units are sold, what is the cost of goods sold under weighted average?
- Under FIFO, if the first 150 units go out as 100 × ₺50 and 50 × ₺60, what is the cost of goods sold?
- Under FIFO, if the remaining inventory is 50 × ₺60 and 100 × ₺70, what is the inventory value?
- What is the average unit cost when ₺900 of freight is added?
Answer key:
- 18.000 ÷ 300 = 60 ₺.
- 150 × 60 = 9.000 ₺.
- 5.000 + 3.000 = 8.000 ₺.
- 3.000 + 7.000 = 10.000 ₺.
- (18.000 + 900) ÷ 300 = 63 ₺.
Frequently Asked Questions About Inventory Valuation
What is inventory valuation?
It is determining the cost of goods sold and the value of the remaining inventory. For products bought at different prices, the choice of method affects profit.
How does the weighted average method work?
The total purchase amount is divided by the total quantity, and the resulting average unit cost is applied to both the sold and the remaining products.
What is FIFO?
It is the first in, first out method. The first products purchased are assumed to be sold first; the remaining inventory consists of the newest purchases.
Which method shows more profit?
When prices rise, FIFO shows higher profit, and when they fall, the opposite happens. The difference is a timing difference; the total cost is the same.
Is shipping cost added to inventory value?
Adding costs tied to the purchase, such as freight, to the purchase cost is a common practice; the details depend on regulation, so consult your certified public accountant (mali müşavir).
Can I change the method?
Changing the method breaks comparability and is subject to accounting regulations. Talk to your certified public accountant (mali müşavir) before changing.
What happens if inventory value falls below cost?
If the realizable value is lower than cost, an impairment comes into play. Consult your certified public accountant (mali müşavir) on how to record it.
How do you verify inventory value?
By multiplying the quantity in the system by the unit cost and comparing it with the physical count and purchase invoices. If there is a difference, its cause is investigated.
Conclusion: Choose the method deliberately, apply it consistently
The most useful thing you can do today is write one product's last three purchases into a table and calculate the cost of goods sold and remaining inventory with both methods. See the difference, include additional costs, and put in writing which method you use. Confirm your choice with your certified public accountant (mali müşavir) and apply it the same way every period.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.