How to Find Cost of Goods Sold Using FIFO: A Step‑by‑Step Guide
Cost of goods sold (COGS) is a cornerstone figure in any profit‑and‑loss statement because it directly impacts gross margin and net income. When a company uses the first‑in‑first‑out (FIFO) method to value inventory, the COGS calculation follows a specific pattern: the oldest costs are assigned to the goods sold first, leaving the most recent costs in ending inventory. Understanding how to compute COGS under FIFO is essential for accurate financial reporting, tax planning, and strategic decision‑making.
Introduction
In accounting, inventory valuation methods determine how the cost of items on hand is moved from the balance sheet to the income statement. That's why the FIFO method assumes that the earliest purchased or produced items are the first to be sold. That said, this approach mirrors the physical flow of many businesses, especially those dealing with perishable goods or rapidly changing prices. Day to day, by mastering the steps to calculate cost of goods sold using FIFO, you gain a clearer picture of profitability, better cash‑flow forecasting, and compliance with generally accepted accounting principles (GAAP). This article walks you through the process, explains the underlying logic, and answers common questions to help you apply FIFO confidently in both periodic and perpetual inventory systems.
Step‑by‑Step Calculation of COGS with FIFO
1. Gather the Required Data
- Beginning inventory cost – the total cost of inventory on hand at the start of the period.
- Purchases during the period – each purchase should be recorded with quantity, unit cost, and total cost.
- Units sold – the total number of items sold during the period.
Tip: Keep a detailed purchase log; it will simplify the FIFO calculation and reduce errors The details matter here..
2. Determine the Flow of Costs
Under FIFO, you layer costs chronologically:
| Layer | Units | Unit Cost | Total Cost |
|---|---|---|---|
| Beginning inventory | X | $a | $X·a |
| Purchase #1 | Y | $b | $Y·b |
| Purchase #2 | Z | $c | $Z·c |
| … | … | … | … |
The first layer to be consumed is the beginning inventory, then the earliest purchases, and so on, until you have accounted for the total units sold Most people skip this — try not to. Still holds up..
3. Calculate COGS
- Start with beginning inventory. If the beginning inventory quantity is less than or equal to units sold, add its entire cost to COGS and move to the next layer.
- Continue with the earliest purchases. Subtract the remaining units needed from each subsequent purchase, multiplying by the unit cost of that purchase, and add the result to COGS.
- Stop when the required units are reached. Any leftover units in the last purchase become part of ending inventory.
Example:
- Beginning inventory: 100 units @ $5 = $500
- Purchase 1: 150 units @ $6 = $900
- Purchase 2: 200 units @ $7 = $1,400
Assume 300 units were sold Turns out it matters..
- First, use all 100 units from beginning inventory → $500 COGS.
- Next, need 200 more units; take them from Purchase 1 → 200 × $6 = $1,200 COGS.
- Total COGS = $500 + $1,200 = $1,700.
The remaining inventory consists of 50 units from Purchase 1 ($6 each) and the full 200 units from Purchase 2 ($7 each).
4. Compute Ending Inventory
Ending inventory under FIFO is simply the cost of the units that remain after satisfying the COGS requirement. Use the most recent unit costs for these leftover units. This ensures that the balance sheet reflects current market prices, which can be advantageous for financing and valuation purposes.
5. Verify with the Formula (Periodic System)
For a periodic inventory system, you can also use the classic formula:
COGS (FIFO) = Beginning Inventory + Purchases – Ending Inventory (FIFO)
Calculate ending inventory using the FIFO layering method described above, then plug the numbers into the formula to cross‑check your step‑by‑step result. Consistency between both methods confirms accuracy.
Scientific Explanation of FIFO’s Impact on COGS
How FIFO Aligns with Economic Reality
When prices are rising—a common scenario in inflationary environments—FIFO assigns older, lower costs to COGS, resulting in lower reported expenses and higher gross profit. Conversely, ending inventory is valued at newer, higher costs, which can improve the balance sheet’s current‑asset figure. This dual effect can influence key financial ratios such as inventory turnover, gross margin percentage, and return on assets.
FIFO vs. Other Methods
- LIFO (Last‑In‑First‑Out) does the opposite: recent higher costs hit COGS first, lowering taxable income in periods of inflation.
- Weighted Average Cost smooths out price fluctuations by averaging all purchase costs, producing COGS that sit between FIFO and LIFO values.
Choosing FIFO often reflects a company’s actual physical flow (e.g., perishable goods) and can provide a more accurate matching of revenue with older, lower costs, thereby presenting a more realistic profitability picture The details matter here..
Tax and Reporting Considerations
While FIFO may increase taxable income during inflation, many jurisdictions allow its use for financial reporting. In the United States, IFRS prohibits LIFO, making FIFO the default for many multinational firms. Understanding these regulatory nuances helps you decide whether FIFO aligns with both operational realities and compliance requirements Easy to understand, harder to ignore..
Frequently Asked Questions (FAQ)
Q1: Can FIFO be used in both periodic and perpetual inventory systems?
A: Yes. In a perpetual system, COGS is updated continuously with each sale, using the oldest costs first. In a periodic system, you calculate COGS at period‑end using the same FIFO layering logic Worth knowing..
Q2: What if inventory costs decrease over time?
A: FIFO will then assign higher, older costs to COGS, potentially lowering profit. This scenario is less common but still possible in deflationary markets It's one of those things that adds up..
Q3: How do I handle inventory shortages or write‑downs?
A: Apply FIFO to the available units first. Any shortage beyond recorded inventory should be accounted for as a loss, and you may need to adjust COGS accordingly.
Q4: Do I need special software to implement FIFO?
A: While spreadsheets can work for small operations, many ERP and accounting systems have built‑in FIFO tracking that automates cost layering and COGS calculation Easy to understand, harder to ignore..
Q5: How does FIFO affect cash flow?
A: FIFO does not directly change cash flow, but higher reported profits can lead to higher tax payments, impacting cash outflows for taxes.
Conclusion
Calculating cost of goods sold using FIFO is a systematic process that begins with gathering beginning inventory and purchase data, then applying the chronological cost flow to determine COGS and ending inventory. Remember to verify your calculations with the standard formula, stay mindful of price trends, and consider the broader impact of FIFO on profitability and tax obligations. By mastering these steps, you ensure accurate financial statements, better strategic insights, and compliance with accounting standards. Whether you employ a periodic or perpetual inventory system, the core principle remains the same: the earliest costs are matched against revenue first. With this knowledge, you can confidently apply FIFO in real‑world scenarios and make informed decisions that drive your business forward It's one of those things that adds up..
This is where a lot of people lose the thread.
