Craft fair inventory tracker – free printable

This post contains affiliate links. If you click and make a purchase, I may receive a commission. Thanks.

Participating in craft fairs is always very exciting. However, it can also easily become overwhelming during those busy moments. Customers tend to come and go in “waves”. One moment your booth is empty, the next you have more customers than you can handle. At the end of the day, when all the busy “waves” have passed, you want to know what you have sold and how much money you made.

There are different approaches to that. I’ve seen many vendors writing down each sale they make throughout the day. I’ve also seen many printable sales trackers online that should make it easier. In theory, it sounds easy. You just need to write down what you sold and for how much each time you make a sale. But in reality, there may be no time for this so you may end up writing down only some of the sales. So instead, consider not tracking your sales throughout the day at all. Enjoy the fair, smile, interact with people and leave counting sales for the end. 

The easiest way to tell how much you have sold is to write down your inventory before the show and then count everything after the show. This way you will see how much you sold and how much you earned. Easy-peasy. To help you count and keep records of your inventory and sales I have created a simple but very useful free printable craft fair inventory tracker.

Craft fair inventory tracker and what it tracks

 

This inventory tracker sheet is quite self-explanatory. On the top, you write down the name of the craft show and participation cost, which is your application fee, booth fee, travel and any other associated costs. 

Below you need to write down all your sales items, how much it cost you to make each item, the price you will be selling each item at and how many of each you are taking to the craft show. After the show, calculate how many of each item you have left. Subtract this number from the number of items you prepared for the show. This will show how much of each item you have sold. Multiply this number (number sold) by your margin (the difference between sales price and cost to make). This will be your gross profit for that item group. Repeat this for all your items.

 

The bottom section of the sheet is for summing everything up:

TOTAL GROSS PROFIT is a sum of all “gross profit” sections. It shows the amount of money you made after deducting production costs.

TOTAL COST should show all your costs related to participation in the fair (application fee, booth fee, travel costs and similar). Do not forget that production costs are already accounted for in the gross profit calculation.

SALES TAX DUE:  how much sales tax you have to pay for the sales you made.

TOTAL FINAL PROFIT – the most exciting part. It is the amount of money you have left after deducting all the expenses. Total final profit = total gross profit – total cost – tax.

And the last part is dedicated to writing down your BEST SELLERS at this particular show. This allows you to analyze your sales better and see what sells well and what does not. Also the over time you might notice that some items sell better at particular shows than the others. This tracker will allow you to prepare your stock for the next show better. 

So in practice, this simple sheet can serve you as an inventory tracker, a sales tracker and a planner. You can download this free printable inventory tracker below.

>>> CRAFT SHOW INVENTORY TRACKER <<<

I hope you will find it useful. And if you like this tracker you may also like a craft show tracker that goes well with this one. You can find it here.

 

 

8 thoughts on “Craft fair inventory tracker – free printable

  • May 1, 2019 at 12:28 pm
    Permalink

    I have been doing shows for a while and I have never came across a site with so much information on it. Thank you I really find it useful.

    Reply
  • November 15, 2019 at 12:26 pm
    Permalink

    I used to do craft shows years ago. Now that I’m RETIRED, I,m just getting back into it.

    Reply
  • December 22, 2019 at 8:20 am
    Permalink

    Thank you for sharing! I am new to this and your tracker will help more than words can say. Thank you for sharing your talent!!

    Reply
    • May 30, 2023 at 5:09 pm
      Permalink

      Thanks. Doing my first show. Much appreciated.

      Reply
  • December 1, 2020 at 11:29 am
    Permalink

    thank you very much for sharing all this. I’m new in Fairs and it will help a lot. Wish you great success.

    Reply
  • October 27, 2021 at 11:55 am
    Permalink

    Thank you for sharing this craft inventory tracker

    Reply
  • November 28, 2021 at 1:59 pm
    Permalink

    Thank you so much for all the help. I’m just starting out and want to make this my full time business

    Reply
  • January 2, 2023 at 8:49 am
    Permalink

    Thank you for sharing your tracker. I have been looking for a practical way to track my items that I’m taking to market and selling. I look forward to utilizing this tool at my upcoming market in March.

    Reply

Leave a Reply

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