We have the same problem and it is a total PAIN!!!! Each month, we export the inventory report into Excel and multiply the qty by the cost and total the column. Then we post a J/E with a debit or credit to Inventory Asset to correct the overall value of the Inventory and post the reverse to Inventory Adjustment. This corrects the monthly financial but a much better fix would be to allow us to adjust the value assigned to the specific product and then when the widget is sold, the correct COGS is deducted and the daily financials would be correct. Unfortunately, we have many products that we make ourselves and do not buy, and thus we need to be able to subtract costs from the ingredients and add costs to the final product. I cannot see a way to do this with QBO.
