6. Reporting

Stock count report

This report provides an overview of what was counted and can be sent to the auditor for review. 

Do the following: 

1. Navigate to Flow of goods.
2. Select Stock count.
   
3. On the relevant stock count, click Show report.
4. The stock report will now download to excel.

Calculate stock value as on 31/12

As many stores choose to have a count after the New Year, it can be good to know how to calculate back to the correct stock value per 1/1. (i.e. the end of 31/12).

Do the following:

1. Take the stock value for 31/12 and then subtract (or add if it turns out to be positive) the deviation from the count.
Adjusted Stock Value = Stock Value on 31/12 ± Deviation.

• Run the Stock report in Portal with date set to 31/12.
• Now, navigate to Stock count and on the relevant stock count, click Show report.
• Note down the stock value for 31/12 and subtract the deviation from the count.

2. If you or the auditor are interested in how this is calculated, take a look at the following example:

Say, a store has created a stock count on the 5/1.

To calculate the correct stock value as of 1/1 do the following:

Done!

Congratulations! You are now done with stock count.