Combine the Power of Excel and Bar Coding for Inventory Control
Excel has always been a powerful tool for tracking and controlling inventory; however, fast data entry of the inventory transactions has been missing. At last portable bar code readers have been seamlessly integrated with Excel, making inventory control practical.

Worth Data has bridged the gap between portable bar code readers and Excel with KwikCount/EX™, a free Add-In for Excel.

KwikCount/EX imports data from our TriCoder portable bar code readers into an Excel worksheet effortlessly. The portable bar code reader becomes an integral part of Excel.

KwikCount/EX requires:

• Microsoft Excel 2010 for Windows® or later (Including Excel in Office 2019, 2016, 2013, & 2010)


• One or more Worth Data TriCoders


• Shelf or item bar code labels to match the item ID's in Excel worksheet (You can print them with LabelRIGHT™)


• A worksheet with data records arranged in rows

The TriCoder is a battery-powered portable data collector capable of storing over 200,000 item numbers and associated quantities. With the KwikCount/EX software, use the TriCoder to:

• Go to the warehouse shelves and scan and/or key data into its memory.


• Connect to the computer and upload the collected data to your Excel worksheet.

• Add multiple TriCoders to run with the KwikCount/EX software to facilitate multiple inventory counters.

 

After you have collected inventory transactions in the TriCoder Portable Bar Code Reader, attach the TriCoder to your PC and start Excel. Using the KwikCount/EX add-in, you can identify which worksheet columns you wish the TriCoder data to be flowed into. To update existing Excel worksheets, simply designate which field sequence (i.e. the stock number) is the controlling “key” or “Index” field and then link it to the appropriate column in the worksheet.

When the data is downloaded from the TriCoder to Excel, the field identified as the “Index” field is read and that column is searched until matched. Once the “Index field” is matched, KwikCount searches that row and updates the additional field columns according to your linking specifications.

When the data is flowed into the corresponding columns for each field in the same row as the “Index” field, the data is accumulated (ADD), subtracted (SUBTRACT), or overwritten (REPLACE) according to the linking instructions you have specified. Receipts can be added, shipments can be subtracted, new physical counts can be overwritten, or data can be written into a new row.

KwikCount/EX provides the flexibility to control and mange your inventory in whatever way you need within Excel. You can set reorder points, safety stock levels, seasonal adjustments, minimum order quantities, etc., according to your requirements- and with NO PROGRAMMING! Use Excel formulas to create your tailored reports.

You can also use one of our TriCoders equiped with Bluetooth® wireless technology to upload data wirelessly and update a spreadsheet automatically without connecting via a USB cable.

Download KwikCount/EX for free

KwikCount/EX can be used for:

• Physical Inventories
• Perpetual Inventory
• Inventory Management
• Receiving
• Shipping
• Inspection
• Any application where data needs to be collected and updated within Excel®!

KwikCount uses the highly acclaimed TriCoder Portable Reader as an input device, supporting the following interfaces:

• USB HID Keyboard
• Full Speed USB Upload
• CDC Serial USB Com Port

Multiple uploads, using one or more TriCoders are supported, allowing accumulation in the uploads to the worksheet.

Also, if you need to print bar code labels related to your inventory, LabelRIGHT for Windows can print labels based on data exported from your Excel worksheets!

 

 

How To Install KwikCount/EX 4 Excel Add-In:

Using KwikCount/EX with a TriCoder:

How To Install KwikCount/EX 2 Excel Add-In (Older Version):