Agents Commission Report
The Agent Commissions report summarises agent commission activity for enrolments that match the selected filter criteria. It shows the total commission invoiced, the amount of funds received for those commissions, the payments made to the agent, and the remaining amount that can be paid to the agent from received funds.
Generate the Report
Go to Reports
Click Agents> Commission Paid/Due
Select an option under the Commissions section:
Due for Payment: Shows enrolments where commission has been received and is available to be paid to the agent.
Credited: Shows enrolments where commission has been deducted by the agent (pre-deducted).
Receipted: Shows enrolments where commission payments have been received.
All the Above: Shows all enrolments with agent commission activity.
Use the enrolment filters to filter the data by the enrolments matching the criteria:
Data Range Options: Select the criteria to find enrolments within the date range.
From/To: Set the period for the report.
Additional Filters
Company: Select the company you with to find the records on.
Location: Select the Campus Location you wish to find the records on.
Faculty: Select the faculty you wish to find the records on. You can select multiple faculties.
Click Excel Merge to generate the dataset.
Report Results
The results include a summary of the agents with commission activity matching the report filters criteria selected.
Column | Description |
|---|---|
Code | Agent Code |
Name | Agent Name |
Country | Agent Country |
Agent Commission | Total Agent Commission Invoiced |
Deducted by Agent | Total Agent Commission Credited (pre-deducted) |
Commission Received | Total Agent Commission Received |
Agent Payment | Total Agent Commission Paid to agent (scheduled) |
Due for Payment | Total amount that can be paid (received) but has not been paid to the agent (scheduled)
CODE
|
API
This report is available in our API:
Report Endpoint: /agentcommissionsummary
The following is the configuration of the report on this endpoint:
Commissions: All
Date Range Option: Starters
Date Range: Based on the parameters provided in the API request
Power BI
V1.8.0
This report is also available in our PBI integration.
The settings for this report are the same as for the API endpoint (see section API above).
The Date Range setting can be updated on the Power BI Report Setting in eBECAS.