Hi, I'm Robert and I'll be helping you with your financial software question.
Does the cogs show up for new items after you changed the cost "to your company" to zero ? or is it from old items before you changed your methods ?
For new items, I have always put in "Zero" for the cost. I think this is for items that are old...that the cost has been changed to "Zero", but I am still using.
Can you send me a screen shot of the report that you are having issues with please
Screen shot instructions
hold alt button down hit print screen button release buttons
click start menu / all programs / accesories / paint
click edit / paste
click file / save as
save as a jpg file in my pictures
on the top of this window click the insert button it should be a paper clip to right of the smiley face.
click browse in the 2nd window that pops up
browse to the file you just saved in my pictures
click insert back in the first window
will that report drill down ?
some of them if you double click on the COGS or the 297 it will open up and show you where that money is coming from.
pull up those invoices and look at them. There is probably something about them in common. They may all have sold one or two particular items that were not adjusted completely when you did the switch
look at a couple of them and then look at that particular item that was sold.
I have checked repeatedly these items. They are all under a single parent group. They all have a COGS as "zero". The amount listed on the report is coming from the "average cost" of the item.
ok. that means that you sold the item previously maybe years ago and it had a cost back then.
That is one of the deficiencies in quickbooks. It insists on using average cost for inventory items. Other programs can adjust to Lifo or Fifo.
Try the instructions on this page to manually adjust the cost for those items. And you might want to avoid the issue totally by giving them new item numbers.