COMMRECON - Commission Reconciliation


This process is designed to review Commission previously calculated and reconcile those values with the current calculation; many factors can affect the current calculation e.g. price change, FX rates, Costs being changed that were used as a component of the original Commission calculation.

The process drives by Purchase TRADE that are allocated and have a Mirror classified Department coding and have a commission expectancy.

This process shows the allocated pair, the counterparties, the commodity codes, the tonnage and weight code, the pack code and units, all of the costs, the prices, and commissions value.

This grid shows allocated purchase and sale pairs that are in mirrored departments and that have a commission detail maintained.
Costs are displayed and can be grouped using the “Organise” button.
Costs and Contract value are displayed in the contract currency.
Commission is displayed in the commission currency.
All costs are shown, including those that do not have an impact on the commission value calculation; this is useful to view where Mirroring of Costs (COSTMIRR) has not been actioned.

Another style of this report shows the comparison of this month or current vs. last month to prove the changes that took place in the costs.
Main Screen showing allocated pairs, commissions and costs. The highlighted values show a  sample scenario: “Comsn Value” shows the commission value taking commission invoicing into account, whereas “Calc. Comsn Value” shows the calculated value of commission.

Sample of main grid/display



There is a mechanism for Costs to be grouped and their sequence for display in grid above. 
This process is activated from grid above by click the 'Organise' button



Was this helpful?
Thanks for your feedback