Stock Audits

What is a Stock Audit

A Stock Audit is a way to ensure all stock movements are being recorded correctly and all stock used is accounted for. This is also a way to ensure that all deliveries have been processed correctly.

stock
/stɒk/
noun
the goods or merchandise kept on the premises of a shop or warehouse and available for sale or distribution.
"the store has a very low turnover of stock"
 
 
audit
/ˈɔːdɪt/
noun
noun: audit; plural noun: audits
 
an official inspection of an organization's accounts, typically by an independent body

Starting a Stock Audit

To start a Stock Audit, navigate to the Stock Audits tab on the left-hand side of the Home Screen. Then, click on the ‘Start Stock Audit’ tab in the top right-hand side. This will bring up a pop-up, where you can enter a title for the Audit, choose the correct Stock Group, select the previous Audit for a starting stock and the end date of the Audit you are processing. Once this pop up has been filled correctly, a blue button at the bottom of the pop up will appear called ‘Start Audit’. This will then put your stocktake in the ‘Open Stock Audits’ section of the Stock Audits page. This will allow you to create count sheets and import the counts.

image-1616687830533.png

When you create the Stock Audit, you can tell the system to include all items from previous stocks, regardless of their open/closing value being zero. This will be helpful when doing food stocks as items will not drop off the countsheets.

image-1618222982992.png

 

 

Creating Countsheets

To create a countsheet, go to the relevant Stock Audit, and select the link on the right-hand side called ‘Export Count Sheets’. This will bring up the ‘Save As’ pop up. This file is to be saved in a memorable place. This will create an Excel file that will contain the countsheets for all outlets within the business. This can be printed and become your countsheets for the job. Complete the count on these sheets and type in the totals when the count is completed

 

image-1616757150842.png

                                                            

All count sheets include the opening count and on standard count sheets blank rows with titles separate the sections, this will not work for Bin Book count sheets.

image-1618223052840.png

                                               

 

 

 

 

 

 

 

Importing Completed Countsheets

Once the count has been completed and all counts are totaled on the Excel file, navigate back to the Stock Audit Screen. The link below the ‘Export Count Sheets’ link is called ‘Import Count Sheets’. When this has been selected, a pop up will appear. Use the ‘choose file’ option to upload your completed file. The upload type can be changed from ‘Appending to Existing Counts’ (If you want to add to counts) to ‘Reset All Counts’ (to enter fully new counts).

If you wish to enter the count via the online platform as opposed to using count sheets, you can do this via the 'View Stock' icon. From here you will be able to click on the 'Stock Declaration' tab at the top of the screen.

 

image-1616687937782.png

This will open all items within the outlet. From here you are able to choose the outlet, search for a product and add new products to the outlet.                                  

image-1616687962887.png

 

Reviewing the Completed Stock Audit

When the count has been input, you can click on the ‘View Stock’ Icon (represented by an eye). This will take you to the overview of the counts. This is where you can make any amendments that are necessary as well as reviewing your entry.

- Errors

Errors prevent the stock from being locked.If an 'error' is found, the system will display the following at the top of the screen;

image-1616688044137.png

To investigate these errors, navigate to the 'Checks' Tab:

image-1616688071738.png

To correct the selling price and the dispense measure errors, navigate to the 'Product Settings' tab and select edit on the 'Master Settings' 

image-1616688097799.png

This will automatically take you to the 'Retail Settings' tab. Any product within this list with missing information will be highlighted as below;

image-1616688147591.png

Simply enter the values and press save.

To correct the cost price, navigate to the 'Cost Settings' tab.

image-1616688178121.png

Search for the product you wish to update, change the 'Type' to 'Manual' and enter the cost price for the product.

image-1616688202304.png

The actions will clear the errors, and will enable the Stock Taker to lock the stock.

 

Audit Result

When you have confirmed all of the counts are correct, you are able to click on the Audit Result Tab. From here you will see four tables (as pictured).

image-1616688271034.png

image-1616757284478.png

The top table is the cost result, showing transfers and consumption values. This table also shows the closing value of the inventory. The second table is the Retail result. This where you can see the surplus/deficit and GPs produced by area within the business. It also displays the Yield, and Estimated GP. The third table shows the deliveries for the current stock period. The final table shows the transfers for the relevant period.

Product Result

From the product result tab, you can see the information for each product. The headings break down each product, opening count, delivered amount, transferred amount, closing count, consumed value and estimated receipts. Here you will be able to identify any erroneous values in deliveries or transfers. You can also use this page to review your entered figures.

image-1616688415468.png

Reports

When reviewing the result of the Stock Take, click on the reports tab in the top-right corner.

image-1616688482415.png

This will open up a list of the available reports for the relevant stock. Below highlights what each report is used for;

Report Use
Site Summary Report Provides an Excel version of the result tables
Product Detail Report Outlines all items with their Cost Price, Retail Price, UOM, Open/Closing counts, Deliveries and transfers. This report also highlights the SOH cover for each item and its respective GPs. A separate tab for every outlet/bar/cellar will be created
Delivery Report Shows all deliveries and their values for the respective period
Transfer Summary Report Details all transfers within the business (i.e. requisitions) within the current period
Cost Price Change Report Highlights all Cost Price Changes, with the opening cost and delivered cost. It will identify which delivery notes are associated with the change of price to aid any investigations needed.

An example of each report is seen below;

 - Site Summary Report

image-1616688545032.png

 - Product Detail Report

image-1616688568210.png

 - Delivery Summary

image-1616688592480.png

The delivery summary also creates an itemised by delivery summary tab as seen below;

image-1616688621617.png

  - Transfer Summary

image-1616688652013.png

This, like the Delivery Summary, produces an itemised version also;

image-1616688680607.png

 - Cost Price Change

image-1616688705081.png

If you have access to Capcon Reality's Portal you can import the stock into the Solutions Tool Box, select the 'Product Result' report and click 'Push to Solutions Portal'. 

image-1616757629562.png

This will then appear within the Tool Box under the user name 'System'

image-1616757681558.png

From here you will be able to access the reports listed below, as well as being able to manually enter the till sales.

image-1616757847397.png

Deleting a Stock Audit

To delete and Audit, click on the bin at the top of the page.

image-1616688793990.png

This will then prompt a pop up confirmng the deletion of the Audit.

image-1616757940452.png

The deleted stock will now have disappeared from the Open Stock category on the Stock Audits page

Completing a Food Audit

To complete a food Audit, you set it up in the same way as the liquor audit, however ensure that the type of stock has been amended to select the food stock.

image-1618229688182.png

When setting up the stock you can include all items from the previous stock to ensure all items (even when the open/close count is zero) are available on the countsheets.

To export/import the countsheets you follow the same processes as a liquor audit. 

To add deliveries, you can add the cost element of a delivery as follows:

image-1618232210272.png

image-1618232248139.png

You are also able to create itemised deliveries in the same way that you create a liquor delivery.

To see the deliveries, change the stock group in the top left hand corner to the relevent area:

image-1618232334178.png

This will bring up a list of all deliveries that are associated with the relevent stock group:

image-1618232387011.png

From here, you are able to view, edit and delete any delivery. You can change the date range at the top to ensure all relevent deliveries can be viewed. 

To view the stock result after the count has been inputted, click on view Audit and it will come up with the following screen:

image-1618232538635.png

The first table shows you the breakdown of opening value, transfer value, closing value, consumption value, allowances (cost), Revenue and GP produced from the inputs.

The second table shows all deliveries that are associated with the current stock period.

The product result shows you itemised products and their opening/closing counts in order to sense check.