Inventory, cogs and stock tracking help for handmade sellers.
The sudden announcement last week that Square Inc. was acquiring and shutting down the popular inventory management software Stitchlabs, has sent many people looking for a suitable alternative for their inventory management needs.
This post covers how to use the Handmade Seller Spreadsheet. This spreadsheet is designed to be a simple, periodic excel based system that will help you understand the fundamentals of inventory tracking and encourage good stock tracking habits.
Studying your discrepancies is a hugely important part of the stocktake process as it allows you to gain more knowledge about your production processes. Only with this knowledge in hand can you begin to make improvements to your process, your products and your bottom line.
As a handmade seller, it is really important to know exactly where your materials are at any point in time. To do this, you'll need to create a good system for labelling each of your materials - we discuss how you can achieve this.
Drops are are a really common way to measure small amounts of certain materials, especially for those creating soap or fragrances. A drop is however not a standard measurement unit which can be problematic when attempting to track your inventory correctly.
Some small manufacturers start tracking lot numbers using written logs and excel spreadsheets, however as the exact relationship between purchases, manufactures and orders can be quite complex, the use of a spreadsheet can lead to errors and inconsistencies as your business grows.
We ♥ to help handmade sellers just like you to become more successful. Please join our newsletter to receive regular updates and actionable tips on how to take your maker business to the next level!