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. (Make sure that you have excel on your computer.)
Calculate stock value as on December 31st yyyy
If you choose to do a stock count after 31.12, you must remember to add goods that have been sold and subtract goods that have been purchased between 31.12. and stock counting.
This must be done to calculate the correct stock value as of January 1st. (i.e. the end of 31.12).
Do the following:
- Retrieve Total value counted from Stock report > Totals worksheet.
- Retrieve Cost of good sold from Daily summary report.
- Retrieve Cost of good purchased from Received items per stock detailed report.
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 5th January 2021 at 10:00.
To calculate the correct stock value as of 1st January 2021 (31st December 2020) 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 |
Done!
Congratulations! You are now done with stock count.
If you want simpler ways to take stock count with fewer resources, contact Front Systems for a quick review on using RFID scanner with FrontZapp.
Comments
0 comments
Article is closed for comments.