cancel
Showing results for 
Search instead for 
Did you mean: 
mccoy
Level 1

How can I adjust inventory without changing COGS?

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? 

7 Comments 7
Anonymous
Not applicable

How can I adjust inventory without changing COGS?

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

How can I adjust inventory without changing COGS?

@mccoy

 

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

jbuzaglu
Level 1

How can I adjust inventory without changing COGS?

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

How can I adjust inventory without changing COGS?


@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

jbuzaglu1
Level 1

How can I adjust inventory without changing COGS?

Ok, so basically for inventory depletion you transfer Inventory to Clearing Account, and for Inventory Purchases, you make a regular expense?

 

What happens to that clearing account, it will grow infinitely, will that increase affect your expenses or sales in any way? 

 

Thanks @Rustler 

Rustler
Level 15

How can I adjust inventory without changing COGS?


@jbuzaglu1 wrote:

Ok, so basically for inventory depletion you transfer Inventory to Clearing Account, and for Inventory Purchases, you make a regular expense?

 

What happens to that clearing account, it will grow infinitely, will that increase affect your expenses or sales in any way? 

 

Thanks @Rustler 


You buy the item FROM the clearing account, so each process zeros out

value goes in the clearing account, same value out to buy the new item

ChalosCoffee
Level 1

How can I adjust inventory without changing COGS?

Thank you so much!  This helped me in my business as well!

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

Need to get in touch?

Contact us