Video Walkthrough

You may also like…


  1. Diana

    I love this spreadsheet! My nerdy side squealed while I was working with it. So much fun! Thanks for all the helpful videos that go with this, that’s SO MUCH VALUABLE training even for a beginner!
    Thanks so much Janet, for making this so much easier 🙂

  2. Jacki

    Just what I needed! Great tool for keeping track of my inventory, sales, overhead, etc.

  3. Liz Adrian

    This spreadsheet is great for spreadsheet-impaired people like me. The PDF book is printable and easy to understand (and I refer to it all the time!). The spreadsheet works, and helps me stay organized and up-to-date for the end of the year. Support is great as well. If you are making stuff . . you need this.

  4. Lydia Yee (verified owner)

    I tried using the spreadsheet for my shop along with the Etsy addon and wound up not being able to use either because of the nature of my business. I sell vintage jewelry and sometimes make minor repairs which would necessitate the use of some type of material. Having to enter each material into a formula by hand onto the COGM Formula sheet is tedious at best. Not having the ability to add shipping cost( I offer free shipping) onto the Pricing Formula is another drawback. Limiting the number of Material sheets that can be added won’t work for me. Above all, there is nothing that addressed paying back startup costs in a transparent trackable way. Profit Per Product is misleading where it concerns startup costs. Repaying the cost of a product you purchased “out of pocket” on startup is important. Then being able to purchase another product plus seeing a profit should be addressed in the retail price. But without removing the initial cost of a product the profit shown in this spreadsheet is not a true profit. After startup costs have been paid then the sheet would work ok if you don’t mind your product expenses not including items like selling fees among others. Shouldn’t this be part of COGS or COGM? It is part of the individual product’s cost and should be used to determine the retail price.

    I am sure this spreadsheet would work for many but for me it and the Etsy one is a wash not to mention a costly lesson learned.

  5. Misty Henry (verified owner)

    I can’t believe I’ve waited this long to leave a review for this spreadsheet! This is the spreadsheet I recommend to all of my clients and followers when they are searching for a tracking system that will work for both tax compliance and safety compliance since 2017. Easy to work on and the added customer service makes this spreadsheet the best business decision for sanity when dealing with numbers.

  6. angie

    Hi there, I am wondering if this spreadsheet will also work for raw ingredients? I make skincare products and want to know if this would work for me:) Thank you!

  7. Ruth Hoover

    I am just starting and have LOADS of fabric I have had for years!! Do I have to include this fabric in my inventory? Yes, I plan on using it in my items. I also make one-of-a-kind items, not multiples of each color and pattern. Spreadsheet type?

Add a review

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inventory Cost & Pricing spreadsheet for one-of-a-kind makers



Stop “just guessing” when setting your prices. Take control of your costs. Get organized. Increase your profits. Know your stuff.

The inventory costing and pricing process for a creative business with physical products can be time-consuming and stressful.

It takes time to sort, enter, and track all those materials & supplies you buy. It takes energy to determine how much of your supplies went into making each product you create. It is stressful to figure out how to correctly price your products to ensure a profit. Are you basing your prices on a proven formula, or are you just guessing at it?

It feels overwhelming to list and track all that inventory you make. What’s still out there for sale and what have I already sold? It takes research and time-consuming Googling to figure out how to calculate the numbers you need for your tax return.

Knowing just how much your products cost you to create and how much you should sell them for are two huge MUST DO’S for any creative biz owner that’s serious about building a profitable, sustainable business.

That’s exactly what the Inventory Cost & Pricing spreadsheet does for you – it takes the guesswork out of costing and pricing your goods.

What does the spreadsheet do?

A lot! This powerful tool will assist you with the following business tasks when it comes to handling your supplies & finished goods:

  • Keep you organized by logging your raw materials & supply expenses
  • Determine how much each finished item cost you to create to ensure accurate pricing for profit
  • Calculate your suggested overhead rate, an important {and often forgotten} component of your pricing formula
  • Calculate a wholesale and retail price, based on a formula that you have the flexibility to adjust
  • Automatically generate an inventory list of finished goods available for sale
  • Compute your sales and cost of goods sold on a monthly basis
  • Take the stress out of your taxes by making your year-end inventory count much less painful and more streamlined
  • Help you calculate purchases and ending inventory for your Schedule C
  • Provide you with the right financial data to determine if you’re making a profit, help you make educated business decisions, and set goals for the future

Updates make dealing with inventory on your tax return even easier.

Based on user feedback after selling hundreds of copies, I’ve added more features to the spreadsheet to make it even more helpful at tax time. New supply quantity tracking helps streamline your year end inventory count, and you can use your spreadsheet to verify your ending inventory cost. The spreadsheet also summarizes your total inventoriable supply purchases for the year. Get peace of mind by having exactly what you need to fill out the inventory section on your business’ tax return.

THE BOTTOM LINE – With this tool, you can log your supplies, cost & price your finished goods, track your inventory and tally your sales & cost of goods – ALL IN ONE PLACE!

What’s included in your purchase?

  • An instantly downloadable & ready-to-go multi-tabbed spreadsheet file, openable in Excel, Numbers, or Google Sheets
  • A detailed PDF instruction guide, with screenshots and explanations of applicable accounting terms and concepts used
  • Series of video tutorials with step-by-step instructions on how to use your spreadsheet

I see you have two versions of this spreadsheet. Who is this version for?

Both Inventory Cost & Pricing spreadsheets are for handmade sellers. They both assist with the main areas of dealing with inventory – costing, pricing, and taxes – they just do it in slightly different ways to fit different needs.

The ICP spreadsheet for one-of-a-kind makers is my original inventory spreadsheet – so if you’re looking for the version I’ve been selling since 2015, this is it. This version is best suited for those who sell unique or custom-made one-of-a-kind items, vs. multiple quantities of the same handmade item over and over.

Watch me sum up the differences and pros/cons of each inventory spreadsheet in this quick video.

Both ICP spreadsheets work for both newbie and experience creative biz owners who create and sell physical products. Sellers with any level (or no level!) of experience using a spreadsheet can use this tool to grow their biz. Our instructional package includes written, photographic, and video step-by-step guides on how to get the most out of your purchase.

Read more about the Inventory Cost & Pricing spreadsheet, and get a video sneak peek here.

Need an inventory spreadsheet AND a Seller Spreadsheet for an all-in-one bookkeeping solution? Build your own bundle of spreadsheets and get a significant discount here.

Got procrastination issues? Need some help staying committed to your new bookkeeping spreadsheet on a consistent basis? Join the Accounting Accountability Club.

Have questions about any of our spreadsheets? Not sure which tool best fits your needs? Check out the Spreadsheet Resource page for FAQs, videos, and more info.

Let’s chat

FB Messenger Chat

Need an answer quickly? Chat with me on facebook!

Start Chat >

Rave Reviews
for Paper + Spark

I love the spreadsheet, but I love the detailed instructions even more, thanks for breaking everything down so that the product is easy to learn to use!

Wendy S.