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
I'm here to provide some insights about the report that you need, Keila.
A 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.