Good morning! I'm hoping you can help me with an inventory issue.

When we first set up QBO, we were not intending to use it as our primary accounting system. Thus, when I set up products, I put in nonsense inventory numbers. Fast forward to a year later, when our company has determined this will be our primary accounting system :)

The current inventory numbers for all products in QBO are incorrect. I now have our exact 5/31 inventory numbers in excel and can do an inventory quantity adjustment in QBO. But, when I do, it creates a huge inventory shrinkage. Is there a method to either eliminate that inventory shrinkage, or somehow do this inventory adjustment without creating the inventory shrinkage? We don't really need the historical stuff to be correct, just want it to be correct going forward and not reflect that huge inventory shrinkage.

Even if there's a work around or anything like that, it would be fantastic. Thanks in advance for any help you can provide!