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