Skip to content

Resin Inventory Spreadsheet: Resin, Pigments, Molds

A free resin inventory spreadsheet for a resin art business: resin and hardener by the ounce with lots and dates, pigments, molds, findings, finished pieces.

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

Resin is sold in two parts that have to be used together, in a set ratio, before they age. A resin inventory spreadsheet counts part A and part B separately, in fluid ounces, because the one you have less of decides how much you can pour. It keeps the lot and the date for each jug, since old hardener yellows and old resin can cure soft. And it lists pigments, molds, findings and boxes, with finished pieces by batch. Below is a sheet filled in for a made-up resin studio, with the file.

The short version

  • Resin and hardener on two rows, in ounces. The lower one limits you.
  • A lot and a use-by for each jug, from the maker's own guidance.
  • Pigments by weight, molds and findings in eaches.
  • Finished pieces by batch, noting the resin lots used.
  • TaroStack takes both parts off stock in the right ratio with every batch. More below.

An example sheet

Tidewater Resin Studio is a made-up Charleston studio making coasters, trays and earrings:

Item Unit On hand Reorder at Unit cost Value Status
Epoxy resin, part A fl oz 256 128 $0.45 $115.20 OK
Epoxy hardener, part B fl oz 192 128 $0.45 $86.40 OK
Mica powder, pearl white g 40 25 $0.24 $9.60 OK
Mica powder, ocean blue g 18 25 $0.24 $4.32 REORDER
Alcohol ink, gold fl oz 3 2 $4.20 $12.60 OK
Coaster molds, silicone each 12 8 $6.50 $78.00 OK

With cork backings, gift boxes and nine finished coaster sets, the studio holds $550.44. Ocean blue mica and gift boxes are under their amounts.

The lower part decides

This resin mixes one to one by volume. There are 256 oz of part A and 192 oz of part B.

Mixed resin the stock can make (twice the lower part) 384 fl oz
Part A left over when B runs out 64 fl oz
A set of four coasters takes 12 fl oz mixed
Sets the resin on hand can pour 32

Sixty-four ounces of resin with nothing to cure it is $28.80 sitting on the shelf getting older. The usual cause is a spill or a mis-measured pour that used more of one part. When you reorder, buy to even the two rows up, not a matched kit by habit. And if your resin mixes two to one, the sum changes: check the label.

Lots and dates

Received or made Item Lot Quantity Use by
Sep 15 Epoxy resin, part A A-250902 384 fl oz Sep 15, 2027
Sep 15 Epoxy hardener, part B B-250903 384 fl oz Sep 15, 2027
Nov 8 Coaster set of four, ocean CS-1108 12 sets

The use-by is what this resin's maker says for unopened jugs; yours will have its own. Hardener is the part that yellows, so the oldest jug gets used first, and a clear casting waits for fresh stock. The sheet flags a jug USE FIRST inside 60 days of its date.

Write the resin lots on each batch of finished pieces (lot codes are explained in how to create lot numbers). CS-1108 was poured from A-250902 and B-250903. If those coasters stay tacky or yellow in a customer's window, you'll want to know what else came out of the same jugs.

Molds wear out. This studio retires a coaster mold after about 40 pours, when the surface dulls. Twelve molds at three pours a week each is about 13 weeks of life, so molds are a supply to reorder, not a tool you buy once.

Get the spreadsheet

Download the resin inventory spreadsheet. Four sheets: inventory with value and REORDER, lots with days left, 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. Pricing the finished pieces is in how to price resin art.

Where this stops working

Every pour uses a little of five or six things: both parts, two pigments, a backing, a box. Updating six rows after each session doesn't happen, and the two resin rows drift apart from the truth fastest of all.

How TaroStack does it

TaroStack moves all six rows when you record the pour.

A piece is a recipe. A coaster set: 6 oz of part A, 6 oz of part B, grams of mica, four cork backings, a box. Record a batch of 12 sets and everything comes off stock, in the ratio the recipe holds.

Lots on the batch. Which jugs were used is noted automatically, oldest first.

What can I pour? "What could I make right now" shows how many sets the stock allows and what runs out first, which is how you'd spot 64 oz of stranded resin.

Dates and reorders. Jugs near their date are flagged, and the reorder list shows pigments and boxes before a show weekend.

The job Spreadsheet In TaroStack
Both parts after a pour Two subtractions Come off with the batch
What the stock can make A sum Shown for you
Which jugs made this batch A note On the batch record
Old hardener Read the dates An alert

Recipes, batches and lots 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 resin supplies?

Count each part of the resin separately by volume or weight, with the jug's lot and date, and list pigments, molds and findings beside them.

Does epoxy resin expire?

It ages. Makers give a shelf life for unopened and opened jugs, and hardener tends to yellow first. Use the oldest stock first and test old resin on a small pour.

Is a resin art business worth it?

It depends on your prices and how many pieces fail. The numbers are in resin art 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.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.