MRSware Sales and Commissions
  • New MRSware.com
  • About EYOND
  • Free Trial / Download
  • New Blogs / Docs / Training
  • Blog
  • Support
    • Training >
      • Sales Training
      • Data Entry Training
      • Training Classes - MRSweb
      • Training Classes - MRSware >
        • Lesson 1 - MRSware Home Page
        • Lesson 2 - CRM - Companies/Contacts
        • Lesson 3 - CRM - Calendar
        • Lesson 4 - CRM - Journals
        • Lesson 5 - CRM - Tasks
        • Lesson 6 - CRM - Projects
        • Lesson 7 - MREPS - Customers
    • Documentation
    • Integrations
    • Admins
    • Live Service Status
  • Web Login
  • Sales Tracking Software for Manufacturers Reps
  • Commission Tracking Software
  • Manufacturers Sales Rep Commission Rates
  • Commission Management Software for Manufacturers Reps

How to Enter Partial and Adjusted Commission Payments

7/8/2013

1 Comment

 
​When you receive your commission reports from your manufacturers, do you reconcile the payments?  There are times when you are not paid the amount you thought you were going to be paid; Payments tracks this difference and helps your agency keep up with what is due, what's been paid, and forecast revenues to come.
​  
There are a few situations when a different amount is shown on the commission report than is shown in MRSware.  In these situations you can enter a partial payment, you can adjusted the commission amount, or both.
The default action in the Add/Edit Payment dialog is to check the box -- checking the box gives you a green-checkmark, indicating the Commission Due is fully paid and shows that same amount in the Apply Amount column.  This is the appropriate action when the first time the system is seeing the Invoice and Commission is from the Commission Statement itself... Since there is nothing previously entered to compare it to, the amounts always match and are marked as fully paid.

The examples outlined below are for when Orders or Invoices are entered before the Commission Statement comes, and then the existing commissions are compared to what is being paid to make sure the numbers match -- and more specifically, how to record the commissions paid when those numbers do not match..  This process is commonly called Commission Reconciliation.
This article walks through several example that would typically be encountered when doing commission reconciliation.  While all of the examples are fun, and very detailed, you may want to skip ahead to the one that applies to what you are working on:

Scenario 1: change the commission due to match what you are being paid
Scenario 2: enter a partial payment of the commissions due
Scenario 2A: enter a second partial payment that matches what was due
Scenario 2B: enter a second partial payment and make the commission due match the totals paid
​Scenario 3: enter a partial payment when there are multiple line items
    Option 1 - spread the payment across all line items
    Option 2 - apply the payment to a single line item
​

Scenario 1
Adjust Commission Due

update the commission on the invoice to match what we were paid

Here's the scenario:
You receive your commission statement and check and while reconciling the invoices you notice one of the invoices is off by a small amount (less than $1.00).  You have set a threshold of $15.00 for further investigation of commissions, so you want to change the amount shown in MRSware to the amount paid by the manufacturer and move on.  

In our example, Invoice #010213, the commission due is $78.00.  The commission payment received is $77.42, and you want to adjust the commission due to that amount.  Making the amounts the same will close out this invoice, so that it no longer appears in the "Eligible Invoices" selection -- i.e. we are all done with it, no more payments expected.

Here are the steps to adjust the commission due amount:

1. Right-click on the specific invoice and select "Adjust/Partial"
​
Picture

2. Enter the adjusted amount -- the dollar amount your want to reflect as the correct and final commission amount on the invoice -- in the field after "Proportionally adjust amounts to Total:"
** Make sure there is a check mark before "Adjust commission due to make even".  The checkmark tells the system to make the change to the Invoice. **
3.  Click "Apply".  Once you click "Apply", the adjusted amount will be reflected in the "(Invoice Total)" line in the Adjust Invoice/Commission Items dialog. ​ 
Picture

4. Click "Ok"​.  ​In the Add/Edit Payment dialog, you will now see that the totals shown in the columns "Commission Due" and "Apply Amount" are the same.
​
Picture

Scenario 2
​Partial Payment Amount
record commission received less that what is due

Here's the scenario:
You receive your commission check with statement and while reconciling the invoices you notice one of the invoices is off by an amount that is larger than your threshold of $15.00.  You want to investigate the difference by contacting the manufacturer, but you don't want to hold up on entering the payment in MRSware.
A partial payment from the manufacturer could also just be par for the course.  As more manufacturers continue to move to paying commissions when they get paid, things like installments, late payments, and partially paid invoices by the customer start to effect commissions payments to the rep.
​In our example, Invoice #CC22185, the commission due is $1,379.83.  The commission payment received is $1,125.00, with a balance due of $254.33.  You want to enter the partial payment of $1,125.00 while you investigate the balance due.

Here are the steps to enter the partial payment towards the commission due:

1. Right-click on the specific invoice and select "Adjust/Partial"
Picture

2. Uncheck the Adjust commission due checkbox, and enter the partial amount in the field after "Proportionally adjust amounts to Total:"
** Make sure there is not a check mark before "Adjust commission due to make even".  We don't want to change the original commission due, so we make sure that box is unchecked. **
​3.  Click "Apply".  Once you click "Apply", the partial payment will be reflected in the "(Invoice Total)" line in the Adjust Invoice/Commission Items dialog. ​ 
Picture

4.  Click "Ok".  ​In the Add/Edit Payment dialog, you will see the difference in the totals shown in the columns "Commission Due" and "Apply Amount".  
Picture
The Amount field shown here, at the bottom of the Add/Edit Payment dialog, is the check amount that is being recorded.  In this case, the check amount would be different than the total shown in the Commission Due column, as we are leaving some of that commission unpaid.  That left over difference can be paid on a later payment or disregarded in the future.

Scenario 2A
2nd Partial Payment (equals Commission Due)

​confirm the remaining commission was received on a previous partial payment

Here's the scenario:
​You receive your commission check with statement for the following month.  When you start the new Payment for this month, you will see invoices with the partial payments from previous months in the Add/Edit Payment dialog.  The amount of the previous payment is shown in the column "Commission Paid".

Between last payment and this one, you had contacted the manufacturer and they have corrected the mistake and paid the remaining amount due in full...  Or the remaining balance on the invoice was paid by the customer and now we are receiving the balance of the commissions on that invoice in full.

In our example, Invoice #CC22185, the original commission due from the Invoice was $1,379.83.  The first partial payment of $1,125.00, which was paid last month is reflected in the column "Commission Paid". 
​
Picture

​Again, in our example, you want to enter the balance due amount of $254.33.  When you enter this amount, the commission paid will equal the commission due. ​
Since the amount received equals the amount due, just click the box to get the green-arrow and you are done. The difference between the two columns, $254.33, is automatically calculated and filled in...  
Picture

However, if you would like to manually enter the amount, follow the steps below (or see Scenario 2B, when the amounts don't match).​​
​Here are the steps to manually enter the second partial payment of the commission due:

1. Right-click on the specific invoice and select "Adjust/Partial"
​
Picture
2. Enter the second partial amount in the field after "Proportionally adjust amounts to Total:"
** Make sure there is not a check mark before "Adjust commission due to make even".  Making it even by leaving the box checked changes the Commission Due amount, and we don't want that in this case. **
​3.  Click "Apply". Once you click "Apply", the partial payment will be reflected in the "(Invoice Total)" line in the Adjust Invoice/Commission Items dialog. ​ 
Picture

4. Click "Ok".  ​In the Add/Edit Payment dialog, you will see the difference in the total shown in the column "Apply Amount".  The "Apply Amount" + "Commission Paid" amounts will equal the amount shown in "Commission Due".  
Picture

Scenario 2B
Partial Payment + Adjusted Amount (check does not equal the original Commission Due amount)

record the last payment to be received for an Invoice, making it even

Here's the scenario:
You receive your commission check with statement for the following month.  You will see the invoice with the partial payment amount reflected in the Add/Edit Payment dialog in the column "Commission Paid".
​You contacted the manufacturer and the amount to be paid is not the full balance due, but a partial payment.
You want to enter the agreed upon amount as a second payment, and make it so that it is even in the books -- no more payments are expected for this entry.

In our example, Invoice #CC22185, the commission due is $1,379.83.  The first partial payment of $1,125.00, which was paid last month is reflected in the column "Commission Paid".  The agreed upon balance is $200.00.

 Here are the steps to enter the second adjusted, partial payment:

1. Right-click on the specific invoice and select "Adjust/Partial" 

Picture

​2. In the Item section click the item(s) you would like to apply the adjustment to.  The entry you are making will be spread across all of the line items checked.  If you would like to adjust a single line item, you can check just that line item, leaving any others unchecked.

​3. Click "Edit" 

Picture
4. Enter the adjusted commission amount (= original partial payment + second partial payment) in the field after "Commission Amount".  The value entered here is the total commission for the Invoice, the amount agreed upon, and will change the Commission Due on the Invoice to match what is entered.

​5. Enter the second partial amount in the field after "Applied Payment Amount".  The previously entered partial payment will stand, and the amount entered here is the difference between that last payment and the new payment, which totals to the Commission Amount.

6. Click "Ok"
Picture
The Adjust Invoice/Commission Items dialog now shows the Due amount entered, the Paid amount previously paid, and the Apply amount from this entry.
There is no need to use the Quick Adjustments panel in this case -- leave it blank -- since you have already made the adjustment directly on the appropriate line item(s).
7. Check the box next to the item(s) you would like to apply the adjustment to.

8.  Click "Ok"
Picture

​In the Add/Edit Payment dialog, you will see the new adjusted amounts.  The "Commission Due" amount now equals "Apply Amount" + "Commission Paid" amounts.  
Picture

Scenario 3
Partial Payment Amount with Multiple Line Items

​record commission received less that what is due when multiple line items are on the Invoice

Here's the scenario:
This scenario is the same as the example in Scenario 2; you receive your commission check with statement and while reconciling the invoices  you notice on of the invoices is less than what is due.  The difference is that in this example, there are multiple line items on the invoice. 

You have some options available at this point -- should the payment be applied across all items on the invoice, one particular item, or several.  The options below give examples of spreading the payment amount out across all the line items, or applying the payment to a single entry on the invoice.

Option 1
record commission received across all line items on the invoice

​
In this example, Invoice #PO3142022TG, the commission due is $429.38.  The commission payment received is $214.69, with a balance due of $214.69.  You want to enter the partial payment of $214.69 and spread the payment across all the line items on the invoice.

Here are the steps to enter the partial payment towards the commission due:

1. Right-click on the specific invoice and select "Adjust/Partial"​

Picture

2. Uncheck the Adjust commission due checkbox, and enter the partial amount in the field after "Proportionally adjust amounts to Total:"​
** Make sure there is not a check mark before "Adjust commission due to make even".  The checkmark tells the system to make a change to the Invoice's commission amount, which we do not want to do in this case. **
Because you are spreading the payment across all line items on the invoice you do not need to select any items.

​3.  Click "Apply".  Once you click "Apply", the adjusted amount will be reflected across all the line items in the Adjust Invoice/Commission Items dialog. ​ 

Picture
​4. Click "Ok".  ​In the Add/Edit Payment dialog, you will see the difference in the totals shown in the columns "Commission Due" and "Apply Amount".  
Picture
The next month's commission check and statement arrive with the invoice's Commission Due amount paid in full.
​
​Again, in our example, you want to enter the amount paid of $214.69.  When you enter this amount, the commission paid will equal the commission due.   Since the amount received equals the amount due,​

5. Click the box with the yellow arrow to get the green-arrow and you are done. The difference between the two columns, $214.69, is automatically calculated and filled in... 
​
Picture

​Option 2
record commission received on a single line item on the invoice

In this example, on the same commission statement, Invoice #PO3162022TG, shows a commission due of $480.64.  The commission payment received is $233.75, with a balance due of $246.88.  You want to enter the partial payment of $233.75, marking 2 items paid in full, leaving the other item unpaid.

Here are the steps to enter the partial payment towards the commission due:

1. Right-click on the specific invoice and select "Adjust/Partial"​
​
Picture

​2. In the Item section click the item you would like to apply the adjustment to.  The adjustment is for this item only.  

​3. Click "Edit" 

4. Enter the amount paid in the field after "Applied Payment Amount"

​5. Click "Ok"​
Picture
Picture
Repeat steps 2. - 5. for the items to be adjusted.

6. When done, check the boxes that you've applied payments to.
Picture
Picture

​We are not using the Quick Adjustments function when working with the line items directly, so there is no need to do anything in the Quick Adjustments section of the dialog -- do not press the Apply button or enter anything in that area for this example.
Picture

8. Click "Ok".  In the Add/Edit Payment dialog, you will now see the difference in the totals shown in the columns "Commission Due" and "Apply Amount", with the total in "Apply Amount" reflecting the commission paid on the 2 selected line items.
​​​​
Picture

​Finally, in our example, the second commission statement and check received is reflected in the Add/Edit Payment dialog (below).

Invoice #PO3142022TG - a second partial payment equal to the Commission Due was entered
Invoice #PO3152022TG - payment in full was entered
Invoice #PO3162022TG - a partial payment on 2 items was entered
​
Picture
The Amount field shown here, at the bottom of the Add/Edit Payment dialog, is the check amount that is being recorded.  In this case, the check amount would be different than the total shown in the Commission Due column, as we are leaving some of that commission unpaid.  That left over difference can be paid on a later payment or disregarded in the future.
​
1 Comment
Louis
1/22/2020 12:47:10 pm

When it comes time to do write-offs -- that is mark some commissions that are due as $0 because we are not going to get paid for them, for various reasons -- an easy way to do this is to pull up a new Payment Entry, select all the Invoices that are going to written-off, mark them with the "make even" checkbox, and save the Payment with the nifty note off "January write-offs".

Before you mark those Invoice as even, save a copy of the open Invoices, Amounts Due, Customers and Sales Reps effected, selecting all the records in the table and pasting them into a spreadsheet. Now you have a handy record of what specifically was written-off for each manufacturer.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    Documentation

    ​You will find technical documentation, MRSware instructions, release notes, and general content to help MRSware users through their day on this page.

    Please use the Categories below to find documentation for each area in MRSware.

    ​You may also use the Search field above to look for specific topics. To get a more precise list of articles for a particular menu option, for example, use quotation marks around the text in the Search box, e.g. "bulk assign sales rep".

    Categories

    All
    1
    Android
    Appointments
    Auto-Complete
    Batch Edit/Bulk Update
    Categories
    Contacts
    Customers
    Data Analysis
    Duplicate Removal
    Education Module
    Email
    Email/Spam
    Email Templates
    File Share
    Google
    Hidden
    IMAP
    Installation
    Journals
    Master List
    Microsoft Office
    Mobile
    (MREPS)
    MRSweb
    New MRSware Users
    Outlook
    Payments
    Projects
    Reports/data Analysis
    RSS Reader
    Sales Force Automation (SFA)
    Search / Filter / Sort
    Sync
    Tables / Listings
    Troubleshooting
    Types
    User Manuals
    Video

    Archives

    November 2022
    September 2022
    June 2022
    March 2022
    February 2022
    January 2022
    December 2021
    May 2021
    October 2020
    September 2020
    July 2020
    June 2020
    May 2020
    September 2019
    April 2019
    September 2018
    January 2018
    August 2017
    February 2017
    January 2017
    December 2016
    September 2016
    July 2016
    June 2016
    May 2016
    February 2016
    January 2016
    December 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    July 2014
    June 2014
    February 2014
    October 2013
    September 2013
    July 2013
    May 2013
    April 2013
    March 2013
    February 2013
    November 2012
    September 2012
    July 2012
    June 2012
    May 2012
    April 2012
    December 2011
    November 2011
    October 2011
    September 2011
    August 2011
    May 2011
    April 2011
    March 2011
    December 2010
    September 2010
    July 2010
    May 2010
    April 2010
    February 2010
    January 2010
    December 2009
    November 2009
    October 2009
    July 2009
    June 2009
    May 2009
    April 2009
    March 2009
    February 2009
    January 2009
    October 2008
    September 2008
    August 2008
    July 2008
    June 2008
    May 2008
    April 2007
    September 2006
    August 2006
    July 2006
    June 2006
    May 2006

    RSS Feed

Home | Sales and Commissions | CRM | Blog |​ Pricing | Training | Support | Log In | Free Trial 
[email protected]    
​(866)795-8386
Copyright (c) 2004 -2025 EYOND
Picture
Live Services Status

​MRSware is an EYOND Integrated Solution
made in Austin, TX  USA