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:
- Inward - the sum total of the costs of goods that have been added to the stock during the period:
- Purchases - goods that were bought and received during the period;
- 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;
- Manufactured - products that were manufactured during the period.
(Cost of a manufactured item = Cost of materials + Manufacturing overhead cost + Cost of labor);
- Outward - sum total cost of goods that have been deducted from the stock during the period:
- Sales - products that have been shipped to customers;
- 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;
- 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