6. Stock count

Stock count

In this article, you will learn how to create a stock count in Portal, view stock count report and reconcile stock.

• Create a stock count in Portal
• Stock count report
• Reconcile stock

Create a stock count in Portal

Stock count can be created via FrontZapp (recommended) or in Portal.

For more information on FrontZapp, click here.

How to create a stock count in Portal

Do the following:

1. Navigate to Flow of goods and then select Stock count.
   
2. Click Create new. 
3. Enter the relevant information such as name, date, description and choose filters if required.
4. Click Save.
5. The stock count will now be reflected in FrontZapp.

Stock count report

This report gives you a complete list of what has been counted, totals and deviations. 

Once the stock count is complete, download the stock count report by doing the following:

1. Navigate to Flow of Goods and then select Stock Count.
2. Find the relevant stock count and click the drop-down arrow next to Open stock count.
3. Click Stock count report. The file will now be downloaded as an excel file. 

Key elements of stock count report 

The stock count report includes three tabs: 

• Count
• Deviations
• Totals 

Count

This sheet gives an overview of each item that has been counted. 

It includes the following information:

• Product information: Product name, brand, size, cost, outprice will be listed here.
• Quantity: This shows the number of items counted. 
• Total: This is Cost multiplied by Quantity.

Deviations

This sheet gives an overview of all deviations on the stock count and helps uncover any discrepancies.

It includes the following information: 

• Product information: Product name, brand size, cost, outprice will be listed here.
• Stock: This shows the inventory levels when you created the stock count.
• Count: This show the number of items counted in that particular stock count.
• Deviation: This is the difference between Stock and Count.
• Absolute deviation: This shows the Deviation in absolute values.

Totals

This sheet shows the Total stock value and Total amount of deviations.

It includes the following information: 

Total value counted: Sum of Total (retrieved from Count worksheet).

Total quantity counted: Sum of Quantity (retrieved from Count worksheet).

Total stock value: This is the expected stock value.

Total stock quantity: This is the expected stock quantity.

Total deviation value: This is Cost multiplied by Diff (retrieved from Deviation worksheet).

Total deviation quantity: Sum of Diff (retrieved from Deviation worksheet).

as well as Total deviation value (including negative stock value) and Total deviation amount (including negative stock quantity).

Reconcile stock

When you have looked through the stock count list and everything is counted, you are ready to reconcile your stock count.

This is how reconciliation is done: 

1. Navigate to Flow of Goods and then select Stock Count.
2. Find the relevant stock count and click Open stock count. 
3. Click Reconcile stock.