Skip to main content

How do I use the Inventory Audit Report?

Helen Kang avatar
Written by Helen Kang
Updated over 2 weeks ago

The Inventory Audit Report surfaces details on inventory changes.

This report is useful for:

  • Viewing all transactions impacting inventory levels for the chosen time frame.

  • Viewing the reason for the inventory level change, when available.

  • Viewing who is responsible for the inventory update.

Pulling up the Report

  1. Navigate to Reports from the left panel > Inventory > Inventory Audit Report > View.

  2. Specify the date range from the date picker.

  3. Apply any additional filters.

    • Filter options:

      • Product Type: The category of items sold (e.g., Clothing)

      • Location: Where the inventory is set

      • Reason for Change: This will include all the items for positive and negative inventory changes - note that “no reason” is not an option to filter

  4. Select Generate Report and, if necessary, export the data.

Understanding the Report

The Inventory Audit Report includes:

  1. Product Type: Classification of product.

  2. Product: Name of product.

  3. Variant Color: Variant color, if any.

  4. Variant Size: Variant size, if any.

    • Each variant will populate its own row.

  5. Location: Where the inventory is set.

  6. Adjustment Amount: The negative or positive numerical change in inventory number.

  7. Reason for Change: Other than when a product is sold, the reason for the change is an optional entry when adjusting inventory. When available, the reason for the change will be noted.

    • Positive change reasons: Found, Purchase, Transfer, Restock, Shipping Discrepancy

    • Negative change reasons: Damaged, Shrink, Internal Use, Transfer, Sale

  8. Broker: Name of the employee who made the inventory change.

  9. Broker ID: Mariana Tek ID of the employee who made the inventory change.

  10. Broker Email: Email of the employee who made the inventory change.

  11. Transaction Day: Date of inventory change.

  12. Transaction Time: Time of inventory change.

  13. Barcode: Barcode associated with the product.

  14. SKU: Stock keeping unit number associated with the product.

  15. Product ID: ID of sold product (Parent ID)

  16. Variant ID: ID of the product variant (Child ID)

    1. This data will never change and is one number higher than the Product ID.

Did this answer your question?