Counting Inventory

The first step to managing your inventory is to know how much you have.  To do this, you need to perform an initial count of each item you wish to track. This number serves as the starting point for tracking the quantity on hand for that item during the entire period that item remains in your inventory. To help you accomplish this task, you can use the Item Count Worksheet to create a listing of all the items you intend to count. Once you’ve done this, print the worksheet and take it with you as you count the items in your store. Write the counts in the appropriate boxes. When you’ve completed your count, use the Count Entry screen to enter the count for the items.

NOTE: If the "Track Inventory" flag is not checked in the Extended Item Setup menu, the item will not appear on "Manage Inventory" pages. By default, the "Track Inventory" flag is checked.


 

Using the Item Count Worksheet

When performing an inventory count on a large number of items, use the Item Count Worksheet. This allows you to create a useful template to print and use when manually (i.e. pen and paper) performing your actual count.

1. Select INVENTORY > MANAGE > Count Worksheet.

2. Filter the items that display by the Category and Last Time Counted options or by entering an item name or barcode in the Search box and clicking  to add the items you want to count on the Item Count Worksheet.
    

3. Print the page so you can have it with you as you count and record the quantity of items on the sales floor and in the stock room.

4. Start by counting the packages on hand and then count any individual units. If an item is only available in individual units, do not write down a quantity in the Enter Full Pkgs. On Hand field, but instead capture it in the Enter Units On Hand field. For the most accurate results, remember to count all inventory, including unopened and partial packages.

5. Write the counts on the Item Count Worksheet and continue with Entering Inventory Counts.

Entering Inventory Counts

1. After completing your count, select INVENTORY > MANAGE > Count Entry to open the Count Inventory screen.

2. Enter the count of the items you just counted. You can filter the items that display by the Category and Last Time Counted options or by entering an item name or barcode in the Search box and clicking .

3. The Expected On Hand quantity is calculated using your last count of an item minus any sales of that item plus any returns of that item since your last count.

4. The system will calculate and display the Total On Hand (Units).

5. Click Save Changes when you are done.

If you see any small, red triangles, they show you where information on the screen has changed since the last save.

keyword: item count, count inventory, inventory management, item count worksheets