I love this deep dive - what made you decide to make your own spreadsheet versus using like Square inventory systems? I would think it would be easier to track inventory/best sellers through something like Square (but i guess you would have to log your cash sales in the POS which may change your flow) - but logging cash transactions in square can be helpful because it can calculate sales tax for you!
Thanks for your question!! I mostly made my spreadsheet so that I could accurately price my inventory first, then tracking sales, expenses and inventory came after. My husband works in Excel daily and is kind of teaching me as this business of mine evolves, and the more I mess with it, the more I really enjoy it and how much I can customize it for my needs. The biggest hurdle with tracking in Square for me is the fact that the majority of my sales are not Square purchases, and I'm not sure at all about how much Square allows you to track purchases outside of Square.
I enjoy your channel ,,, I have been working on smalls,,, I have lots of bigger items,,, I have signed up for so many shows already and xmas show already too,,, I need to keep the stock going!!
The grouping of the items by price range is a really great idea ❤ I’ll most likely try this at my next sale
I agree!! Anything to help the customer feel at ease :)
Glad this was helpful!!!
Awh I think I saw my flower guy pattern in there! 👀
Yeah he's probably in there (:
I love this deep dive - what made you decide to make your own spreadsheet versus using like Square inventory systems? I would think it would be easier to track inventory/best sellers through something like Square (but i guess you would have to log your cash sales in the POS which may change your flow) - but logging cash transactions in square can be helpful because it can calculate sales tax for you!
Thanks for your question!!
I mostly made my spreadsheet so that I could accurately price my inventory first, then tracking sales, expenses and inventory came after. My husband works in Excel daily and is kind of teaching me as this business of mine evolves, and the more I mess with it, the more I really enjoy it and how much I can customize it for my needs.
The biggest hurdle with tracking in Square for me is the fact that the majority of my sales are not Square purchases, and I'm not sure at all about how much Square allows you to track purchases outside of Square.
I enjoy your channel ,,, I have been working on smalls,,, I have lots of bigger items,,, I have signed up for so many shows already and xmas show already too,,, I need to keep the stock going!!
It's definitely a good idea to have lots and lots of inventory!!!
How much sales tax do you charge? Is it based on the market location? Thanks!
I charge sales tax based on my market location, and it's built into my prices in my spreadsheet. Sales tax is 8.25% where I am located.
Is there anyway you would be willing to let someone test your excel spreadsheet?
That's not something I feel comfortable releasing to other people right now. Maybe in the future though!