Highlighted
Experienced Member
5 Comments
Established Community Backer ***
Re: Inventory and COGS

Just to clarify - do you have QuickBooks Desktop (QBDT) or QuickBooks Online (QBO) like Plus, Essentials or Simple Start)? 

Experienced Member
Re: Inventory and COGS

QBO Plus.

QuickBooks Team
Re: Inventory and COGS

Hi Jenae85,

 

I can share a bit of information about inventory setup in QuickBooks.


How exactly did you enter your raw materials in QuickBooks Online? Once you set up your first inventory item, the program automatically adds two accounts to your Chart of Accounts.


They are the Inventory Asset (Other Current Asset) and Cost of Goods Sold.  Generally, COGS is affected only when you sell the items. This account isn’t meant for the items you use to create your products, such as raw materials.


For more details about how inventory works in QuickBooks, check out these articles:

If the items you bought are used to run your business or part of your inventories cost, you can record them as expenses. However, for those you buy and resell, you can directly add them to your Products and Services List.


Here’s how:

  1. Go to the Gear icon at the top then pick Products and Services.
  2. In the Products and Services window, select New.
  3. Click the product or service type.
  4. Enter the new product or service information.
  5. Choose Save and close.

If you want to replenish these items in the future, you'll have the option to use the Expense or Bill functionalities. Just make sure to use the item details field so you can select which one you need from the list. This way, the program will recognize an increase in volume.


To answer your last concern; yes! You can enter the actual cost so that the program can automatically calculate the COGS amounts upon the sale of your items.

 

That's it! Don't hesitate to let me know if there's anything else you need help with. I'm here to help anytime.

Experienced Member
Re: Inventory and COGS

This is where I'm getting confused, I didn't enter the raw material into inventory. I simply expensed to Supplies & Materials - COGS when I entered the transaction into QBO. I only added the final product into the inventory. The expense account used for inventory items is COGS. So am I doubling the expenses in COGS? I guess my biggest problem here is that I don't understand how COGS and Inventory works. Nor do I understand how this effects my financials. If you could explain it in Layman's terms that would be great!   

Established Community Backer ***
Re: Inventory and COGS

QuickBooks Inventory functionality is very basic like buy gadgets and sell the same gadgets. It's really not designed for converting from raw materials to finished products process.
If you're buying/selling products, you can follow the above article link for more information.

 

The only workaround is if you're buying few material items and making the final product out of that, you can create known as Zero Bill in QBO.
See example below with attachment for reference.

 

In this example, $1000 materials purchased and expensed to COGS (a separate account). Final product - produced 10 units. Average Cost is $100 per unit ($1,000 /10 = $100).

To enter Zero Bill:
Select create "+" sign on top > Vendors > Bill
For Payee, create a new one something like inv adj
Under account details section > select account originally used to purchase materials > enter negative amount -1,000.00. (This will reverse out previously entered COGS expense).
Under Item details section > enter product/service item, quantity and the amount same as above account details. In this case, $1,000. (This will add to the inventory item. When you create invoice or sale receipt, it will also post COGS at $100 each unit).
Entered Bill should zero out.

 

-

zero_bill.PNG