Solved

Correct Average Cost

Forum|Forum|7 years ago
February 18, 2019
5 replies
2 views

We are using QB Desktop Premier 2018

When we setup our inventory we have a few items that were entered at a very wrong cost, when those items were sold, it created a transaction recording that transaction.

And now it lists the average cost as the incorrectly. (of course)

We would like to do the following:

Correct the cost in the Inventory Edit item, we know how to do this.

Go back and find the few transactions that use the incorrect cost, and correct those. One by One.

Have inventory now show the proper correct average cost, in the reports.

Thanks

Aaron

QuickBooks Desktop

Best answer by Aaron_M

@Teri11_2

RE: When your customer is the US Government and you agree to a price that is based on average cost plus say a material OH rate and a fee, then you get audited and average cost used to buildup price CHANGED....

When you are this person with such a contract, then you better not mess up your average cost! If you don't mess it up, then you won't need to fix it.

Thanks Everyone, we've come up with a solution we like.

The few items with a messed up cost were located, and then corrected.

Then only after it is fixed, go into the first Invoice with the item on it, remove it, and save the order, then add the item back and re-save the order.

The costs are re-calced and the problem solved.

Ta-Daaaa, just like magic.

And no, the client is not the US Government, so there is no long term GAAP paradox. :)

Thanks Again to everybody who answered.

T

Teri11_2

Level 2

Sounds like the right thing to do to make all correct, but I would think if the item has been sold it is no longer IN inventory for you to edit cost nor to be included in the average cost to be computed

A

Anonymous

@Teri11_2

RE: Sounds like the right thing to do to make all correct, but I would think if the item has been sold it is no longer IN inventory for you to edit...

You can edit your purchases at any time, even after you have sold the items, and QB will adjust the average cost and 'ripple' the costs forward to the sales.

T

Teri11_2

Level 2

Interesting, since it would be too late to bill customer at "cost" plus mark-up at that point.

That would not pass audit in my industry, since that is the whole point of average costing.

A

Anonymous

The cost is normally based on your purchases of that item. So, if you record those purchases correctly, then the cost will adjust. If the initial inventory balances were set up with adjustment transactions, then edit those transactions on order to update the average cost.

qbteachmt

Level 11

Please note that this is only a Notational field: "Correct the cost in the Inventory Edit item, we know how to do this"

That doesn't affect Average. That is Notational, as data entry Jump Start. If I buy something at various costs, I can leave that as $0, or note my most likely cost or a quoted cost to document it.

What matters is this part, what you did and how you did it and when you did it: "When we setup our inventory we have a few items that were entered at a very wrong cost"

When you first started using QB, you set up Items. The Cost here is meaningless, because you are then going to use your most recent Physical Inventory to make one Adjust Inventory worksheet, entering Quantity and Cost on Hand, from that Physical Inventory.

Now, if instead, you used New Item, put in a Cost, and also entered On Hand Beginning Balance here, you made up Phony data. You told that system, "Hey, I just found some stuff!" And the system attempts to compute data you did not provide, so it assumes Cost in Edit item x Quantity you just put in the New Item entry, is Basis on hand. And the offset is Opening Balance Equity.

If you did it like that, then the Errors are in that Opening Balance Entry adjustment screen that got created each time you Made an Item and also put Beginning Quantity on hand. You need to fix each of these entries. Because you used a function that allowed you to provide an inadequate amount of info.

You Make New Accounts, New Names or New Items. Then you use the Functions, not the "field for beginning balances" to populate the actual data.

T

Ted D

I am using QB Pro 2020

We had lottery tickets and the cost of the ticket is $5.00 but the average cost is $300.00 per ticket. It is using that $300.00 in "other assets" and in COGS. I have tried and tried to be able to change the amount to $5.00 but it will not let me change it. it is adding 60 X $300.00 in other assets and in COGS instead of 60 X $5.00 or $18,000 instead of $300.00.

Can anyone help me with this?

Thank you

Rubielyn_J

Level 8

Welcome to the Community space, @Ted D.

Thanks for providing screenshot. Let me provide you some insights on how QuickBooks calculate average cost.

When you sell what you don't have in stock, QuickBooks will post the current average cost to COGS. When you buy items, QuickBooks compares them to the average cost used when sold what you do not have. If there's a difference, QuickBooks makes an adjustment entry to both inventory assets and COGS.

If you're having a high cost posted, then it means that the item doesn't have an established average cost. Established average cost comes from purchases of the item, qty, and total cost of that qty.

As a workaround, we can create an adjustment to these items. If you have entered these items without using them in a transaction you can delete and recreate the item and enter the correct amounts.

Here's how:

Go to the Lists menu, choose Item List.
Click the Activities drop-down then select Adjust Quantity/Value on Hand.
Input the correct details then check the Item Info After Adjustment at the bottom-left of the window.
Click Save & Close once finished.

You can also recreate the items by batch using the Add/Edit Multiple List Entries options. Please refer to this article for more info: Add and edit multiple customers, vendors, and items.

Let me know if you have further concerns. I'd be glad to lend a hand. Keep safe and healthy.

D

dwade1

Hello~

I want to make sure I understand this correctly. The average cost is (incorrectly) inflated due to a) original cost being entered incorrectly, or b) the cost changes everytime an item is sold, when not on hand, per QB? For example, one of our items is part of a bill of materials. the normal average cost of this SHOULD be 373.18, however, it is showing a -2314.16 for the average cost and -33 on hand, because it has to be mixed with another product for the final product - which has been done, physically, but the BOM has not been generated yet in QB to zero out the QOH. There has to be another explanation than the -33 on hand changing that cost. I know the original costs were put in correctly. Am I misunderstanding your explanation? Is there anyway to change to a FIFO system in Premier Mfg & Wholesale 2020 version? This average cost changes so much and is frequently incorrect and we can't seem to change it to the correct prices. Any breakdowns would be appreciated...

A

aht1

Our general ledger did NOT change when I tried this solution!!!

Do I have to wait for an overnight-update?

I can see the change in reports as "transaction detail by account"

But the trial balance did NOT change!

R

RCV

QuickBooks Team

I've got you covered in repairing your damaged company file in QuickBooks Desktop, aht1.

We can run the Inventory Valuation Summary report if you have any questions about an average cost. This shows you how QuickBooks got the item's average cost.

Go to Reports, on the top menu.
Select Inventory.
Select Inventory Valuation Summary, then set the dates to All.
Double-click the item in question.

Once done, run the General Ledger and Trial Balance report to see if it will provide you with the correct data. QuickBooks will post the current average cost to COGS when you sell what you don't have in stock. QuickBooks compares them to the average cost used when selling what you do not have when you buy items. Then, the software makes an adjustment entry to both inventory assets and COGS if there's a difference. Here’s an article that provides more insights on how QuickBooks handles inventory accounts and the average cost: Understand inventory assets and cost of goods sold tracking.

If the same thing happens, we can update QuickBooks Desktop to the latest release. Once done, use the Rebuild Data tool to automatically fix minor company file data issues. Here's how:

Go to the File menu, then hover over Utilities and select Rebuild Data.
On the QuickBooks Information window, press OK. Follow the onscreen steps to save a backup.
Let the tool repair your file. It may take some time. QuickBooks may seem stuck, but as long as you can move your mouse, the tool is working.
When the tool finishes, press OK.
Go to the File menu. Then hover over Utilities and click Verify Data.
Let the tool check your file for data issues.

If QuickBooks doesn't find any problems, press OK. You can keep using your company file if you don't have any data damage. Then, select Rebuild Now if QuickBooks finds an issue with your company file.

If you’re still having data issues after rebuilding your company file, try again. If you still have data issues, use the QuickBooks File Doctor to fix your company file. You can check out this article for more details about fixing data damage on your QuickBooks Desktop company file: Fix data damage on your QuickBooks Desktop company file.

I want to make sure I've got you covered. You can click the Reply button below for follow-up questions and clarifications about running your financial reports in QuickBooks. I'll be in touch.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded