Welcome to the Help Center

Inventory Report

This report shows the current inventory level of each SKU. 

Things to know:

  • Only stocked products are listed in the report.
  • Status is based on the "Min" level set from POS > Inventory.

To access this report:

  1. Navigate to Dashboard

  2. Select the Reports tab

  3. Under the Point Of Sale section, select the Inventory report

11858308-78f9187bae69afd553b3e3a1b0eca4ee.png

When the report opens, you can filter by a specific location. If the By Location button is used at the top of the report, you will be able to easily compare metrics across locations and location groupings to see which locations are doing better or worse on that dimension.   

You also have the ability to export to Excel, PDF, or print.

11185093-8665c18de5acce72bb5a7ec3bdb17f36__1___1_.png

Once you have selected your filters, click on the UPDATE button to generate the desired data.

11910149-5387f1432d39dd4852100d57d294c2e5.png

Report Columns

Column Description
Brand Brand of the product.
Product The full name of the SKU.
SKU # The product ID used by your wholesaler or distributor. 
Cost Basis

The price paid to the vendor for the SKU. If an SKU has multiple shipments, the cost basis will be calculated as the total cost value of all shipments/quantity of all shipments.

Example:

Cost Basis Retail Quantity/Stock Back bar Quantity/Stock Total Cost
$6 9 0 $54
$8 2 0 $16
Total 11 0 $70
 

 

Total cost basis = Total cost / Total quantity

70 / 11 = $6.36

Retail Price The price paid by the client for the SKU.
Vendor The supplier of the product.
Retail Stock  The total retail quantity of the product on hand.
Back Bar Stock The total back bar quantity of the product on hand.
Cost Value Total retail and back bar stock x cost basis
Retail Value Total retail stock x retail price
Min The quantity at which you want to be alerted to re-order on MyTime.
Max The quantity of each SKU you want to maintain. This is used to calculate the reorder
amount. 
Reorder

The quantity level at which you need to reorder the product.

Reorder = Max - Current Retail & Back Bar Quantity OR 0 if total quantity > max

Example:

Max = 4

Retail Stock = 2

Backbar Stock = 1

Reorder = 4 - (2 + 1) = 1

 

Status

Indicates whether a product needs to be replenished.

Example:

The alert threshold (Min) is 5.

If the retail/back bar quantity =/< 0, status is OUT

If the retail/back bar quantity < alert threshold (Min), status is LOW

Otherwise, the status is OK

 
Powered by Zendesk