Part 7: MREPS – Commission Rules Engine & Reconciliation

Commission Rules Engine

The MRSware Commission Rules Engine resolves complex rate schedules automatically using a strict priority resolution hierarchy:

1. Customer-Specific Override Rule (e.g. Account XYZ gets 8% rate for Principal ABC).
2. Product Class Rule (e.g. Equipment class gets 5%, Parts class gets 10%).
3. Sales Rep Territory Split Rule (e.g. 60% Originating Rep / 40% Destination Rep).
4. Default Principal Contract Rate.

Payment Entry & Deposit Logging

Log factory commission checks and direct deposit statements into Payment Entry. Record Check Date, Deposit Date, Check Number, Gross Commission Paid, and Factory Adjustments.

Commission Reconciliation Workflow

Reconcile commission payments against open factory invoices using the Payment Lookup Table:

• Search open invoices by Invoice Number, Customer PO, or Account Number.
• Match check line items against expected commission amounts.
• Highlight rate variances or unpaid invoices for factory dispute resolution.

Auditing Unpaid Commissions

Run the Unpaid Commissions Audit Report to generate aging summaries of shipped invoices for which factory commission payments are overdue.