How do I track Cost of Goods Sold by Customer

@gianikasl @Anonymous 

If you've QBO plus plan (or Advanced plan), you can track Cost of Goods Sold (COGS) or Cost of Sales (COS) by CUSTOMER in QuickBooks Online. But you've Essentials or Simple Start, this feature is not available in QBO.

So what's the point of having a P&L report in QBO Simple Start if you cannot enter COGS???  And why in the heck would you leave this out in the first place?  I mean its pretty much part of the basics in any business!!

Hi carbonicboy,

You'll want to enter COGS manually in cash basis when you purchase the item. However, tracking the item when it's sold is unavailable. Let me guide you through the steps.

To track manually, please check this article for the detailed steps: Can I track inventory manually?

You can also read this article about: Impacts of inventory tracking on balance sheet and profit & loss reports.

You might want to visit our page for future reference: Inventory and projects.

Let us know if you have other questions.

I have Quickbooks Enterprise, I need to be able to track the margin per account.  Easiest way to do this would be to have CoGS available in sales summary.  But I'm not finding a way to add that column of information.  Is their a way to add that to the customizing options?  Or is their a better way to retrieve this data?

Thank you for joining this thread, RobBrown. 

I'm here to guide you on how to add the column of COGS in QuickBooks Desktop. 

Here's how:

1. Go to the Reports tab, then select Sales. 

2. Look for Sales by item detail. 

3. Click on Customize Reports at the top.

4. Go to the Display tab. Add Account under Columns. 

5. Then go to Filters. Filter the Account to COGS. 

6. Click OK once done. 

That should do it!

Keep your post coming if you need more help. I'll be there!

I cant find Sales by item detailed for one of the options. Could there be a different name for the category?

Hi there, 9130 3565 9599 3436.

Thank you for visiting the QuickBooks Community. I'll share details about the Sales by item detail report in QuickBooks. Also, let's perform alternative steps to ensure you can achieve your goal.

Please keep in mind that the Sales by item detail report is only available in QuickBooks Desktop. With this, it's possible that you're utilizing the Online version, which is why the mentioned report isn't an option in your list.

I recommend running and customizing the Profit and Loss by Customer report in QuickBooks Online. This allows you to personalize the data and track or view the Cost of Goods Sold by the customer.

Here's how:

1. Go to Business overview and select Reports.
2. Choose Profit and Loss by Customer on the search bar.
3. Click the Customize button.
4. Go to the Filter drop-down arrow and tick the Distribution Account box. Then, select Cost of Goods Sold.
5. Checkmark the Customer box and select a specific customer's name.
6. Click Run report.

Once done, the Cost of Goods Sold account will appear in the first column of the report. I've attached a screenshot below for visual reference.

Lastly, I'm adding this article to see details on how memorizing a report authorizes you to save it with its current customization settings: Memorize reports in QuickBooks Online.

You can always add a comment below if you still have further questions about managing your reports in your QuickBooks account. I'm always around to help, 9130 3565 9599 3436. Keep safe and have a good one.