Stock take
Bookmarks:
Start counting & record counts |
Finish & complete |
Initial transfer of the quantities from another system |
[Video] How to do a full stocktake?
The stocktake process has three main parts:
Creation
Click "Add stock take" to start a new stocktake. Enter a description of the stocktake, e.g. Cyclic weekly mobile phones
To add products, you can manually search or enter the Sku item, or click on the "Add products" button where you can filter products with a range of filtering options.
When a stocktake is newly created, it's status is set to Draft.
At this stage, you can choose to:
- print the stock count list hardcopy to prepare for counting
- or download the entire list to a spreadsheet so you can easily input stock counts as well as perform other functions such as summing, filtering, and searching.
This action sets the stocktak status to In progress.
At this stage, you can perform the following functions:
- input the item counts
- print item differences between the actual count vs system's inventory on hand
- download or upload the counting spreadsheet that was previously exported
click here to download the stocktake quantities data template
- add more products into the stocktake or remove products from the stocktake
- enter notes
- cancel the stocktake
This is the final action. It performs the following actions in order
- for those items have counted quantities, the action posts the differences between the actual count vs system's inventory on hand
- completes the stocktake
- generates the stocktake differences report
Note, those items have no counts entered against them, the action skips these from posting
See a quick process below:
- Ensure the products have the right unit costs in the "Last buy price" field
- Create a stocktake and add all products to it
- Download the data into spreadsheet
- Populate the actual qty count into column E
- Save the file
- And then re-upload the same file back onto the system
After posting the stocktake, these will be uploaded and the cost value of the products can be viewed from Reports menu > Inventory levels.