Skip to content

Filament Inventory Tracker for a 3D Printing Business

A free filament inventory tracker: grams left by material and color, cost a gram, spool lots, reorder amounts, and how many parts the stock on hand prints.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 19, 2026 · 5 min read

A print shop's raw material is plastic by weight, so a filament inventory tracker counts grams, not spools. Each material and color gets a row with the grams left, a reorder amount, and a cost a gram. Since your slicer tells you the grams in every part, the tracker can answer the question that matters before you accept an order: is there enough terracotta PLA on the shelf for 40 planters? Below is a tracker with a made-up shop's stock in it, and the file.

The short version

  • One row for each material and color, counted in grams.
  • Cost a gram: spool price ÷ 1,000 for a 1 kg spool.
  • Reorder amount: what you print during your supplier's shipping time, and a spool more.
  • Weigh open spools to count: total weight less the empty spool.
  • TaroStack takes the grams off stock for every batch of parts you record. More below.

An example tracker

Snake River Print Lab is a made-up shop in Boise, Idaho, running five printers:

Item Unit On hand Reorder at Cost a kg Value Status
PLA, black, 1.75 mm g 3,400 2,000 $19 $64.60 OK
PLA, white, 1.75 mm g 1,150 2,000 $19 $21.85 REORDER
PLA, terracotta, 1.75 mm g 2,600 1,000 $22 $57.20 OK
PETG, clear, 1.75 mm g 1,900 1,000 $24 $45.60 OK
TPU, black, 1.75 mm g 620 500 $38 $23.56 OK
Nozzles, 0.4 mm brass each 6 4 $2.10 each $12.60 OK

Build plates, shipping boxes and 18 finished planters round it out to $536.03. White PLA is under its reorder amount.

Grams into parts

The shop's 5-inch planter takes 120 g of PLA, supports and purge included.

Terracotta on hand 2,600 g
Planters that prints (2,600 ÷ 120) 21
Order on the table 40
Filament needed 4,800 g
Short by 2,200 g, so three spools

That's the check to run before saying yes. It takes ten seconds with the tracker and saves the mid-run color mismatch that comes from finishing an order on a different spool lot.

Allow for failures. If one print in twelve fails, plan on 130 g a good planter, not 120. Your own failure rate is in your print log if you keep one. Terracotta at 2.2 cents a gram makes the 120 g planter $2.64 in plastic; the rest of its cost is machine time and yours, worked through in how to price 3D prints.

Counting open spools

Weigh an empty spool of each brand once and write it down (many are around 200 g, but check yours). Then:

Open spool on the scale 742 g
Empty spool 205 g
Filament left 537 g

Sealed spools count as 1,000 g each. A monthly weigh-in of the open ones keeps the tracker honest.

Spool lots and moisture

Received Item Lot Quantity Note
Oct 14 PLA, black BK-2510-A7 5,000 g Five spools; one open
Aug 3 PLA, white WH-2507-C2 3,000 g Opened Aug 20: keep dry

Color varies a little between production lots. For a matched set or a repeat customer, print the whole order from one lot and write it down. And note when a spool was opened: PETG and TPU take on moisture and print badly after weeks in open air.

Get the tracker

Download the filament inventory tracker. Four sheets: inventory with value and REORDER, spool lots, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Counting stock of any kind is covered in how to count inventory.

Where this stops working

Five printers run all day. Each finished plate used some grams of something, and nobody subtracts 86 grams from a spreadsheet forty times a day. The tracker is right after the monthly weigh-in and wrong by the next afternoon.

How TaroStack does it

TaroStack subtracts the grams as the parts are made.

Each part is a recipe. The planter: 120 g of terracotta PLA and a box. Record a batch of 12 finished and 1,440 g comes off the filament, from the oldest lot first.

Failed prints are waste with a reason. Record the scrap, and filament lost to failures becomes a number by month.

It answers the order question. "What could I make right now" shows how many planters the filament on hand prints.

The reorder list. White PLA shows up on it before a customer does.

Selling online. Connect your Shopify store, and we set it up with you.

The job Tracker In TaroStack
Grams after each plate Nobody subtracts Come off with the batch
Enough for 40 planters? A sum Shown for you
Filament lost to failures Unknown Waste, by reason
Finished parts on the shelf A separate count Stock, by lot

Recipes, batches and the reorder list are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do you keep track of filament?

Count grams by material and color, weigh open spools monthly, and subtract what each job uses, or let software do the subtracting.

How much filament is left on a spool?

Weigh the spool and subtract the weight of an empty one of the same brand.

How much filament should a print shop keep?

Enough for your open orders and what you'd print while a reorder ships, plus a spare spool of each color you sell most. Planning a shop is in 3D printing business plan.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

TaroStack for Shopify

Free for 14 days.