How to prepare a stock audit report?
After logging into the application there will be an option of “Vouchers” on the left side. Under “Vouchers” we have “Inventory” under which there is an option of “Physical Stock Audit”.
Clicking on “Physical Stock Audit” will redirect to the screen where the user needs to select the store for which the audit needs to be conducted, select audit type (Internal/External), provide closing balance date, audit start date, select status as open.
After providing all the details clicking on “Start Audit” CTA will create an entry for the stock audit and the same will be recorded under Registers → Inventory → Stock Audit Register.
As soon as the start audit is clicked, a list of all the items will be displayed, this list can be filtered by Product name, Brand name, Category, etc.…
Physical Quantity against each item needs can be recorded after manually counting the items in the store.
At this stage when audit status is ‘Open’, System quantity and difference columns in the report will be displayed as 0 against each item.
After the physical quantities against all the items are added, clicking on ‘Lock & Submit’ CTA will update the status of audit to Locked.
Now users can go to the stock register, find the respective stock audit entry and clicking on “Manage items option” will display the list of all the items with respective physical quantity against each item.
In order to display the system quantity against the items, click on “Post System Quantity” option available on the screen.
Difference between physical quantity and system quantity will be displayed on the screen against each individual item.
In case there was any wrong entry provided by the user for physical quantity against any item, admin will have access to edit the same in this screen.
Audit report can be printed using the option of “Print audit report” available on the top of the screen.
Last column in the audit report is “Accuracy %” against each item. 100% accuracy indicates physical quantity and system quantity are matching.