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

Can we enter our total cost by product for reporting in Cost of Goods Sold on P

We are having issues understanding how the cost of goods sold arrives at the cost in the P
5 Comments 5
katherinejoyceO
QuickBooks Team

Can we enter our total cost by product for reporting in Cost of Goods Sold on P

Hi there, @gngrbrmn.

 

Thanks for asking us today. The total cost of sales for a product with inventory type is calculated by adding all costs together. Also, the report will be based on the amount entered on the expense transaction.

 

You can also read these articles for more information about inventory tracking in QuickBooks Online:

 

 

 

Feel free to come by and post some more of your concerns if you have any. I'll be right up to help you again. Take care. 

gngrbrmn
Level 1

Can we enter our total cost by product for reporting in Cost of Goods Sold on P

Thanks so much for responding!  I'm still having trouble understanding how it is arriving at the amount for each finished product we sell in cost of goods sold.  We sell roughly 20-25 products that we build in our warehouse from multiple parts we buy from various vendors - some finished products are made up of over 15 different parts we purchase from various vendors. Quickbooks does not know which parts we buy go into which completed product we then sell.  Is there not a spot under products for us to list our actual cost to build that finished product we will then sell? I've attached a screen shot of what we see in the detail of cost of goods sold under the p&l accrual method.  Many products even show zero which we know is not correct and the cost for the products it does show a price for is not correct.  

CharleneMaeF
QuickBooks Team

Can we enter our total cost by product for reporting in Cost of Goods Sold on P

Thanks for updating us on this, gngrbrmn. I know it can be difficult when the COGs show incorrectly. I'm here to share some insights.

 

Unlike QuickBooks Desktop, QuickBooks Online doesn't offer a Manufacturing feature. It doesn't allow you to combine items to make something else. This is the reason the COGs are incorrect on the Profit and Loss.

 

Since you can only track your finished products as inventory items, you can create a cash-type bank account called WIP (Work in Progress). Then, create a vendor called in-house.

 

In real life, make your finished product. Please note how many items were used and made. In QuickBooks, you can perform these steps:

 

  1.  Use inventory adjusts, then set the adjusting account to the WIP bank account and lower the qty of all items used.
  2. If outside processing costs are also paid, use this WIP bank as the expense (reason) for the payment.
  3. Bring up an expense transaction, select the in-house vendor.
  4. In the item details part, select the finished item. Then, enter the qty made. Put the total amount that is in the WIP bank account.
  5. On the account details part, select the WIP account. Then, enter that same amount as a negative number.
  6. Save the zero-dollar transaction.

 

The inventory has been relieved, the costs accumulated in the WIP account, and finally, that total cost paid for the finished inventory item and stocked it with qty and item cost. The WIP bank is zero until you need it again.

 

To learn more tips in managing your inventory, you can visit our Inventory and projects page.

 

You can also check out this article to learn more about COGs: How to calculate and record COGS.

 

To check if QuickBooks Desktop is the right one for your business, please see this article: Track the Products you Manufacture.

 

If you're interested in moving to QuickBooks Desktop, you can check out our Plans and Pricing page.

 

Also, let us know how did you track your manufactured items in QuickBooks. This way, we'll be able to further investigate this.

 

I'm only a few clicks away if you need assistance managing your sales items. It's always my pleasure to help you out again.

gngrbrmn
Level 1

Can we enter our total cost by product for reporting in Cost of Goods Sold on P

So quickbooks desktop has better way of tracking cost of goods sold that might be more suited to our type of business? 

 

I noticed if we changed the initial cost/quantity on hand it does pull correctly then to cost of goods sold under the p&l but it changes it so that it shows that cost for prior dates too not just today's date going forward - so no way to compare our cost from one year to the next as it relates to sales etc in the p&l.  I was hoping there was just a simple field we could update with our total cost that we could then change as our product cost changes.

Angelyn_T
Moderator

Can we enter our total cost by product for reporting in Cost of Goods Sold on P

Hi there, @gngrbrmn.

 

QuickBooks Desktop (QBDT) and QuickBooks Online (QBO) might have unique ways of tracking inventory, however, both products assure you to handle your inventories or products and services accordingly. To learn more about these, you can review these articles:

 

 

 

You can also visit this page to see the QuickBooks products and the features offered: Plan and Pricing Comparison.

 

On the other hand, I can see the importance of getting a field to update your total cost so you can track your product cost changes in QBO. For now, you can use the Feedback feature to send this idea directly to our engineering team. This way, they could take action to help improve your experience. Rest assured they're working nonstop to enhance the product and deliver the best experiences to all QuickBooks users. 

 

Here's how you can submit your feedback through QuickBooks:

 

  1. Sign in to your QBO account.
  2. Go to the Gear icon, then click on Feedback.
  3. Enter your comments or product suggestions. Then select Next to submit feedback.

 

Your valuable feedback goes to our Product Development Team to help improve your QuickBooks experience.

 

If you have any other questions while updating the costs of your products, let me know by adding a comment below. I'm just a post away to help. Have a good one!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us