So, in this month's Expert's Corner, Account Director Richard Pride shares the key things that users need to know about Charts and Reports, including tips on how to get the most out of them.
The Easiest Way To Export Data Out Of Riskfactor
Reports are the gateway to getting hundreds of data fields found within EQ Riskfactor out of the system. You can export data in three ways:
- Excel format allows you to repurpose data in a variety of ways
- PDF format puts data in a read-only and presentable format
- CSV format allows you to import data into other systems and software.
You can also save Charts as an image that you can repurpose.
How To Create Your Chart Or Report
While many useful Reports and Charts come as standard, the ‘Custom Selection’ functionality allows users to export or visualise data as required. And if viewed in a Grid, it can be used to create a Report or Chart.
This is quickly done by ticking the required fields from within a Portfolio and then clicking ‘Custom Selection’ on either the Reports or Charts bar.
Both options can be done on any Aggregation or Period, as the Report or Chart will mirror the data selected. Reports can be generated on a whole Portfolio or an individual client, whereas a Chart is for one client at a time.
How To Make Use Of Pre-Installed Reports
As mentioned above, EQ Riskfactor contains some useful Reports and Charts as standard:
The Portfolio event history report gives the business a complete audit trail of changes that are made within EQ Riskfactor, including:
- Journals that are entered
- When a client enters and leaves a Focus List
- When Covenants become breached.
The Schedule report shows the current state of Schedules and is configured to display just those that are overdue or all schedules, regardless of when they fall due. The report can also be configured to show all or certain types of Schedules.
The Follow-up report enables a system-wide view of all Follow-ups, which can be filtered depending on their category, status, and due date.
One of our most recent additions is the Client review approvals report, which was introduced alongside the addition of review approvals. This enables users to track their reviews' status as they progress through underwriting.
Finally, unlike the others above, the Cash forecast report enables a user to focus on one client and model how cash collections would vary based on a change in DSO. This report was featured in our June Masterclass on How to Spot a Fraud, which can be found here.
Turn Reports Into A Subscription
Users can turn any Report into a Subscription so that the data within it is sent to an individual or group email inbox. Each instance of a Subscription will be adapted to the Portfolio on the day that it is run, therefore meaning that Subscriptions can be used to send monthly, weekly or even daily lists of clients that meet certain criteria. Examples of this functionality may be to send over a daily list of overpaid clients or a weekly update of overdue Schedules.