Telus TPM Documentation

Broker Commissions Process

Within GoSimple, the client has the ability to build and maintain their Broker Commission contracts. Plus, on a timed basis such as monthly, the GoSimple system can produce backup per Broker Commission contract showing what is owed to the broker that month. There are 5 steps to maintain this whole process:

1. Administer the Broker to Distributor Relationship
2. Build Contracts
3. Send Sales Data
4. Run monthly Commission Process & Approve
5. Send backup and check to Broker

Step 1: Build Broker/Distributor Relationships

There are three ways to build the broker/distributor relationship:

1. Via visibility feed or Admin tool. Here you’d tell GoSimple what brokers you use and what distributors each of those brokers are responsible for.
2. Using Broker/Distributor Assignment, track what broker owns each distributor with the ability to track start/end dates. There is a data feed to auto manage this, or the Admin tool to manually manage. See broker_distributor_assignment for more information.
3. Tell us directly in the sales feed on each line. This is preferred.

Brokers themselves come in via the Company feed or the client enters them manually via the Admin tool.

Step 2: Build a contract with a broker

Create a contract for a particular broker, timeframe, products/product groupings, and pricing options offered to the broker. See the section setting_up_a_new_contract for specific information on creating contracts.

Determine if there are any backout/exception rules in place on the contract.

Step 3: The client sends a daily/weekly/monthly distributor sales file to GoSimple.

Step 4: Run monthly Commission Process & Approve

Based off the payment schedule in the application, the process grabs all lines of distributor sales data linked to the broker contractee for the products on the contract and timeframe and produces a report to show what is owed. Since there is a link between each broker and distributor, we can now produce a report per broker that shows all the sales for the month for their distributors and bump it up against the contract to show what is owed. An earnings spreadsheet is sent to the client to review and approve.

Step 5: Cut check and send backup to Broker

Once GoSimple receives approval for the payments, claims are generated and included in the next payment file to the manufacturer along with backup so checks can be cut (whether client cuts checks themselves or GoSimple does). The client will also receive the backup per check so they can send it to their Brokers.

Reporting

Ability to see Broker Commission reports that slice and dice the data by broker, distributor, month, product, allowed amounts, etc. via Tableau Broker Commission Reports.