Supply Inventory Template: Track Supplies by Unit

Supply Inventory Template: Track Supplies by Unit

Supply inventory template for makers: count wax in ounces, oils in grams and jars each, set reorder levels, and see what one batch takes off the shelf.

By · Editorial policy

Published · 9 min read

Supply Inventory Template: Track Supplies by Unit

In a made-up example, one candle maker has 40 jars before a batch. Making 18 candles leaves 22, below a reorder level of 24. That gap is why a supply and stock file for makers beats memory.

The short answer: a supply inventory template needs three things: one stocking unit for each supply, a reorder level you can read at a glance, and a way to take supplies down each time you make a batch. A stocking unit is the repeatable quantity you use to count one supply.

In Short

  • Choose one stocking unit per supply and keep using it.
  • Set a reorder level with the next batch in mind.
  • Record each batch once, then check the shelf against the sheet.

This post is for makers of candles, soap and similar goods. Wax is counted in ounces, oils in grams and jars one by one. It builds the sheet in that order, then runs one made-up batch through it.

What a Supply Inventory Template Needs

A supply inventory template needs one row per supply and a unit you choose once. Add what is on hand, what is on order, a reorder level, and a status that shows when you are at or below that level. Unit cost and supplier are useful extras.

Column Why a maker needs it
Item / ID One row per supply, so soy wax flakes never appear twice
Category Wax, oils, packaging and market kit group together
Unit Each, oz or g, chosen once per supply
On hand The count, in that unit
On order What you have bought but not yet received
Reorder level The count at which you buy again
Status Shows Low when On hand is at or below the level
Unit cost What one unit cost you, for your own tracking
Supplier Who you buy it from

The rule behind Status is "at or below". A count that sits exactly on the level is already time to buy. In Google Sheets, conditional formatting changes a cell's color when its value meets a rule you set, so the Status cell can change color when On hand reaches the level.

A general stock sheet needs a few more columns than these, and inventory management spreadsheet lists them.

What a supply inventory template needs: labelled supply containers in neat rows beside a pencil and paper count slip

Pick One Unit Per Supply: Each, Ounces or Grams

Count each supply in the unit you use it, buy it in whatever the supplier sells, and record it in your counting unit when it arrives. Wax goes in ounces, fragrance oil in grams, jars one by one. Never mix ounces and grams inside one supply.

  • Wax: ounces. A batch uses a weight, so the count should be a weight.
  • Fragrance and essential oils: grams. Small amounts read better in grams than in fractions of an ounce.
  • Jars, wicks and labels: each. You use them one at a time.

A case of jars or a bag of wax is a purchase, not a stock unit. Your sheet can track the jars or wax in the unit you use, while the package size matters when you log what arrived. For example, a 10 lb bag of wax is 160 oz if the stock row counts ounces. NIST Handbook 44 (2026) lists 1 avoirdupois pound as 16 ounces, so multiply the bag weight by 16 before entering the quantity.

Pick the unit once and keep it. If wax is in ounces on Monday and pounds on Friday, the count is wrong, and a plain sheet may not flag the change. For weights, use the unit printed on your recipe or batch notes.

Pick one unit per supply: wax flakes on a kitchen scale beside wicks and a case of glass jars

Supply Tracking: What to Use When

A notebook can work for a handful of supplies. Microsoft's gallery lists free inventory templates, including an inventory list with reorder highlighting. For a maker, check whether a chosen file supports different units and batch use before you rely on it. For shared access across devices, inventory management google sheets walkthrough covers sharing and limits.

Situation What works Where it strains Best for
Notebook or paper list Quick, no setup, travels to the stall Nothing flags a low count, and every sum is yours A handful of supplies
Template from a free gallery A grid to start from Open it and check: can each supply have its own unit, and does anything take supplies down for a batch? Makers who count everything one way
Your own sheet with formulas Fits your supplies exactly You build and maintain every formula Makers happy to build
A purpose-built file Ultimate Inventory Tracker by Cosmo Suite: one Google Sheets and one Excel file with the same 12 tabs, $9 once. Unit per supply, reorder level, status flag, a Reorder List and batches No connection to an online shop or till, and no barcode scanning Makers who mix units and make batches

If you build your own, see how to build the stock sheet in Google Sheets or the Excel formulas for stock on hand.

Choose by how many ways you count.

A 30-Supply Example Before the Batch

In this made-up example, a candle-and-soap shelf has 30 supplies, each with its own unit, on-hand count and reorder level. Before any batch, three sit at or below their level: bubble mailers, tealight cups and scent sniff strips.

An illustrative example, made up for this post, not a real shop's numbers. It covers one shelf and one batch, with quantities and no prices. The rule: at or below the reorder level reads Low. Tealight cups show 24 on hand against a level of 24, so they count as Low.

# Supply Unit On hand Reorder level Status
1 Soy wax flakes oz 260 150 OK
2 Lavender fragrance oil g 600 300 OK
3 Cedar fragrance oil g 420 250 OK
4 Cotton wicks each 60 25 OK
5 Glass jars, 8 oz each 40 24 OK
6 Jar lids each 50 24 OK
7 Wick stickers each 200 50 OK
8 Candle dye chips each 90 30 OK
9 Candle labels each 100 30 OK
10 Olive oil oz 96 64 OK
11 Coconut oil oz 80 48 OK
12 Shea butter oz 40 24 OK
13 Lye oz 48 32 OK
14 Lavender essential oil g 60 40 OK
15 Oat powder g 450 200 OK
16 Soap mold liners each 12 6 OK
17 Soap wrap bands each 70 40 OK
18 Soap box sleeves each 35 30 OK
19 Shipping boxes, small each 28 20 OK
20 Tissue paper sheets each 140 60 OK
21 Kraft stickers each 110 50 OK
22 Bubble mailers each 16 20 Low
23 Packing tape rolls each 5 2 OK
24 Thank-you cards each 75 40 OK
25 Gift tags each 60 25 OK
26 Twine spools each 4 2 OK
27 Paper bags each 120 50 OK
28 Price tags each 160 60 OK
29 Tealight cups each 24 24 Low
30 Scent sniff strips each 40 50 Low

Three of 30 supplies are flagged before the batch.

Reorder Levels That Match How You Make Things

Set the level at one batch of cover plus a small cushion, so you can buy before the next batch starts. For the soy wax, one batch uses 126 oz, and a 24 oz cushion makes the level 150 oz.

For example, the made-up batch uses 18 candles at 7 oz of wax each: 18 × 7 = 126 oz. Add the cushion: 126 + 24 = 150 oz. The 24 oz cushion is a choice made for this example, not a rule. Pick yours from how soon you can restock.

Jars follow the same pattern. The batch needs 18 jars, and a cushion of 6 gives a level of 24.

The recipe is illustrative only. It is not candle-making advice or a recommended fragrance load. This post also leaves out supplier lead times and covers only the shelf.

How a Batch Draws Supplies Down

In the illustrative example, making 18 lavender candles takes 126 oz of wax, 252 g of fragrance oil and 18 each of jars, lids, wicks, wick stickers and labels. Afterwards wax and jars sit below their levels, so 5 of 30 supplies are flagged, up from 3.

Per candle, the illustrative recipe is 7 oz of wax, 14 g of lavender fragrance oil, 1 jar, 1 lid, 1 wick, 1 wick sticker and 1 label. For 18 candles, the fragrance oil is 18 × 14 = 252 g.

Supply Unit Before Used After Level Status
Soy wax flakes oz 260 126 134 150 Low
Lavender fragrance oil g 600 252 348 300 OK
Glass jars, 8 oz each 40 18 22 24 Low
Jar lids each 50 18 32 24 OK
Cotton wicks each 60 18 42 25 OK
Wick stickers each 200 18 182 50 OK
Candle labels each 100 18 82 30 OK

One batch took two supplies below their reorder levels. The wax is at 134 oz, under its 150 oz level, but still covers one more 126 oz batch. That batch would leave 8 oz, so order before starting it. The fragrance oil fell by 252 g and stays above its level at 348.

How a batch draws supplies down: 18 glass jars with wicks beside a scoop of wax flakes

What Keeps Supply Counts True

Four habits help keep counts true: stock rises when goods arrive, corrections carry a reason, each supply keeps one unit, and each batch is logged once. Break one and the sheet can drift away from the shelf.

  • Log stock when it arrives, not when it's ordered. An order is not on the shelf yet. Keep it in On order until the box is open.
  • Correct counts with a reason, don't overwrite. If a jar breaks, record the loss and the reason instead of typing a new total over the old one.
  • Keep one stocking unit per supply. In Google Sheets you can add a dropdown list to a cell, so the Unit column offers only each, oz or g and you can set it to reject any other entry.
  • Log each batch once. Log it twice and the supplies come down twice.

After a full recount, inventory management google sheets helps you compare the shelf with the sheet and fix the differences.

How the File Handles This

The Ultimate Inventory Tracker (by Cosmo Suite: one Google Sheets and one Excel file, 12 tabs, $9 once) is built for this kind of tracking. For supplies, Products & Supplies holds the unit, on hand, on order, reorder level, status flag and unit cost, and Batches takes supplies out when you make something.

Products and Supplies tab in the Ultimate Inventory Tracker

It is a Google Sheets and Excel file that logs batches and shows what is running low. Each part of this post has a home in the file:

Reorder List tab in the Ultimate Inventory Tracker

  • Products & Supplies: one row per supply with its unit, on hand, on order, reorder level, status flag and unit cost.
  • Reorder List: supplies at or below their reorder level, with a suggested quantity to a target level and the usual supplier.
  • Purchases: stock goes up when an order arrives.
  • Adjustments: count corrections, breakage, samples and gifts, each with a reason.
  • Recipes and Batches (optional): Recipes list the supplies in one finished piece and the cost of one piece. Batches take supplies out and put finished pieces in.

Each format comes in a sample copy with a small maker's example data and a clean copy.

Choosing the unit stays your job: pick one unit for each supply and keep using it.

Two limits, plainly. It has no connection to an online shop or till, and it does not scan barcodes, so you log or paste each entry yourself. Cost is for your own tracking.

Ultimate Inventory Tracker is published by Cosmo Suite. Read About Us for company details. The editorial policy explains how the site handles sources and corrections. For product questions, contact support@ultimateinventorytracker.site.

Frequently asked questions

What should a supply inventory include?

One row per supply, with a unit, an on-hand count, a reorder level and a status. Add on order, unit cost and supplier if you buy from more than one place. For a candle or soap maker, group the rows by category: wax, oils, packaging and market kit. The sheet tracks what you buy and use.

How do I track supplies measured by weight?

Count them in a weight unit you can read off your scale, such as ounces for wax and grams for oils, and keep that unit for the life of the row. Record what arrives in that same unit. Mixed units inside one supply make a count drift, so a dropdown on the unit column helps.

Should packaging and wax share one sheet?

Yes, if each row has its own unit and a category. Jars, boxes and labels count each, and wax counts in ounces. One sheet gives you one place to check before you order, and every Low flag shows up together.

How do I track supplies used in a finished piece?

Write down the supplies in one finished piece, then enter the quantities used when you record a batch. In this post's made-up example, 18 candles use 126 oz of wax and 18 jars. The Recipes and Batches tabs hold the per-piece supplies and the batch amounts.

Is there a free supply inventory template, and what does it cover?

Yes. Microsoft publishes free Excel inventory templates, including an inventory list with reorder highlighting. The listing does not say whether a file handles different units or takes supplies down for a batch. Open the template and check its fields and formulas before you rely on it for a maker's stock.

Does it scan barcodes?

No. Ultimate Inventory Tracker does not scan barcodes and does not connect to an online shop or till, so you log or paste each entry yourself. It can hold up to 1,000 products and supplies and up to 20 places in one file.

Sources

  1. Google Docs Editors Help: drop-down lists in Google Sheets
  2. Google Docs Editors Help: conditional formatting in Google Sheets
  3. Microsoft: inventory templates gallery
  4. NIST Handbook 44, 2026, Appendix C: General Tables of Units of Measurement

Ultimate Inventory Tracker

Ready for the Ultimate Inventory Tracker?

Log each sale, purchase and batch once. One stock file you own, pay once.

Get instant access
Ultimate Inventory Tracker