Understanding the First In First Out Method
Imagine you run a small business selling artisanal coffee beans. You receive a shipment of 100 bags in January at $10 each. In March, you get another 100 bags, but the price has risen to $12 each. Now, a customer buys 120 bags. Which cost do you assign to the bags you sold? The answer shapes your profit, your taxes, and your understanding of business health. This is the core dilemma that the First In First Out, or FIFO, method solves.
FIFO is an inventory costing assumption. It presumes that the oldest items in your inventory are the first ones to be sold or used. In our coffee example, under FIFO, you would assume the 120 bags sold came from the oldest stock: first the 100 January bags at $10, then 20 of the March bags at $12. This method mirrors the physical flow of perishable goods—you sell the old stock first to prevent spoilage—but it’s also a critical accounting principle applied to non-perishables.
Businesses and investors rely on accurate inventory valuation. Using FIFO during periods of inflation, like we often see, means your Cost of Goods Sold (COGS) reflects older, lower costs. This results in a higher reported gross profit and a higher ending inventory value on the balance sheet compared to other methods like LIFO (Last In First Out). Understanding how to calculate it is not just academic; it’s a practical skill for managing costs, pricing products, and filing accurate tax returns.
The Core Principle and Formula of FIFO
Before diving into calculations, you must grasp the unwavering rule of FIFO: the first costs that enter your inventory are the first costs to leave when an item is sold. Your inventory list is treated like a queue. New purchases go to the back of the line. Sales are fulfilled from the front of the line.
There is no single, complex “FIFO formula.” Instead, the calculation is a logical process applied to your inventory layers. You will need two key pieces of information for any given period:
– The quantity and unit cost of each purchase (inventory addition).
– The quantity of items sold.
The process always follows these steps:
1. List all inventory purchases in chronological order, from oldest to newest. This forms your cost layers.
2. When a sale occurs, allocate the sold units to the oldest cost layer first.
3. Once that oldest layer is exhausted, move to the next oldest layer, and so on.
4. The total cost of the units allocated from these layers becomes your Cost of Goods Sold (COGS).
5. The remaining units in your most recent, unexhausted layers constitute your ending inventory value.
Setting Up Your Inventory Ledger
The most practical way to perform and track FIFO calculations is with an inventory ledger. This can be a simple spreadsheet or a section in your accounting software. For each transaction, you’ll track four key columns: Date, Purchase Quantity/Cost, Sold Quantity, and Running Inventory Balance.
Your running balance should be detailed by layer. For instance, instead of just “50 units,” your balance should note “30 units @ $10, 20 units @ $12.” This layer-by-layer tracking is the heart of the FIFO method. It makes the calculation for the next sale clear and auditable.
Let’s build on our coffee bean example with a specific timeline to see this ledger in action, which will lead us directly into the step-by-step calculation.
Step-by-Step Calculation: A Detailed Example
Let’s follow a full month for “BrewMaster Beans.” We’ll calculate COGS and ending inventory using FIFO.
Beginning Inventory (Jan 1): 0 bags.
Purchases:
– Jan 10: Purchased 80 bags at $10 per bag.
– Jan 18: Purchased 120 bags at $11 per bag.
– Jan 25: Purchased 50 bags at $13 per bag.
Sales:
– Jan 15: Sold 60 bags.
– Jan 22: Sold 110 bags.
– Jan 30: Sold 70 bags.
We calculate after each sale to maintain accurate layers.
After the Jan 15 Sale (60 bags sold)
We only have one inventory layer: the Jan 10 purchase of 80 bags @ $10.
– COGS for this sale: 60 bags * $10 = $600.
– Remaining inventory: 20 bags from the Jan 10 layer @ $10. (80 – 60 = 20).
After the Jan 18 Purchase (120 bags @ $11)
Our inventory layers are now:
1. 20 bags @ $10 (oldest)
2. 120 bags @ $11 (new)
After the Jan 22 Sale (110 bags sold)
We fulfill this sale from the oldest layers first.
– First, take all 20 remaining bags from the $10 layer. Cost: 20 * $10 = $200.
– We need 90 more bags (110 total – 20 taken). We take these from the next oldest layer: the Jan 18 purchase @ $11.
– Cost: 90 bags * $11 = $990.
– Total COGS for this sale: $200 + $990 = $1,190.
– Remaining inventory: We have 30 bags left from the $11 layer (120 – 90 = 30). So, one layer: 30 bags @ $11.
After the Jan 25 Purchase (50 bags @ $13)
Inventory layers are now:
1. 30 bags @ $11 (oldest)
2. 50 bags @ $13 (newest)
After the Jan 30 Sale (70 bags sold)
Fulfill from the oldest layer first.
– Take all 30 bags from the $11 layer. Cost: 30 * $11 = $330.
– We need 40 more bags (70 – 30). Take these from the next layer: the $13 layer.
– Cost: 40 bags * $13 = $520.
– Total COGS for this sale: $330 + $520 = $850.
– Remaining inventory (Ending Inventory for January): We have 10 bags left from the $13 layer (50 – 40 = 10). Value: 10 bags * $13 = $130.
Summary for the Month
– Total Bags Sold: 60 + 110 + 70 = 240 bags.
– Total COGS: $600 + $1,190 + $850 = $2,640.
– Ending Inventory Value: $130 (10 bags @ $13).
You can verify the math: Total cost of goods available for sale was (80*$10 + 120*$11 + 50*$13) = $800 + $1,320 + $650 = $2,770. COGS ($2,640) + Ending Inventory ($130) = $2,770. It balances.
FIFO in Perpetual vs. Periodic Inventory Systems
The example above demonstrates a perpetual inventory system. COGS and inventory are updated continuously, after each sale. This is common with modern point-of-sale and inventory software. The layer tracking happens in real-time.
In a periodic inventory system, common for smaller businesses doing manual counts, you calculate COGS only at the end of an accounting period (like a month or a year). The formula is different:
COGS = Beginning Inventory + Purchases During Period – Ending Inventory.
To find the Ending Inventory value under FIFO in a periodic system, you physically count your ending inventory and then assign costs to those units by working backward from the most recent purchases. You assume the items left in stock are the ones bought last.
Using our same data for January in a periodic system:
– Beginning Inventory: $0
– Purchases: $2,770
– Ending Inventory (from our earlier layer logic, the newest items): 10 bags from the last purchase at $13 = $130.
– COGS = $0 + $2,770 – $130 = $2,640.
Notice the COGS and ending inventory values are identical to the perpetual method. This will always be true for FIFO. The only difference is the timing of the calculation.
Comparing FIFO to LIFO and Weighted Average Cost
FIFO doesn’t exist in a vacuum. The choice of inventory method has real financial consequences.
FIFO vs. LIFO (Last In First Out): LIFO assumes the newest items are sold first. In an inflationary period, LIFO would assign the higher, recent costs to COGS. This leads to lower reported profit and lower taxes in the current year, but also a lower-valued (older cost) inventory on the balance sheet. While LIFO is permitted under US GAAP for tax purposes, it is prohibited under International Financial Reporting Standards (IFRS).
FIFO vs. Weighted Average Cost (WAC): WAC smooths out price fluctuations. It calculates an average cost per unit for the entire period (Total Cost of Goods Available / Total Units Available). This average cost is then applied to both COGS and ending inventory. It’s simpler to calculate but doesn’t reflect the specific flow of costs like FIFO or LIFO.
In times of rising prices, here is the typical outcome:
– Highest Net Income: FIFO (due to lower COGS from older, cheaper inventory).
– Highest Ending Inventory Value: FIFO (inventory is valued at newer, higher costs).
– Lowest Net Income / Tax Burden: LIFO.
– Middle Ground: Weighted Average Cost.
Common Mistakes and Troubleshooting Your FIFO Calculation
Even with a clear process, errors can creep in. Here are the most common pitfalls and how to avoid them.
Mistake 1: Ignoring Chronological Order
The most fundamental error is not listing purchases in the exact order they were received. Double-check purchase dates and invoice numbers before building your cost layers. An out-of-order purchase will completely distort your COGS and inventory value.
Mistake 2: Incorrectly Allocating Partial Layers
When a sale partially depletes a layer, it’s crucial to remember that the remaining units in that layer stay at their original cost. You don’t re-average them. In our example, after the Jan 22 sale, we had 30 bags left at $11. They remain valued at $11 each until they are sold.
Mistake 3: Confusing Units and Dollars
Always perform the allocation step in units first. Determine how many units come from each layer. Only then multiply by the cost per unit to get the dollar value for COGS. Mixing these steps leads to calculation errors.
Mistake 4: Forgetting to Reconcile
Always use the check figure: Cost of Goods Available for Sale must equal COGS plus Ending Inventory. If your numbers don’t balance, you have an error in one of your layer allocations. This reconciliation is your best friend for catching mistakes.
Strategic Implications and When to Use FIFO
Choosing FIFO is not just a mathematical decision; it’s a strategic one.
Use FIFO if:
– Your inventory is physically perishable (food, cosmetics, pharmaceuticals). FIFO reflects the actual flow of goods.
– You operate in an industry where inventory costs are steadily rising, and you want to show stronger profitability to investors or lenders.
– You need your balance sheet to reflect a more current, higher value of your remaining inventory.
– You are reporting under IFRS, where LIFO is not an option.
Consider other methods if:
– Your primary goal is to minimize current-year tax liability in a rising-cost environment (LIFO may be better, but consult a tax advisor).
– Your inventory is homogeneous and price volatility is high, making the simplicity of Weighted Average Cost appealing.
Once you choose an inventory accounting method for tax purposes, you generally must stick with it and get IRS approval to change. This makes the initial choice significant.
Implementing FIFO in Your Business Operations
For the calculation to be accurate, your physical operations must support it. This is known as the “lower of cost or market” rule’s companion: your bookkeeping should reasonably reflect reality.
– Warehouse Management: Organize your storage so older stock is physically in front of newer stock. Use clear labeling with received dates.
– Point-of-Sale (POS) Integration: Most modern POS and inventory management software (like QuickBooks Commerce, TradeGecko, or Zoho Inventory) have built-in FIFO costing. Ensure it’s enabled and that your purchase entries include accurate dates and costs.
– Regular Audits: Conduct periodic physical inventory counts to verify that your perpetual system’s records match what’s actually on the shelf. Discrepancies can indicate theft, spoilage, or data entry errors that will throw off your FIFO calculations.
Mastering the FIFO calculation gives you clarity. You’ll know your true cost of doing business, can price your products for sustainable profit, and will present accurate financial statements. Start by applying the step-by-step process to a single product line this month. The logic, once practiced, becomes an indispensable part of your financial toolkit.
