BasisBasis
Inventory

Stock Opname

Physical stock count — compare what the system shows vs. what is actually in the warehouse. Variances become Inventory Adjustments automatically. Use monthly or quarterly to keep inventory accurate.

Menu: Inventory → Stock Opname · Route: /inventory/stock-opname

Stock opname list

Stock Count Process

Step 1 — Set Up the Count

Go to Inventory → Stock Opname, then click New.

  1. Set the Date of the physical count.
  2. Select the Location (warehouse) to count. The system loads all items currently in stock at that location.
  3. Select the Inventory Account and the Adjustment Account (used for the GL variance entry).
  4. Enter a Narration (e.g., "Monthly count — Warehouse A — April 2026").
  5. Click Load Items — the count sheet appears, pre-filled with system quantities.
Stock opname form

Step 2 — Enter Physical Counts

  1. For each item in the count sheet, enter the Physical Qty — the actual quantity counted in the warehouse.
  2. The Difference column updates live: Physical Qty − System Qty. Positive = surplus; negative = shortage.
  3. Optionally add a per-row Narration explaining large variances.
  4. Items with zero difference are saved but do not generate any adjustment entry.
  5. Click Save. Only rows with a non-zero difference create Inventory Adjustment GL entries.

Count sheet columns

ColumnNotes
ItemItem code and name.
UnitItem's base unit of measure.
System QtyCurrent quantity per the GL/stock balance. Read-only.
Physical QtyQuantity actually counted. Pre-filled with system qty — edit where count differs.
DifferencePhysical − System. Computed automatically. Non-zero rows become adjustment entries on save.
NarrationOptional per-row note for explaining the variance.
Only items with non-zero differences generate GL entries. Items where Physical Qty = System Qty are recorded in the opname document for audit purposes but create no inventory or financial movement.

GL Impact (for each variance row)

AccountSurplus (Physical > System)Shortage (Physical < System)
Inventory Asset AccountDebit (variance × WAC)Credit (variance × WAC)
Inventory Adjustment / Variance AccountCreditDebit