Stock count report
This report provides an overview of what was counted and can be sent to the auditor for review.
Do the following:
- Navigate to Flow of goods.
- Select Stock count.
- On the relevant stock count, click Show report.
- 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:
| Report | Period | Value |
|
Stock count > Show report > Total value counted |
5th January 2021 | 1 000 000 |
| Daily summary > Cost of goods sold |
1st January 2021 - 4th January 2021 |
10 000 |
|
Received items per stock detailed > Cost of goods purchased |
1st January 2021 - 4th January 2021 |
2000 |
| Stock value as of 1st January (i.e. the end of 31.12) = 1000000 + 10000 - 2000 = 1 008 000 | ||
N.B.
Deviations can occur when selling a Generic product.
Done!
Congratulations! You are now done with stock count.