Last updated 04/02/2021
Now that your system is running smoothly, it's good to regularly do stocktakes of some or all of your products to make sure your stock levels are accurate.
If you are new to the system and you've never done a stocktake before, please read the Completing Your First Stocktake article first as there are some initial steps required for first-time users.
Remember that the end result of a stocktake is to create an adjustment that increases or decreases your inventory and therefore your inventory value.
In order to create an adjustment for all your stock, you will use a feature called "Stocktake Master". The Stocktake Master compiles the stock for one particular branch and creates an adjustment for the required stock.
There are three steps to using the Stocktake Master:
Once you have the data you can go about your stocktake, filling in the Count column. Remember that you are only filling in information for the selected branch; you can only stocktake one branch at a time.
Once you have your counts in your spreadsheet, import the counts into the system.
These adjustments will increase or decrease the Stock on Hand in the system.
For those that are using the perpetual inventory system, you must now import those adjustments into your accounting software. This will make the necessary journals to balance your stock value in Cin7 with the stock value in your accounting software.
If you use the periodic method, and you are stocktaking at the end of a period, you will need to find the total stock value and make the necessary journals in your system. Your accountant is the best person to advise you on this. If you are stocktaking between periods, then you can carry on as usual.
For the difference between the two methods see Periodic and Perpetual Accounting.
Yes - the Pick 'n' Pack app allows you to do a stocktake whilst on the move. For your first stocktake, it may seem easier to use a spreadsheet instead but there is no reason you shouldn't use the Pick 'n' Pack as much of the process is the same. See the Stocktaking using Pick 'n' Pack article for additional details.