cancel
Showing results for 
Search instead for 
Did you mean: 
tlenzmeier
Level 4

Sales By Item Summary - COGS

I'm trying to figure out how best to use my items list. On the Sales By Item Summary there are columns for COGS. I have separate items for the following service activities listed below. I'm not sure how to get the COGS to show up properly.

 

Entry Fees (item -- income=Fee Income)

Judging Fees (item - subcontractor, expense=Cost of Labor: Judging, income = fee income)

Facility Rental (item - Cost of Labor: Facility -- do I need to denote this as a subcontractor for the expense line to show up?)

 

There are other COGS expenses, but these to illustrate what I'm after. I'm wondering if my COGS items need to be sub-items fo the entry fee item??

 

Any help would be greatly appreciated!

 

Solved
Best answer April 06, 2021

Best Answers
Rubielyn_J
QuickBooks Team

Sales By Item Summary - COGS

I appreciate you for getting back to us, @tlenzmeier. Let me provide some insights about generating reports in QuickBooks. 

 

In the Sales Item Summary report, COGS is only posted when the sale has been paid for. It assumes that you paid for the purchase of inventory. Also, the column for the non-inventory is blank. That being said, getting the COGS info show in the report is unavailable.

 

I've also added these resource to guide you manage reports in QuickBooks Desktop for Mac:

 

When you customize a report, you can memorize it to save the changes you made. Once you’re done, simply select Memorize.

 

If you have further concerns with creating reports in QuickBooks, just click the Reply button. I'm here to help you more. Have a good one.

View solution in original post

8 Comments 8
Rustler
Level 15

Sales By Item Summary - COGS

All payments to a sub contractor are reportable (cash and check) on the form 1099, so no they are not COGS

facility rental payments are also not COGS

they are expenses

COGS, when you file taxes, are directly related to the cost of the inventory items you sell, nothing else.

tlenzmeier
Level 4

Sales By Item Summary - COGS

I am not filing a tax return. I am also not manufacturing anything, so your response is wrong. The reporting I do is predicated on competitive canine sporting events. Judges, facility rentals, etc. are ALL direct costs of “producing” the event. If you’d bother to answer the question, rather than lecture me on what is or isn’t COGS, that would be helpful. 

Candice C
QuickBooks Team

Sales By Item Summary - COGS

Good morning, @tlenzmeier

 

Thanks for reaching back out to the Community. I hate to hear that your question wasn't answer. I want to make sure that you're able to get back on track. 

 

Since this is more on accounting standards, I recommend consulting with your accountant to be sure of this information. They'll be able to give you the best accounting advice for your business. If you don't have one, no worries. Here's a link to help you find one near you: Find ProAdvisor

 

In the meantime, you can check out this guide about managing items that may be helpful in the future for your business: Add, edit, and delete items

 

Let me know how it goes. It's my priority that you're able to put these details correctly into your QuickBooks Desktop for Mac (QBDT Mac). If you should have any other questions or concerns, don't hesitate to contact us. Take care!

tlenzmeier
Level 4

Sales By Item Summary - COGS

This isn't an accounting question. I have over 20 years of accounting experience, so I know what COGS are. Our business provides classes and canine competitive events. Our primary income is class fees and event entry fees. My direct costs (COGS) are judges, facility rental, ribbons, certifying organizations (American Kennel Club), and so on. I have created items  for each of our classes and events. I have sub-items for each of the direct costs of putting said classes/events on. This is my "above the line" operating net income. On the sales by item summary there are columns to the right of income that detail out COGS. ALL I want to know is how to get my COGS information to appear on the report. I DO NOT need any "pro" advice.

 

My question is about how to get COGS information to show up on the sales item summary report.

Rubielyn_J
QuickBooks Team

Sales By Item Summary - COGS

I appreciate you for getting back to us, @tlenzmeier. Let me provide some insights about generating reports in QuickBooks. 

 

In the Sales Item Summary report, COGS is only posted when the sale has been paid for. It assumes that you paid for the purchase of inventory. Also, the column for the non-inventory is blank. That being said, getting the COGS info show in the report is unavailable.

 

I've also added these resource to guide you manage reports in QuickBooks Desktop for Mac:

 

When you customize a report, you can memorize it to save the changes you made. Once you’re done, simply select Memorize.

 

If you have further concerns with creating reports in QuickBooks, just click the Reply button. I'm here to help you more. Have a good one.

tlenzmeier
Level 4

Sales By Item Summary - COGS

Thanks for the clarification. I'll close this out, but it seems to me that for service-oriented businesses that don't have a physical inventory, QB is really lacking in this regard.

S72
Level 1

Sales By Item Summary - COGS

Dear Concern, can you please help me out, i want only one column and that is 'Qty' in 'Sales by item summary' how can i do it in simplest way, your cooperation in this regard would be highly appreciated.

JenoP
Moderator

Sales By Item Summary - COGS

Joining the conversation to answer your report-related questions, S72.

 

We're unable to customize the Sales By Item Summary to only show the Qty column. You'll want to export the report to Excel. Then, remove the other columns so only Qty will remain. Here's how:

 

  1. Open the Sales By Item Summary report. 
  2. Select Export.
  3. When Excel opens, go to File and select Save As to save the file where you want it.

 

Additional guidance about removing or adding certain types of data when running reports are discussed here: Customize Reports in QuickBooks Desktop for Mac.

 

You can also visit this site where for additional articles and references when using the QuickBooks for Mac: https://qblittlesquare.com/

 

Reply to me or post another question if you need anything else. We'll make sure to offer our help anytime of the day.

Need to get in touch?

Contact us