Top menu >> Commissions >> Reconcile


This feature allows you to compare a Money or Formula field from a process, typically the MRC on an order, to the Net Billed or Gross Commissions of the matching Account Number, Customer Name, Supplier, Agency, and Rep from the latest commissions run.


Reconciling will help you identify if your supplier or commissions from a Master Agent is paying the correct amounts on your Orders.


The Reconcile feature works best if there are no conflicts, and to ensure that you will need to have one Order per Account Number in your RPM. If you find that it is difficult to track Orders or you've already have a multitude of Orders that conflict when reconciling our new Dynamics Order process is the best solution to this. 


*To be made public soon* For more information in the meantime please email support@rpmtelco.com

https://support.rpmsoftware.com/a/solutions/articles/12000059891-guide-to-dynamic-orders 


To update your reconcile you have to click Reconcile (required).


On the reconcile page you will find 3 tabs: Correct, Incorrect, No Match



Correct


Orders showing in this tab have successfully been matched to a line item (line items) and the values that your are comparing (Setup) are within the tolerance that is setup. 




Incorrect


Orders showing in this tab have successfully been matched to a line item (line items) and the values that your are comparing (Setup) are not within the tolerance that is setup. 





No Match



There can be various reasons for an order to show in the No match tab:

  • The order is not commissioned yet.
  • One of the conditions is missing (Supplier, Customer, Account, Agency, Rep).
  • The conditions in the order are different than the item. Example: the Rep in the order is not the same Rep the item is assigned to or the Carrier defined in the order is different than the carrier that the line item belongs to. 
  • The order is in conflict; which means there is more than 1 order with the exact same conditions. When this happens RPM will need you to resolve this. 





Conflicts


Conflicts happen when there are multiple orders with the same conditions: Supplier, Customer, Account, Agency, Rep


Due to this RPM does not reconcile multiple orders to 1 line item.


Click Conflicts






The Conflicts page shows the Forms that have the same conditions and a Resolve link. 


Click Resolve






Select a form to match the line item to

Click OK when done. 




See also: