Gross Profit Report by Sales Rep - Cash basis

Welcome to the Community, @yvn_tx. Let's dive into paying your sales representatives by referencing the available sales report.

I'd like to know what kind of view you used when you ran the Sales by Product/Service Summary report because it does matter when showing the COGS column.

If you use the Classic View, the COGS column will disappear once you change the Accounting Method to Cash. It's different when you Switch to the Modern View because it will show the COGS column even if you interchange the methods. Yet, no amount will show when you switch to Cash accounting.

When it comes to reporting, the Cash and Accrual Accounting Methods differ from each other. The Cash accounting record only shows transactions when cash is received and paid out.

The Accrual method reflects transactions when they occur, regardless of when cash changes in hands, including all types of invoices and sales receipts. This is the reason why the COGS columns and amounts are only visible in the Accrual Accounting Method.

 

As a workaround, you can click the Export to Excel the report you pull up and modify it outside QuickBooks based on your sales rep sold items.

I'll also share this article to help you keep the report you customize for future use: Save a customized report in QuickBooks Online.

You can also reach out to QuickBooks Live Expert Assisted to further guide you in personalizing your report and ensure your sales inventory report details align with your company perspectives.

Never hesitate to reach out again if you have additional questions about managing reports.

I see the cogs column now in the Modern View however you are correct, there are no values there under Cash basis. Is there a reason why? When I run a P&L under Cash basis, of course, I am left with a Net Income. I understand the cash is only accounting for cash actually exchanged for goods or services. But thats exactly the report I am wanting, under the Sales by Product/Service. I would want to know the same COGS per product line so I can pay out commissions based on what was sold and what was actually paid (Again we do ALOT of in-house financing and some of those terms are well past 6 months, and in some cases, never paid) I would want to pay out commissions based on money we received for products sold, not just products sold (paid or not) 

Good morning, @yvn_tx. 

I appreciate you coming back on this thread and asking additional questions. 

When you choose the cash basis method, the COGS are realized as an asset account and only show once the invoice is paid. However, if you select Accrual, the COGS has realized whether it's paid or unpaid invoice. This is why it doesn't appear in the report. 

If you want to view the COGS on a cash basis, the best option would be to run the P&L or the Balance Sheet report.

Feel free reach back out if you have any other concerns. We're always here to help. Have a wonderful day! 

@yvn_tx 

"I see the cogs column now in the Modern View however you are correct, there are no values there under Cash basis. Is there a reason why?:

Inventory and, therefore, COGS do not apply to cash basis accounting.  Cash basis accounting expenses the cost of items at the time you purchase them, so there's no way to track gross profit by product on cash basis. 

Think of it this way: if you purchase 10 items for $50 each, you have $500 in product expense at the time you purchase them.  If you sell 5 of them for $500, you have $500 in income and $500 in expense and $0 gross profit. 

In order to track gross profit, you need to be on accrual basis so the 5 unsold units are in inventory and not expensed.  In that case, you'd have $500 in income and $250 in COGS expense (5 X $50) for a gross profit of $250 ($500 - $250) with the remaining 5 units (and $250) sitting in inventory.