This article describes a simple inventory system that has been implemented in Excel and Google Sheets.
"Discovering this inventory system has been a lifesaver for our small business. It will allow us to track our inventory in a simplistic and inexpensive way, without having to pay for expensive subscriptions that are not practical for our budget. Neil has been wonderful to work with and will help you every step of the way. I highly recommend!"
-- Catherine Brooks, Brooks Optical, VA
On this page
- YouTube video link that describes barcoding and the spreadsheet
- Example screen shots from the video
- Example usage for supplies and finished product inventory
- Example usage for toolbox inventory
- Example usage for a rental equipment inventory
- Purchase links and other label formats
YouTube video description
This video describes a simple spreadsheet inventory system. It covers how to:
- Define and record SKUs
- Generate barcodes
- Track products purchased and sold
- Track rental items you have in stock and what is incoming and outgoing
- Track company shared resources (tools and equipment)
Example screen shots from the video
Example usage for supplies and finished product inventory
The inventory sheet is used to track supplies and finished products. Supplies and finished products both have their own SKUs.
- INcoming list = Supplies on-hand and finished items (both listed by unique SKUs)
- Supplies are added to inventory when they are purchased
- A finished product is scanned in when it is ready for sale
- OUTgoing list = Supplies that are consumed, and finished items when sold.
- For efficiency, scanning could be done one time at the beginning of a production run. E.g., You make 10 products per day, scan out the components with -10 as the count. When the final products are finished, scan in to inventory the final product label with +10
- This approach maintains visibility of component inventory and the final product
Example usage for toolbox inventory
The inventory sheet is used to track tools in a toolbox. Each tool is either present or lost/broken. If there are many toolboxes, make a copy of the inventory tab for each toolbox.
INcoming list = Initial tools in the toolbox
OUTgoing list = Tools that are broken or missing
Type = Missing/broken
Example usage for rental equipment inventory
The inventory sheet is used to track rental equipment. In this example Rental Item 2 is lost/broken (on the OUTgoing sheet) and is then replaced on the INcoming sheet.
INcoming list = Equipment on hand in the store
OUTgoing list = Equipment rented out OR lost/broken
Type = Rented
Type = Missing/broken
Purchase links and other label formats
Use the link below to purchase the spreadsheet and any additional help.
Purchase link for the spreadsheet and the option for 1 or 2 hours assistance
Purchasing notes
- Select the first link "Inventory spreadsheet" to purchase and spreadsheet and any additional assistance. Select the second link "Live Assistance" if you just need help before or after purchasing the spreadsheet.
- You will be taken to the Gumroad payment screen where you can download the spreadsheet after payment.
- Set the tip to 0% (unless you really like me).
- If you purchase help, I will contact you to set up a time using the email you provide on the payment screen.
- 100% refund if not satisfied.
- If you would like different label sizes, try this free site: (http://app.print.avery.com) which allows you to create PDF label sheets based with different Avery labels. Some common ones for barcodes are Presta 94749 and Presta 94220. Feel free to contact me if you have questions.
