# Stock Balance Report

Use the **Stock Balance** report to review the quantity and value of stock for a selected date range. You can review totals by item and warehouse, or split the results by inventory dimensions such as **Warehouse Bin**.

## Before you start

Make sure that:

* You have access to the **Stock Balance** report.
* The correct company, items, warehouses, and dates are available.
* Stock transactions for the period are submitted.
* Warehouse bins are set up if you need bin-level results.

The report is read-only. It does not change stock quantities or values.

## Open the Stock Balance report


1. Open the **Stock** workspace.
2. Select **Stock Balance**.
3. Confirm the company and report dates.

## Set the report scope

Use the filters to limit the report to the stock that you want to review.

| Filter | Use |
|--------|-----|
| **Company** | Select the company that owns the stock. |
| **From Date** | Set the start of the movement period. |
| **To Date** | Set the date for the closing balance. |
| **Item Group** | Limit the results to an item group. |
| **Items** | Select one or more items. |
| **Warehouses** | Select one or more warehouses. |
| **Warehouse Type** | Limit the results to warehouses of one type. |
| **Valuation Field Type** | Show value fields as currency or numbers. |
| **Include UOM** | Add quantities in another unit of measure. |
| **Show Variant Attributes** | Add item variant details to the results. |
| **Show Stock Ageing Data** | Add stock age and age ranges. |
| **Ignore Closing Balance** | Calculate the opening balance from ledger entries instead of a closing balance record. Use this only when you need to investigate a difference. |
| **Include Zero Stock Items** | Include items that have a zero balance. |
| **Show Dimension Wise Stock** | Split the results by configured inventory dimensions. This also shows dimension filters such as **Warehouse Bin**. |

Select **Generate New Report**. When a prepared result already exists, select **Rebuild** to refresh it.

 ![Stock Balance report with filters and result columns](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC9iZTdhYWRjOC05ZTM0LTRkY2EtOTQ1My01MzM4MmRkMjAxODkvc3RvY2stYmFsYW5jZS1yZXBvcnQuanBnIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTI2MjA5MDAsImV4cCI6MTc5MjcwNzMwMH0.mqmltlU4hz7nAnwo2QiF37iPrAg0GmyMDcFzVSMhdpg)

## Review quantities and values

Use the main result columns as follows.

| Column | Meaning |
|--------|---------|
| **Item** and **Item Name** | Identify the stock item. |
| **Item Group** | Shows the group used for the item. |
| **Warehouse** | Shows where the stock is held. |
| **Stock UOM** | Shows the unit used for stock quantities. |
| **Balance Qty** | Shows the quantity on hand at the end of the period. |
| **Balance Value** | Shows the stock value at the end of the period. |
| **Opening Qty** and **Opening Value** | Show the quantity and value before the movement period. |
| **In Qty** and **In Value** | Show stock received during the period. |
| **Out Qty** and **Out Value** | Show stock issued during the period. |
| **Valuation Rate** | Shows the valuation rate for the balance. |
| **Reserved Stock** | Shows stock reserved for another transaction. |

Check that:

* **Opening Qty** plus **In Qty** minus **Out Qty** agrees with **Balance Qty**.
* **Balance Value** is reasonable for the quantity and valuation rate.
* The warehouse and item filters match the business question.
* Negative quantities or values have a valid reason.

## Review stock by warehouse bin

Use dimension-wise results when warehouse bin management is active.


1. Select **Show Dimension Wise Stock**.
2. If required, select a value in **Warehouse Bin**.
3. Select **Generate New Report**.
4. Review the **Warehouse Bin** column beside **Warehouse**.

 ![Stock Balance report with Warehouse Bin filters and results](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC9lZjQ1MDgwMC00NDMxLTQ2NzctYTg1MC1hMmM4MTU1MGFlNGMvc3RvY2stYmFsYW5jZS13YXJlaG91c2UtYmluLmpwZyIsInR5cGUiOiJhdHRhY2htZW50IiwiaWF0IjoxNzkyNjIwOTAwLCJleHAiOjE3OTI3MDczMDB9.TzGhheGKO4L7-ygalDkYwEeQUcspEhr-N75nAW4Tj8M)

The report creates a separate result for each inventory dimension combination. For example, the same item and warehouse can appear on more than one row when stock is held in different bins.

A blank **Warehouse Bin** value means that the related stock ledger balance does not have a bin value. This can include stock that existed before bin tracking was used or stock that has not yet been allocated to a bin.

The report helps you find a difference. It does not correct bin quantities. Use the relevant stock or bin movement process to correct the source transaction.

## Use the report for common checks

### Prepare for a stocktake


1. Set **To Date** to the count date.
2. Select the warehouses that will be counted.
3. Select **Include Zero Stock Items** if the count sheet must include expected zero balances.
4. Generate the report and use **Download Report** if you need an offline copy.

### Review purchasing and replenishment


1. Select the relevant **Item Group**, **Items**, or **Warehouses**.
2. Review **Balance Qty** and **Reserved Stock**.
3. Investigate low or negative available stock before you place an order.

### Check month-end stock value


1. Set **To Date** to the period end.
2. Use the correct company and warehouse scope.
3. Review **Balance Value** and the total row.
4. Compare unusual values with the **Stock Ledger** report.

### Check warehouse-bin accuracy


1. Select **Show Dimension Wise Stock**.
2. Review rows with a blank **Warehouse Bin**.
3. Compare the report with physical bin labels and recent bin movements.
4. Correct the source movement when stock is in the wrong bin.

## Export and follow up

* Select **Actions** and then **Download Report** to export the current result.
* Select **View Stock Ledger** to open the detailed ledger with the related report filters.
* Use the filter row under the column headings to find a specific item, warehouse, bin, quantity, or value.
* Select **See all past reports** when you need an earlier prepared result.

## Confirmation checks

Before you use the report for a decision, confirm that:

* The **Company**, **From Date**, and **To Date** are correct.
* The item and warehouse filters do not exclude required stock.
* The report was generated after the latest stock transactions were submitted.
* Dimension-wise results are active when you need warehouse-bin information.
* Any negative, blank-bin, or unusual valuation result has been investigated.

## Troubleshooting

### Warehouse Bin is not shown

Select **Show Dimension Wise Stock**. The **Warehouse Bin** filter and column appear only in the dimension-wise view when the dimension is configured.

### Warehouse Bin is blank

The stock balance has no bin value. Review recent bin movements and use the bin allocation process for unallocated stock.

### The report does not show recent transactions

Confirm that the transactions are submitted. Then select **Rebuild**, or change the filters and select **Generate New Report**.

### A quantity does not agree with the expected balance

Check the date, item, warehouse, and dimension filters. Then select **View Stock Ledger** and review the detailed incoming and outgoing entries.

### The report takes a long time

Use a shorter date range or select specific items and warehouses. Generate a broader report only when you need the full stock position.

## Related documentation

* [Stock](/doc/42e81da0-a3bc-4f24-a596-63df62a260ae)
* [Stock Ledger Report](/doc/30fbfe06-4828-49c9-8349-161b66d68ae2)
* [Complete a Stocktake with Stock Reconciliation](/doc/f1e142cb-9233-46b1-8693-9fef52f577b7)
* [Bin Management](/doc/ca60123c-7366-4f25-affa-ffc02ebb0164)
* [Move Stock Between Warehouse Bins](/doc/bee69c8c-4e1d-4738-aa85-9b1e0469509c)