Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
December 6, 2018
Question

How can I adjust inventory without changing COGS?

  • December 6, 2018
  • 2 replies
  • 0 views

We have 2 versions of several products. 

Version A and Version B

All the BILLS for inventory were created as Version A.  We did not create inventory for version B.   We sold many version B units and now have negative inventory for Version B and too much inventory for Version A.

 

If I adjust inventory the cost of goods changes and profit goes out of whack.

Is there a way to adjust inventory without affecting cost of goods? 

2 replies

December 7, 2018

Glad to see you here, Mccoy,

 

I can share some information about adjusting your inventory.

 

At this time, there isn't an option to adjust the inventory without affecting the COGS account in QuickBooks Online. This is because inventory is the main component for calculating the Cost of Goods Sold that's reported in the income statement.

 

Any changes made to the inventory will always affect your company's Current Assets in the Balance Sheet and the COGS accounts. In your case, it would be best to check with an accounting professional to get help adjusting your inventory without affecting the COGS. They can provide you with the best legal and accounting advice on what you can do to get past this hurdle.

 

Please update me on how this goes, Mccoy. I'm your personal QuickBooks guide. Have a good one!

Rustler
Level 15
December 7, 2018

@mccoy11

 

QB does not allow for the transfer of item qty and cost from one item another at all in QBO, and it makes it difficult to do so in desktop.

in QBO you have to use a work around

create a cash type bank account called clearing
use inventory adjust, set the adjusting account to the clearing bank account, then lower the qty of item A
use any vendor, or create one called inhouse, and "BUY' the item B in the same qty, the total amount is the balance in the clearing bank account

October 22, 2019

Hi @Rustler 

I am having trouble with this. I understand what you did with the clearing account. However when you "BUY" or create an expense of the same product, it will obviously change your costs.

 

Am I missing something?

 

Thanks

Rustler
Level 15
October 23, 2019

@jbuzaglu wrote:

Hi @Rustler 

I am having trouble with this. I understand what you did with the clearing account. However when you "BUY" or create an expense of the same product, it will obviously change your costs.

 

Am I missing something?

 

Thanks


What this does is move the value of the item(s) to the clearing account

at that point the total value of inventory asset is lowered

then you "buy" inventory using that value and inventory asset increases

so the cost is transferred to the new item