FIFO Calculator for Inventory

Calculate the cost of goods sold (COGS) and ending inventory value using the First-In, First-Out (FIFO) inventory method. Track multiple purchase batches and see detailed cost flow analysis.

Inventory Purchases

Enter your inventory purchases in chronological order. The oldest purchases will be sold first under FIFO.

Batch Date (Optional) Units Purchased Cost Per Unit ($) Total Cost ($) Action
1 $1,000.00
2 $1,800.00
3 $2,200.00

Sales Information

Number of units sold using FIFO method
For gross profit calculation

Cost of Goods Sold (COGS)

$1,960.00

Ending Inventory Value

$3,040.00

Remaining Units

270

Gross Profit

$1,640.00

FIFO Cost Flow Analysis

Batch Original Units Cost Per Unit Units Sold COGS from Batch Units Remaining Remaining Value

Inventory Distribution

Cost Breakdown

FIFO vs LIFO Comparison

Metric FIFO (First-In, First-Out) LIFO (Last-In, First-Out) Difference
Cost of Goods Sold $1,960.00 $2,060.00 $100.00
Ending Inventory $3,040.00 $2,940.00 $100.00
Gross Profit $1,640.00 $1,540.00 $100.00

What is FIFO Inventory Method?

FIFO stands for "First-In, First-Out" and is one of the most common inventory valuation methods used in accounting. Under FIFO, the oldest inventory items (first in) are recorded as sold first (first out), regardless of the actual physical flow of goods.

This method is based on the assumption that the first goods purchased or produced are the first ones to be sold. While this may not always reflect the actual physical movement of inventory, it often matches the natural flow for many businesses, especially those dealing with perishable goods.

Key Concept

Under FIFO, your Cost of Goods Sold (COGS) reflects the cost of your oldest inventory, while your ending inventory reflects the cost of your most recent purchases.

How FIFO Works

When you sell items using FIFO:

  1. Start with your oldest inventory batch
  2. Deduct sold units from that batch at its purchase cost
  3. Once that batch is exhausted, move to the next oldest batch
  4. Continue until all sold units are accounted for
  5. Remaining inventory consists of your most recent purchases

FIFO Calculation Example

Inventory Purchases: - Batch 1: 100 units @ $10 = $1,000 - Batch 2: 150 units @ $12 = $1,800 - Batch 3: 200 units @ $11 = $2,200 Total Inventory: 450 units, $5,000 value Units Sold: 180 units FIFO Cost Flow: - From Batch 1: 100 units × $10 = $1,000 - From Batch 2: 80 units × $12 = $960 - Total COGS: 180 units = $1,960 Ending Inventory: - Remaining Batch 2: 70 units × $12 = $840 - All of Batch 3: 200 units × $11 = $2,200 - Total Ending Inventory: 270 units = $3,040

FIFO Formulas

Cost of Goods Sold (COGS)

COGS = Sum of (Units Sold from Each Batch × Cost Per Unit of That Batch) Starting from oldest batches first, until all sold units are accounted for.

Ending Inventory Value

Ending Inventory = Total Purchases - COGS Or calculated as: Ending Inventory = Sum of (Remaining Units in Each Batch × Cost Per Unit)

Gross Profit

Gross Profit = Revenue - COGS Revenue = Units Sold × Selling Price Per Unit

When to Use FIFO

FIFO is particularly suitable for:

FIFO vs LIFO Comparison

LIFO (Last-In, First-Out) is the opposite of FIFO, where the most recent inventory is sold first.

Aspect FIFO LIFO
Cost Flow Oldest costs to COGS first Newest costs to COGS first
During Inflation Lower COGS, Higher Profit Higher COGS, Lower Profit
Ending Inventory Reflects recent prices (higher) Reflects older prices (lower)
Tax Impact Higher taxable income Lower taxable income
Balance Sheet More accurate current values May understate inventory value
IFRS Compliance Allowed Not allowed

Advantages of FIFO

Disadvantages of FIFO

FIFO Impact on Financial Ratios

The inventory valuation method affects several important financial ratios:

Inventory Turnover Ratio

Inventory Turnover = COGS / Average Inventory Under FIFO with rising prices: - Lower COGS → Lower turnover ratio - Higher ending inventory → Lower turnover ratio

Current Ratio

Current Ratio = Current Assets / Current Liabilities Under FIFO with rising prices: - Higher inventory value → Higher current assets - Results in higher current ratio (better liquidity appearance)

Gross Profit Margin

Gross Profit Margin = (Revenue - COGS) / Revenue × 100% Under FIFO with rising prices: - Lower COGS → Higher gross profit - Results in higher gross profit margin

FIFO in Perpetual vs Periodic Systems

Perpetual Inventory System

In a perpetual system, inventory records are updated continuously after each transaction. FIFO is applied at each sale:

Periodic Inventory System

In a periodic system, inventory and COGS are calculated at the end of the period:

Important Note

For FIFO, both perpetual and periodic systems yield the same results for COGS and ending inventory. This is not true for LIFO, where the two systems can produce different results.

Frequently Asked Questions

Can I switch from FIFO to another method?

Yes, but accounting standards require consistency in inventory methods. Changes must be justified, disclosed in financial statements, and may require restating prior periods. Consult with an accountant before making changes.

Is FIFO or LIFO better for taxes?

During periods of rising prices, LIFO typically results in lower taxable income (and thus lower taxes) because it assigns higher recent costs to COGS. However, LIFO is not permitted under IFRS and may not reflect economic reality.

Does FIFO require physical tracking?

No, FIFO is an accounting cost flow assumption, not a requirement for physical inventory movement. You can use FIFO accounting even if your actual inventory isn't physically moved in that order.

How does FIFO affect cash flow?

FIFO itself doesn't affect actual cash flow. However, during inflation, FIFO reports higher profits which can lead to higher tax payments, thus reducing cash flow compared to LIFO.

Is FIFO required for any industries?

While not legally required in most cases, FIFO is strongly recommended or effectively required for perishable goods industries to prevent spoilage and ensure food safety compliance.