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. 

• Related Articles

• How do I upload my Commission Files

  We recommend uploading your commission reports as you receive them and Sherlok will match your data from your CRM. Any unmatched data will be available in the Loans with Missing Data feature allowing you to fill in the missing details and convert it ...

• If I add clients from a previous aggregator to my current CRM, will Sherlok be able to import it?

  No, Sherlok needs to match the basic details found in the CRM with data accessed on the original commission report.

• What does (Est) mean?

  Est stands for estimation. Sherlok has specific algorithms to calculate certain figures that may vary from the time of settlement, like Property Value, LVR and Current Rate.

• How does Sherlok know if a loan has been discharged?

  Sherlok relies on the Discharge/Inactive status from Flex. Our development team is currently working on a solution that will mark a loan as discharged if the commission has not been paid for two consecutive months. This fix is in progress.

• Why are some of my clients missing?

  Sherlok may not be able to match 100% of your loan book. This is usually due to these four reasons: You have a purchased loan book - Depending on your aggregator, Sherlok may not be able to import orphan clients. You have switched aggregators - ...