Stock Movement

The Stock -> Stock movement page shows a financial report of on-hand stock balance and its detailed movements in any chosen period.

Tips and tricks

  • The period of a report can be custom defined or selected from pre-defined options.
  • Reports can be saved in PDF or CSV.
  • Click on a number to see a detailed report, how it's calculated.

In the detailed reports of any category:

  • Click Choose columns to choose which columns to display.
  • Drag the columns to rearrange them.
  • Click List to see all transactions line-by-line.
  • Click Sum per stock item to see all transactions summed by stock item.
  • The tables can be searched and filtered (see Usage tips for wildcards).

Stock movement reports

The Stock -> Stock movement report shows on-hand balance change during the defined period. Click on a number to see a detailed report.

There are the following categories:

  1. Inward - the sum total of the costs of goods that have been added to the stock during the period:
    1. Purchases - goods that were bought and received during the period;
    2. Adjustments - manual positive adjustments to inventory (manually added stock lots or manual inventory increases).
      - Stock lots are either manually created at Stock -> Stock lots, or automatically created when a user manually increases the stock quantity at Stock -> Inventory;
    3. Manufactured - products that were manufactured during the period.
      (Cost of a manufactured item = Cost of materials + Manufacturing overhead + Cost of labor);
  2. Outward - sum total cost of goods that have been deducted from the stock during the period:
    1. Sales - products that have been shipped to customers;
    2. Write-offs - manual negative adjustments to inventory (manually created write-offs or manual inventory decreases):
      - Write-offs are either manually created at Stock -> Write-offs, or automatically created when a user manually decreases stock quantity at Stock -> Inventory
      - Manual write-off types (sub-categories) can be defined in Settings -> System settings -> Write-off types. Then, each type is shown separately;
    3. Used in manufacturing - raw materials that have been consumed during the period.

Click on any number to see how this balance is calculated.

The ending balance is calculated as follows:

  • Ending balance = Starting balance + Inward - Outward
We use cookies to enhance your experience on our website. If you continue using this website, we assume that you agree with these. Agree Learn more Ok