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

Sales Order report by customer showing COGS per order

Need help with creating a Sales Order report by customer that also shows the COGS per order.  I've tried a few of the other Solutions on here and none have worked for what we are looking for.

 

Running QB Desktop: Premier Plus Manufacturing and Wholesale 2022

Solved
Best answer February 22, 2022

Best Answers
MaryLandT
Moderator

Sales Order report by customer showing COGS per order

I'm here to provide some insights about the report that you need, Keila.

 

Sales Order (SO) is a non-posting transaction. It doesn't impact the financial statements in QuickBooks. 

 

Also, the inventory Cost of Goods Sold (COGS) is only affected when you sell inventory items on invoices or sales receipts. Hence, COGS won't show up on the Sales Order by Customer report. 

 

When you sell an inventory item, run the Transaction Journal Report for the invoice/sales receipt and you see the Sales/Accounts Receivable transaction. The Inventory/COGS transactions credit the Inventory Asset account and debit the COGS accounts.

 

In addition to this, you need to create an invoice and record the payment to see the COGS account. You can follow the Accounts Receivable workflow to organize your transactions.

 

Check out this link for instructions and detailed steps: Get started with customer transaction workflows in QuickBooks Desktop.

 

Stay in touch with me if there's anything else I can help you with the Sales Order report. Don't hesitate to leave a comment below, and I'll get back to you.he

View solution in original post

1 Comment 1
MaryLandT
Moderator

Sales Order report by customer showing COGS per order

I'm here to provide some insights about the report that you need, Keila.

 

Sales Order (SO) is a non-posting transaction. It doesn't impact the financial statements in QuickBooks. 

 

Also, the inventory Cost of Goods Sold (COGS) is only affected when you sell inventory items on invoices or sales receipts. Hence, COGS won't show up on the Sales Order by Customer report. 

 

When you sell an inventory item, run the Transaction Journal Report for the invoice/sales receipt and you see the Sales/Accounts Receivable transaction. The Inventory/COGS transactions credit the Inventory Asset account and debit the COGS accounts.

 

In addition to this, you need to create an invoice and record the payment to see the COGS account. You can follow the Accounts Receivable workflow to organize your transactions.

 

Check out this link for instructions and detailed steps: Get started with customer transaction workflows in QuickBooks Desktop.

 

Stay in touch with me if there's anything else I can help you with the Sales Order report. Don't hesitate to leave a comment below, and I'll get back to you.he

Need to get in touch?

Contact us