6. Reporting

Stock report

You can at any time look at the stock count list to get an overview of what was counted. This list can be sent to the auditor for review. 

Do the following: 

1. In Portal, click Flow of goods.
2. Select Stock count.
   
3. On the appropriate stock count, click Show report.
4. The stock report will now download to excel. (Make sure that you have excel on your computer)

How to calculate stock value per. 31/12

If you choose to do a stock count after New Year, it can be useful 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. Find the stock value for 1/1 and then subtract, or add if it turns out to be a positive, the deviation from the stock count.
   • Go to Portal > Reports > More.. > Stock value pr. stock.
   • Set the date to 1/1/20xx, so that you retrieve the outgoing stock value as of 31/12/20xx (and run the report (Do NOT set 31/12).
   • Go to Flow of Goods > Stock and find the current stock count and press Show report.
     Take the stock value for 1/1 and subtract/add the deviation from the count.

If you or the auditor are interested in how this is calculated you can look at the following example:

Say, a store has created a stock count on the 5th of January at 10:00, with a stock value of 1,000,000.00. To calculate back to the correct stock value per 1/1 do the following:

Counted stock value (retrieved from stock report) = 1,000,000.00

+ Cost of Goods Sold (retrieved from Reports > More.. > Daily report for period 1/1 - 1/4) = 10,000.00

- Stock value (retrieved from Reports > More... > Stock value pr. stock 1/1 - 1/4) = 2,000.00

= Calculated stock value = 1,008,000.00