Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
7399socks
Level 2

If I change the Cost price of an inventory item in Quickbooks online, will that change the COGS going forward only or will it change all past COGS of that inventory item as well?

If I change the Cost price of an inventory item in Quickbooks online, will that change the COGS going forward only or will it change all past COGS of that inventory item as well?

 

Example:

We purchase an item on 1/1/2019 at $50 and enter the sale price as $100. COGS will be $50, GP will be $50. Due to covid, costs have increased. We purchase more inventory on 1/1/2022 of the same item, this time costing $75. We still sell our items at $100. When we sell an item, COGS will be $75, GP will be $25. If we edit the "cost" of the item (in the Products & Services section) to be $75, will that change in COGS be reflected in all future sales of that item? Or will that change in "cost" change all previous sales of that item too?

 

Hoping and praying it only changes future sales going forward... otherwise how the F are people supposed to update their inventory costs on Quickbooks Online to reflect the fluctuating prices in inventory due to covid?!?!?!?

1 Comment 1
JonpriL
Moderator

If I change the Cost price of an inventory item in Quickbooks online, will that change the COGS going forward only or will it change all past COGS of that inventory item as well?

Hi there, @7399socks.

 

I'm here to help share insights about the cost of your inventory items in QuickBooks Online so you can update them accordingly.

 

Changing the cost of goods sold or the cost of an inventory item does not affect the purchasing amount recorded in your existing transactions. Yes, you can change the cost of a product or service item without worrying about the effect within your existing entries since it'll only reflect on your future transactions.

 

However, changes like this may affect the amount of COGS tracked within your financial records due to the concept of inventory tracking used in QuickBooks. Kindly read and use this article to learn more: What is FIFO and How is it Used for Inventory Cost Accounting?

 

I'm also including this reference so you're able to use all the features and functions of QuickBooks: Help Articles in QuickBooks Online. Here, you're able to read subtopics that will describe how a feature is used and how to accomplish tasks related to its functions.

 

It'll always be my pleasure to help if you've got questions other than working with your product and service items in QuickBooks. Use the Reply button and leave your comment below so that I, @JonpriL, can lend a helping hand.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up