cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
amynhemani
Level 2

Problem with average cost

Hi, I just acquired a new business and the previous owner was using Quickbooks 2023 Premier Pro and I am using the same but just 2024 version. The inventory data was transferred and the the average cost got messed up, I have tried my best to change it but it doesn't let me change it. I have successfully changed the cost of the items. I have about 552 items and the data is messed up in 335.

Is there a way to unlock the average cost to change it and reflect the correct amount.

Please help me out as I have to start invoicing customers from Monday.

2 Comments 2
JamaicaA
QuickBooks Team

Problem with average cost

Welcome to QuickBooks Community, amyn. 

 

I understand the importance of recording the correct average cost of the 552 items. Let me share some steps to help you fix the discrepancies and reflect the right amount.

 

We can start by running the Inventory Valuation Summary report to see how QuickBooks got the item's average cost. It will help you locate the cause of the issue. I'll show you how:

 

  1. Select Reports, then click Inventory.
  2. Choose Inventory Valuation Summary, then set the dates to All.
  3. Double-click the item in question.

 

Unlocking the average cost to change it is unavailable. What we can do is create an adjustment to these items. To proceed, follow the steps below:

 

  1. Go to the Lists menu and select Item List.
  2. Click the Activities drop-down, then pick Adjust Quantity/Value on Hand
  3. Input the correct details and check the Item Info After Adjustment at the bottom-left of the window.
  4. Hit Save & Close.

 

Here's an article about computing the average cost and handling inventory management: Understand Inventory Assets and COGS tracking.

 

Find out more about inventory quantities and value through the following resources:

 

 

I want to make sure I've got you covered. Feel free to click the Reply button below for follow-up questions and clarifications about inventories. I'll be in touch.

4Gal
Level 11

Problem with average cost

@amynhemani 

I suspect there is negative inventories. Run Verify/Rebuild Data utility. Did you encounter any error message?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us