Mango Report
Help Center
Search:
Contents
:
IndexBookmarkPrint

Home > Excel Reports > Fiscal Shrinkage

Fiscal Shrinkage - Excel Workbook

This workbook shows SKU-level net shrinkage for your store's fiscal period (usually Jan - Dec). It is separated into three worksheets: Fiscal (Adjusted), Excluded and Defective. 

 

This report can be found in your Online Reports -> Store Folder -> Excel Folder.


Tips for processing this worksheet:

  1.  Look at the Fiscal Shrink tab. 
  2. Try to resolve shrinkage beyond $100 (both shrink and swell).
  3. You can filter on a SKU's class to see net shrinkage for the class. many times there is offsetting shrink/swell within a class.
  4. Reverse significant shrinkage at its source. Create a PO if the SKU was not received or fix the SKU at point of sale if it was rung in error.
  5. Try to resolve the root issue of large shrinkage.  To classify shrinkage you would rather exclude (such as live goods, lumber, etc.) please follow this link.

 

Fiscal Shrink Tab - these SKUs contribute to your shrink key metric as seen on your Charts and Key Metrics reports. This is measuring impactful uncontrolled shrinkage likely triggering a reorder event.

Excluded Tab - these SKUs exhibited financial shrinkage but were likely mitigated with offsetting with dump SKU sales (fasteners, bulk) or was otherwise controlled (Store Closeout, Store Supply) and therefore is not likely theft.

Defective Tab - this is a special class of shrinkage where vendor credits are likely booked against the shrinkage loss and therefore called out as a separate class of shrinkage.

     Column Definitions