Inventory Audit with Smartphones and Tablets

[Note: Also see Asset Tracking – Asset Audits.]

Most companies need to audit their inventory on a periodic basis. Our codeREADr app with our Inventory Audit’ Google Sheets Add-On can help you more accurately count, analyse and update your inventory electronically.

Master List
You start with a simple, prepared list of each item’s Barcode (required), Description (optional) and Quantity (optional). You paste that list into our Sheets add-on.

Import to codeREADr
In our Sheets add-on you can export a CSV file specifically structured for use with the codeREADr app.

Count Inventory Use the codeREADr app to scan your item’s barcodes and enter the item’s quantities. If there’s only one item per scan then that can be auto-entered.

Expected vs. Actual
After each scan your app-users can compare the expected quantity to the actual quantity on hand. In this way if the count is off significantly then the app user can recount to be sure.

Auto-Insert to Google Sheets
Your app-user’s scan records will be automatically inserted into the Sheets add-on.

Audit Worksheet
The add-on’s worksheet automatically calculates the difference between the expected quantity and then actual quantity. You can accept the new count or recount and then accept. Once accepted, individually or in bulk, the new quantity becomes the new quantity on the Master list.

<<<  This add-on is currently in beta release. Once it’s been fully vetted we will publish it on Google Sheets. Please download the instructions here. For beta users we give you free use of codeREADr for a month (up to 5 devices, normally $44.95). Please email to request free access. >>>

in Best Practices with Instructions