Transcript Stock Audit - Tally Solutions

Stock Audit in Shoper 9
February 2010
© Tally Solutions Pvt. Ltd. All Rights Reserved
1
Introduction
 Stock Audit
 Reasons for auditing stock
 Stock Audit in Shoper 9
o Pre-requisite to do a Stock Audit
o Methods of Stock Audit
o Reports generated during Stock Audit
o Stock Audit updations available
© Tally Solutions Pvt. Ltd. All Rights Reserved
2
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
© Tally Solutions Pvt. Ltd. All Rights Reserved
3
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
© Tally Solutions Pvt. Ltd. All Rights Reserved
4
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
© Tally Solutions Pvt. Ltd. All Rights Reserved
5
Scope and Methods of Stock Audit
 In Full or Partial Scope
o Full - All the products and brands available in the showroom are
selected for stock taking purpose
o Partial - You can select a specific product brand combination and do
the stock taking and update
 Record Methods
o Record the physical stock through
 Manual Entries
 Prefill items
 Scan
© Tally Solutions Pvt. Ltd. All Rights Reserved
6
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
© Tally Solutions Pvt. Ltd. All Rights Reserved
7
Stock Audit Updates
 Updating Opening Stock (Open Stock Loading)
o To update the stock for the first time in a new company
 Updating Discrepancies (Discrepancy Update)
o To update the stock of a running/ existing store
o On executing this option, the system adjusts the stock according to
Physical Stock through Miscellaneous Issues and Miscellaneous
Receipt, by default
o 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.
© Tally Solutions Pvt. Ltd. All Rights Reserved
8
Verification
 After updating the Physical Stock
o Check the Stock Balance and Stock Movement Reports with the
Physical Stock Report
o The reports should match and should not contain any Negative Stock
© Tally Solutions Pvt. Ltd. All Rights Reserved
9
Questions & Answers
For more information log on to:
www.tallysolutions.com
© Tally Solutions Pvt. Ltd. All Rights Reserved
10
Thank You
© Tally Solutions Pvt. Ltd. All Rights Reserved
11