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

WHO IS THIS INVENTORY SPREADSHEET FOR?

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.

WHAT YOU GET IMMEDIATELY AFTER PURCHASE:

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? 

WE GOT A BUNDLE FOR THAT.

NEED THIS SELLER SPREADSHEET AND AN INVENTORY one too?

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 82 reviews
95%
(78)
2%
(2)
0%
(0)
0%
(0)
2%
(2)
K
Kay

What an amazing wealth of information and resources! This will be such a great help in my business.

S
Stacey Shevlin
Fantastic Spreadsheets!!

I have a very small new business and everything is a learning curve. So happy to have these easy to use spreadsheets and the community on FB - plus the office hours are so generous, you can ask anything you need an answer to in those. Have learned so much - very grateful to have found these.

M
M.E.
Just what I needed!

As always, Janet has the tools I need to keep track of everything. This updated Inventory Sheet is perfect for what I'm working with and it's been great so far. I purchased the Inventory for Handmade Sellers Spreadsheet. And with your purchase comes the membership in the Accounting Accountability Club. That is so worth it! I can get my questions answered in the Facebook group and I've also gone to Janet's office hours. So very helpful for all of my questions!

K
Karen McHenry
Spreadsheet for Handmade Sellers

So far I've been able to navigate the spreadsheets. It's just time consuming entering all the data . I'm glad the formula automatically calculates for me. Thank you for developing such a helpful tool.

J
Jennifer White
This has helped my anxiety so much!

This has been a huge live saver. I was wanting to be able to keep track of everything for my new store, but I had no idea where to begin and that made me hella nervous. I got this in a bundle- the Etsy bundle- and it’s helped me keep track of everything and it’s so easy to use. So glad I decided to invest in this ❤️