Menu

Inventory Cost & Pricing spreadsheet for handmade sellers

$77.00

Description

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 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!

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

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 written instruction guide, with screenshots and explanations of applicable accounting terms and concepts used, available in Google Docs
  • Series of video tutorials with step-by-step instructions on how to use your spreadsheet
  • Access to the Accounting Accountability Club on Facebook for support, questions, and monthly office hours
  • Monthly checklist & reminder emails

What you’re really buying:

When you purchase a Paper + Spark spreadsheet, 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.

Every P+S spreadsheet comes with step-by-step video & text instructions. You’ll not only be able to see how to use your spreadsheet and do your biz books every month with clarity, but you’ll finally truly understand what these numbers, reports, and terms MEAN.

Every P+S spreadsheet also comes with the support you need to stay motivated and confident.Your purchase includes access to the Accounting Accountability Club, where you can ask questions about doing your books, understanding your numbers, and more. We also hold live monthly office hours in the Club, during which I walk through your questions and screen share examples so you can see how things are done.

Finally, you’ll also get email reminders and monthly checklists on the first of each month delivered straight to your inbox. I’ll hold you accountable to keep your spreadsheets updated and even send you a step-by-step list in case you forget where to find what!

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 an out-of-the-box, one-size-fits-all bookkeeping software option?

The Inventory Cost & Pricing spreadsheet is designed for handmade sellers.

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.

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.

Video Walkthrough

Customer Reviews

Based on 73 reviews
95%
(69)
3%
(2)
0%
(0)
1%
(1)
1%
(1)
A
Andrew Gloyd
Very Helpful

I’m still getting up to speed on it all, but the videos are very helpful. I’m brand new to everything and I’m looking at starting my own business to sell my woodburnings and I want to do things right, and your videos and instructions have been so helpful to me as I’m just starting out. You have included a lot of information that has made this process attainable for me and less scary, and is helping me get all of my ducks in a row! Thank you so much!

D
Dawn Vosburg
Perfect tool

I don't have any experience with spreadsheets, but this one is very user friendly. I was able to start plugging in my inventory and materials without any problems. I only regret not being more organized sooner.

K
Kathleen
Awesome tool!

I wish I have known about P&S before I started my business. 14 days into trying to do my inventory and I'm already loving it. Its hardwork but I know its all worth it. Thank you for this awesome tool!

M
Misty Henry
Easy to use and peace of mind for tracking!

I haven't yet used the add-on sheets, but the inventory tracking is *exactly* what I needed! I already have a bunch of components listed and a few completed projects listed, and I know what I'll list them for thanks to this spreadsheet! Janet took the mathing and made it a breeze so that I didn't have to think too hard about each little thing that goes into pricing!

C
Claudia Kamen
Great Tool

Another great product from P&S, so grateful for a tool that I can use as a new Etsy shop owner to keep my inventory organized and up to date. I've asked myself a number of times how the heck would I have figured out all the administrative aspects of running a shop without Janet LeBlanc!?

You may also like…

Let’s chat

FB Messenger Chat

Need an answer quickly? Chat with me on facebook!

Start Chat >

Rave Reviews
for Paper + Spark

This is such a great resource! I was always intimidated by the thought of using spreadsheets. This has simplified it and made it do-able.

Kayla F.