Understanding Cost Valuation on Inventory Dashboard

josephmckeownjosephmckeown Moderator, Lightspeed Staff Posts: 66 moderator
edited February 5 in Reporting & Analytics

Sometimes we'll notice variance between the Inventory levels displayed on the Dashboard.

The single-digit number tells us one valuation:


...and the Shop-Inventory Breakdown references another:

How can we tell which one to use?

The answer depends then on the question you're trying to answer. This is how to go about understanding the reason behind the different numbers.


The Single Digit Cost

If we explore the preparation of the single-digit calculation:


we'll see that two filters are applied to calculate the displayed cost:

Item Archived is equal to "No" (meaning that Archived items are not contributing the value of Inventory)

and

Item Metrics is Included is "Yes" (meaning that Inventory you wish not to include may be omitted)

If you wish to select certain categories to include in or omit from Inventory valuation, you can define this in your Analytics configuration.

The Shop Inventory Breakdown Cost

If we do the same thing for the Shop Inventory Breakdown Cost,


...we'll notice slightly different filters being applied:

...we get the same filter for "Include Archived"

but we also see a filters for

Quantity on Hand is greater than 0 (meaning that all negative inventory values are not included)

and

Top Level Category is not Labor or Null (meaning that Labor items are not included, and products without Categories are not included)


Reporting Intentions: Single Digit and Shop Breakdown

So the question of which number to use depends very much on what the question is. This is a simple way of considering the meaning within each number.

The intention of the Shop Breakdown valuation is to illustrate the current whole valuation of Inventory by category by store. This is primarily for control reasons, upon which, the next actions may be:

  • Determining if additional inventory from a category is needed
  • Determining if any inventory can/should be transferred
  • If any Stores warrant specific attention for Dusty analysis

etc...

The intention of the Single-Digit number is to illustrate a para-store valuation of assets including liabilities. This means, items with negative inventory will be included (therefore deducted) in the valuation.

This is primarily for assessment of assets and accounting reasons, upon which, the next actions may be:

  • Determining the overall valuation of inventory
  • Monitoring dusty-to-whole analysis

etc...


Next Steps: Using both Numbers

There are therefore two valuable questions that you can consider when observing variance between the single-digit and Shop Breakdown valuations:

1st) Is it possible that some items do not have Categories assigned to them?

To test this, you can run the Uncategorized Inventory report, which looks at recently sold items that have no category assigned to them.

2nd) Is is possible that there are some items unexpectedly with negative inventory?

To test this, we could open the Low Stock Alerts report, but change the filters for "Quantity on Hand is greater than 0" to "Quantity on Hand is less than 0"

...and by removing the filter for "Days to Sell out" completely.


Having the full spectrum of numbers makes it easier for us to see trends, find patters, notice action points, and position our stores for success!


Calculation Home

Joseph McKeown
Lightspeed Analytics and reporting consultant
Lightspeed HQ
Sign In or Register to comment.