Video Walkthrough

You may also like…


  1. Autumn

    One of the most helpful tools you can buy as a seller (wish I had been using these a long time ago… if you are waiting or debating on buying both this and/or the seller spreadsheet, you’ll save yourself so much time and trouble, so just do it!). Janet is also so helpful and accommodating, amazing customer service. Thank you again!

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 batch makers & multiple quantity handmade sellers



Time to get your inventory organized – get a handle on your costs, set a profitable price point, and finally understand your inventory when it comes to taxes.

If you’re a physical product seller, you may be struggling with exactly HOW to handle tracking your goods. Not to mention all those raw materials and supplies (beads, fabric, shiny things, tiny things, #allthethings, oh my!).

The inventory entry, costing and pricing process for a creative business can be time-consuming and stressful. And don’t forget about that year-end inventory count for tax purposes! 🤦🏻‍♀️

If you’re tired of wasting energy trying to figure out a way to track inventory or price your handmade goods on your own, a Paper + Spark inventory spreadsheet is for you!

Plus 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 handmade inventory.

What does this 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 (and automatically calculating your cost per unit)
  • Determine how much your finished goods 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
  • Keep track of finished goods available for sale and sold throughout the year
  • Keep track of inventory taken out for personal use (an important number for tax time)
  • Easily calculate the tax numbers you need for inventory (total purchases and ending inventory)
  • Take the stress and overwhelm out of your year-end inventory count

What’s included in your purchase?

  • An instantly downloadable & ready-to-go multi-tabbed spreadsheet file, openable in Excel, Numbers, or Google Sheets. This one file can be used year after year.
  • 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 batch makers and multiple quantity handmade sellers is geared towards those who sell the same handmade goods over and over. If you are making and selling identical goods multiple times, then this spreadsheet is the better fit for you. It’s also a good fit for those who create their goods in batches (like soap makers for instance), but batch making is not a requirement of using this spreadsheet.

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.

Curious about how this spreadsheet works? You can watch the video tutorials even before you purchase to see if this tool is a good fit for you. Watch the overview video here.

Need an inventory solution bundled with a bookkeeping template too? 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.

I can just make a spreadsheet template myself, can’t I?

Sure you can. But as with all P+S spreadsheets, the value of the reseller inventory spreadsheet is in the guidance. This isn’t just a barebones spreadsheet. Your purchase also includes step-by-step PDF and instructions, along with video tutorials that guide you through the entire inventory process – from initial set up to year end tax time. My goal is not to just give you a tool for entering your inventory, but for you to actually understand all the concepts related to inventory – like cost of goods sold, the year end count, and how inventory works for your taxes. I break down the “why” behind what you’re doing in plain English.

Let’s chat

FB Messenger Chat

Need an answer quickly? Chat with me on facebook!

Start Chat >

Rave Reviews
for Paper + Spark

Awesome spreadsheet and amazing tools for understanding how to input all of your information. It can get so confusing and all the resources are phenomenal. Thank you!!!