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. (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:

1. Retrieve Total value counted from Stock report > Totals worksheet.
2. Retrieve Cost of good sold from Daily summary report. 
3. 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:

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.