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 - 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 - manually added stock lots;
    3. Manufactured - products that were manufactured during the period.
      (Cost of a manufactured item = Cost of materials + Manufacturing overhead cost + 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 adjustments (if write-off types are defined in Settings -> System settings -> Write-off types, 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