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

Open the Stock workspace.
Select Stock Balance.
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

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.

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

Stock Balance report with Warehouse Bin filters and results

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

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

Review purchasing and replenishment

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

Check month-end stock value

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

Check warehouse-bin accuracy

Select Show Dimension Wise Stock.
Review rows with a blank Warehouse Bin.
Compare the report with physical bin labels and recent bin movements.
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.