MRSware Sales and Commissions
  • MRSware
    • About
  • Sales & Commissions
    • Sales Reps
    • Manufacturers
  • CRM
  • Blog
  • Pricing
  • Support
    • 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
  • Login
  • Free Trial

Use Payment Entry to Reconcile Commissions

6/20/2012

0 Comments

 
Sales and commission tracking is one of the major reasons rep firms use MRSware.   The tracking process entails entering invoice data into Invoice Entry, reconciling commissions in Payment Entry, reviewing data via Report Explorer or Data Analysis.
With the first step in the process, the rep agency receives the sales data in a variety of ways -
  • paper invoices via U.S. mail
  • paper commission reports via U.S. mail
  • faxed invoices
  • sales reports via manufacturer website
  • commission reports via e-mail
  • Automatic import direct from manufacturer


Once received, there are a variety of ways to enter the sales data in Invoice Entry -
  • manually
  • Invoice Import
  • Automatic Import


The second step in the process is to reconcile commissions paid.  When the commission check is received it is usually accompanied by a commission report.  This report is used to reconcile the commissions entered into the system when the sales numbers were entered.  Whether you're working from a paper report or a spreadsheet e-mailed to you, the payment steps are easily accomplished in Payment Entry.


Here's how to use Payment Entry to reconcile your commissions:
​
1. Click on Payment Entry in the Shortcuts panel or on the Shortcuts Toolbar
​

Picture
Picture

2. Add a New Payment by clicking on the New button on the Main Toolbar or on the Create Payment button on the New Toolbar
​
Picture
Picture

3. Type in the name of the Manufacturer
​

Picture

4. Select the date range for eligible invoices to be paid

Picture

5. Using the commission report as your guide, check the box next to the invoices in the system that are included in the commission check you have received. 
​
Picture

- Notice the Apply Amount column next to the Commission Due column in the table.  When you mark an invoice as paid the commission applied to that invoice appears in the Apply Amount column.

Picture

6. When done, enter the payment entry information at the bottom of the Add/Edit Payment dialog

Picture

7. Check to see if the amount shown in the Apply Amount column matches the amount received in the commission check.  
Picture

8. If the amounts match click Save or Save & New (if you have more payments to enter).  You can also check Run Commission Payment Reconciliation Report on Save in order to have a report showing the invoices reconciled.
​

Picture

9.  If the amounts do not match you can contact your manufacturer for further information about the commissions due.  

In addition to the Reconciliation report, shown above, there are a number of reports found in Report Explorer, such as, Agency Commission Statement, Commission Statement, or Sales and Commissions.  You can also use cubes in Data Analysis to sort and filter the sales and commission entries, such as, Commission Payment Analysis, Commission Due Analysis, Sales and Commission Analysis.

Feel free to view the companion videos -

​Commission Payment Analysis
Commission Due Analysis 

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 
sales@MRSware.com     (866)795-8386 x1
Copyright (c) 2002-2023 EYOND, Inc
.
MRSware is an EYOND, Inc. Integrated Solution
made in Austin, TX  USA