Skip to main content
J
JZ63
January 11, 2024
Question

Physical Inventory - QB Desktop Enterprise Edition

  • January 11, 2024
  • 1 reply
  • 0 views

We are in the process of completing a physical inventory and the enterprise edition is not specific as to how to reconcile the counts to complete the physical inventory.

We currently utilize the QB Desktop Enterprise solution for Manufacturing & Wholesale.

Our inventory is very large so manual entry one item at a time would not be an option.

 

1 reply

MJoy_D
MJoy_D
January 11, 2024

 I can share some information that can help you with completing your physical inventory, @JZ63. 

 

You can use the Add/Edit Multiple List Entries window tp copy the data from an Excel file and paste them in QuickBooks to update your inventories. 

 

Here are the steps to follow:

 

  1. Go to the List menu and select Add/Edit Multiple List Entries.
  2. Click the dropdown list for List and select Inventory Parts.
  3. Copy your data from Excel and paste them in the screen.
  4. Select Save Changes.

 

You can also use this feature to update multiple customers, vendors, and other items in the program. Check out this article for more information: Add and Edit Multiple Customers, Vendors, and Items.

 

Refer to this article for more information about adjusting the quantity or total value of your products in QuickBooks Desktop: Adjust your inventory quantity or value in QuickBooks Desktop. 

 

Here are also the possible causes as well as it effects on your company file when you have negative inventory: Fix negative inventory issues in QuickBooks Desktop. 

 

You can always leave a reply below if you have follow-up questions regarding inventories. I'm always here to assist. Have a wonderful day!

J
JZ63Author
January 11, 2024

I find it hard to believe that the Enterprise Solutions for Manufacturing & Wholesale 23.0 with the Advanced Inventory module does not have an actual physical inventory reconciliation.  We have approximately 2700 to 2800 active items and a reconciliation thru the item list does not seem like a very productive method, in addition, it also does not generate any audit records. 

S
SheandL
January 11, 2024

Hello there, @JZ63.

 

I can see how much this feature is a must in QuickBooks Desktop since it streamlines your physical inventory reconciliation. Please know that we value our customer's experience while using our product. To make this possible, I recommend sending a feature request to our product engineering team so they can consider adding this functionality to the upcoming updates. To do so, here's how:

 

  1. Go to Help. 
  2. Select Send Feedback Online, then Product Suggestion.
  3. The QuickBooks Feedback window will appear.
  4. From there on, write your product suggestion in the field provided.
  5. Hit Send Feedback and Close Window to exit.

 

You can also check this article to learn how to organize your account to match your bank and credit card statements: Reconcile an account in QuickBooks Desktop.

 

If you have further questions regarding physical inventory in QBDT, don't hesitate to get back to us by replying to this post. 

Terms & ConditionsAccessibility statement