Absorption costing sticks every manufacturing cost—materials, labor, and both variable and fixed overhead—right onto inventory. That’s why fixed overhead doesn’t hit the income statement right away; it rides along in inventory until the product sells.
Quick Fix Summary
- Need it now? Grab the template below for 2026 GAAP-compliant statements.
- Starting point: Add beginning inventory to cost of goods manufactured to get goods available for sale, then subtract ending inventory to land on cost of goods sold.
- Show all: Tack on gross margin, then split selling & administrative expenses into variable and fixed piles.
- Reconcile: If you switch methods, adjust for the fixed overhead that got parked in (or freed up from) inventory.
What’s Happening
Absorption costing is the rule under U.S. GAAP and IFRS for external reporting. Every unit produced carries a slice of fixed manufacturing overhead, so unsold units drag that overhead into the next period’s balance sheet. The resulting income statement looks like this:
| Line Item | Where It Comes From | GAAP Ref. |
|---|---|---|
| Sales | Revenue recognized when earned | FASB ASC 606 |
| Cost of Goods Sold | Beginning inventory + COGM – Ending inventory | IRS Pub. 538 |
| Gross Margin | Sales – COGS | — |
| Selling & Admin Expenses | Split variable vs. fixed | AICPA Accounting Trends |
| Net Income | Gross Margin – Total S&A | — |
How do you build one from scratch?
Follow these steps in Excel 365 (Version 2405) or Google Sheets.
- Drop in your raw data:
- Beginning finished-goods inventory (units and cost)
- Units produced
- Units sold
- Direct materials per unit
- Direct labor per unit
- Variable manufacturing overhead per unit
- Total fixed manufacturing overhead for the period
- Variable selling & admin per unit
- Fixed selling & admin total
- Selling price per unit
- Calculate Cost of Goods Manufactured (COGM):
- COGM = (Units produced × (Direct materials + Direct labor + Variable overhead)) + Total fixed overhead
- Compute Goods Available for Sale:
- Goods Available for Sale = Beginning inventory cost + COGM
- Work out Ending Inventory:
- Ending Inventory cost = (Units in ending inventory) × (COGM / Units produced)
- Figure Cost of Goods Sold:
- COGS = Goods Available for Sale – Ending inventory cost
- Assemble the income statement:
- Sales = Units sold × Selling price
- Gross Margin = Sales – COGS
- Total variable S&A = Units sold × Variable S&A per unit
- Net Income = Gross Margin – Total variable S&A – Fixed S&A
Why did my numbers look off?
Try these three quick fixes.
- Check your denominator. If actual production didn’t match the volume you used to allocate fixed overhead, recalculate the per-unit fixed overhead rate using the budgeted production volume for the period.
- Move period costs. If any fixed overhead hit the income statement right away (think idle facility costs), shift it to S&A and call it “Non-manufacturing fixed overhead.”
- Reconcile to variable costing. Add back the fixed overhead parked in ending inventory and subtract the fixed overhead freed from beginning inventory to match variable-costing net income.
How can I keep this from happening again?
- Lock your rates. Freeze the fixed-overhead allocation rate at the start of each fiscal year to dodge “rate drift.”
- Cycle-count inventory. Reconcile physical inventory every month; a 5 % shrinkage swing can swing net income by 3–4 %. IMA Statement on Management Accounting suggests monthly cycle counts for manufacturers with >$10 M in inventory.
- Tag costs early. Slap a cost-center code on every invoice (materials, labor, variable overhead, fixed overhead, S&A) so the roll-forward practically writes itself.
- Automate the roll-forward. Pull data straight from your ERP into a Power BI template that auto-calculates COGM, COGS, and the inventory variance reserve each close cycle.
What’s the difference between absorption and variable costing?
Absorption costing buries fixed manufacturing overhead in inventory, while variable costing expenses it immediately. That’s why net income can swing between the two methods when inventory levels change.
Can I use this for internal reporting?
You can, but most managers prefer variable costing for internal decisions because it shows contribution margin clearly. Absorption costing is mainly for external filings.
What if I have multiple products?
Allocate fixed overhead to each product line using a reasonable base—units produced, direct labor hours, or machine hours. Honestly, this is the best approach when you’re juggling several products.
How do I handle seasonal production swings?
Use a normalized denominator—typically annual budgeted production—to smooth out per-unit fixed overhead rates. That keeps your cost of goods sold from bouncing around with every production spike.
What’s the most common mistake?
Forgetting to adjust for the fixed overhead deferred in (or released from) inventory when switching methods. It’s an easy step to skip, but it throws off your reconciliation fast.
Do I need special software?
Not necessarily. A well-built spreadsheet can handle this, but specialized cost-accounting modules in ERP systems save time and reduce errors.
How often should I update my template?
At least once a year, or whenever your cost structure changes materially. Locking in rates at the start of the fiscal year keeps things consistent.
What’s the impact on cash flow?
Absorption costing can delay cash outflows for fixed overhead until products sell, which can temporarily boost operating cash flow compared to variable costing.
Where can I find a free template?
Check the AICPA’s free resources page—they usually have a basic absorption-costing template you can tweak for your needs.
How do I explain this to my boss?
Start with the bottom line: absorption costing spreads fixed overhead across all units produced, so unsold inventory carries those costs forward. Then walk through how it affects net income when inventory rises or falls.
