Generating a Settlement Report
Updated over a week ago

Tracking settlement values in order to analyse performance is essential in managing the overall health of your business, while also identifying areas for improvement and opportunities for growth. Mercury Nexus comes with a Settlement Report that allows you to generate this data in seconds.

How do I create a Settlement Report?

To track your settlements:

  1. In the CRM app, select Reports from the main left-hand menu.

  2. Navigate to Business Statistics in the top menu.

  3. From here you can choose to customise the report using the following filters:

    • Select the Opportunity Type from the drop down.

    • Choose a Date range to report on.

    • Enter your upfront commission rate

  4. You can also select how the data is presented by using the Group By drop-down and selecting:

    • Month.

    • Loan Writer.

    • Virtual Branch.

    • Lead Source.

    • Lender

  5. The report will automatically generate based on the filters you select and display the:

    • Expected Settlement value.

    • Confirmed settlement value.

    • Estimated UFC

    • Number of settlements by group.

    • Average value of settlements by group.

  6. Click on the Chart tab to view the data in a chart.

  7. You can pin the report to your Dashboard by checking the Pin to Dashboard. Learn more about the Dashboard.

Note: Right click the data results to Export the data into Excel.

Note: The Settlement Date needs to be present in the Opportunity in order for it to appear in the Settlement Report.

Generating_a_Lead_Source_Report.gif
Did this answer your question?