Free Raw Material Inventory Management Spreadsheet

Your complete raw material list — the foundation the rest of the spreadsheet builds on. For each material:

• SKU and name — identify each material clearly (e.g. "Shea Butter — Refined")
• On-hand quantity — current stock, updated as you count
• Stock status — calculated in/out of stock flag
• Unit cost — the fully landed cost per tracking unit
• Tracking unit — grams, ml, metres, units — whatever you manufacture in
• Preferred vendor — where you usually buy it
• Starting quantity and value — feeds your start-of-year valuation

A full record of every material purchase — one row per material bought, so five items from one supplier means five rows:

• Purchase date and vendor — when and where you bought it
• Item cost — what you paid, excluding shipping and tax
• Quantity purchased — in the material's tracking unit
• Proportional shipping and tax — allocated per item across the order
• Landed unit cost — calculated automatically, the true cost per unit including freight

The step most inventory spreadsheets skip entirely: recording what you make and the materials each production run consumes:

• Manufacture date — when the batch was made
• Product made — SKU and name of the finished product
• Materials used — one row per material consumed in the run
• Quantity used — how much of each material to deduct from stock
• Total material usage cost — calculated per row, building your cost per batch

Your finished goods — what's made, priced, and ready to sell:

• SKU, name, and category — identify each sellable product
• Unit price — your retail price per item
• Manufacture cost — the material cost to make one unit, tallied from your Manufactures tab
• On-hand quantity and stock status — what's actually available to sell
• Inventory values — calculated starting and current stock value

Every sale, recorded one product per row so manufacture costs can be tallied against revenue:

• Order date and ID — match rows back to your sales channels
• Product and quantity sold — what went out the door
• Unit manufacture cost — feeds your COGS tally for the year
• Tax and shipping — proportional amounts per line item
• Totals — calculated line totals and grand totals

A log for materials withdrawn from inventory for anything other than production — samples, testing, or personal use. Keeping these out of your production costs means:

• Date removed and material — what left inventory, and when
• Quantity and unit cost — valued at the material's landed cost
• Total cost — calculated, so your COGS only reflects materials genuinely used in products

The tab that makes the rest worth maintaining — your key totals, tallied automatically through the year:

• Revenue totals — orders and tax, tallied from your Orders tab
• Expense totals — purchases and tax from your Purchases tab
• Inventory valuation — start-of-year value, plus purchases, less personal use and cost of product sold
• Year-to-date inventory total — the number your accountant asks for at tax time