# Inventory Reports
*** ## Inventory Reports Overview In the sidebar, go to **`Reports`** > **`Inventory`**. You can adjust formula settings to analyze your inventory data, filter results by location or date range, and export reports to Excel for recordkeeping and analysis.
### A. Quick Add Quickly add from our predefined, commonly-used formulas and generate insightful reports. {% embed url="" %} #### Item Attributes You can use [attributes](https://www.boxhero.io/docs/data-center/attributes) with numerical values to create formulas. #### Sales & Profit * **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 & Movement** * **Inventory Value**: Cost x Current Quantity * **Inventory Turnover Ratio**: Total Stock Out Quantity ÷ Average Quantity in a Period * **Average Daily Stock In**: Total Stock In Quantity ÷ Number of Days * **Average Daily Stock Out**: Total Stock Out Quantity ÷ Number of Days * **Reorder Status**: if(Current Quantity < Safety Stock, "Reorder Needed", "-") * **Stockout Forecast in Days**: Current Quantity ÷ (Total Stock Out Quantity ÷ Number of Days)
{% hint style="warning" %} When updating item costs or prices, be aware that **`Reports`** calculations use *current* values. For historical accuracy, consider using the **`Purchases & Sales`** feature or exporting data regularly. {% endhint %} ### B. 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 NameDescription
Current QuantityThe current inventory level of items.
Number of DaysThe number of days in the analysis period.
Average Quantity in a PeriodAverage inventory during the analysis period, calculated using the inventory quantity at 23:59:59 each day.
Initial Quantity in a PeriodInventory 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 PeriodInventory at the end of the analysis period (i.e. 23:59:59 on the last day of the selected period).
Total Stock-In QuantityTotal inbound quantity.
Stock-In FrequencyThe number of times an inbound transaction was made during a specific period.
Total Stock-Out QuantityTotal 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 FrequencyThe number of times an outbound transaction was made during a specific period.
Variation Quantity from AdjustThe difference in inventory quantity from using the Adjust menu (i.e. Increased Quantity - Decreased Quantity)
Decrease Quantity from AdjustThe decrease in quantity from using the Adjust menu.
Increase Quantity from AdjustThe increase in quantity from using the Adjust menu.
Adjust FrequencyThe number of times an Adjust transaction was made during a specific period.
Variation Quantity from MoveThe difference in inventory quantity from using the Move menu (i.e. Increased Quantity - Decreased Quantity)
Decrease Quantity from MoveThe decrease in quantity from by using the Move menu.
Increase Quantity from MoveThe increase in quantity from by using the Move menu.
Move-Out FrequencyThe number of times a Move transactions were was made to decrease the overall inventory level.
Move-In FrequencyThe number of times a Move transactions were was made to increase the overall inventory level.
{% hint style="success" %} **Pro Tip**: Use *weighted averages* for more nuanced trend analysis and *combine formulas* to create complex metrics by nesting functions with variables. {% endhint %} ### 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
{% hint style="info" %} Variables and functions not available in **`Inventory Reports`** can be used in [Custom Analytics](https://www.boxhero.io/docs/other-features/custom-analytics). {% endhint %} *** ## Frequently Asked Questions (FAQ) ### How can I calculate my total inventory value? To calculate the total value of your inventory: 1. Navigate to **`Reports`** > **`Inventory`**. 2. Click the blue **`Formula Settings`** button in the top right. 3. Add a Formula and go to **`Quick Add`** > **`Inventory Movement`**. 4. Select **`Inventory Value`**. \* Please note that this formula calculates the inventory value using the item’s *cost*.

To calculate the inventory value for a specific date or time frame, please filter by date and location.

### Will deleted items still appear in my inventory report? Only items currently registered in your BoxHero team appear in the report. ### How can I monitor items that need restocking? Use the **`Reorder Status`** formula in the **`Inventory & Movement`** 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 **`Inventory Reports`** 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 **`Purchases & Sales`** feature to record the cost and price at the time of *each* transaction. ### I can’t find the data I’m looking for in my inventory report. In this case, you can use **`Custom Analytics`** feature to select the fields you need and create your own calculations for inventory metrics.