Skip to main content

Commission Rule Detail

Commissions > Rules > (rule name or Add Rule)

This page creates or edits a single commission rule. A rule has four parts: a name, rule-level settings, criteria (which projects qualify), and payment rules (how the amount is calculated).

Rule Name

Click the rule name at the top of the page to edit it inline. The name is required and limited to 64 characters.


Rule Details

FieldDescription
Related CommissionLink this rule to another rule. When set, a project only qualifies if a payment has already been recorded for it under the related rule. The related rule's payment amount is available in formulas as [related_payment_amount].
Total Collected Matches SoldWhen checked, a project only qualifies if total collected is within $50 of total sold and estimated remaining cost is within $1 of zero — confirming the project is fully paid by the client.
Full CommissionMarks this rule as a full commission rule.

Applies To

FieldDescription
Team Member TypeThe project team role that earns this commission. Required.
Unique PositionWhen checked, the user must be listed in only one role on the project. Supported for Sales Person, Designer, and Estimator.

Available team member types:

Team Member Type
Intake User
Sales Person
Designer
Estimator
Assistant Designer
Inside Sales
Lead Remodeler
Lead Painter
Project Manager
Design Coordinator
Employee Referrer
Employee Referrer

Employee Referrer pays the employee recorded in the Referred By card on the project. Employee referrals are only ever counted for commissions at the project level — the Employee Referrer and Employee Referral Date fields on the project, not the contact, drive qualification.

Unlike other team member types, Employee Referrer rules do not require the project to have a sold production estimate, so referral bonuses can qualify before a project sells (for example, when the first appointment is completed). For unsold projects, margin- and sold-amount-based values are not yet available — pair these rules with the Static Payment Amount checkbox.


Criteria

Criteria are filter conditions that determine which projects appear in the pay list for this rule. All conditions must be satisfied for a project to qualify.

Click Add Criteria to add a row. Each row has three fields:

PartDescription
Field NameThe project field to evaluate
OperatorThe comparison operator
ValueThe value to compare against

At least one criteria row is required. Rows cannot be reduced below one.

Available fields:

FieldDescription
Created DateProject creation date
Actual Close DateDate the project was closed
Actual Finish DateProduction job finish date
Job Completion DateProduction completion date
Substantial Completion DateSubstantial completion date
Sales PersonProject sales person
DesignerProject designer
Asst. DesignerProject assistant designer
Lead RemodelerProject lead remodeler
Lead PainterProject lead painter
Project ManagerProject project manager
Design CoordinatorProject design coordinator
EstimatorProject estimator
Opportunity TypeProject opportunity type
1st AppointmentDate of the project's first completed, non-canceled First Appointment activity (the activity result must be Completed). Canceled and incomplete appointments are ignored; only the earliest completed appointment is evaluated, so a project cannot qualify twice through rescheduled appointments.
Presentation DateDate of the project's first completed, non-canceled Presentation activity. Same completion and cancelation logic as 1st Appointment.
Referral DateThe project's Employee Referral Date (from the Referred By card on the project).
OutcomeThe project's stage type. Use the = or <> operator with one of: O (Open), W (Won), L (Lost), D (Deferred). For example, Outcome = W qualifies only won projects.

Available operators:

OperatorMeaning
<Less than
<=Less than or equal to
>Greater than
>=Greater than or equal to
=Equal to
<>Not equal to

Payment Amount

Payment rules define how the commission amount is calculated. Rules are evaluated from top to bottom — the first row whose condition is true determines the formula used.

Click Add Payment Amount to add a row. Rows can be reordered by dragging the handle on the left. At least one row is required.

Each row has two sections: a condition and a payment calculation. Checking Static Payment Amount on a row replaces both with a single fixed amount.

Static Payment Amount

Each payment row has a Static Payment Amount checkbox. When checked:

  • The condition fields (Field Name, Operator, Value, and the secondary condition) are disabled and ignored — the row always matches when it is reached in the evaluation order.
  • The Payment Calculation field becomes Payment Amount and accepts a fixed dollar amount (e.g. 500) or a formula using the same placeholders as Payment Calculation (e.g. [total_sold_amount]*0.05).

Rows are still evaluated top to bottom, so a conditional row above a static row takes precedence when its condition matches. You can add additional payment rows alongside a static row.

This is the recommended setup for Employee Referrer rules, where the bonus is a fixed amount and margin-based values may not exist yet for unsold projects.

Condition

A row has a primary condition and an optional secondary condition. Both must be true for the row to match.

PartDescription
Field NameThe project field to test (primary condition)
OperatorThe comparison operator
ValueThe value to compare against — can be a number, a date expression, or a formula placeholder (e.g., [actual_direct_margin_dollars] * 0.10)
Field Name 2An optional second field to test
Operator 2Operator for the second condition (optional)
Value 2Value for the second condition

Available condition fields (PAYMENT_RULE_FIELD_NAMES):

FieldDescription
Estimated Direct Margin DollarsOriginal estimated direct margin in dollars
Actual Direct Margin DollarsActual direct margin in dollars
DivisionProject opportunity type / division
Estimated Direct Margin %Original estimated direct margin percentage
Actual Direct Margin %Actual direct margin percentage
Satisfaction ScoreProject satisfaction score
Actual Finish DateProduction job finish date
Contracted Finish DateProduction contracted finish date
Predicted Job Finish DatePredicted production finish date
Assistant DesignerProject assistant designer
Design CoordinatorProject design coordinator
Substantial Completion DateSubstantial completion date

Payment Calculation

The Payment Calculation field (right side) is a formula expression that calculates the commission amount when this row's condition matches.

Available placeholders:

PlaceholderDescription
[actual_direct_margin_dollars]Actual direct margin in dollars
[orig_est_direct_margin_dollars]Original estimated direct margin in dollars
[total_est_direct_margin]Total estimated direct margin (including change orders)
[orig_est_direct_margin_percent]Original estimated direct margin percentage
[total_est_direct_margin_percent]Total estimated direct margin percentage (including change orders)
[orig_sold_amount]Original sold amount (before change orders)
[total_sold_amount]Total sold amount including change orders
[related_payment_amount]Payment amount from the related commission rule

Example:

[actual_direct_margin_dollars] * 0.15

Pays 15% of the actual direct margin.


Saving

Click Save Rules to save the rule and return to the Commission Rules list. The button is only active when there are unsaved changes.

Click Cancel to discard changes and return to the list.