Skip to content

Stock Balance ​

The Stock Balance report answers "how much do we have, where, and what is it worth?". It shows one line per item and location, with the stock at the start of a period, what came in and went out during it, and what is left at the end. Values are FIFO costs.

Open the report ​

In the sidebar, click Reports > Stock Balance. The report is there only when inventory is on.

Stock Balance with one line per item and location for Gudang Utama and Toko Dago, showing balance, opening, in and out quantities and values

How each line is worked out ​

The report adds up the stock entries of each item and location (and batch, if batches are on):

ColumnMeaning
Opening Qty., Opening ValueStock before the From Date
In Qty., In ValueStock that came in from the From Date to the To Date (shown in green)
Out Qty., Out ValueStock that went out in the same period (shown in red)
Balance Qty., Balance ValueOpening plus in, minus out: the stock at the end of the To Date
Valuation rateBalance Value divided by Balance Qty.

A negative Balance Qty. is shown in red.

Only a Books Manager or System Manager sees the value columns. Other users see quantities only.

Example: on 30 November, Toko Dago starts with 4 kg of Arabica Gayo. During the week it receives 10 kg by Material Transfer and sells 11 kg. With From Date 1 December and To Date 7 December, the line shows Opening Qty. 4, In Qty. 10, Out Qty. 11 and Balance Qty. 3.

Filters ​

FilterUse
Item, LocationShow one item or one location
BatchShow one batch. Shown when batches are on.
From Date, To DateThe period. By default, the last year up to today. To see stock on a given day, set To Date to that day.
Serial NumberShow one line per serial number. Shown when serial numbers are on.
Serial Number StatusShown when Serial Number is selected: All, In stock or Out stock

Batches and serial numbers ​

When batches are on, the report has a Batch column and shows one line per batch of an item at each location. See Batches.

When you select Serial Number, the report lists only items with serial numbers, with one line per serial number and location. In stock keeps the units with a balance above zero, and Out stock keeps the rest. See Serial Number.

When a backdated document is refused

A document dated in the past cannot make stock negative on a later date. To see where the stock runs out, open the Stock Ledger for that item and location and look at Balance Qty. on the entries after the document's date.

To export or print the report, see Reports. The export contains every line that matches the current filters.