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.
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