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

Working with Sales Rep Splits

3/23/2011

0 Comments

 
​In the system there are 3 commission columns/calculations that are done automatically: a) Total Commission, b) Agency Split, and c) Sales Rep Split.  These three commission calculations are shown on various reports and in data analysis.
 
a) Total Commission is the amount of commissions paid to the agency by the manufacturer.
 
b) Agency Split is the amount credited within the agency to itself, or the "House", when the sales rep is paid some portion (the split) of the commissions paid to the agency by the manufacturer.
 
c) Sales Rep Split is the amount that the sales rep is paid, his portion of the commissions paid by the manufacturer.
 
These split cases are only used when you pay the sales rep a split of the commissions.  For example, a salaried sales rep may not be paid any split of the commissions, and so his split rate would be set to 0 (0%).
 
There are 3 places that the split rate can be set: d) Sales Rep Management, e) Customer Listing, and f) Invoice Entry.  Those three places are listed in order that they take effect, for example a setting in Invoice Entry overrides any setting in Customer Listing or Sales Rep Managmenet; a setting in Customer Listing overrides a Sales Rep Management entry; and a Sales Rep Management entry is the default for all cases where it is not overidden in one of these other places.
​The best practice is to set the Sales Rep Management Split Rate field to the most common percentage that the sales rep is paid for his customers.  For example, if the sales rep is paid a 40% split on most of his accounts (this means that 60% is retained by the agency), then the Sales Rep Management entry for this rep should be set to 40.  We will call this Sales Rep Management Split Rate the "default rate" for that sales rep.
 
Now, for any customers where the sales rep is paid a different percentage of the commissions, we need to set that split rate on an individual customer basis.  This is done in the Customer listing screen, by entering the correct percentage for that customer in the Split Rate field in the Edit Customer dialog.  This is where you would enter your 100 (for 100%) for the cases where the sales rep was paid all of the commissions that the agency is paid by the manufacturer for that account, for example.
 
At this point, we have the system set up to automatically calculate the splits for all of the accounts that are called on by one sales rep.  The splits are calulated automatically based on the percentages entered, and show on reports.  Most reports have the ability to show any of the 3 commission fields, so that the generated reports have what you would like the sales rep to see as far as commissions go.  Data Analysis has the ability to show all (or any) of the 3 commissions columns at the same time.
 
Exception cases:  There are a couple of commission cases that are not covered by the above splits built into MRSware.
 
1) Split between 2 (or more) Sales Reps on a single Customer account, where the 2 sales reps are splitting all of the sales into that account.
 
In some cases, you may have 2 sales reps that call on the same customer, and share some portion of the split between them.  In these cases, you have two options:
 
a) Use two different Sales Rep entries for the Customer, and manually split the sales between them at Invoice Entry time.  This method creates more work on the import side, but no addition work is required on the reporting side to generate a report that shows the correct amount of commissions earned by the sales rep.
 
b) Use a shared Sales Rep entry for the Customer.  This would be in the format of something like "Lisa-Jim shared account" and would be assigned to the customer that is shared.  All sales would be credited as normal to this sales rep as invoice entry time, and the split between the two would be handled manually at report generation time.  This method has the advantage of making data entry much easier, but does require the amount to be split at reporting time to pay each sales rep the proper amounts.
 
2) Two sales reps call on the same customer, but each represents a different line for that customer.
In this case, you would create separate Customer entries for each line represented.  Each customer entry can be assigned the correct sales rep for that line, and no additional work is required at invoice entry or reporting time to separate these sales.  Each customer entry should be named uniquely so that they are easily identified in the system -- an easy example of this is just to add the name of the line at the end of the customer name, "abc co. - awesome products".

​For this case, the same split calculations apply as normal, so a split between the house and the rep can still be done as normal, and that applies to the corresponding line for each customer and assigned rep.
There are many commissions systems that are in use.  If you have specific questions about how to apply your rules in MRSware, please let us know.
0 Comments

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