Commission 

The Commission Report tracks and calculates commissions earned by sales representatives over a specific period. This Report monitors performance and ensures accurate payouts based on sales data. 

Prerequisites 

1. Logicim XLGL version 5.0 or higher  
2. Microsoft Excel 2016 or higher 
3. Sage 50 US edition (2021 and above) 

What the Report does 

Commission Report enables you to: 

1. Calculates sales commissions: Applies the defined commission percentage to sales figures. 
2. Tracks commission based on preferences: Enables you to choose between calculating commissions based on invoice amounts or actual payments received. 
3. Monitors sales performance: Provides insights into how individual reps or teams perform over time. 

How to use the Report 

1. Open the Report workbook. 
2. Go to the Instructions sheet. 
3. Set your Parameters: 
4. Enter the Start Date in the designated cell. 
5. Enter the End Date to define the Reporting period. 
6. Specify the commission percentage. 
7. Choose Paid By option: Invoice Amount or Paid Amount. 
8. Click the Refresh button in the Logicim XLGL tab to update the Report. 

Customization options 

1. Adjust the date range to analyze different periods. 
2. Modify the commission percentage for different sales roles or periods. 

Common use cases 

Monthly and quarterly sales performance reviews. 

Commission payout calculations. 

Sales team incentive tracking. 

Troubleshooting 

1. Issue: The Report doesn’t update when a new date is entered.  
2. Solution: Ensure you are connected to your data source and refreshed. 

1. Issue: Commissions seem incorrect. 
2. Solution: Double-check the commission percentage and Paid By selection. 

FAQs 

1. Q: Can I apply different commission rates for different sales reps? 
2. A: No. Add custom columns for specific reps and adjust their commission percentages accordingly. 

Best practices 

Regularly refresh data to keep the Report updated. 

Verify commission rates periodically to ensure accuracy. 

Save a backup before creating significant adjustments to the Report structure. 

Related article

See also: Cash flow