Quarterly Bonus

This rule defines a quarterly tiered bonus based on a monetary target called Sales Closed. As attainment increases, the bonus percentage grows across tiers.

🔍 How It Works

  1. Start node initializes the logic.
  2. A bonus node calculates a tiered outcome using the user's quarterly attainment.
  3. A payment node sends 100% of the bonus to the user (owner) in the current month.

🧩 Nodes Used

Node TypePurpose
startEntry point for the rule logic.
bonus -> tieredCalculates a tiered bonus based on the user's quarterly attainment.
paymentSends payout to the deal owner in the current month.

📈 Bonus Tiers

% of Target AchievedBonus Paid (%)
0% – 99.99%0%
100% – 109.99%100%
110% – 129.99%150%
130% – 149.99%175%
150% and above200%

💰 Payment Details

  • Timing: Current month
  • Recipient: Owner
  • Amount: 100% of calculated bonus

🧱 Full Dolfin Diagram

{
  "edges": [
    {
      "id": "start-node->placeholder-7455b9b1-c326-4751-8dae-140f41001930",
      "type": "default",
      "source": "start-node",
      "target": "placeholder-7455b9b1-c326-4751-8dae-140f41001930",
    },
    {
      "id": "edge-placeholder-7455b9b1-c326-4751-8dae-140f41001930-7dddc834-1833-4038-8352-e7587b01bcc2",
      "type": "default",
      "source": "placeholder-7455b9b1-c326-4751-8dae-140f41001930",
      "target": "7dddc834-1833-4038-8352-e7587b01bcc2",
    }
  ],
  "nodes": [
    {
      "id": "start-node",
      "data": {},
      "type": "start"
    },
    {
      "id": "placeholder-7455b9b1-c326-4751-8dae-140f41001930",
      "data": {
        "id": "bonus",
        "type": "compensation calculations",
        "edges": [{ "type": "default" }],
        "formData": {
          "type": "tiered",
          "label": "Sales Closed",
          "tiers": [
            { "value": "0", "attainment": 0 },
            { "value": "100", "attainment": 100 },
            { "value": "150", "attainment": 110 },
            { "value": "175", "attainment": 130 },
            { "value": "200", "attainment": 150 }
          ],
          "target": {
            "label": "Sales Closed",
            "type": "monetary",
            "period": "quarter",
            "metric_id": 29
          },
          "contributor": { "key": "user", "label": "User" },
          "reference_type": "target"
        }
      },
      "type": "bonus"
    },
    {
      "id": "7dddc834-1833-4038-8352-e7587b01bcc2",
      "data": {
        "id": "payment",
        "type": "payment",
        "edges": [],
        "formData": {
          "phases": [
            {
              "id": "34d039d8-cf7b-4724-8c19-0576e0b20631",
              "timing": "current_month",
              "percentage": 1
            }
          ],
          "recipients": [
            {
              "id": "95309015-0dfa-4193-8517-253299d1e96c",
              "recipient": "owner",
              "percentage": 1
            }
          ]
        }
      },
      "type": "payment"
    }
  ]
}

Sample test case

📐 Metric Used: Sales Closed

The Sales Closed target in this rule is based on the following metric definition:

{
  "type": "monetary",
  "label": "Sales Closed",
  "source": "deal",
  "filters": {
    "==": [
      { "var": "deal.stage" },
      "Won"
    ]
  },
  "formula": "deal.amount",
  "rule_id": 999,
  "metric_id": 29,
  "user_field": "deal.owner_id",
  "accrual_date_field": "deal.close_date",
  "description": "Sum of deal amounts for deals marked as 'Won'",
  "aggregated_value": 0,
  "aggregate_function": "sum",
  "formula_explanation": "Sum of all deal amounts where stage is 'Won'"
}

📄 Example Deals for a Quarterly Commission Cycle

Deal IDStageClose DateAmountCurrencyContributes to Metric?
D-001Won2025-04-0120,000USD✅ Yes
D-002Open2025-04-1018,000USD❌ No (not Won)
D-003Won2025-05-0530,000USD✅ Yes
D-004Lost2025-05-2025,000USD❌ No (Lost)
D-005Won2025-06-1035,000USD✅ Yes

📊 Metric Calculation

  • Metric: Sales Closed
  • Quarter: Q2 2025
  • User: AE John Smith
  • Eligible Deals: D-001, D-003, D-005
  • Total Sales Closed: 20,000 + 30,000 + 35,000 = 85,000

🎯 Target and Attainment

  • Target Amount: 80,000
  • Actual Metric Value: 85,000
  • Attainment: 85,000 / 80,000 = 1.0625 → 106.25%

💰 Bonus Outcome (per rule logic)

Tier Range (% Achieved)Bonus Paid (%)
100% – 109.99%100%

✅ Final Payout

  • Rule Type: Bonus
  • Base Bonus Defined in Rule: $3,000
  • Applied Bonus Percentage: 100%
  • Payout Amount: $3,000 × 100% = $3,000
  • Timing: Paid in current month via payment node