Supported formats
- CSV — Comma-separated values
- XLSX — Excel workbook (first sheet is used)
File format
Download the template from the import dialog. Expected columns:Column mapping
CommissionKit auto-detects columns by name. Common variations are recognized:- Rep:
Rep Email,email,Rep,sales_rep,Sales Rep - Deal Name:
Deal Name,Name,Deal,deal_name - Amount:
Amount,Price,Value,Deal Amount,deal_amount - Close Date:
Close Date,Date,close_date - Stage:
Stage,stage - Currency:
Currency,currency - Notes:
Notes,Description,notes
Import process
- Set the default currency fallback (used when a row has no currency)
- Select your file
- Review the parsed preview — each row is editable
- Rows with unrecognized reps are highlighted in red
- Use the dropdowns to assign reps to unknown emails
- Click Finalize Import to save all deals
Validation
- Deals without a recognized rep email cannot be imported until you select a rep
- All deals are assigned to the period you selected when opening the import dialog