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.

How each line is worked out
The report adds up the stock entries of each item and location (and batch, if batches are on):
| Column | Meaning |
|---|---|
| Opening Qty., Opening Value | Stock before the From Date |
| In Qty., In Value | Stock that came in from the From Date to the To Date (shown in green) |
| Out Qty., Out Value | Stock that went out in the same period (shown in red) |
| Balance Qty., Balance Value | Opening plus in, minus out: the stock at the end of the To Date |
| Valuation rate | Balance 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
| Filter | Use |
|---|---|
| Item, Location | Show one item or one location |
| Batch | Show one batch. Shown when batches are on. |
| From Date, To Date | The period. By default, the last year up to today. To see stock on a given day, set To Date to that day. |
| Serial Number | Show one line per serial number. Shown when serial numbers are on. |
| Serial Number Status | Shown 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.
