How To Track Finished Items Inventory for Makers-Without a Spreadsheet Meltdown

If you make physical products there comes a moment when you look around your craft room and think:

🤔 “I know I made all this … but how much do I actually have?”

That’s finished items inventory.

And no — it’s not just a pile of hats, mugs, candles, or amigurumi on a shelf.

It’s money sitting there, quietly waiting to be sold, tracked properly, and reported correctly at tax time.

Let’s talk about how to track finished items inventory using spreadsheets — without it turning into a spreadsheet circus!

Short on time? This post will take approximately 3 minutes to read, but feel free to just skim through the headings.

What counts as Finished Items Inventory?

Finished items inventory includes anything that is:

• Fully made
• Ready to sell
• Sitting in your studio, closet, craft fair bins, or on consignment

This is different from:

• Materials Inventory (yarn, fabric, blanks, supplies)
• Work-in-progress (WIP) items

Once an item is finished, it moves into it’s own inventory category — and that’s where tracking gets fuzzy for a lot of makers.

Why Finished Items Inventory Is Tricky (You’re Not Imagining It)

Tracking “inventory” is hard because there are multiple moving parts happening at once:

• You’re buying new materials
• Materials are being used
• Items are sold (sometimes months later)
• Things get damaged, stolen, donated, or quietly claimed as “mine now“

And all of those actions affect your:

• Inventory value
• Cost of Goods Sold (COGS)
• Taxable income

This is exactly why finished items inventory tends to get ignored … until tax time panic sets in.

What You Might Want to Track for Each Finished Item

Here’s where most makers feel the overwhelm kick in — so take a breath ☕
You do not need to track everything, but you do need to track the right things – think of it as a craft fair inventory list on steroids.

Common Finished-item details include:

Basic tracking

• Item name or SKU
• Date the item was completed
• Where it’s being stored or sold (studio, craft fair, consignment)

Cost Tracking

• Materials used (and their costs)
• Total cost of the finished item
• When that cost moves from Inventory –> Cost of Goods Sold

Inventory adjustments

• Products sold
• Items damaged or stolen
• Projects removed for personal use
• Items donated to charity

Helpful (but optional) extras

• How long it took to make
• Your fair hourly wage
• Overhead or markup
• Sale price vs. discounts
• Actual income received

Yup — it’s a long list.

And yes — this is where makers start thinking….

“Do I seriously need 15 spreadsheets for this?”

The Spreadsheet Hamster Wheel (We’ve all Been There)

I’ll be honest.

I’m not a fan of random, disconnected spreadsheets.

One spreadsheet leads to another …
Which leads to another …
Until suddenly you’re stuck in a hamster wheel of tabs, formulas, and well – mild rage.

But — and this is a big but — spreadsheets do make sense when:

• You’re just starting out
• Money is tight
• You’re not ready for bookkeeping software, yet
• You want to understand the flow before upgrading

And that’s where one well-designed system makes all the difference.

The Key: One Finished Items Inventory Spreadsheet (Not Twenty)

Instead of juggling separate sheets for costs, sales, adjustments, and totals – the goal is:

➡️ One spreadsheet per year
➡️ One row per finished item
➡️ Clear ins and outs
➡️ A running inventory balance you can trust

When it’s set up properly, you can:

• See what you have on hand
• Know what’s been sold
• Move costs correctly into COGS
• Adjust inventory without guesswork
• Walk into tax time with confidence instead of dread

Want a Done-For-You Finished Items Inventory Spreadsheet?

The Finished Items Inventory Spreadsheet is included inside:

The 10-Minute Bookkeeper – Handmade Business Spreadsheet Bookkeeping System

It’s designed specifically for handmade businesses and works together with:

• Materials inventory tracking
• WIP tracking
• Income & Expense tracking
• Clear COGS calculations

No hamster wheel.
No Franken-spreadsheet situation.
Just a simple, connected system that actually makes sense.

👉 Click here to learn more about the 10-Minute Bookkeeper

• Author
• Recent Posts

Nancy Smyth, The YarnyBookkeeper

Hey, I’m Nancy— your no-nonsense bookkeeping coach for handmade and creative business owners.

If you'd rather be working with yarn, fabric, paint or clay than deal with a pile of receipts or bookkeeping spreadsheets, you're in the right place.

I help you get a handle on your numbers, make sense of what's coming in and going out, and actually feel confident running your business -- without accountant-speak or guilt.

👉 Want help figuring out your bookkeeping (without overcomplicating it)? Join the free bookkeeping community.

I am a coach/educator, not your bookkeeper or CPA.This information is for educational purposes, NOT financial or tax advice.

Latest posts by Nancy Smyth, The YarnyBookkeeper (see all)

• A Weekly Bookkeeping Reset Plan for Handmade Businesses - April 26, 2026
• Bookkeeping Doesn’t Have to Steal Your Creativity (For Handmade Businesses) - April 19, 2026
• Money In, Money Out for Handmade Business Owners — How to Stop Guessing - April 12, 2026