You are here:
Create a Commission Statement and Related Line Items
Create a commission statement that summarizes the total commission earned by a producer or salesperson over a specific period, such as a month or a quarter. The statement provides a detailed breakdown of the commission amounts and the sources from which they are derived. Ensure transparency and accountability, by helping producers understand how their commission is calculated and from which sales or policies it’s generated.
Required Editions
| Available in: Lightning Experience |
| Available in: Professional, Enterprise, and Unlimited Editions where Financial Service Cloud and Insurance Brokerage are enabled |
| User Permissions Needed | |
|---|---|
| To assign producer split arrangement to an account: | Insurance Commissions Management, Basic CSV Data Import User, and Insurance Brokerage User |
Create a Commission Statement
Create a commission statement that represents a commission summary associated with a party or commission statement line item.
Required Editions
| Available in: Lightning Experience |
| Available in: Professional, Enterprise, and Unlimited Editions where Financial Service Cloud and Insurance Brokerage are enabled |
| User Permissions Needed | |
|---|---|
| To create a commission statement: | Insurance Commissions Management, Basic CSV Data Import User, and Insurance Brokerage User |
- From the App Launcher, find and select Commission Statements.
- Click New.
-
In the New Commission Statement window, enter these details.
field name description Name The name of the commission statement summary record. Account The account that's associated with the commission statement. Statement Date The date when the commission statement was generated for an account. Status Specifies the status of the commission statement summary. Payment Amount The amount paid by the payor account. Payment Method Specifies the payment method used to pay the commission. Payment Reference Identifier The identifier of the external transaction associated with the commission payment. Accounting Date The accounting date of the commission statement. -
Save your changes
A message confirms that the commission statement is created.
Create a Commission Statement Line Item
Create a commission statement line item that represents commission information associated with a service or an item. You can either upload a CSV file or manually create the line items.
Required Editions
| Available in: Lightning Experience |
| Available in: Professional, Enterprise, and Unlimited Editions where Financial Service Cloud and Insurance Brokerage are enabled |
| User Permissions Needed | |
|---|---|
| To create a commission statement line item: | Insurance Commissions Management, Basic CSV Data Import User, and Insurance Brokerage User |
- From the App Launcher, go to Commission Statements, and open a commission statement record for which you want to create line items.
- From the commission statement record page, click the Related tab.
- In the Commission Statement Line Items section, click CSV Import.
- In the Import window, click Upload Files.
- After the file is imported, click Done.
-
Preview the uploaded CSV file and then click Next.
The Salesforce object is autopopulated.
- Select Insert for the Import Type field, and click Next.
-
Enable View Unmapped Columns and verify that the fields are
automapped.
When the uploaded CSV file contains standard fields, the CSV file is automapped. If you upload a nonstandard CSV file, you must manually map the fields in the source data to the fields in the Salesforce Object column.
Tip To avoid manual mapping of fields for statements that the carrier uploads for processing next time, select Save mapping configuration, enter a name for the file, and click Save & Download. When you upload a nonstandard CSV file again, in the Map Column step, select Use a saved mapping configuration and upload the previously saved file with the right mappings. - Click Next, and then click Start Import.
- To manually create the line items, in the Commission Statement Line Items section, click New.
- Enter the required details and save your changes.
The commission statement line items are created.

