Templates › Forms › SEO page

Run: Broker Commission Reconciliation Worksheet

Reconcile broker commissions against lender statements, aggregator policy, and payment batches in one worksheet. Use it to spot upfront and trail variances, ...

Fill this out, get a PDF emailed to you. No account required. Want to run it with your team and track results? Sign up free →

Submission Notice and Reconciliation Scope

Reconciliation Period Start (required)

Start date for the commission period being reconciled.

Reconciliation Period End (required)

End date for the commission period being reconciled.

Reconciliation Type (required)

Select the reconciliation workflow that applies.

Lender Name (required)

Name of the lender included in this reconciliation.

Aggregator Name (required)

Aggregator or licensee whose commission policy applies.

Aggregator Commission Policy / Agreement Reference (required)

Policy, agreement, or document reference used for the reconciliation.

Reviewer and Broker Payment Details

Reviewer Name (required)

Name of the person completing the reconciliation.

Reviewer Role (required)

Broker Identifier (required)

Internal broker code, employee ID, or approved business identifier.

Broker Name

Optional broker name if needed for internal matching.

Payment Currency (required)

Payment Batch Reference

Optional payment run or batch reference for traceability.

Commission Reconciliation Summary

Expected Upfront Commission (required)

Expected upfront commission amount under the lender agreement and policy.

Paid Upfront Commission (required)

Actual upfront commission amount paid to the broker.

Expected Trail Commission (required)

Expected trail commission amount under the lender agreement and policy.

Paid Trail Commission (required)

Actual trail commission amount paid to the broker.

Number of Loans Reviewed (required)

Count of loans included in this reconciliation.

Reconciliation Status (required)

Variance Review and Exception Handling

Is there any variance? (required)

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 (required)

Upload the lender statement, commission report, or equivalent supporting file.

Policy or Agreement Document (required)

Upload the relevant aggregator policy or lender agreement excerpt.

Supporting Notes

Add any additional context needed for the audit trail.

Review Completed Date (required)

Date the reconciliation review was completed.

Attestation and Approval

Attestation (required)

Yes No N/A

Approval Status (required)

Approver Comments

Add approval notes, correction requests, or escalation details.

Get your results

Enter your email — we'll send you a PDF of your filled-out template, plus the occasional MangoScoop newsletter (templates, workflow tips, product updates). Unsubscribe anytime — link is in every email.

Email (required)

Your name (optional)

Generated with MangoApps Templates — browse 250+ free