Log into Clove Hill QuickBooks 

 

Click on Reports:

 

 

 

Click on Physical Inventory Worksheet under Sales and Customers:

 

 

Click on Export in the upper right hand side:

 

 

Click on Export to Excel:

 

 

Open the Excel Spreadsheet

 

Click on Enable Editing:

 

 

Remove Column A if it is blank

 

Hide the Description Column to make sure all columns fit, and print properly

 

Add gridlines 

 

Print spreadsheet.  Make sure you are printing to HPIFFF8C.local domain

 

Count inventory for each product, and add those numbers to the Physical Count Column on the spreadsheet you just printed out:

 

 

In the Blank Column next to the Physical Count Column, Add the word Difference

 

In the first box of the first product in the Difference Column enter this formula:  =(click on the count column - click on the on hand column):

 

 

A number will pop up in the fist box of the first product in the Difference Column. 

 

Click on this number.

 

Grab the blue dot on the bottom right of the cell and drag this formula down to all of the cells in the Difference Column.  

 

Go through the list for any discrepancies, and figure out why any numbers do not equal Zero.  

 

• Check Due to/Due From Slack Channel
• Look for products that are pulled off the shelf for awaiting orders
• Check for products that may have been placed on NSC shelves by accident 
• Check for products that have matching, missing vs. extra products.  EX: Bowel Rej. is missing 2, but Bowl Rev has 2 extra.  
• Check orders in Finale and Shopify
• Check NSC to SP/CH Items Doc
• Recount

 

If you are able to account for the product, adjust the number in the Count Column.

 

Highlight anything that does not equal zero.  

 

Go back to Clove Hill Quick Books

 

Click on New:

 

 

Click in Inventory Qty Adjustment:

 

 

Enter any products you are adjusting in the Product Column and Enter the number in Change in Quantity Column:

 

 

Enter this information in the Memo:  Inventory Count and your initials:

 

 

Click Save and Close

 

Open the CH Inventory Counts spreadsheet:

 

 

Add a new tab and title it the date you are completing inventory

 

Add the entire spreadsheet in the new tab.