Free Finished Goods Inventory Excel Template
Track every finished SKU by lot, location, and customer allocation. Spot excess inventory tying up cash and stockout risk before customers find them.
What you get
Working FG tracker with allocation logic (allocated vs available), shelf-life flagging, and reorder-point analysis. Bridges make-to-stock operations to MRP.
Free 30-day trial · No credit card required · Used by manufacturers since 1991
Why manufacturers still use Excel for this
Finished goods inventory is the most expensive inventory in the shop. Raw material can be returned to suppliers; WIP can be finished into different products; finished goods can only sell or be written off. Misjudging FG levels is the largest single source of working capital waste in most make-to-stock operations.
This template tracks FG with the discipline that prevents both excess and stockout. Each SKU has a current on-hand quantity, an allocated quantity (committed to specific customer orders), and an available quantity (on-hand minus allocated). Reorder triggers fire based on available, not on-hand — preventing the common mistake of thinking you have stock when half of it is already sold.
Shelf-life tracking matters for any FG with expiration. The template flags lots aging past 50% / 75% / 90% of shelf life, giving operations time to push the older lots before they expire.
What's inside the template
FG master
SKU, description, customer (if make-to-order), unit of measure, reorder point, reorder quantity, shelf life days.
Lot-level stock
Lot number, SKU, on-hand quantity, location, produced date, expiration date.
Allocated vs available calculation
On-hand minus customer-allocated = available. Reorder logic uses available, not on-hand. This is the bug in most FG tracking.
Reorder flag
Available below reorder point triggers a buy/make signal for planning review.
Shelf-life aging
Lots flagged at 50% / 75% / 90% of shelf life consumed. Older lots get sold first (FIFO discipline).
Customer allocation tab
For make-to-order or contract manufacturing: which SKU quantity is allocated to which customer order.
How to use this template
A practical walkthrough — five steps from blank spreadsheet to a working schedule.
- 1
Distinguish make-to-stock from make-to-order
MTS SKUs need reorder points and trend analysis. MTO SKUs need allocation tracking. Mixing them in one template confuses both.
- 2
Set reorder points based on customer service level
Higher service level = more safety stock = more inventory cost. Common targets: 95% service level for A items, 90% for B, 85% for C. Choose the right tradeoff per SKU.
- 3
Enforce FIFO at picking
The lot-level detail enables FIFO. Without enforcement, operators pick the closest lot. FIFO discipline cuts shelf-life expirations dramatically.
- 4
Review monthly with sales and operations
S&OP discipline starts here. The FG report shows which SKUs are excess (slow movers) and which are at stockout risk (fast movers). The conversation reshapes production priorities.
When you outgrow this template
Excel is the right answer for early-stage scheduling — until it isn't. Here are the warning signs that you need a real production scheduling tool.
If three or more of these apply, you have outgrown Excel scheduling. The good news: you do not have to leave Excel behind. Resource Manager for Excel (RMX) is a real finite-capacity scheduling engine that runs as an Excel add-in — so your team keeps the interface they know while gaining the scheduling power of a dedicated APS tool.
Learn about RMXFrequently asked questions
What is the difference between on-hand and available inventory?+
On-hand = total physical quantity in stock. Available = on-hand minus quantity already allocated to customer orders. Reorder logic must use available, not on-hand — otherwise you think you have stock that is actually already sold. This is the single most common error in spreadsheet FG tracking.
How do I calculate the right safety stock?+
Safety stock = service level Z-score × √(lead time + review period) × demand standard deviation. The math is intimidating; the template provides a simplified version using usage variability over the last 90 days. Get to 80% of optimal with the simple formula; do not chase the last 20% in Excel.
What inventory turnover should I target?+
Industry-specific. Distribution: 12+ turns/year. High-mix manufacturing: 6–10 turns. Long-cycle aerospace: 2–4 turns. Compare to your own trailing year, not to industry benchmarks. Improving turns by 1.5× over 18 months is realistic and impactful.
How do I handle obsolete inventory?+
A separate "obsolete" status flag in the master. Obsolete SKUs do not trigger reorders, do not count toward turn calculations, and need a disposition decision (sell at discount, scrap, return to supplier). The aging report surfaces candidates for obsolete review.
Get the free template — plus the tool that grew up around it
The template is the starting point. Resource Manager for Excel (RMX) is what manufacturers move to when their Excel scheduler starts breaking. 35+ years in production, free 30-day trial.