Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Expand
titleView Change Log

Date

Change

July 2022

Initial Version

December 2023

Screenshots updated

October 2024

Quicker commission report generation process.

Change History

Info

Introduction: This guide describes how to use using the Commissions Console to setup set up pay periods and review commission reports.

Navigating the Console

To access the Console, click the Commissions tab (1), then click on Console (2). The Console has three tabs.

  • The Statements tab (3) allows you to review Commission reports and statements for each pay period.

  • The Setup tab (4) allows you to configure the various functions that make up of the Console.

  • Finally, the History tab (5) allows you to view a history of past commission runs.

Audience: Commissions Team Members

Related Pages

Filter by label (Content by label)
max5
reversetrue
cqllabel in ( "commissions" , "employee-monitor" , "lookup-tables" , "commission-run" , "pay-periods" ) and type = "page" and space = currentSpace ( )

The Statements Tab

The Statements tab displays commissions as a folder tree. Folders vary based on site configuration, but you will see the following types of folders.

Level 1

This folder is named after your site. It contains all other folders.

Level 2

This folder identifies the pay period category. You can assign pay periods to a category in the Setup tab.

Level 3

This folder is always organized by Pay Period. An A icon identifies the Active pay period. Periods above the active period are in the future, and periods below the active period have already passed.

Level 4

By default, the folders in this level are organized by Business Role. You can change this in the Setup tab.

Note: In some cases, this folder is named Undefined.

Level 5

Finally, this level is broken down by rep. Clicking on a Rep’s name (5) in the Commissions tree displays the commission statement and detailed reports associated with that rep. When a document is in the Review tab (6), only users with console access can see these reports. Once a user clicks Release (7), the documents move to the Release tab (8).

Note

Attention: Each time you generate a commission run, the system overwrites any documents still in the Review tab.

Tip

Tip: You can preserve a report or statement by releasing

them

it before generating another commission run. You can then compare the initial report with the new one.

commissions_2.pngImage Added

Generating Statements

Usually, the system is configured to run commission statements automatically on a monthly basis. However, it is possible to re-generate the reports manually.

Rw ui steps macro
Rw step

Select the Active period (1) marked with the A icon in the Commissions tree.

Rw step

Click Generate Statements (2).

Image RemovedHistory

commissions_6.pngImage Added

Rw step

In the Request Commission Statements dialog select the options for generation:

  • Generation Period

  • Generation Type

  • Transactions

  • Complete Regeneration or Update Using New Transactions

  • Post Transactions

  • Ignore Report stage

  • Generate Logs - use this to debug issues with an existing generation process

  • Parallelization Level - select level 5 to get the quickest generation

  • Payroll Extracts Only - select to generate payrolls for specific employees only

commissions_7.pngImage Added
Rw step

Click OK to run the commissions reports.

History Tab

The History tab allows you to view information about past commission runs, including whether

it was auto or manually generated.Image RemovedSetup

they were generated automatically or manually.

Double-click on the entry to see the information about this event.

commissions_3.pngImage Added

Setup Tab

The Setup tab allows you to configure various essential elements of the Console. The following list briefly summarizes each item.

Commissions

Transactions

Tree

This

tab

preference tells the system what to use as the second grouping level when displaying the Commissions tree. For example, selecting Business Role will group reps by roles such as Registered Rep (RR).

Image RemovedImage Removed
Image AddedImage Added

Payroll Periods

This

subtab

screen allows you to create the pay periods that serve as the first level of the Commission tree. Many users prefer to set up all the pay periods for a given year at the beginning of that year.

Note

Attention: You cannot generate a commission run for a pay period until you create the pay period.

You can batch-generate payroll periods or add them one-by-one.

To generate several consecutive periods, click Generate Payroll Periods, fill out the following options, then click Create Periods:

  • Period Type

  • Periodicity

  • The First Day Of Month

  • Start Date

  • End Date

  • Suffix

commissions_5.pngImage Added

To create a single pay period, right-click

on

in the payroll periods

window

table, select Add from the pop-up menu and enter the following information

.

:

  • Period Name

Tip

Tip: A good naming convention to use is [Year].[Month].[EndDay] [Type] (

ie

i.e. 2021.8.02 Brokerage).

  • Type

  • Description

  • Start Date

  • End Date

  • Look Back Date

Info

Example: If you enter 7/1 as the Look Back Date, the system will include any unposted transactions that occurred between 7/1 (Look Back Date) and 8/01 (Start Date).

The Look Back Date tells the system how far back to look for transactions that may have come in from feeds after someone posted the previous period. You can only post a pay period if there is at least one future pay period in your system.

Image Removed
commissions_4.pngImage Added

Business Roles

This section allows you to view the list of business roles in your system and the employees assigned to that role.

Note

Attention: You cannot remove a business role from the system unless it has no employees assigned to it.

Note: The business role assigned in Employee Manager for each employee will automatically prefill here for each employee.

Image Removed
Image Added

Commission Plans

This section allows you to view which employees, lookup tables, and draws are associated with a selected commission plan.

Image Removed
Image Added

Employees

Some employees require unique lookup tables, commission plans, draws, or goals.  This window allows you to override the default assignments setup on the Commission Plan tab.

Image Removed
Image Added

Lookup Tables

Confirm that the tables related to your Commission setup contain information. You can right-click on this window to make changes.

Image Removed
Image Added

If you add a new lookup table, you must include a start date. However, you do not need an end date.

Image Removed
Image Added

Draws

Add description, type, and value to the entry. You may assign the draw to an employee or a commission plan.


Adjustments

When adding a Payout Adjustment, you need to provide the following information

  • Assignment

  • Type of Adjustment

  • Adjustment Value

  • Description (optional)

  • Date/Date Range

Notes: For a One Time Adjustment, populate the Adjustment Date field.
For a Recurring adjustment, populate the Number per Period and Effective date range fields.


Goals

To add a new goal, click the "Add" button in the upper right corner of your screen. Type in all of the goal information and then click Save. You may assign the goal to an employee, a commission plan, or a particular business role.

Image Removed
Image Added

Report Design

On the Reports Design screen, you can customize your generic reports. You may change:

  • Report Info Name

  • Commission Plan

  • Report Description

  • Business Role, etc.

Image Removed
Image Added

Commission Dates

The selections you make on this screen determine the order that the system looks at transaction dates when generating a commission run.

Info

Example: The system will look for a Trade Date (1) in each record. If a record doesn’t have a Trade date, then the system will look for a Settlement Date (2). Finally, the system will look for the Entry Date (3).

Image Removed
Image Added

Fees

Select appropriate checkboxes to add the fees you want to include in your commission calculations.

Image Removed
Image Added

Auto Generation

Here you can set up commissions to run automatically on specific days and/or times. You can also configure options such as whether the system should post periods or release commission runs.

Image Removed

Click ADD to schedule a new automatic commission report generation.

commissions_auto_1.pngImage Added

In the Commission Generation Scheduler dialog select the options for generation:

  • Period Type

  • Generation Frequency

  • Start Time

  • Auto Release

  • Post Transactions

  • Post Payroll Period

  • New Trades Only

  • Email

  • Next Generation Time - shown automatically based on previous selections

  • Exclude the report creation step

  • Generate Logs - use this to debug issues with an existing generation process

  • Parallelization Level - select level 5 to get the quickest generation time


Status Flags

Here you can create new status flags to add to pay periods.

Image Removed

Audience: Commissions Team Members

Related Pages

Filter by label (Content by label)max5reversetruecqllabel in ( "commissions" , "employee-monitor" , "lookup-tables" , "commission-run" , "pay-periods" ) and type = "page" and space = currentSpace ( )
Image Added