Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
mccoy11
December 6, 2018
Question

How can I adjust inventory without changing COGS?

  • December 6, 2018
  • 2 replies
  • 10 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

A
Anonymous
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
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

    J
    jbuzaglu
    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
    Rustler
    Level 15
    October 23, 2019

    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 


    @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

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement