Skip to main content
L
lbenioff
October 10, 2024
Question

An entry was created adjusting the the cost of an item by it's average cost

  • October 10, 2024
  • 1 reply
  • 0 views

I've discovered a few of these, but here is one example. 

 

This is a report of a COGS account.  The amount of $812.73 is the average cost that I see when I open this Item to edit it.  The actual cost of the item cost on this transaction was $759.36 so another entry was created by QB for $53.37 which is the difference.  Why is QB doing this on this item?  I have many other items in this same COGS report whose cost differs from the average, but no such entry was created.   I've compared items and can't see why this one item is being treated this way. 

 

 

1 reply

J
JorgetteG
October 10, 2024

I appreciate you coming to us with your question about the adjustment entry created for your item's average cost in QuickBooks, Lbenioff. I see how important inventory costing is for your business, and I'm here to guide you and address your concerns.

 

QuickBooks has made an automatic adjustment entry to ensure the accuracy of an item's average cost. This is due to the item's actual cost in the transaction being different from its average cost. This is to adhere to the first-in, first-out (FIFO) cost flow assumption, which is a method to determine the cost of goods sold. In a FIFO inventory system, items sold are assumed to be the oldest items in stock. Therefore, the system needs to track and adjust the cost of items to guarantee that the inventory and cost of goods sold accounts are precise.

 

Other items in the COGS report whose cost differs from the average may not have the same adjustment entry because their cost deviation may not reach the threshold to trigger the system to make such an adjustment. Aside from this, it may also be due to other factors such as the item's receipt into inventory, whether its cost was manually adjusted, or whether other transactions have previously affected its cost.

 

However, to prevent any future adjustment entries related to the item's average cost, you may consider the following suggestions:

 

  • Check if there are any manual cost adjustments made to the item that caused the deviation from the average. If so, review the reasons behind the manual adjustment and adjust your inventory costing procedures accordingly to avoid inconsistencies.
  • Review your inventory costing procedures regularly to ensure that all adjustments made (whether manual or automatic) are appropriate and accurate.
  • If you have any further concerns or questions about the inventory costing and adjustment entries in QuickBooks, consult with an accountant or QuickBooks ProAdvisor for assistance and guidance.

Lastly, I've added these articles as additional references about ways to understand inventory costs:

 

 

We understand how crucial it is to have accurate inventory costing, and we assure you that QuickBooks is designed to help ensure your inventory and financials are precise. If you have any further questions or concerns, you can leave a message below. We're committed to providing you with the best support and guidance possible.

L
lbenioffAuthor
October 10, 2024

Thank you for the quick response.  I understand the concept of FIFO.  I actually carry very little inventory, but instead order an item as needed and sell it.  For this item I was able to correct the issue by changing the date of the invoice which preceded the bill (inventory increase).  However, I have another situation that also had the invoice date prior to the bill, but changing the Invoice date did not correct the issue.  To be clear I had none of these items in stock as seen in the picture below. The last ones I sold were in Oct of 23. 

 

 

So why is QB adjusting the cost?

 

M
MAnneJ
October 11, 2024

I appreciate you for your prompt response, @lbenioff. Let me provide additional information about the invoice date prior to the bill.

 

QuickBooks Desktop (QBDT) is adjusting the cost of the item based on the average cost because the average cost is set as the default cost method for inventory items. This is how QuickBooks helps maintain accurate inventory values.


To verify this, you can go to the item's Settings and check the cost method. If it is set to average cost, then QuickBooks will adjust the cost of the item based on the average cost.


As for the issue with the invoice, it is possible that the item's cost was adjusted after the invoice was created, which caused the difference in cost. You may refer to this article for detailed information: Fix negative inventory issues in QBDT. 

 

The average cost is based on your purchase history for the item, calculated from the beginning to date. QuickBooks will compare the new average cost to the average cost used when selling and purchasing more of the item. Therefore, QuickBooks will make an adjustment entry to both the inventory asset and COGS accounts.

 

Changing the invoice date will not correct this as the cost of the item has already been adjusted. To prevent this issue in the future, make sure to update the cost of the item before creating any invoices or bills that include it.

 

Additionally, you might want to refer to this article and learn how to track discrepancies in the Inventory Asset account: Balance Sheet and Inventory/Stock Valuation reports show different amounts for the Inventory Asset account.

 

I'd be glad to assist if you have additional questions about inventory adjustments in QBDT. Have a good one.

Terms & ConditionsAccessibility statement