Stock on Hand Counts

 Top  Previous  Next

After the stocktake has been created a list of stock items which are available and/or have been changed in some way since that last stocktake was created will be available. It is necessary then to declare the physical count of each item listed and enter it into the system so a comparison can be made. The amount entered is the number of units based on the description when the item was created.

 

<INSERT PICTURE HERE>

 

Items marked in yellow are yet to have their stock on hand count entered. Once all items have had their stock on hand entered, the stock take can then proceed to the next step.

 

Stocktake Worksheet

The stocktake worksheet is provided as a summary and as a means to help calculate any discrepancies that may exist.

 

Opening Stock:

This is the finalised Closing Stock from the last stocktake.

Plus Transfer In:

This is any amounts transferred to this item. These amounts will include invoices, stock transfers in and any other non-shrinkage or variance items that are transferred in.

Less Actual Sales:

These are the sales based on the product recipes.

Less Transfer Out:

This is any amounts transferred out from this item. These amounts will include credit notes, stock transfers out and any other non-shrinkage or variance items that are transferred out.

Less Shrinkage ([S] Reason Types):

This is any amount that was transferred out due to wastage, breakage's, etc...

plus/less Stocktake Adjustments ([V] Reason Types):

This is any amount that was transferred in/out as a result of a stocktake variance.

Closing Stock:

There are 3 methods of calculating the Closing Stock depending upon the stage of the stocktake:

1.Closing Stock - Non-Adjusted: (This is the calculated Closing stock at the time the stocktake was created)

Closing Stock = Opening Stock

+ Plus transfers In

- Less actual Sales

- Less Transfers Out

+/- Plus/Less any Shrinkage

 

2.Closing Stock - Adjusted: (This includes any non-stock take variance adjustments that were included after the stocktake was created).

Closing Stock = Opening Stock

+ Plus transfers In

- Less actual Sales

- Less Transfers Out

+/- Plus/Less any Shrinkage

 

3.Closing Stock - Stocktake: (This includes all adjustments that were included after the stocktake was created, including the stocktake adjustments).

 

Closing Stock = Opening Stock

+ Plus transfers In

- Less actual Sales

- Less Transfers Out

+/- Plus/Less any Shrinkage

+/- Plus/Less and Stocktake Adjustments

 

Stock on Hand:

This is the physical stock count for this item.

 

Transfer IN Req'd, Transfer OUT Req'd, Adjustments Completed:

This item refers to the status on the selected item. If the status is Transfer IN then an amount must be TRANSFERRED IN to account for the discrepancy, If the status is Transfer OUT then an amount must be TRANSFERRED OUT to account for the discrepancy. This amount will appear in RED. The reason for the transfer may either be a normal reason (if one is known) or a stocktake variance if it is unknown, but the amount MUST be adjusted before the stocktake can be finalised. Once the amount has been adjusted the status will then display Adjustments Completed.