Commissions

Commissions in CORESense are assigned at the product level.  There are three different methods in which commissions are calculated:

• Profit = the commission is calculated as the amount in the commission rate field multiplied by the sale price of the product - COGS for that product (COGS is from the order items table).

• Top Line =  the commission amount is the sale price multiplied by the amount in the commission rate field.

• Fixed = the commission amount is exactly the number in the commission rate field. If the commission rate is fixed then the commission amount is automatically set as a dollar amount.

Commissions Report

The Commissions Report reports on the following fields:

• Product ID
• Product Name
• Order Number
• Creation Date
• Recognition Date (The date that the order is Paid in Full or Shipped in Full)
• Return Number
• Return Creation Date
• Return Close Date
• Originating Channel
• Quantity
• Unit Price
• Extended Unit Price
• Extended Price
• Cogs
• Commission (from the order_item_commissions table)

Salesperson Summarization

The commissions report will summarize the following columns per salesperson:

• Order # (the total number of orders recognized for this reporting period)

• Return # (the total number of returns closed during this reporting period)

• Units Sold (the sum of the units sold for recognized sales less the sum of the units returned from closed returns)

• Unit Price (the sum of the unit price for recognized sales less the sum of the unit price for closed returns.)

• Extended Unit Price (the sum of the extended price for this salesperson)

• COGS (the sum of COGS for this salesperson, from the order_items table, for all sales that she has received a commission for)

• Commission (the sum of commissions for this user). If the sum of commissions is less than zero, then the value should be zero.

The commissions report will summarize the following columns for ALL salespeople:

• Order # (Total count of commission bearing orders)
• Return # (Total count of commission bearing returns)
• Units sold (The total number of commission bearing units sold)
• Unit Price (The total unit price for all commission bearing products recognized as sold

© 2015 CORESense · 1-866-229-2804 · info@coresense.com · 125 High Rock Avenue, Saratoga Springs, NY 12866