cancel
Showing results for 
Search instead for 
Did you mean: 
budmax305
Level 1

COGS not posting from invoice

We do progress invoices to our customers based on milestones we've attained, but not based on inventory shipping.  The inventory is shipped all at once later in the project timeline and we have already invoiced the customer at least twice by then.  To manage our inventory, we create a separate sales order for all the inventory on the job with $0 revenue. When the inventory ships, we create an invoice from this sales order to remove the inventory and record COGS.  However, about 20% of the time the COGS does not record.  I have verified the inventory items are set up correctly, so that's not the problem.  And it happens randomly (meaning an item will normally records COGS, but once in a while it won't).

 

Does anyone else have this problem and know how to fix it?  Right now I copy the first inventory sales order to a secondary one and invoice from there.  Sometimes even a third sales order is needed because some items have now hit COGS and some haven't.  It is very random and frustrates us.

1 Comment 1
JoesemM
Moderator

COGS not posting from invoice

Thanks for posting the Community space, @budmax305.

 

The source of Cost of Goods Sold(COGS) is the purchase cost. If the inventory sold doesn't have any purchase transaction, then this will post as zero COGS when you used it on the invoice.

 

To better isolate this, we can check the transaction history of those invoices that don't post to the COGS. This way, we can verify if the posting is correct.

 

However, if it's correct, let's verify and rebuild your QuickBooks software. This process is used to fix common data issues and unexpected behavior within the file.

 

Before doing so, make sure to update you QuickBooks for Desktop to the latest release so you'll have the latest features and fixes. Then follow the steps below:

 

To run the Verify Data utility: 

  1. Go to File at the top menu.
  2. Select Utilities.
  3. Click Verify Data.
  4. Let the tool check your file for data issues. 

 

To run the Rebuild Data utility: 

  1. Go to File at the top menu.
  2. Select Utilities.
  3. Click Rebuild Data.

Here's an article that'll serve as your step by step guide in resolving common data damage on your company file: Verify and Rebuild Data in QuickBooks Desktop.

 

You can also run the Transaction Journal Report for the inventory item you sell. From there, you'll see the Inventory/COGS transactions which credit the Inventory Asset account and debit the COGS accounts.

 

Let me also share these articles that can serve as additional guides when tracking inventory in QuickBooks: 

 

 

I'm still here to help if there's anything else that you need. Just leave a reply below and I'll get back to you. Have a lovely day ahead!

Need to get in touch?

Contact us