Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
ntrotter@surface
Level 1

Can you track commissions on a "pay on pay" basis?

I pay my sales reps on a "pay on pay" basis. The current way I track commissions takes a really long time to do. I am using classes to track commissions

I do not pay my sales reps when an order is placed but instead when an order is paid for. Sometimes an order will not be paid for 90 days. Also, sometimes a customer applies an open credit memo to pay for part of the invoice. This also reflects in the commissions amount.

Example:
An order is placed on 5/1/22 for $1000. It is paid in full on 7/5/22, using a $100 credit and $900 cash. This invoice will be paid as part of the July commissions.

Is there a way to see all invoices that were paid for as well as all credits used in July? Preferably not including the "shipping cost" but if not I can find a way around that.
2 Comments 2
DivinaMercy_N
Moderator

Can you track commissions on a "pay on pay" basis?

Welcome to the QuickBooks Community, ntrotter@surface. I'm here with the steps to ensure you can track commissions on a pay-on-pay basis in QuickBooks Online (QBO).

 

Thanks for providing detailed information about your concern. This helps me to come up with a solution to make sure you can achieve your goal.

 

In QuickBooks Online (QBO), tracking commissions can be done by utilizing the Class and Location Tracking features. To know more about this, feel free to visit this article: Track sales commissions in QuickBooks Online.

 

To clarify, when you say track commissions on pay on pay basis, does it means to track it when an invoice is paid? If so, you can run the Sales by Rep report on a cash basis so you can only see the sales that are paid at a specific time. Here's how:

 

  1. In your QBO account, go to the Reports menu.
  2. Next, from the search field type Customer Detail click the report to open. 
  3. Then, click Customize.
  4. From the Rows/Columns look for the Sales Rep box and put a checkmark.
  5. Next, expand the Filter section.
  6. Then, check the Sales Rep box.
  7. Once done, select Run report.

 

If you're referring to something else, please add a reply below. 

 

Also, to view all invoices that were paid in July as well as all credits applied, you can simply pull up the Invoices and Received Payments report. I'll guide you on how:

 

  1. Navigate to the Reports menu.
  2. Then, scroll down to the Who owes you section.
  3. From there, click the Invoices and Received Payments report.

 

Customizing the reports to show only the specific details you need is a breeze. QBO also allows you to save the modification for future use. 

 

Let me know how this goes and feel free to add a comment below if you have additional questions about tracking commissions on a pay-on-pay basis in QBO. I'm always around and ready to help. Have a good one. 

Fiat Lux - ASIA
Level 15

Can you track commissions on a "pay on pay" basis?

ntrotter@surface 

Consider having a sales commission app to integrate with QBO. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us