Verification of Stock Items (International Audit)

 

The Verification of Stock Items report will help the user to check the available Stock Item details for the Analysis Year and compare the same with the Previous Year.

To view the Verification of Stock Items report,

Go to Gateway of Tally > Analysis & Verification > Data Analysis > Verification of Stock Items

Note: If the previous year (year before the Analysis year) data is available as a different Company, the same has to be loaded before accessing Verification of Stock Items report for accurate analysis.

The Verification of Stock Items reports classifies and displays all the exceptional Stock Items (All Exceptions) along with the Item Count under the following exception status:

Difference in Opening Stock

Stock Items with difference in Opening Stock from Previous Year and Current Year will be listed under this status.

Negative Stock

Stock Items with Negative Closing Balance at the end of the Current Year (Analysis Year) will be displayed under this status.

Not Available in Current Year

Stock Items that have been discontinued (not present) in the current year will be listed under this status.

Not Used

Stock Items which do not have any balance and have not been used in recording any transaction during both the years will be displayed under this status.

Not Used in Current Year

Stock Items which have been used for recording transactions only in the previous year, have no Closing Balance (from the previous year), and have no Opening Balance in the current year will be listed under this status.

Only Balances, No Transactions

Stock Items that have only Balances, but have not been used for recording transactions during both the years will be displayed under this status.

Used Only in Current Year

Stock Items (with or without Opening Balance) that have been used to record transactions only in the Current Year will be displayed under this status.

The other Status which can be viewed using the F12: Configure are:

All Items

Displays all the Stock Items irrespective of the status.

No Change

Displays the Stock Items which are used in both the Years.

Button Options in the Verification of Stock Items report

F1: Detailed

Click F1: Detailed or press Alt+F1 to view the list of Stock Items under the selected status.

F4: Group

Click F4: Group or press F4 to filter the Stock Items belonging to a particular Group.

Ctrl+F3: Compare Cmp

Click Ctrl+F3: Compare Cmp or press Ctrl+F3 to load the company that contains the data for the year prior to  the analysis period.

F9: Verify

Click F9: Verify or press F9 to mark any Stock Item as On Hold or Verified.

Note: The facility to mark a Stock Items as Verified is provided only for those Stock Items which are present in the Analysis Year.

In Verification Details screen,

Note: The option Copy Verification Details to Working Paper will be displayed in Verification Details screen only when the Working Paper is enabled in F11: Accounting Features

Ctrl+F9: Master Config

Click Ctrl+F9: Master Config or press Ctrl+F9 to identify Related Parties, Periodic Ledgers and apply Sampling methods for Analysis.

Ctrl+F10: Remove Verify

Click Ctrl+F10: Remove Verify or press Ctrl+F10 after selecting the required ledgers from the above report to change the Verification Status to blank.

N: Dly Negative Stock

Click N: Dly Negative Stock or press Alt+N to display the list of stock items having negative stock on each day of the analysis period.

 

Verification of Stock Items - Negative Stock report, the user can drill down to the Daily Breakup for stock item to view the negative stock during the analysis year.

The Daily Breakup for Stock Item is displayed as shown:

W: Working Note

Click W: Working Note or press Alt+W to specify the working note details at Company or Stock Group or Stock Item level. The details provided in working note will be captured in Working Paper along with the details of User Name, Working Note Date & Time, Status, Note etc.

In Working Note Details screen

Ctrl+W: Wkg Paper

To view the  Working Paper during analysis, click Ctrl+W: Wkg Paper or press Ctrl+W. The details displayed in Working Paper will be relevant to the report from where it is triggered.

For more details on working paper refer the topic Working Paper

F9: Inv Reports

Click F9: Inv Reports or press F9 to navigate to the default Inventory Reports like Godown Summary, Movement Analysis, Stock Summary etc.

F10: Acc Reports

Click F10: Acc Reports or press F10 to navigate to the default Accounting Reports like Balance Sheet, Cash Flow, Trial Balance etc.

F10: Verify Reports

Click F10: Verify Reports or press Alt+F10 to navigate to the other Verified Reports

F12: Configure

Click F12: Configure or press F12 to change the configuration for the displayed report.

The facility to view the Stock Items belonging to a particular status is also provided by pressing Enter on the required Stock Item Type from the Verification of Stock Items report for All Exceptions type.

The Verification of Stock Items report for the items Used Only in Current Year is displayed below:

Note: The above report is same when option Show Stock Items of Type is selected as Used Only in Current Year in the F12: Configuration.

The user can press Enter on any of the selected stock items to view the Stock Vouchers report.