You are here:
Run a Rebate Program for AMER and LATAM Partners (Example)
This example shows how an administrator in an automotive company configures an end-to-end advanced rebate program to calculate monthly accruals for channel partners using Data Processing Engine definitions on Data Cloud.
Required Editions
| Available in: Enterprise, Unlimited, and Developer Editions that have Rebate and Accrual Management Advanced enabled. |
Program Specifications
The automotive company designs a partner incentive structure with the following requirements:
- Duration: Full calendar year (January 1, 2026 to December 31, 2026).
- Liability Frequency: Calculated monthly to ensure precise corporate forecasting and P&L liability accuracy.
- Data Processing Engine: Execution Type set to Advanced to securely offload high-volume ERP transaction calculations to the Data Cloud platform.
Create the Program and Add Partners
The company creates a rebate program for partners in two regions and aims to increase the sales of two top-selling products.
| Field | Value | Description |
|---|---|---|
| Name | AMER and LATAM Partners Program | User-defined name of the program. |
| Execution Type | Advanced | Mandatory to trigger the Data Cloud engine. |
| Status | Active | The program is live and processing transactions. |
| Start Date | January 1, 2026 | The start date of the program. |
| End Date | December 31, 2026 | The end date of the program. |
| Accrual Frequency | Monthly | Accruals are calculated each month |
Create Accrual Periods
- Navigate to the Rebate Program Accrual Periods related list on the newly created record.
- Click New to manually add 12 consecutive monthly records spanning from January 1, 2026 to December 31, 2026.
Enroll Members
- Navigate to the Members related list.
- Click Add Member List and select the predefined Accounts List View containing all verified LATAM dealer accounts.
- Click Add Member to individually lookup and attach the two unique AMER partner accounts.
Create the Volume-Based Rebate Type
Navigate to the Program Rebate Types related list and click New to define the calculation rules. Create the volume-based rebate type with these specifications:
| Field | Value | Description |
|---|---|---|
| Name | Volume-Based Incentives | User-defined name of the rebate type. |
| Execution Type | Advanced | Routes data transforms through Data Cloud. |
| Calculation Type | Aggregate Based | Aggregates qualified journal items by member and anchor fields. |
| Source Matching Field | MemberID | The unique identifier used to link Transaction Journals to members in Data Cloud. |
| Calculation Method | Retrospective | Use Retrospective for monthly accrual calculation. |
| Calculation Basis | Accrual | Enables independent logic for forecasting. |
| Measure Type | Amount Per Unit | Accrual is offered for an amount per unit of the Total Transaction Quantity. |
| Measure Field | Total Transaction Quantity | The field used to calculate the accrual amounts. |
| Benefit Qualifier Field | Total Transaction Quantity | Field that is used to qualify the member from one benefit tier to the next. |
Create Benefit Mapping
Benefits for the rebate type differ across two products: Grand SUV and Classic Sedan. In the Advanced engine, Product is the criteria used as an Anchor to vary benefits. Ensure that Product is an available field on both the Transaction Journal (Source) and the Program Rebate Type Benefit (Target) objects.
Create a new record under Program Rebate Type Benefit Mappings:
| Field | Value | Description |
|---|---|---|
| Source Field | Product ID | Field on the Transaction Journal used to aggregate data by product in Data Cloud. |
| Benefit Field | Product | Field on the Program Rebate Type Benefit that serves as a criteria for benefits. |
| Program Rebate Type | Volume-Based Incentives | Lookup field that associates this benefit mapping with the Advanced rebate type. |
Add Benefits
Create the benefit tiers for the two products. Because you have mapped the Product field, the engine applies product-specific accrual rates based on transaction volumes.
- For Grand SUV, the benefits are scaled based on the total transaction quantity.
- For Classic Sedan, a flat accrual is offered on achieving a quantity threshold.
| Benefit Tier Name | Minimum Range Value (Total Transaction Quantity) | Maximum Range Value (Total Transaction Quantity) | Applied Benefit Value (Amount Per Unit) | Product (Mapped Benefit Criteria) |
|---|---|---|---|---|
| Bronze Tier Grand SUV Benefit | 250,000 | 500,000 | 0.02/unit | Grand SUV |
| Gold Tier Grand SUV Benefit | 500,001 | - | 0.04/unit | Grand SUV |
| Classic Sedan Flat Tier Benefit | 500,000 | - | 0.05/unit | Classic Sedan |
Accrual Calculation
The admin executes the Data Processing Engine definitions to calculate accruals. The jobs must run in this exact operational order:
- Advanced Rebate and Accrual Pre-Processing - Rule Configuration DPE: Generates the foundational metadata and qualification logic needed for the engine to calculate accruals.
- Advanced Rebate and Accrual Pre-Processing - Data Preparation DPE: Ingests transactions, rebate programs, and benefit rules into the specific Data Lake Objects used by the engine.
- Accrual and Payout Engine - Delta Calculation DPE: Identifies transactions that fall within specific benefit dates to determine which new or modified records are eligible for calculation.
- Accrual and Payout Engine - Rule Processing DPE: Executes the actual financial calculations to generate accruals for the qualified transactions.
- Advanced Rebate and Accrual Post-Processing - Source Generation DPE: Aggregates calculated results to create the required accrual member and rebate type records and sources.
- Advanced Rebate and Accrual Post-Processing - Status Update DPE: Finalizes the process by updating the accrual period status and the last calculation date.
Accrual Calculation Output
After the admin runs the six DPE definitions in sequence, the engine generates Program Rebate Type Accrual Source records for each member per product per accrual period. The following table shows the calculated accrual output for January 2026.
| Member | Accrual Period | Rebate Type | Product | Total Transaction Quantity | Applied Benefit | Accrued Amount |
|---|---|---|---|---|---|---|
| LATAM Dealer A | Jan 2026 | Volume-Based Incentives | Grand SUV | 480,000 | $0.02/unit | $9,600 |
| LATAM Dealer A | Jan 2026 | Volume-Based Incentives | Classic Sedan | 500,000 | $0.05/unit | $25,000 |
| AMER Partner 1 | Jan 2026 | Volume-Based Incentives | Grand SUV | 510,000 | $0.04/unit | $20,400 |
These records roll up into the Rebate Program Member Accrual object, giving the finance team a consolidated view of total accrued liability per member for the period.

