Analytics

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.

Easy Add

Quickly add from our predefined, commonly-used formulas and generate insightful reports.

Attribute

Use item attributes with numerical values to create formulas.

Sales Management

  • 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 Management

  • 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)

Calculate Inventory Turnover Ratio using BoxHero's predefined formula

Custom Formula

Create unique formulas that meet your needs using BoxHero’s variables and functions.

Autocomplete Variables

Enter $ to access inventory variables and {{ to retrieve saved attributes/values.

Variable Name
Description

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.

Available Functions

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


Frequently Asked Questions (FAQ)

How can I calculate my total inventory value?

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.

To calculate the Inventory Asset value for a specific date or time frame, please filter by date (and by location, if applicable).

Can I track the total value of my sales?

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.

How can I monitor items that need restocking?

Use the Reorder Check formula in the Inventory Management section. This will flag items when their quantity falls below the set safety stock level.

What happens when I update the cost or price of an item?

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.

Last updated