Skip to main content
Y
yvn_tx
April 2, 2025
Question

Gross Profit Report by Sales Rep - Cash basis

  • April 2, 2025
  • 1 reply
  • 0 views

I need a report that gives me the gross profit of specific products that are in inventory, on cash basis, and by sales rep so I can pay out commissions. I found a report that is very close but its doing it on accrual basis which is an issue because a solid 80% of our business is in-house financing.  

 

I'd like to be able to pay my sales rep by those items they sold, but we were actually paid for during a set period of time 

 

The report I found is Sales by Product/Service Summary, and filter to sales rep. Its giving me the data I need however its on accrual, when I switch it to cash basis it removes the columns for COGS. 

    1 reply

    Bryan_M
    Bryan_M
    April 3, 2025

    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.

    Y
    yvn_txAuthor
    April 4, 2025

    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) 

    Candice C
    Candice C
    April 4, 2025

    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! 

    Terms & ConditionsAccessibility statement