Inventory spreadsheet v4 and v5 (includes Avery 5161 barcode sheet)

Version 5 additional features

• Define up to 2000 SKUs with their descriptions.
• Add Date Needed and Lead Time information.
• Add transaction notes to IN and OUT scans.
• Find SKUs automatically.
• Summarize inventory across 3 separate locations.

Version 4

• Define up to 500 SKUs with their descriptions. 
• Define SKU cost and sales price.
• Define the quantity re-order level — turns red when low.
• Define an item's storage: Location/Aisle/Bay/Shelf.
• Calculate the total inventory cost and sales values.
• Scan items into inventory using a barcode.
• Scan items out of inventory using a barcode.
• Display current quantities and highlight when reorder levels are reached.
• Display a counter to show the most frequently scanned items indicating which might need to be ordered soon.
• Create barcodes with Avery 5161 labels.

It includes the Avery 5161 label sheet and instructions on how to use Avery's website to generate other label sizes.

It comes as an Excel file.

(Does not include barcode scanner, which can be purchased from Amazon).