Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Nonpublic companies

Inventory Test Counts & Tag Control

This workbook provides two worksheets. The inventory test counts worksheet provides the form to document test counts recorded during observation of the physical inventory count. The inventory tag control worksheet provides the form to facilitate the documentation of an inventory count.

Entering Data

For the summary information at the bottom of the test counts worksheet to calculate correctly, column B and column G of the worksheet must be completed for each test item. If not completed properly, the summary information will display an error message, and a note describing the error will be provided nearby. In most cases, the individual cell(s) causing the error will be surrounded with a red border.
On both worksheets, certain columns require a specific response, so the cells within these columns have been “validated” to prevent the user from inputting the wrong type of information. Each cell that is validated includes a down-arrow for the user to select. Once selected, a drop-down list appears to provide the user with the different response options to choose from.

Inserting and Deleting Line Items

For each worksheet, additional rows may be added or excess rows may be deleted. See the section “General Workpaper Functionality and Tips for Entering Data” for information concerning the tips for and potential effects of inserting and deleting workbook line items.