cancel
Showing results for 
Search instead for 
Did you mean: 
shanbala99
Level 2

How to make entries for purchase (COGS) against the sales in quickbooks online plus

 
11 Comments 11
MadelynC
Moderator

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Thanks for posting in the Community page, @shanbala99.
 

A way to track the Cost of Goods (COGS) is to make sure that there are income and expense details in your inventory items.
 

Also, you can manually track the value of your inventory assets in QuickBooks Online. To start, you can create an account to track your inventory value. Here's how:
 

  1. Select the Gear icon, then Chart of accounts.
  2. Click New.
  3. Select Current assets from the Account Type drop-down.
  4. Select Other current assets from the Detail Type drop-down.
  5. Hit Save and Close.

Second Create an account to track your cost of goods sold.
 

  1. Select the Gear icon at the top, then Chart of Accounts.
  2. Click New.
  3. Select Cost of Goods Sold from the Account Type drop-down.
  4. Select the closest type of Cost of Goods Sold that matches your situation from the Detail Type drop-down.
  5. Hit Save and Close.

When you purchase inventory using Checks, Expenses or Bills, use the asset account you created to track its value in the Account field. This "transfers" the money into the asset account, increasing the value of your inventory.

If you're using QuickBooks Online Plus, you can use the built-in inventory feature instead of tracking inventory manually.

 

You can refer to this article for further details: Manually track inventory.

Please let me know if you have any other concerns  in QuickBooks Online, I'll be right here to help. Have a good day ahead!

shanbala99
Level 2

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Hi Madelyn C

I have made entries as you said but in Reports in COGS showing only sales invoice not the purchase.

 

Can you please clarify.

shanbala99
Level 2

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Hi QB Team,

 

Please give us the step by step process for the purchase entry is to be posted in QB.

 

Thanks

Shanti

IamjuViel
QuickBooks Team

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Hello, @shanbala99.

 

When you set up your first inventory item in your Inventory List, the system automatically creates the Inventory Asset (Other Current Asset) and Cost of Goods Sold accounts

 

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.

 

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.

 

You can refer to this article for more insights: Understand Inventory Assets and COGS tracking.

 

Fill me in if you have other questions. I'm always here to help.

shisuman2011
Level 1

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Thanks it was good.

Alfred Guirgis
Level 1

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Hello IamjuViel

 

Good day

I am new with quickbooks, and trying to build it for my e-commerce business.

 

But I am stuck on several things..

 

1- I sell for ex: at ebay & shopify,, So I found several ways to do it,, 

  • Option 1: is to make a customer called ebay & shopify.. ( Which I do not think the best way for reporting )
  • Option 2: To make it on Charts of ACcounts : EX: Ebay Sales ( sub Accounts : Ebay Refunds / ebay product sales ) Then --- ebay Expenses ( Sub accounts: ebay fees / ebay transactions fees ) & same for the shopify or amazon
  • Option 3: is using Classes or Projects for each store..

So now I became confused, which is the right way to do it....

 

Putting in mind that I need in reporting: COGS to be linked to each account... 

It is as if I have several branches or stores, so I need to know the full image for each one.. To link each with their.expenses..  

 

I need to know more about the differences if I used those options.. 

 

Thanks for your support

 

 

  •  
AileneA
QuickBooks Team

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Hello, Alfred Guirgis. 

 

Allow me to dive in and share information about COGS in QuickBooks Online. Costs of Goods Sold (COGS), tracks all of the costs associated with the items you sell, which allows you to calculate gross profits accurately. 

 

COGS accounts also give the total underlying costs on your Profit & Loss reports. In QuickBooks, you create new accounts through the Chart of Accounts (COA). 

 

You then assign the necessary inventory items to these accounts so that you can accurately track what you have in stock, and know exactly how much you've spent and earned with it.  

 

Though, I still suggest reaching out with your accountant to give you a snapshot of the exact account that would be assigned to prevent any discrepancy in your book.   

 

To learn more and understand the workflow of Chart of account in QuickBooks, you can refer to this article: Understand the chart of accounts in QuickBooks

 

However, for option 3, Projects help track income, expenses, profitability, and organize all job-related information in the account in one place. You can create projects for multiple customers and add certain transactions such as estimates, invoices, expenses, bills, purchase orders, or time.

 

On the other hand, class and location tracking monitors income, expenses, and reports for different segments or locations of the business.  

 

For more information about these features, check out the following articles:

 

Lastly, you can also reach out to Shopify to guide on ways of syncing your data. 

 

As always, feel free to let me know if you have other questions about QuickBooks Online. I'd be happy to help. Have a great day, and be safe always!

Gerald6
Level 1

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Do products need to be set as inventory in order to get COGS, gross margin and gross margin % in Sales by product/service summary report?

SashaMC
Moderator

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Hey Gerald 6,

 

Thank you for reaching out to the QuickBooks Community. I was able to pull up my test account to verify this. You are correct in saying that the product would need to be set as an inventory to get COGS, gross margins, and gross margin % in the Sales by Product/Service Summary Report. If you ever need to customize a report, this article is very resourceful.

 

Please do hesitate to let me know if you have questions. I will be here to assist. I hope you have a lovely day!

TrinaMI
Level 1

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Hi,

 

I linked a PO to a bill to pay out. For some reason the items are now showing up on our P&L as a negative material amount. Is there a way to link a PO and have it reflect as Materials (COGS)?

 

Thank you, 

Rasa-LilaM
QuickBooks Team

How to make entries for purchase (COGS) against the sales in quickbooks online plus

Hello there, TrinaMI.

 

I'm here to help you find a solution to your dilemma. But first, I need to gather some information about the problem so that I can offer the best solution.

 

May I ask if you track the items using COGS or an expense account? Did you add the products to the Item details area or the Category details section? Also, can you send a screenshot of your concern (visual reference)? Just make sure to grey out personal information.

 

I'm looking for your response. Thank you in advance. 

Need to get in touch?

Contact us