Bulk commission import
Prepare Excel or CSV history, then process it through Configure and Assign. Instructions
Select the agency receiving these commissions.
Import supporting records
Import Producers first, then Commission Rules. Use the exact template headings in their original order. Use one populated worksheet per file. Validate to review new and matching records before importing. These imports create no login accounts or invitation emails.
Producers
Download XLS template · Download CSV template
One row per producer. Producer Name is required. Code, Email, Phone and Notes are optional. Blank codes use uppercase name initials. Existing codes are preserved. Enter a unique code if initials are already used. Supplied details must match existing records.
Commission Rules
Download XLS template · Download CSV template
One row per recipient. Repeat Rule Name and Description for every recipient in that rule. Identify an existing active producer by name or code. Enter 30 for 30%. Each rule must total 100%; omit zero-percent recipients. In Excel, use General or Number format with 30 for 30%, or standard Percentage format. Custom number formats are not supported.
Import commissions
Download Excel template · Download CSV template
Use the template headings or map your own column names. Use one row per commission. Supply Carrier on every row, or select one carrier when the file has no Carrier column. Statement Name is optional; use it for formats such as Individual or Group. For each carrier, fill it on every row or leave it blank on every row. Supply Customer ID or Customer Name. Policy ID is a separate optional reference. IDs may repeat. Use Period (YYYY-MM), or Period Start and Period End.
Your source and choices stay saved for the selected agency.
1. Check your data
2. Resolve values and settings
Choose an import field for each nonstandard column. Map values such as MED to an insurance type, or percentage text to a complete commission rule. Producer and Payee are separate.
Fill missing values
Only columns with absent or blank data appear here. Values fill blank cells. A mapped Carrier column must be complete; correct missing carrier values in the source file.
Statement Configuration
Only statements that need configuration appear here. Choose the same settings used in RR Configure, or leave them for Configure after import. Earning periods remain on each row.
Create supporting records in bulk
Review all proposed records before importing. No percentages are assumed.
Select only if you did not import a Producers file.Select only if you did not import a Commission Rules file.Enter the split to use when a row has no rule and no saved assignment. Select Producer from this commission row for its producer share. Unknown named rules remain in Assign.
Check Date is the producer Check Run date. Carrier Payment Received Date determines when RR recognizes carrier commission revenue. It may be an entered date or the estimate calculated above.
How assignments are reused
RR keeps every commission row. A matching customer name, source customer reference, policy reference and insurance type can reuse a confirmed assignment within the same series. Repeated IDs alone never establish a duplicate. Indistinguishable rows keep their individual assignments and do not teach a unique future rule.
3. Check and import
Keep this checked for historical commissions. They remain in the workflow and reporting but are excluded from Check Run payment exports. Clear it only when these commissions should produce new payments.
New series start in Configure. For a returning series, RR checks its saved setup and assignments. Unresolved or changed assignments go to Assign. Fully matched statements go to Approve. Missing producers and commission rules do not reject the earnings. Import does not approve statements, issue checks, or mark historical payments as paid.