Sales Commission Processing System

The VFP Enterprise Commission system is a powerful and flexible commission tracking system that integrates with your ERP or accounting data.  Mange your sales reps commission with flexible commission calculation methods and reports.  You can setup up different parameters and commission rates for the sales rep, customers and inventory master files.   Quickly and easily display invoices ready to pay commissions on and view reports by a variety of parameters.  All of these features allow you to track and process commission quickly and accurately.   

Key features:

• Commission based on gross sales or gross margin.
• Set up to six sales tiers with different commission rates per tier.
• Select Tier reset terms, weekly, monthly, quarterly, yearly or none.
• Split commissions for multiple reps.  
• Have up to two sales reps per invoice.
• Unlimited sales rep per invoice detail.
• Varying commission rates by products, sales reps or customers.
• Commissions based on paid invoices or unpaid invoices.
• Exclude credit memos or debit memos from commissions.
• Exclude shipping and other expense items by product from commissions.
• Calculate gross margin using a loaded cost, average cost, landed cost, last cost, job cost, or PO cost.
• Calculate commissions based on the cost of a serialized item.
• Multiple commission rates by product selling price.
• Integration available with your ERP or accounting system including QuickBooks.  Link the Inventory Items, Customers, Sales Invoices, Credit Memos, Payments, Sales Reps and more.
• Multiple commission reports in summary or detail format with a variety of selection criteria.
• Export to Excel. 

The Commission Processing form shown in the figure below, list sales that are ready to pay commission on. This form allows the selection of a sales rep and range of dates.  The column labeled "P" is to select those invoices that you want to pay commission on.  Invoices that you have already paid commission on will not show up in this list unless you check "Include Processed Items".   The Commission Approved to Pay report will list those invoices selected to pay commission on. 

 

Commission Processing Form Summary

 Commission Processing Form Detail

Commission Approved to Pay Report

 

The Sales Rep Commission Report will produce a number of useful reports.  You can select from several  report formats, commission calculation methods, and other parameters to make this a very powerful tool.

 

Sales Rep Commission  Report

 

Date Range - Select the range of dates you want to work with.  Complete historical sales data is maintained and is limited by disk space.  This data is synchronized with your ERP or accounting sales data.

• Sales Rep - Select one or all sales reps.  If you select All Sales Reps, you can view a summary of your commission pay out for all Reps.
• Include 2nd Sales Rep - The system allows up to two sales reps per invoice.  If you select this option the commission will be split between the two sales reps on the invoices.
• Sales Rep by Line Item - This option is available on the detail report option. This will take the sales rep in the line item detail and over-ride the sales rep in the header.  In order to take full advantage of this feature you have to use the VFP Enterprise Sales Order Entry system.
• Comm. % from Sales Rep file - Selecting this option will over-ride the sales commission percentage from the sales data with the value entered in the sales rep master file.
• Load Cost - Checking this box will use the Loaded Cost in the inventory master file to calculate the gross profit commission values.  To use this option you must setup the loaded cost in the VFP Enterprise inventory master file.
• Cost Serial No. - If you have serialized inventory and you checked this box, the cost for the gross profit will be taken from the serial number file for each individual item.
• Summary Short Format - If you check this box and select the Summary format, the report produced will be one line per sales rep.
• Check Item Status - If checked will determine the commission status of the item based on the parameters form the inventory master file.
• Paid Status - You can select to view all sales, invoices that are fully paid or unpaid invoices.

 

The Sales Rep Maintenance master file is shown in the figure below.  This is where you keep track of your sales reps.  You can have several commission levels per rep.  Each commission level can be linked to a price related to the inventory master file.

Sales Rep Maintenance 

 

• Sales Rep ID - This is the sales rep unique identifier.

• Sales Rep Name - The name of the sales rep.

• Commission % 1 - This is the 1st  tier commission percentage.

• Commission % 2 - This is the 2nd tier commission percentage.

• Unit Price >= and < - This is related to an Item and establishes a low and high value to pay commission 1 or 2.

• Commission Tier Levels - This section allows setting up to six tiers linked to the commission percentage. 

• Sales Activity - The sales rep total Gross Sales and Gross Margin sales values for the given periods.

 The Customer Master form displays pertinent information about each customer.  The tab that is shown in the figure below is related to Sales. There are several fields that might not be available in your ERP or accounting software.  These additional fields can be managed using  the customer master form in the VFP Enterprise System which is included in the Commission Processing System.  To view all the additional fields click on this link Customer Master Form.

 

 Customer Master - Sales Tab

• Sales Rep 1 - This is the primary sales rep assigned to this customer. (This is the Sales Rep Initials in QuickBooks)

• Sales Rep 2 - This is the secondary sales rep assigned to this customer.

• Commission - This is the commission percentage for each sales rep 1 and 2.  In the figure above the 0.5 represents 0.5%.  If you want to enter five percent you would enter 5.0.

• Commission Over Ride - If this box is checked, during commission processing, the value entered in the Commission field on this form will over-ride the inventory master and the sales rep master file

   

  The figure below displays the Commission tab of the Inventory Master Form.  There are several fields that might not be available in your ERP or accounting software. These additional fields can be managed using the Item Display form in the VFP Enterprise System which is included in the Commission processing System.  To view all the additional fields, click on this link Inventory Item Display Master Form.

  

  Inventory Item Display Master - Item Commission Tab
  

  • Commission Type -  This filed determines how commission is paid on this item. 

  • Commission % 1 - This is the 1st  tier commission percentage.

  • Commission % 2 - This is the 2nd tier commission percentage.

  • Unit Price >= and < - This is related to an Item and establishes a low and high value to pay commission 1 or 2.