Broker Commission Reconciliation Worksheet

Reconciles lender-paid upfront and trail commissions against aggregator commission policy and lender agreements to confirm accurate broker payments.

Submission Notice and Reconciliation Scope

• Reconciliation Period Start
  Start date for the commission period being reconciled.
• Reconciliation Period End
  End date for the commission period being reconciled.
• Reconciliation Type
  Select the reconciliation workflow that applies.
• Lender Name
  Name of the lender included in this reconciliation.
• Aggregator Name
  Aggregator or licensee whose commission policy applies.
• Aggregator Commission Policy / Agreement Reference
  Policy, agreement, or document reference used for the reconciliation.

Reviewer and Broker Payment Details

• Reviewer Name
  Name of the person completing the reconciliation.
• Reviewer Role
• Broker Identifier
  Internal broker code, employee ID, or approved business identifier.
• Broker Name
  Optional broker name if needed for internal matching.
• Payment Currency
• Payment Batch Reference
  Optional payment run or batch reference for traceability.

Commission Reconciliation Summary

• Expected Upfront Commission
  Expected upfront commission amount under the lender agreement and policy.
• Paid Upfront Commission
  Actual upfront commission amount paid to the broker.
• Expected Trail Commission
  Expected trail commission amount under the lender agreement and policy.
• Paid Trail Commission
  Actual trail commission amount paid to the broker.
• Number of Loans Reviewed
  Count of loans included in this reconciliation.
• Reconciliation Status

Variance Review and Exception Handling

• Is there any variance?
• Upfront Commission Variance
  Difference between expected and paid upfront commission. Enter a positive or negative amount if applicable.
• Trail Commission Variance
  Difference between expected and paid trail commission. Enter a positive or negative amount if applicable.
• Variance Reason
• Variance Explanation
  Explain the cause of the variance and how it was validated.
• Corrective Action Required?

Supporting Documents and Audit Trail

• Lender Statement or Commission Report
  Upload the lender statement, commission report, or equivalent supporting file.
• Policy or Agreement Document
  Upload the relevant aggregator policy or lender agreement excerpt.
• Supporting Notes
  Add any additional context needed for the audit trail.
• Review Completed Date
  Date the reconciliation review was completed.

Attestation and Approval

• Attestation
• Approval Status
• Approver Comments
  Add approval notes, correction requests, or escalation details.