Inventory tracking for handmade sellers
track cost of good sold for taxes
get inventory numbers for taxes
track goods sold on online shop
find the best price to list your item
inventory spreadsheet for creatives
online tools for handmade sellers
e-commerce sellers inventory tracking
e-commerce inventory
inventory spreadsheet reviews
easy to use inventory tracking
track purchases for business
paper and spark inventory sheet
paper and spark reviews
inventory template

Inventory for handmade sellers spreadsheet

Regular price$77.00 USD

Get your inventory organized - track your costs, set a profitable price point, and finally understand what you need for 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 process for entering raw materials & supplies, figuring out the cost of a handmade item, and setting a profitable price point for a maker can be time-consuming and stressful. And don't forget about doing that year-end inventory count for tax purposes!

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 handmade seller inventory spreadsheet does for you - it takes the guesswork out of pricing your handmade goods and tracking your inventory numbers for tax time.

What does the inventory for handmade sellers 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


This particular spreadsheet is designed for handmade sellers, makers, and artists. It's specifically helpful for those that combine multiple raw materials & supplies together to create a new good.

If you sell handmade goods alongside wholesale or retail items, this is also my recommended inventory tracker for you. 

📌 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.


Spreadsheet file

Instantly downloadable spreadsheet file that can be used in Excel, Numbers, or Google Sheets, for any year you need to track your inventory

Video & Text Instructions

A Google Doc guide with crystal clear written & visual instructions, plus video tutorials with step-by-step instructions & examples

support & motivation

Access to the Accounting Accountability Club on FB for support, questions, and monthly office hours, plus monthly checklists delivered to your inbox

Your new community of support includes:

✅ Access to the Accounting Accountability Club on Facebook for support where we answer your bookkeeping or spreadsheet questions and you can meet with like-minded entrepreneurs

✅ Monthly office hours to dish on numbers & keep you motivated, with live screen-sharing how-tos

✅ Monthly checklist & reminder emails delivered straight to your inbox on the 1st of each month

✅ Lifetime access to any updates to your spreadsheet (you can use it in future years too!)

The best part about buying a Paper + Spark spreadsheet is the support. You’re not simply getting a downloadable spreadsheet file. You’re really getting a set of resources & support that help you understand your business finances with confidence. You’ll do your biz books every month with clarity, and you’ll finally truly understand what these numbers, reports, and terms MEAN.

You’re not just buying a file. You’re buying lifetime access to a bookkeeping template, step-by-step instructions for how to understand your biz finances, access to a CPA who actually *understands* e-commerce and how your maker biz operates, an easier tax time for yourself, monthly accountability and a community that will support you throughout your journey as an entrepreneur.

Can you say the same about that out-of-the-box, one-size-fits-all bookkeeping software option? 



Get them both bundled together for a discount! Pick out the exact spreadsheet combo for whatever and wherever you sell.

Why A Paper + Spark Spreadsheet?

Traditional bookkeeping software is made with accountants in mind. It’s expensive (and generally requires a monthly subscription payment), bulky, and oftentimes more complicated than a micro business like yours needs. It’s made for any and all types of small businesses, and not specific to YOUR business needs as a handmade biz owner or e-commerce seller. When your bookkeeping software is too complicated, too vague, and support or in-plain-English instruction is lacking, you tend to procrastinate on using it. Not updating your books consistently means severe stress once year end or tax deadlines hit.

Spreadsheets are powerful but simple tools. Partner a well-crafted spreadsheet file designed by an accountant intimately acquainted with e-commerce with clear, understandable instructions and you’ve got a formula for bookkeeping success. You get everything you need to feel empowered by your numbers, and nothing you don’t need.

Paper + Spark has been selling spreadsheets since 2015. We currently support thousands of makers and creative entrepreneurs in doing their books and understanding their money. Our spreadsheets have received countless rave reviews from shop owners. No other bookkeeping solution out there offers our level of step-by-step guidance & support. We also stay up-to-date on e-commerce reporting and platform changes.

With a Paper + Spark spreadsheet, you’ll pay a one-time fee for lifetime access to your files and support. We provide any future year files and updates for free, forever, via the account you create at checkout. You can always reach out in the Accounting Accountability Club, or via DM or email, and get answers to your spreadsheet & bookkeeping questions.

Customer Reviews

Based on 77 reviews
Patricia Witzmann
Learning Never Ends

Thank you for the clarity. I have alot of work ahead of me. I'll be glad when next year's tax Season come I hope to be better prepared.


Product is easy to use and easy to follow

Inventory spreadsheet - not what I expected

I thought this would help me keep track of my inventory, but it is very confusing and hard to keep a running total of what I have on file. I will continue to use it, maybe someday, I can make it work for me.

Solomae Stoycoff
Love the Spreadsheets

I absolutely love the spreadsheets. I got the Etsy seller spreadsheet and the inventory spreadsheet with the Shopify plug in. Love having all the info in one place and to be able to see in real time exactly where my business sits financially. Thank you for this product!

Ashley Ayers
Love it

Thank you for being exactly who I needed to teach me about all of this legal and financial stuff. Before I found paper & spark, I literally said, "I need to find a video of an Etsy seller explaining sales tax and how it really is." And here you are!