Audit Unit-Based Inventory

Regular audits are a great tool to help you stay on top of your inventory and ensure your physical quantities in your store match your digital quantities in Green Bits and the state traceability system.

Avoid auditing the entire store without successfully completing a really small audit. 

A small audit will give you an idea of what to expect and will help focus your efforts on a routine that will work best for your store.  

A few things to keep in mind

  • Weight based products and unit based products have to be audited separately.
  • Choose how you will audit. You can audit by Vendor or Product Type but not both. 
  • Save your audits as drafts before submitting your adjustments to the state traceability system. 
  • When you click the Save Adjustments Button, your adjustments will be reported to the state traceability system. 
  • Always run a test audit with a small group of items to ensure that you understand the process. 
  • The Audit Tool was designed to read .txt or .csv files.
  • If auditing all inventory, create multiple separate audits by product type or vendor.
  • Never worry about losing control of your inventory again.

1. Schedule your audit in the Back Office.

Choose whether you would like to audit for a  Product Type or Vendor.

2. On your Ipad - Download Google Docs (FREE!).

3.Put the scanner in HID Mode and pair it with your iPad.

See exactly how to put your scanner in HID mode.  

After putting your scanner in HID mode, you’re ready to scan skus into your document.  

Scan a few items to make sure that the scanner is picking up. If it’s not, try putting the scanner in HID mode again.

4. There are 2 auditing styles.

The Green Bits audit tool works best when weight and unit based products are separate. 

In this article we’ll focus on manual scanning, which is usually best for pre-packaged inventory.  

If there are  multiple skus on the shelf for each product; let the scanners do the work for you. Scan unit based items 1 by 1.

You can also scan the item one time and then perform a hand count.  
Ex. 234567, 10. In this ex the Sku ends in 3335 and the quantity counted is 10.

Once you’re satisfied, save your file as a txt or csv. 

5. Upload the csv to Green Bits.

Select a completed at time and upload your completed txt or csv file to the Auditing Tool.

Click Upload after you attach the file. 

6.Edit before you submit your adjustments

Click the x on any line item you don’t want to adjust, or manually edit any numbers before clicking Save Adjustments. 

Put a 0 in the Adjustment column if you want to keep the item on the audit, but the count for it is accurate. There won't be any change to products you adjust with 0.

The counted column is what you counted, the actual column is what's in your inventory.

The Adjustment number is the difference between the 2.

If you see “Cannot adjust” in the Adjustment column, it means the item doesn’t fit into the category you selected to audit. This can be because the audit is not the correct product type of vendor.

If you click Save Adjustments  and there are mistakes on your audit, you'll need to create a new audit to correct the issue. The audit can't be edited after it has been saved.

Leave a detailed note in the adjustments section. 

 NOTE: These inventory adjustments will be made in both Green Bits and in the state traceability system after you click Save Adjustments. 

**Tips & Tricks**

  • Have a different person count than did it the first time / double eyes for double verification.
  • Audit a different product type every day of the week, repeat weekly.
  • Measure results.
  • Audit weight-based products.

After you’re done with auditing, put your scanner in iOS mode and pair again.

Have more questions? Submit a request


Please sign in to leave a comment.