Free Material Tracking Spreadsheet

A ready-made Excel template for tracking materials through your operation — what you hold, what it landed at, what each production run consumed, and what's left. Seven linked tabs, no formula-building required.

Material register with on-hand quantities and stock status
Landed unit costs — shipping and tax allocated per line
Consumption logged per production run, in any unit of measure
Free to download — Excel, Google Sheets, and Numbers

Free material tracking spreadsheet for Excel and Google Sheets, showing material stock levels and unit costs

Join the Stocksmith mailing list and we'll send you our material tracking spreadsheet template for free! We typically send 2-4 emails a month about small batch production topics which we hope are useful to our readership.

What's included

Materials tracked all the way through, not just counted

A stock count tells you what's on the shelf today. It doesn't tell you what that stock cost, how fast you're consuming it, or what it contributed to the products you sold. This template links all four, so a material register turns into something you can actually plan from.

A single material register

Every material in one place, with SKU, description, preferred vendor, on-hand quantity, and a calculated stock status — so "do we have enough to run this batch" is a glance, not an investigation.

On-hand quantity per material
Calculated in-stock / out-of-stock flag
Preferred vendor recorded for reordering

Any unit of measure

You buy in one unit and consume in another more often than not — a drum, a roll, a sack. Set the tracking unit to whatever you actually issue to production, and the cost maths follows it.

Tracking unit defined per material
Unit costs calculated in that same unit
Works for weights, volumes, lengths, and counts

Consumption you can see

Every production run records the materials it drew down and what they cost. Over a few months that becomes a usage rate — which is the input a reorder point needs and the thing a stock count can never give you.

Quantity consumed logged per run
Total material cost per batch, calculated
Non-production withdrawals logged separately

Template walkthrough

What each tab of the spreadsheet tracks

The workbook is divided into seven linked tabs, each covering one part of your inventory workflow. It's built to run over a single calendar year, so it can calculate your start and end-of-year inventory values. Calculated columns are shaded in the file — enter your data everywhere else and let the formulas do the work.

Material Inventory

A complete list of the materials you hold — the foundation the rest of the workbook builds on. For each one:

SKU and name — identify each material clearly (e.g. "Stainless M4 Bolt — 12mm")
On-hand quantity — current stock, updated as you count
Stock status — a calculated in-stock / out-of-stock flag
Unit cost — the fully landed cost per tracking unit
Tracking unit — grams, millilitres, metres, or units — whatever you actually produce in
Preferred vendor — where you usually buy it
Starting quantity and value — feeds your start-of-year valuation

Personal Use

A log for anything withdrawn from stock that didn't go into a product you sold — samples, testing, or personal use. Keeping it separate means your COGS only reflects what genuinely went into production:

Date removed and material — what left inventory, and when
Quantity and unit cost — valued at the material's landed cost
Total cost — calculated, and deducted from your year-end tallies

Purchases

A full record of every material purchase — one row per item 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

Manufactures

The step most inventory spreadsheets skip entirely: recording what you made, and which materials each production run consumed:

Manufacture date — when the run 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 to deduct from stock
Total usage cost — calculated per row, building your cost per batch

Product Inventory

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

Orders

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

Reports

The tab that makes the rest worth maintaining — your key totals, tallied automatically through the year. Every figure here is calculated:

Revenue totals — orders and tax, 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

Every inventory figure is derived from the unit costs you enter during the year, so the accuracy of your reports depends on the accuracy of those costs.

Start tracking materials properly this week

Download the free spreadsheet and you'll have a working material register, cost history, and consumption log in place today — no software required.

Download the free spreadsheet →

What material tracking actually involves

Material tracking is the practice of recording what raw materials you hold, what they cost, and how much of them each production run consumes. Done properly, it answers three questions a stock count can't: what do I have, what did it really cost me, and how fast am I getting through it.

The cost half is where most registers fall down. The price on the invoice isn't the cost of the material — freight and tax have to be spread across the order before you have a number you can build a batch cost on. A drum that lists at $200 but arrives with $60 of freight against a mixed pallet is a different input to your pricing than the invoice suggests, and the gap widens as freight moves.

The consumption half is what turns a register into a planning tool. Once you know that a run of 200 units draws 4.2kg of a material, you can work out a reorder point from your supplier's lead time instead of reordering when the shelf looks low. That single change is usually what stops a shortage from halting a run.

This template covers both. For the wider picture — valuation methods, reorder formulas, and how material tracking feeds COGS — read our complete guide to raw material inventory management.

Who uses this

Who should use this material tracking spreadsheet?

Anyone who buys materials, converts them into something else, and needs the numbers in between to hold up.

Small-batch manufacturers

Production runs draw on a dozen materials at once. Logging what each run consumed is what keeps stock levels and batch costs connected rather than drifting apart.

Formulated-product businesses

Long ingredient lists with small usage rates per unit. Tracking in the unit you actually weigh out is the difference between an accurate cost per batch and a rounded guess.

Assembly and fabrication shops

Components, fixings, and stock lengths bought in bulk and issued in fractions. A per-material tracking unit keeps the register honest when the purchase unit and the usage unit differ.

Teams introducing stock discipline

A shared workbook with defined columns is a system someone other than the founder can run. It's also the cleanest starting point for a later move into software.

Frequently Asked Questions

What is a material tracking spreadsheet?

A material tracking spreadsheet is a pre-built workbook for recording raw material stock levels, purchase costs, usage per production run, and stock status. A useful one has separate tabs for the material register, purchases, production runs, and a reports summary — so you can see both what you hold right now and what it costs to make each product. The template above has all of those linked together.

How do I track raw materials in Excel?

Start with one row per material and columns for name, SKU, tracking unit, landed unit cost, quantity on hand, and stock status. Log every purchase on a separate tab so you keep a cost history rather than overwriting a single figure, and record material usage each time you complete a production run. A reports tab then tallies opening and closing inventory values. That's the structure of the free template above — enter your own materials and costs and it works immediately.

How do I calculate material cost per product?

List every material a single batch consumes, multiply each quantity used by its landed unit cost (purchase price plus proportional shipping and tax), and sum the results. Divide by the number of units the batch produced to get cost per unit. The manufactures tab does this for you — enter the quantities and it calculates the total. The figure is only as good as your unit costs, which is why logging purchases with freight allocated matters more than it first appears.

Can I use this material tracking sheet in Google Sheets?

Yes. The file is delivered as an Excel (.xlsx) workbook and opens in Google Sheets, Apple Numbers, and any application that reads the Excel format. Upload it to Google Drive and open with Sheets — the formulas and calculated columns carry across intact. Google Sheets also makes it easier for more than one person to keep the register current, which matters once someone other than you is issuing materials.

What's the difference between a material tracking spreadsheet and inventory software?

A spreadsheet needs a manual entry for every purchase, production run, and sale. That's manageable with a small material list and one sales channel. Inventory software deducts materials automatically when you record a manufacture, syncs orders from your sales channels, recalculates landed costs as prices move, and warns you before a material runs short. The usual switching point is when the spreadsheet stops being a record and starts being a chore — typically at multiple channels, or once you're maintaining it more than once a week.

Does the template handle reorder points?

The template gives you a calculated in-stock / out-of-stock flag and the consumption history a reorder point is derived from, but it doesn't compute reorder points or alert you when stock crosses one — that's a limitation of the spreadsheet format, not an oversight. Once you have a few months of usage logged you can work the figure out yourself; our reorder point formula guide walks through it. Automatic low-stock alerts are one of the clearer reasons businesses move off a spreadsheet.

When you outgrow the spreadsheet

Stocksmith tracks materials without the data entry

The spreadsheet works, and for a while it's genuinely enough. But every row is manual: each purchase logged by hand, each production run deducted by hand, each count reconciled by hand. The register is accurate exactly as often as you sit down with it.

Stocksmith runs the same workflow as connected software. Record a production run and materials come out of stock at their real landed cost. Purchases update unit costs automatically. Stock levels stay current, and you get told before a material runs short instead of discovering it mid-batch.

The discipline transfers directly — the same materials, the same units, the same costing logic, minus the typing.

Start my free 14-day trial → See how Stocksmith tracks materials

No credit card required. Takes hours to set up, not weeks.

With the spreadsheet

Deducting materials by hand after every production run
No warning before a material runs short
Unit costs frozen at whatever you last typed in
A formula that stops covering new rows, silently

With Stocksmith

Stock adjusts automatically when you log a manufacture
Reorder alerts before a shortage stops a run
Landed costs recalculated with every purchase
COGS and valuation reports ready at tax time

Related resources

Free Template