# Inventory Reports

<figure><img src="/files/Lyr6cDKXKa6iYtez1gIu" alt=""><figcaption></figcaption></figure>

***

## Inventory Reports Overview

In the sidebar, go to <mark style="color:blue;">**`Reports`**</mark> > <mark style="color:blue;">**`Inventory`**</mark>.

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.

<figure><img src="/files/gh3gWyb593fL1wF19rGg" alt=""><figcaption></figcaption></figure>

### A. Quick Add

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

{% embed url="<https://customer-0jrbilsa8yt3k758.cloudflarestream.com/75a44bd8bef54f0eaffffe6c74fc86e7/iframe?autoplay=true&controls=false&letterboxColor=transparent&loop=true&muted=true&poster=https://customer-0jrbilsa8yt3k758.cloudflarestream.com/75a44bd8bef54f0eaffffe6c74fc86e7/thumbnails/thumbnail.jpg?height=1080&preload=true>" %}

#### Item Attributes

You can use [attributes](/docs/concepts/attributes.md) 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)

<figure><img src="/files/3rN0AkgXCRjDU8pLntPf" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
When updating item costs or prices, be aware that <mark style="color:blue;">**`Reports`**</mark> calculations use *current* values. For historical accuracy, consider using the <mark style="color:blue;">**`Purchases & Sales`**</mark> feature or exporting data regularly.
{% endhint %}

### B. Custom Formula

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

<figure><img src="/files/IYvvexe75YFr3jrj4B2R" alt=""><figcaption></figcaption></figure>

### Autocomplete Variables

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

<table><thead><tr><th width="209">Variable Name</th><th>Description</th></tr></thead><tbody><tr><td><strong>Current Quantity</strong></td><td>The current inventory level of items.</td></tr><tr><td><strong>Number of Days</strong></td><td>The number of days in the analysis period.</td></tr><tr><td><strong>Average Quantity in a Period</strong></td><td>Average inventory during the analysis period, calculated using the inventory quantity at 23:59:59 each day.</td></tr><tr><td><strong>Initial Quantity in a Period</strong></td><td>Inventory at the start of the analysis period (i.e. 23:59:59 on the <em>day prior to the start date</em> for the selected period).</td></tr><tr><td><strong>Final Quantity in a Period</strong></td><td>Inventory at the end of the analysis period (i.e. 23:59:59 on the <em>last day</em> of the selected period).</td></tr><tr><td><strong>Total Stock-In Quantity</strong></td><td>Total inbound quantity.</td></tr><tr><td><strong>Stock-In Frequency</strong></td><td>The number of times an inbound transaction was made during a specific period.</td></tr><tr><td><strong>Total Stock-Out Quantity</strong></td><td>Total outbound quantity.</td></tr><tr><td><strong>Weighted Stock-Out Average (linear: 2, 3, 4)</strong></td><td><p>Calculates the weighted average of daily outgoing quantities, giving more importance to <em>recent</em> 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:</p><ul><li>Linear weight 2: Oldest day has weight 1, most recent day has weight 2</li><li>Linear weight 3: Oldest day has weight 1, most recent day has weight 3</li><li>Linear weight 4: Oldest day has weight 1, most recent day has weight 4</li></ul></td></tr><tr><td><strong>Stock-Out Frequency</strong></td><td>The number of times an outbound transaction was made during a specific period.</td></tr><tr><td><strong>Variation Quantity from Adjust</strong></td><td>The difference in inventory quantity from using the <strong>Adjust</strong> menu (i.e. Increased Quantity - Decreased Quantity)</td></tr><tr><td><strong>Decrease Quantity from Adjust</strong></td><td>The decrease in quantity from using the <strong>Adjust</strong> menu.</td></tr><tr><td><strong>Increase Quantity from Adjust</strong></td><td>The increase in quantity from using the <strong>Adjust</strong> menu.</td></tr><tr><td><strong>Adjust Frequency</strong></td><td>The number of times an <strong>Adjust</strong> transaction was made during a specific period.</td></tr><tr><td><strong>Variation Quantity from Move</strong></td><td>The difference in inventory quantity from using the <strong>Move</strong> menu (i.e. Increased Quantity - Decreased Quantity)</td></tr><tr><td><strong>Decrease Quantity from Move</strong></td><td>The decrease in quantity from by using the <strong>Move</strong> menu.</td></tr><tr><td><strong>Increase Quantity from Move</strong></td><td>The increase in quantity from by using the <strong>Move</strong> menu.</td></tr><tr><td><strong>Move-Out Frequency</strong></td><td>The number of times a <strong>Move</strong> transactions were was made to decrease the overall inventory level.</td></tr><tr><td><strong>Move-In Frequency</strong></td><td>The number of times a <strong>Move</strong> transactions were was made to increase the overall inventory level.</td></tr></tbody></table>

{% 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

<figure><img src="/files/nbyifvJKuMqM2ZR8Nqm6" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Variables and functions not available in <mark style="color:blue;">**`Inventory Reports`**</mark> can be used in [Custom Analytics](/docs/other-features/custom-analytics.md).
{% endhint %}

***

**Looking for more info?** Browse our FAQ:

{% content-ref url="/spaces/mkYNU2xLl20GSI6NQQ6q/pages/HABeINmjzAqEWNjoxMLv" %}
[Inventory reports](/docs/faq/reporting/inventory-reports.md)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://www.boxhero.io/docs/other-features/analytics.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.