How To Calculate Fifo Ending Inventory

How to Calculate FIFO Ending Inventory

Understanding how to determine the value of ending inventory is essential for accurate financial reporting, tax compliance, and informed business decisions. The FIFO (first‑in, first‑out) method assumes that the oldest inventory items are sold first, leaving the most recent purchases in ending inventory. This approach often aligns with the physical flow of goods in many industries and can significantly affect reported profit and inventory balances. Below is a step‑by‑step guide, complete with examples and practical tips, to help you calculate FIFO ending inventory confidently.

Understanding the FIFO Method

FIFO is one of the primary cost flow assumptions used in inventory accounting. Under FIFO:

• Cost of goods sold (COGS) reflects the cost of the earliest purchased or produced items.
• Ending inventory consists of the most recent purchases, valued at their latest costs.

Because prices tend to rise over time in many markets, FIFO usually results in lower COGS and higher ending inventory compared with LIFO (last‑in, first‑out). This can lead to higher reported net income during periods of inflation.

Key points to remember:

• FIFO can be applied under both periodic and perpetual inventory systems. - The calculation differs slightly between the two systems, but the underlying principle—using the oldest costs for COGS and the newest costs for ending inventory—remains the same.
• Accurate records of purchase dates, quantities, and unit costs are critical for a correct FIFO calculation.

Steps to Calculate FIFO Ending Inventory

Whether you are using a periodic or perpetual system, follow these general steps. Adjustments for each system are noted where relevant.

1. Gather Inventory Data

Collect all purchase transactions for the accounting period, including:

• Date of each purchase - Quantity purchased per transaction
• Unit cost (price paid per unit)

Also note the beginning inventory quantity and its unit cost (if any).

2. Determine Total Units Available for Sale

Add beginning inventory to all purchases made during the period:

[ \text{Total Units Available} = \text{Beginning Inventory} + \sum \text{Purchases} ]

3. Identify Units Sold (or Units Remaining)

• Periodic system: You will know the total units sold from sales records or by subtracting ending inventory from total units available.
• Perpetual system: Track each sale as it occurs, reducing inventory layers in real time.

4. Apply FIFO to Cost of Goods Sold

Starting with the oldest inventory layer, allocate units to COGS until you have accounted for all units sold:

1. Take the earliest purchase (or beginning inventory) and use its full quantity, or as much as needed to cover units sold.
2. Move to the next oldest layer and repeat until the total units sold are satisfied.
3. Multiply the quantity taken from each layer by its unit cost, then sum these amounts to get COGS.

5. Calculate Ending Inventory

The remaining units after fulfilling COGS constitute ending inventory. Value them using the costs of the most recent layers:

1. Starting from the most recent purchase (or the top of the inventory stack), assign units to ending inventory until you reach the desired ending quantity. 2. Multiply each layer’s quantity by its unit cost and sum the results.

6. Verify the Calculation

Check that:

[ \text{Beginning Inventory} + \text{Purchases} = \text{COGS} + \text{Ending Inventory} ]

If the equality holds, your FIFO ending inventory is correct.

Example Calculation (Periodic System)

Suppose a company reports the following inventory data for January:

Sales records show that 300 units were sold during January.

Step‑by‑Step FIFO COGS

1. Use beginning inventory: 100 units × $10.00 = $1,000
2. Need 200 more units → take from Purchase #1: 150 units × $11.00 = $1,650
3. Still need 50 units → take from Purchase #2: 50 units × $12.00 = $600

COGS = $1,000 + $1,650 + $600 = $3,250

Step‑by‑Step FIFO Ending Inventory

Remaining units = 550 total – 300 sold = 250 units

• After allocating 50 units from Purchase #2 for COGS, 150 units of Purchase #2 remain.
• All of Purchase #3 (100 units) remains untouched.

Ending inventory valuation:

• Purchase #2 remaining: 150 units × $12.00 = $1,800
• Purchase #3: 100 units × $13.00 = $1,300

Ending Inventory = $1,800 + $1,300 = $3,100

Verification Beginning inventory ($1,000) + Purchases (150×$11 + 200×$12 + 100×$13 = $1,650 + $2,400 + $1,300 = $5,350) = $6,350

COGS ($3,250) + Ending Inventory ($3,100) = $6,350 ✓

The numbers balance, confirming the FIFO ending inventory of $3,100.

Periodic vs. Per

7.Periodic vs. Perpetual Inventory Systems The mechanics illustrated above assume a periodic approach: all purchases are recorded in a single “Inventory” account, and the cost of goods sold is calculated only at period‑end after the physical count of remaining units.

In contrast, a perpetual system updates the inventory ledger continuously. Every receipt and issue triggers an immediate journal entry that adjusts both the inventory balance and the cost of goods sold. The FIFO logic is applied at the moment of each sale, rather than being postponed until the books are closed.

7.1. How the Two Systems Interact with FIFO - Periodic: FIFO is applied to the entire pool of units on hand at period‑end. The calculation shown in Sections 1‑6 is performed only after the physical count, and the resulting COGS figure is posted to the “Cost of Goods Sold” account in a single entry.

• Perpetual: FIFO is embedded in each sale transaction. When a sale of, say, 20 units occurs, the system automatically selects the earliest cost layers (e.g., 10 units from the $10 layer, 10 units from the $11 layer) and posts the corresponding cost to COGS. The inventory balance is reduced layer‑by‑layer in real time.

7.2. Journal‑Entry Illustrations

Periodic – Purchase

Dr. Inventory   xxx
    Cr. Accounts Payable   xxx

Periodic – Sale (recorded at selling price only)

Dr. Accounts Receivable   xxx
    Cr. Sales Revenue        xxx

COGS is posted later, after the periodic FIFO calculation, via a adjusting entry: ``` Dr. Cost of Goods Sold xxx Cr. Inventory xxx

**Perpetual – Purchase** (same as periodic, but inventory is updated immediately)  

Dr. Inventory xxx Cr. Accounts Payable xxx

**Perpetual – Sale (FIFO cost flow)**  
Assume a sale of 25 units drawn from the layers described in the example:  
- 10 units @ $10 = $100  
- 10 units @ $11 = $110  - 5 units @ $12 = $60  

Dr. Accounts Receivable xxx (selling price) Cr. Sales Revenue xxx Dr. Cost of Goods Sold $270 Cr. Inventory $270

The perpetual entry reflects the exact cost layers used, eliminating the need for a separate reconciliation at period‑end.

#### 7.3. When to Choose Which System  

- **Periodic** is suitable for small businesses with low transaction volume, where the additional tracking overhead is not justified.  - **Perpetual** is preferred for larger operations, multi‑location firms, or businesses that require real‑time inventory control, accurate gross‑margin reporting, and automated reorder triggers.

---

## Conclusion  

FIFO provides a clear, logical method for assigning costs to both sold and unsold inventory. Whether a company employs a periodic or perpetual inventory system, the core principle remains the same: the oldest costs are exhausted first, ensuring that the cost of goods sold reflects the earliest purchase prices and that ending inventory is valued at the most recent costs.  

By systematically layering purchases, applying FIFO consistently, and verifying the balance  

\[
\text{Beginning Inventory} + \text{Purchases} = \text{COGS} + \text{Ending Inventory},
\]

the organization can produce reliable financial statements, maintain accurate margin analysis, and support informed purchasing decisions. The choice between periodic and perpetual recording merely influences *when* the FIFO logic is executed, not *how* it is applied. Mastery of both the calculation steps and the underlying system architecture equips managers to keep inventory accounting both precise

and efficient, ultimately contributing to the overall financial health and operational effectiveness of the business.