Simple and Inexpensive Barcode and Inventory System

This article describes a simple inventory system that has been implemented in Excel and Google Sheets.

On this page:

1. YouTube video link that describes barcoding and the spreadsheet
2. Example screen shots from the video
3. Example usage for supplies and finished product inventory
4. Example usage for a toolbox inventory
5. Example usage for a rental equipment inventory
6. Purchase link

1. YouTube video description: https://youtu.be/GxO2SvlUHj8

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)

2. Example screen shots from the video

3. 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

4. Tool inventory in a toolbox
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

5. 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

6. Purchase link

• Select one of the options below (Spreadsheet only, Spreadsheet plus 1 hour, Spreadsheet plus 2 hours).
• You will be taken to the Superpeer payment screen where you can download the spreadsheet after payment. 
• 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:
  • You can ignore the FAQ on the payment screen where it says "Can I refund or cancel my digital products?" The is Superpeer’s standard FAQ.

Spreadsheet only

Download Simple and Inexpensive Barcode and Inventory Spreadsheet digital product by Neil Potter

A spreadsheet that you can use to: - Define and record SKUs - Generate barcodes - Track items (e.g., products, rental items, company shared equipment) that come in and out It comes as Excel but can be imported to Google Sheets

Superpeer

Spreadsheet plus 1 hour live assistance

Download Spreadsheet plus 1 hour live assistance digital product by Neil Potter

The hour can be used to discuss items such as, the existing problem, barcode generation, or usage of the spreadsheet. Email after purchase to set up a convenient time.

Superpeer

Spreadsheet plus 2 hours live assistance

Download Spreadsheet plus 2 hours live assistance digital product by Neil Potter

The two hours can be used to discuss items such as, the existing problem, barcode generation, or usage of the spreadsheet. Email after purchase to set up a convenient time.

Superpeer