Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
June 30, 2022
Question

COGS Doubling

  • June 30, 2022
  • 4 replies
  • 44 views

Sometimes when we sell a item the COG's on the P and L will show zero, then double on the next sale of that item to make up the difference. We are using the calculated average. 

 

Has anyone else come a crossed this issue?

 

Justin

4 replies

Rainflurry
Level 11
June 30, 2022

@jth21usa 

 

That is a frequent question on this forum.  QB will do that when you oversell an item.  When you oversell the first item, it won't record any COGS but will make it up when you sell the next item. 

jth21usaAuthor
June 30, 2022

I'm not sure what over sell is, I had two items in stock and sold one. Is there a way to manual correct or over ride?

QuickBooks Team
June 30, 2022

Hello there,@jth21usa.

 

I'm here to help you figure out how to resolve these discrepancies in COGS. Let me go over some specific information.

 

One of the reasons why COGS is unable to match P & L is that there are items that were entered or received that have an incorrect cost.

Items initially don't have a cost, and we're only entered after a sale has been made. Or there are adjustments to the QuickBooks Desktop COGS account that have been made that will not be reflected in Point of Sale.

 

Moreover, running an Item Summary report is the key to determining whether items have a zero cost.

 

  1. Select Sales Item Summary from the drop-down menu.
  2. By selecting Modify and then Revert, you can ensure that all filters and customization have been removed.
  3. To sort and group by Item, click the Item Name column header.
  4. Look for 0.00 dollar amounts in the Ext Cost column. Inspect other item costs to ensure they are what you would expect.

 

Note: If no items have 0.00 dollar amounts, try Solution 2.

 

Let's try fixing this by following the steps below:

 

  1. Make a note of the item or items with a 0.00 ext cost.
  2. Select Inventory, then select Item List.
  3. Select Edit after bringing up each item one at a time.
  4. Examine the History report to see how many items sold for free.
  5. Multiply the quantity sold by the cost of each item.
  6. Enter this amount into QuickBooks Desktop and create a journal entry that debits Inventory assets and credits the Cost of Goods Sold.

 

Furthermore, to avoid this problem in the future, please make sure you receive items on a voucher rather than manually entering quantities as you add new items.

 

Feel free to visit this page for your reference in resolving discrepancies with the Cost of Goods Sold in QuickBooks Desktop.

 

In addition, read this QuickBooks Blog on to how to calculate and record COGS.

 

If you have concerns, tap the Reply button. I'll be around to offer some help. Have wonderful day.