The Commissions Module is where you can manage and approve Commissions for both Sales and Change Orders. 1Stop automatically creates Commission records when a Sale, Change Order or Commission Adjustment is approved (if they are Commission eligible). In this article, we define all the fields available on the Commission record.
This section contains all the key information on the commission record.
- Sale Name - Populated with the related Sale record name upon creation after approval of a Sale or Change Order record.
- Commission Owner - Populated with the primary sales representative for the related Sale. If a Commission record is created after a Sale is approved, the Commission Owner is automatically set to the Sale Owner. If a Commission record is created after a Change Order is approved, the Commission Owner is automatically set to the Change Order Owner, which should be the sales representative.
- Commission Name - Automatically generated using the following format: C(Sales Auto Number) - Commission Record Number for this Sale - Product - Contact Name. For example, let's say there is a sales record for Bob Stewart with an auto number of 1252. If there is already one existing commission record for this sale, the new commission record would be named C1252 - 02 - Windows - Bob Stewart.
- Commission Stage - Indicates the current stage of the Commission as it moves through the Commission process (e.g., To Be Completed, Split Update, Ready for Review, Approved, etc).
- Job Cost Name - Populated with the related Job Cost record name upon creation after approval of a Sale or Change Order record.
- Sales Rep 1 - The primary Sales Representative associated with the Commission.
- Change Order Name - Populated with the approved Change Order name when a Commission record is created after Change Order approval.
- Sales Rep 2 - The secondary Sales Representative associated with the Commission, if applicable.
- Product - Populated with the Product field from the related record upon creation after approval of a Sale or Change Order record.
- Status - Indicates the current status of the Commission as it moves through the Commission process (e.g., Active, Active-ISSUE, Hold, Completed, etc).
- One-Call Close - Populated with the Sale’s One Call Close field after Sale approval. The One Call Close field on the Sale record is automatically marked “Yes” if the Sign Date on the Sale record matches the Initial Meet Date for that Customer.
- City -The city associated with the Sale or Commission, typically the customer’s location or where the transaction occurred.
- Grand Total - Populated with the Sale’s Grand Total Amount field after Sale approval, and updated with the Change Order’s Change Amount field after Change Order approval.
- Signed Date - Populated with the Signed Date from the related record upon creation after approval of a Sale or Change Order record.
- Change Order Type - Indicates the reason the Change Order was created.
- Location - If your company operates in multiple locations, this field will specify the location to which this record is linked.
- Connected To - Records in other modules that are related to this record.
This section contains the key assumptions fields that are needed to calculate commissions.
- Non-Commissionable - The amount of Non-Commissionable items included in the Net Sold amount.
- Adjust Commission $ - A manual adjustment field that allows adding or subtracting a fixed dollar amount from the Commission. To add a fixed amount (e.g., a bonus), enter a positive number. To deduct an amount, enter a negative number.
- Commission % - The percentage the sales representative should be paid on the Commissionable Amount, entered as a whole number. For example, enter 10 for 10% or 10.5 for 10.5%.
- Front Payment % Due - The percentage of the Commission paid upfront (front half). The remaining percentage will be paid later (back half). For example, if 25% is due initially, enter 25, and the remaining 75% will be automatically assigned as the back half.
- Pay Terms - Front - Defines when the front half of the commission should be paid (e.g., Signed Date, Install Approved Date, Installed Date).
- Pay Terms - Back - Defines when the back half of the commission should be paid (e.g., Signed Date, Install Approved Date, Installed Date).
- % Paid to Sales Rep 1 - The percentage of the commission allocated to the primary sales representative. Defaults to 100%, but can be adjusted if the Commission is split (e.g., 50 for 50%).
- Effective Discount % - The total discount percentage applied to the sale, which affects the total Commissionable Amount.
- Commission Notes - Additional comments or details related to the Commission.
- Manager Note - Comments or notes provided by a manager regarding the Commission.
Calculated Fields
This section includes all the formula fields required for properly creating commission payments.
- Commissionable Amount - = Net Sold Amount - Non Commissionable
- Commission - = Commissionable Amount * Commission % +/- Adjust Commission $
- Front Commission - = Commission * Front Half % Due
- Back Commission - = Commission * (100 - Front Half % Due)
- Front Sales Rep 1 - = Commission * Front Half % Due * % Paid to Comm Owner
- Back Sales Rep 1 - = Commission * (100 - Front Half % Due) * % Paid to Comm Owner
- Front Sales Rep 2 - = Commission * Front Half % Due * (100 - % Paid to Comm Owner)
- Back Sales Rep 2 - = Commission * (100 - Front Half % Due) * (100 - % Paid to Comm Owner)
Analysis & Approval
This section provides details about the approval process, including information on who approved the commission, when it was approved, and the approved amount. These fields are read only except for Administrators.
- Created By - System-generated field identifying the user who created the record, including the date and time of creation.
- Modified By - System-generated field identifying the last user who modified the record, including the date and time of modification.
- Employee-Rep 1 - Employee associated with the Commission, if applicable.
- Vendor-Rep 1 - Vendor associated with the Commission, if applicable.
- Employee-Rep 2 - 2nd Employee associated with the Commission, if applicable.
- Vendor-Rep 2 - 2nd Vendor associated with the Commission, if applicable.
- Analysis By - The user responsible for reviewing or analyzing the Commission record.
- Analysis Time - The date and time when the Commission record was analyzed.
- Approved By - Populated with the user’s name once the Commission is approved.
Approved Time - Populated with the date and time when the Commission is approved.
Approved Commission - Populated with the final Commission amount once approved.
Administrator Fields
This last section is reserved for fields created and used by the system for automation and reference purposes. This section is typically only available to Administrators.