> For the complete documentation index, see [llms.txt](https://www.boxhero.io/docs/llms.txt). Every page is available as Markdown by appending `.md` to its URL; this page is [Markdown](https://www.boxhero.io/docs/other-features/analytics.md).

# Inventory Reports

> Add formulas to Inventory Reports to calculate custom metrics from your inventory and sales data, and track the numbers that matter most to you.

![](https://assets.boxhero.io/docs/images/2bc5535f1c8c4c2935cce50d6e04fad600c0e0ffd515f1c97e9ebf840bc68928-1600x940.png)

---

## 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.

![](https://assets.boxhero.io/docs/images/f2ae1f3a5b96f74e8208a8c66b438cf714947165215da06b6f7f8e8a9e899303-2800x1549.jpg)

> **Caution**
>
> **Inventory reports use each item's** **_current_** **cost and price**, not the values at the time of the transaction. If you change an item's price, past reports will recalculate using the new price. For point-in-time accuracy, use `Purchases & Sales` or export regularly.

## Add Formula

To add a formula, click `Formula Settings` > `Add Formula`. You'll have two options:

- **Quick Add** — pick from ready-made formulas for common metrics like profit, turnover, and more. No setup required.
- **Custom Formula** — build your own from BoxHero's variables and functions. Use it for metrics we don't offer, or to combine your own item attributes with inventory data.

![](https://assets.boxhero.io/docs/images/563058490a16c780dc770de075ba30097b545c93d9d44f508e84ff8684c01367-2492x1243.jpg)

### A. Quick Add

Add a ready-made formula and start reporting immediately.

![](https://assets.boxhero.io/docs/images/81cea997afbf32e958de9dde626184cf6b71fb0eb1b0926f80f53f84f8fa8f29-2800x1759.jpg)

#### Attributes

You can use item [attributes](https://www.boxhero.io/docs/concepts/attributes.md) with numerical values to create formulas.

#### Sales & Profit

- **Cost**: The cost set in the item's details.

- **Price**: The selling price set in the item's details.

- **Total Cost**: `Cost × Total Stock In`

  - _The total cost of all stock received during the selected period._

- **Revenue**: `Price × Total Stock Out`

  - _The total sales value of all stock shipped during the selected period._

- **Unit Profit**: `Price - Cost`

  - _Profit per unit._

- **Gross Profit**: `(Price - Cost) × Total Stock Out`

  - _Total profit from everything sold during the selected period._

- **Margin %**: `(Price - Cost) ÷ Price`

  - _The percentage of the selling price that is profit._

- **Avg. Daily Revenue**: `(Price × Total Stock Out) ÷ Days in Period`

- **Avg. Daily Profit**: `(Price - Cost) × Total Stock Out ÷ Days in Period`

#### Inventory & Movement

- **Current Stock**: The quantity you have on hand right now.

- **Average Stock**: The average quantity you had on hand during the selected period.

- **Inventory Value**: `Cost × Current Stock`

  - _The total value of the stock you have on hand right now._

- **Turnover**: `Total Stock Out ÷ Average Stock`

  - _How many times you sold through your average stock during the selected period. Higher means faster-moving inventory._

- **Total Stock In**: The total quantity received during the selected period.

- **Avg. Daily Stock In**: `Total Stock In ÷ Days in Period`

- **Total Stock Out**: The total quantity shipped during the selected period.

- **Avg. Daily Stock Out**: `Total Stock Out ÷ Days in Period`

- **Adjust Qty (Net):** Quantity adjusted _up_ minus quantity adjusted _down_ during the selected period.

- **Move Qty (Net):** Quantity moved _in_ minus total moved _out_ during the selected period.

- **Days of Stock**: `Current Stock ÷ (Total Stock Out ÷ Days in Period)`

  - _How many days your current stock will last, based on average daily stock out. Use it to time reorders._

### B. Custom Formula

Build your own formula from BoxHero's variables and functions.

![](https://assets.boxhero.io/docs/images/b03d9de8ca62a119d3f0a146730b8e3b36dc44a7248a3017193050d8454c5557-2788x1383.jpg)

#### Autocomplete Variables

Enter `$` to access inventory variables and `{{` to retrieve saved attributes or the results of other formulas.

![](https://assets.boxhero.io/docs/images/cad03ae9e65cf4c581510336a489822b0798bf7d7ebe615d100735867a7719fe-2522x1577.jpg)

| Variable Name | Description |
| --- | --- |
| **Current Stock** | The quantity on hand right now. |
| **Days in Period** | The number of days in the selected period. |
| **Average Stock** | Average stock during the selected period, based on the quantity at 23:59:59 each day. |
| **Starting Stock** | Stock at the start of the selected period (23:59:59 on the _day before_ the start date). |
| **Ending Stock** | Stock at the end of the selected period (23:59:59 on the _last day_ of the period). |
| **Total Stock In** | The total quantity received during the selected period. |
| **Stock In Count** | The number of **Stock In** transactions during the selected period. |
| **Total Stock Out** | The total quantity shipped out during the selected period. |
| **Stock Out Count** | The number of **Stock Out** transactions during the selected period. |
| **Weighted Avg. Stock Out (Linear 2, 3, 4)** | Average daily stock out, weighted so recent days count more. Each day in the selected period gets a weight that increases linearly, with the oldest day always weighted 1. The number sets the weight of the most recent day — 2, 3, or 4 — so a higher number makes the average more responsive to recent activity. - **Linear 2**: Oldest day has weight 1, most recent day has weight 2 - **Linear 3**: Oldest day has weight 1, most recent day has weight 3 - **Linear 4**: Oldest day has weight 1, most recent day has weight 4 |
| **Adjust Qty (Up)** | Quantity added by **Adjust Stock** transactions. |
| **Adjust Qty (Down)** | Quantity removed by **Adjust Stock** transactions. |
| **Adjust Qty (Net)** | Adjust Qty (Up) − Adjust Qty (Down). |
| **Adjust Count** | The number of **Adjust** transactions during the selected period. |
| **Move Qty (In)** | Quantity moved _into_ the selected location(s) by **Move Stock** transactions. |
| **Move Qty (Out)** | Quantity moved _out of_ the selected location(s) by **Move Stock** transactions. |
| **Move Qty (Net)** | Move Qty (In) − Move Qty (Out). |
| **Move In Count** | The number of **Move Stock** transactions that moved stock _into_ the selected location(s). |
| **Move Out Count** | The number of **Move Stock** transactions that moved stock _out of_ the selected location(s). |

#### Available Functions

BoxHero supports a variety of functions, similar to their Excel equivalents.

![](https://assets.boxhero.io/docs/images/85f25a6d0b3839f4c08b27586cbd2809d226454fe49ab3adafb80728fa442af3-2268x1281.jpg)

- **Basic arithmetic:** `+`, `-`, `*`, `/`

- **Conditional**: `if(condition, value if true, value if false)`

  - Evaluates a condition and returns one value if it's true, another if it's false.

- **Rounding:**

  - **round**: `round(number, digit)`
  - **roundUp**: `roundUp(number, digit)`
  - **roundDown**: `roundDown(number, digit)`

- **Type Conversion:**

  - **toNumber**: `toNumber(string, fallback value)`

    - Converts text to a number, returning the fallback if conversion fails.

  - **toString**: `toString(number)`

    - Converts a number to text.

![](https://assets.boxhero.io/docs/images/ddddf41866013691b83cfd93f716a00c7324a26a00a1cb0c466b3ebc09f09af2-2264x1283.jpg)

> **Tip**
>
> **Need something else?** [`Custom Analytics`](https://www.boxhero.io/docs/other-features/custom-analytics.md) lets you query your inventory data directly with SQL. Use it for questions that don't fit a per-item formula.

---

## Frequently Asked Questions

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

- [Inventory reports](https://www.boxhero.io/docs/faq/reporting/inventory-reports.md)
