cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
itsjayem
Level 3

Cost of Goods Sold showing in Enter Bill

Hi,

 

I am having an issue recording transaction in enter 

bills QB desktop. One item (#812) adds an entry to COGS and when I try to back date, it doesn't show up anymore. 

 

Please see attached the same transaction with 2 different dates.

 

Thank you!

 

Screenshot 2022-09-23 082322.png

Screenshot 2022-09-23 082222.png

1 Comment 1
BigRedConsulting
Community Champion

Cost of Goods Sold showing in Enter Bill

This is normal.

 

If you sell inventory so that you end up with a negative QOH, QuickBooks estimates the COGS on the sale based on the last known average cost for the item (or FIFO cost of you're using FIFO).

 

If you then purchase more of the item at a later date using a price that is different than that estimated cost, QuickBooks adjusts it on the purchase, adding or subtracting COGS on that transaction.

 

But, if you enter a purchase on an earlier date than the sale, or you edit the purchase and change the date to be an earlier date, then QuickBooks does not enter a COGS adjustment on the purchase and instead recalculates the COGS on the sale.

-------------------

Note that, actually, none of the COGS line items you see in reports - those automatically calculated when you record sales for inventory items (and sometimes purchases) - actually exist in your data file. Instead they are manufactured at report time based on each item's history of purchases and sales, in date order. So, when you enter data out of order, or you change the dates of existing transactions, the results you see in reports will re-calculate and potentially change.

 

For example, if you purchase a brand new inventory item (with no history) for $10 and then sell it a week later for $20, your COGS will appear as $10 on the invoice in reports. But, then if you purchase another of those things for $15 and date that purchase before the invoice, the COGS you see on reports for the sale will change to $12.50.

 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up