Analytics
Last updated
Last updated
The Analytics feature in BoxHero helps you generate custom reports from your inventory and sales data. You can create personalized calculations and track key metrics that matter most to you.
Quickly add from our predefined, commonly-used formulas and generate insightful reports.
Use item attributes with numerical values to create formulas.
Total Purchase Amount: Cost x Total Stock In Quantity
Total Sales Amount: Price x Total Stock Out Quantity
Net Profit: Price - Cost
Gross Profit : (Price - Cost) x Total Stock Out Quantity
Profit Rate : (Price - Cost) ÷ Price
Daily Average Profit : (Price x Total Stock Out Quantity ÷ Number of Days
Daily Average Gross Profit : (Price - Cost) x Total Stock Out Quantity ÷ Number of Days
Inventory Asset: Cost x Current Quantity
Inventory Turnover Ratio: Total Stock Out Quantity ÷ Average Quantity in a Period
Average Daily Stock-In Quantity: Total Stock In Quantity ÷ Number of Days
Average Daily Stock-Out Quantity: Total Stock Out Quantity ÷ Number of Days
Reorder Check : if(Current Quantity < Safety Stock, "Reorder Needed", "-")
Stock-Out Estimate in Days: Current Quantity ÷ (Total Stock Out Quantity ÷ Number of Days)
When updating item costs or prices, be aware that Analytics calculations use current values. For historical accuracy, consider using the Purchase & Sales feature or exporting data regularly.
Create unique formulas that meet your needs using BoxHero’s variables and functions.
Enter $ to access inventory variables and {{ to retrieve saved attributes/values.
Current Quantity
The current inventory level of items.
Number of Days
The number of days in the analysis period.
Average Quantity in a Period
Average inventory during the analysis period, calculated using the inventory quantity at 23:59:59 each day.
Initial Quantity in a Period
Inventory at the start of the analysis period (i.e. 23:59:59 on the day prior to the start date for the selected period).
Final Quantity in a Period
Inventory at the end of the analysis period (i.e. 23:59:59 on the last day of the selected period).
Total Stock-In Quantity
Total inbound quantity.
Stock-In Frequency
The number of times an inbound transaction was made during a specific period.
Total Stock-Out Quantity
Total outbound quantity.
Weighted Stock-Out Average (linear: 2, 3, 4)
Calculates the weighted average of daily outgoing quantities, giving more importance to recent data. Each day in the selected period gets a weight, with the weight increasing linearly each day. Daily stock-out quantities are multiplied by their weights, and the sum of these weighted quantities is divided by the sum of the weights. The linear weighting includes three options:
Linear weight 2: Oldest day has weight 1, most recent day has weight 2
Linear weight 3: Oldest day has weight 1, most recent day has weight 3
Linear weight 4: Oldest day has weight 1, most recent day has weight 4
Stock-Out Frequency
The number of times an outbound transaction was made during a specific period.
Variation Quantity from Adjust
The difference in inventory quantity from using the Adjust menu (i.e. Increased Quantity - Decreased Quantity)
Decrease Quantity from Adjust
The decrease in quantity from using the Adjust menu.
Increase Quantity from Adjust
The increase in quantity from using the Adjust menu.
Adjust Frequency
The number of times an Adjust transaction was made during a specific period.
Variation Quantity from Move
The difference in inventory quantity from using the Move menu (i.e. Increased Quantity - Decreased Quantity)
Decrease Quantity from Move
The decrease in quantity from by using the Move menu.
Increase Quantity from Move
The increase in quantity from by using the Move menu.
Move-Out Frequency
The number of times a Move transactions were was made to decrease the overall inventory level.
Move-In Frequency
The number of times a Move transactions were was made to increase the overall inventory level.
BoxHero supports a variety of functions that are similar to Excel for creating custom formulas.
Basic arithmetic: +, -, *, /
Conditional: if(condition, value_if_true, value_if_false)
Rounding:
round: round(number, decimal_places)
roundUp: roundUp(number, decimal_places)
roundDown: roundDown(number, decimal_places)
Type Conversion:
toNumber: toNumber(string, fallback_number)
String to be converted into a numeric value, Number to show when conversion fails
toString: toString(number)
Number to be converted into a string
Pro Tip: Use weighted averages for more nuanced trend analysis and combine formulas to create complex metrics by nesting functions with variables.
To calculate the total value of your inventory, navigate to Reports > Analytics and click the blue Formula Settings button on the top right. Add a Formula and go to Easy Add > Inventory Management and click Inventory Asset.
Please note that this formula calculates the inventory value using the item’s cost.
Yes! To find your total sales value, go to the Analytics menu and add a formula by clicking Easy Add > Sales Management > Total Sales Amount. This will display the total value of your sales in the Analytics dashboard.
Use the Reorder Check formula in the Inventory Management section. This will flag items when their quantity falls below the set safety stock level.
When you update the cost or price of an item in BoxHero, the previous values are not retained. Reports generated in the Analytics menu will reflect calculations based on the current cost and price, which may differ from your historical cost and price data.
To maintain records of past transactions, we recommend exporting your reports or documenting these changes separately. Alternatively, you can use BoxHero’s Purchase & Sales feature to record the cost and price at the time of each transaction.
Need more help? Contact our support team for detailed guidance on creating custom formulas.
