Stock Audit in Shoper 9

1. Stock Audit in Shoper 9 February 2010

2. Introduction • Stock Audit • Reasons for auditing stock • Stock Audit in Shoper 9 • Pre-requisite to do a Stock Audit • Methods of Stock Audit • Reports generated during Stock Audit • Stock Audit updations available

3. Stock Audit Stock Audit is a statutory process which every business institution needs to perform at least once in a financial year This process involves the counting of Physical Stock present in the specified premises and verifying the same with Book Stock (Computed Stock) maintained by the company This process is executed to correct the discrepancies present in the Book Stock when compared to Physical Stock by passing necessary adjustment entries

4. When and Why Stock Audit Instances During the implementation of Shoper 9 at an existing business location During regular scheduled Stock Audit Reasons To update the Opening Stock details in Shoper As per statutory requirement To identify the discrepancy between Book Stock (Computed Stock) and Physical Stock To update the actual Physical Stock as Book Stock

5. Prerequisites for Stock Audit Before starting Stock Audit process Generate Stock Balance and Stock Movement Reports Take a backup of the database Keep the physical stock count ready Check whether all the items have barcode Ensure the stock taking procedure document, Stock Taking in Shoper 9 POS is present in customer system You can download this document from Tally website at Products › Shoper 9 › Implementation Guides

6. Scope and Methods of Stock Audit In Full or Partial Scope Full - All the products and brands available in the showroom are selected for stock taking purpose Partial - You can select a specific product brand combination and do the stock taking and update Record Methods Record the physical stock through Manual Entries Prefill items Scan

7. Reports generated during Stock Audits Progress Summary Physical Stock Report Batch-wise - Summary and Detailed Physical Vs Computed Stock Report - Summary and Detailed Physical Stock Report - Summary and Detailed Note: Generate/ check the Physical Stock Reports after completing the Physical Stocking Taking process

8. Stock Audit Updates Updating Opening Stock (Open Stock Loading) To update the stock for the first time in a new company Updating Discrepancies (Discrepancy Update) To update the stock of a running/ existing store On executing this option, the system adjusts the stock according to Physical Stock through Miscellaneous Issues and Miscellaneous Receipt, by default The status of the items are displayed as Recorded, Non-Recorded or Negative Note: Take a backup before updating the stock. Once you start the process of updation, the Physical Stock Take details will not be available.

9. Verification After updating the Physical Stock Check the Stock Balance and Stock Movement Reports with the Physical Stock Report The reports should match and should not contain any Negative Stock

10. Questions & Answers For more information log on to: www.tallysolutions.com

11. Thank You