# Stock Movement report: opening and closing balance for a period

URL: https://bimpsoft.com/en/help/reports/stock-movement-report/
Updated: 2026-11-06

> The Stock Movement report shows, for each warehouse and product, the opening balance, receipts, sales, write-offs, transfers and closing balance for the selected period, in units or in value. To run it, open "Reports → Stock Movement", enter a period and click "Generate report".

## What the Stock Movement report is for

The Stock Movement report answers how much of a product was in the warehouse at the start of the period, what happened to it and how much is left at the end. It is used in three situations:

- **Purchasing.** The manager sees the closing balance and the speed of sales: if 15 units were sold in a week and 2 are left, it is time to order from the supplier.
- **Warehouse and audit.** If a quantity does not match the actual one, the report shows all inflow and outflow documents for the period, which helps find the stage where the error occurred.
- **Write-off analysis.** You can see how much of a product went into production, into defects or into transfers between warehouses.

General report features (templates, export, search) are described in [Reports in Bimp](https://bimpsoft.com/en/help/reports/reports-overview/).

## Which documents feed the report

The report is built only from posted documents. An unposted document is not shown in the report.

| Document | How it affects the balance |
|---|---|
| Goods receipt, Return to supplier | increases or decreases the balance on purchasing, the "Receipts" column |
| [Sales of goods and services](https://bimpsoft.com/en/help/sales/shipment/), [Customer return](https://bimpsoft.com/en/help/sales/customer-return/) | decreases or increases the balance on sales, the "Sales" column |
| Stock transfer | moves goods between warehouses, the "Transfers" column |
| Write-off, [Stock posting](https://bimpsoft.com/en/help/inventory/stock-posting/) | adjusts the balance for defects and surpluses |
| Assembly, [Disassembly](https://bimpsoft.com/en/help/production/disassembly/) | stock movement in production |
| [Cost allocation](https://bimpsoft.com/en/help/costing/cost-allocation/), [Additional costs](https://bimpsoft.com/en/help/costing/additional-costs/) | write-off of stock to the cost price of products |
| Entering opening balances | opening balances when accounting is set up |

For more on the documents, see [Goods receipt](https://bimpsoft.com/en/help/purchasing/goods-receipt/), [Stock transfer between warehouses](https://bimpsoft.com/en/help/inventory/stock-transfer/), [Write-off](https://bimpsoft.com/en/help/inventory/write-off/) and [Assembly](https://bimpsoft.com/en/help/production/assembly/).

## How to run the report

To run the Stock Movement report, open it in the "Reports" menu, set a period and click the generate button.

1. Open **Reports → Stock Movement**.

   ![The "Reports" menu with the "Stock Movement" report selected](https://bimpsoft.com/help/_img/ce468669-fc44-4905-8587-9b97bd75ccd6.webp)

2. In the top left part, click the calendar and select a period, for example the current month.
3. If needed, open the **Filters** panel and set the selection conditions.
4. Select "Group by" and "Detail by" (see below).
5. Click **Generate report**. After you change the period or filters, the table does not refresh by itself, so generate the report again.

## Indicators

The table shows the following columns; by default values are shown in quantity (pcs, m and so on).

| Column | What it means |
|---|---|
| "Opening balance" | the quantity at the start of the period |
| "Receipts" | how much arrived during the period |
| "Sales" | how much was sold during the period |
| "Write-offs" | how much was written off, including to production |
| "Transfers" | movement under Stock transfer documents; outflow from a warehouse is shown with a minus sign |
| "Closing balance" | the quantity at the end of the period |
| "Series" | the product's series numbers |
| "Expiry date" | the product's expiry dates |

The closing balance is made up as follows: opening balance plus receipts, minus sales, minus write-offs, plus transfers (taking the sign into account). The "Total" row at the bottom sums the columns.

To see value instead of quantity, turn on the **Show cost** switch in the top right corner. The cost is calculated in the management accounting currency from the [accounting settings](https://bimpsoft.com/en/help/getting-started/accounting-settings/).

## Filters and grouping

Filters are in the left "Filters" panel; the selected settings can be saved as a template.

| Filter | What it gives |
|---|---|
| "Warehouse" | movement for a single warehouse |
| "Product" / product group | movement for a product or category |
| "Supplier" | movement of goods by supplier |
| "Batch number" | movement for a single batch |
| "Series" | movement for a series |
| "Expiry date" | selection by expiry date |

"Group by" is available by warehouse, product, product group and warehouse group. "Detail by" is by products, product groups and batch numbers.

Switches above the table:

- **Show as last level: Documents** expands a product row to the documents that created the movement;
- **Show supplier's product name** adds a column with the product name from the supplier's products list, if you keep one;
- **Show cost** switches the report from quantity to money.

![Stock Movement report in "Show cost" mode: grouping by warehouses, detail by products, columns "Opening balance", "Receipts", "Sales", "Write-offs", "Transfers" (with negative values), "Closing balance", "Series", "Expiry date"; the "Total" row at the bottom](https://bimpsoft.com/help/_img/0d214d95-5a83-442d-b197-02dcb090ad5c.webp)

![Stock Movement report with the "Show supplier's product name" switch on: the "Supplier's product name" column is added, product rows are expanded to batch numbers and documents](https://bimpsoft.com/help/_img/dabdaa47-59e4-4165-8f72-1e7636424ad4.webp)

## How to read the numbers: an example

Consider the warehouse "Main warehouse (components)" for 01.04.2026 – 26.04.2026 in cost mode (USD):

| Opening balance | Receipts | Sales | Write-offs | Transfers | Closing balance |
|---|---|---|---|---|---|
| 3,003.77 | 1,763.84 | 870.31 | 719.22 | −915.77 | 2,262.31 |

Check: 3,003.77 + 1,763.84 − 870.31 − 719.22 − 915.77 = 2,262.31. The item "Speed controller": 19.32 + 2.76 − 13.80 − 2.76 = 5.52. A negative transfer means the goods left this warehouse for another, for example for the semi-finished goods warehouse.

## Why the numbers do not match

**The actual balance in the warehouse differs from the "Closing balance".** Expand the product to documents (the "Show as last level: Documents" switch) and check whether all receipts and issues are posted. An unposted document does not get into the report. To reconcile with a physical count, use a [stock count](https://bimpsoft.com/en/help/inventory/stock-count/).

**The balance in this report differs from the Stock with Reserve report.** "Stock Movement" shows the balance at the end of the period, while [Stock with Reserve](https://bimpsoft.com/en/help/reports/stock-with-reserve-report/) shows the current balance and reserve on a selected date.

**A warehouse or product does not appear in the report.** Check the "Warehouse" and "Product" filters and the period: if there was neither a balance nor movement during the period, there will be no row.

**The cost is not what you expect.** The cost is taken at cost price in the management accounting currency; after late additional costs or corrections to a receipt it changes. See [Cost price recalculation](https://bimpsoft.com/en/help/costing/cost-recalculation/).

## FAQ

**How do I see an amount instead of a quantity in the Stock Movement report?**

Turn on the “Show cost” switch in the top right corner of the report. The cost is calculated in the management accounting currency specified in the company's accounting settings.

**Why does the “Transfers” column have negative values?**

A negative value is the outflow of goods from the sending warehouse under a Stock transfer document. At the receiving warehouse the same transfer is shown as a positive number.

**How do I find the document that caused a balance discrepancy?**

Turn on the “Show as last level: Documents” switch and expand the product row. Under it you will see the receipt, sales, write-off and transfer documents for the period.

**Can I look at the movement of a specific batch or series?**

Yes. Use the “Batch number” and “Series” filters or select detail by batch numbers.