How to manage inventory used for making a product, i.e. inventory to make scones.

[thePantryBend]

Hello, we have a small bodega store.  We sell bulk items, retail items, coffee drinks, and some house made food products.  We purchased the store 6 weeks ago.  

Managing inventory and cost of goods is my primary focus . . . but I am struggling to do this well in Square.  

My primary question is how do I purchase and inventory items that will be used in our baked products (flour, eggs, etc).  My end goal is to be proactive ordering more supplies for production and secondly, know exactly what our cost of goods are for these items.

Thank you in advance for any help you can share with this newbie! 🙂 

[Candlestore]

@thePantryBend ;

There are not really ways to do this in Square as you would need an accounting system for this more so.  Square is more of a Point of Sale system.  This is that you buy or create items for sale, and then sell them.  The actual cost to make an item would be in your accounting system.  Now if you subscribe to Square for Retail you could create a Bundle of for an Item.  Here is more about Bundles :

8057-create-managing-bundles-with-square-for-retail 

The issue currently with a Bundle is the way you create it is the way you Must sell it.  You can not for instance in a coffee have the bundle as a Cup of coffee for a Price then the customer wants Xtra sugar. for example. Now with coffee for an example in a Bundle you could have in the bundle:

Large Cup of Coffee Bundle:

     1 Large Cup

     1 Lid for Large coffee

     .25 oz coffee

     1 pack of Sugar

     1oz Creamer

Cost of items of X.XX  then you have a Refrence of how much all items in this bundle cost before adding in your profit and Labor prices to get you sales Price for the bundle.

In the above example your inventory when 1 Large Cup of Coffee Bundle is sold all the items also reduce by the Quantity you specify.

Now you would need to create bundles for Each type of Coffee people may order or anything else you make and want to track the ingedients of.

This is good for tracking inventory when Items are Sold which is easier than trying to do it in an accounting package.

For example :

Accounting software such as Quickbooks uses something called Build Assemblies.  The problem with these is you have to basically tell Quickbooks to make XX number of Coffee Bundles so you can sell them.