Skip to content
  • There are no suggestions because the search field is empty.

What should my commission report look like? (Connective)

The Commission Report can be downloaded directly from Mercury.
 
Sherlok requires commission reports in the header format below. 
 

What should my commission report look like Connective

Header names are as follows:

  • RCTI
  • Acc_number
  • Loan_Name
  • Loan_Amount
  • Loan_Balance
  • Date_Settled
  • Total_Commission
  • GST
  • Line_Total
  • Comm_Percentage
  • Comm_Paid
  • GST_Paid
  • Comm_Type
  • Total_Paid
  • Lender
  • Broker_ID
  • Broker_Name