Built-in Reports

Using Built-In Reports

Built-in Reports (as well as any Custom Reports you have created) are accessed by clicking on the Reporting icon in the header of any Case List or Portfolio.
Built-in Reports will be formatted as CSV (Comma Separated Value), PDF (Portable Document Format), or XLSX (Excel 2013 and later format files). Reports which are published as PDF will require that you specify a Page Format when generating the report, which can be set to A4, Letter, Ledger or Legal. Reports which are published as PDF will include your company's logo (if it has been uploaded into ClariNet on the Client Information page), otherwise they will include the ClariNet logo.

GO Column

The go column allows the feature listed below

Favorite a built-in report
Hide/Show a built-in Report

Favorite Built-In Reports

The empty Star icon under the go column allows you to favorite a report by clicking on the icon.

This feature allows you to filter your favorite reports. By having at least one report favorited, just the favorited reports will be listed whenever you access the Export and Reports page.

At least one report must be favorited to display only favorites every time you access the Exports and Reports page.

All the favorite reports will be listed first under the label Favourite Reports on reporting modals when accessed from

Home Page
Advanced Search Page
Portfolios List Page.

Hiding a Built-In Report

The eye icon under the GO column allows you to hide a built-in Report. Hidden reports will be hidden from the reports list and the reporting modal.

The filters in the screenshot below allow you to filter the reports.

You must select “All” to view all the reports, including hidden ones. “Visible” must be selected to display only visible reports and are not hidden.

Example: The 1099Fire(XLSX) and Annual Premiums (CSV) reports are hidden as shown in the screenshot below. These reports are now hidden. Hence the fully open eye represents that the report is now hidden and you can click on the same to make it visible.

Hidden built-in reports will not be listed in any reporting modals.

Reports can be either hidden or favorited but not both

The list of Built-in Reports are :

Annual Premiums (CSV)

This report shows the premium payments scheduled for a Case on an annual basis. It selects the Premium Schedule based on the Valuation Settings (or shows “No PS” if no Premium Schedule is available). Fields included in the report are:

Column1	Column2
Case Reference	Sender
State of Ownership	Carrier
Policy Number	Policy Date
Face Amount	Derived Policy Type
Coverage End Date (calculated based on the Policy Date, Age Basis and Maturity Age/Extended DB Rider Age)	Coverage End Age (based on Maturity Age/Extended DB Rider Age)
Premium Financed	Insured1Reference
Insured1Firstname	Insured1Lastname
Insured1Gender	Insured1DOB
Insured1SSN	Insured1Report1Underwriter
Insured1Report1Date	Insured1Report1LE50
Insured1Report1Smoker	Insured1Report2UW
Insured1Report2Date	Insured1Report2LE50
Insured1Report2Smoker	Insured2Reference
Insured2Firstname	Insured2Lastname
Insured2Gender	Insured2DOB
Insured2SSN	Insured2Report1Underwriter
Insured2Report1Date	Insured2Report1LE50
Insured2Report1Smoker	Insured2Report2UW
Insured2Report2Date	Insured2Report2LE50
Insured2Report2Smoker	PremiumPricingDate
PremiumStartDate

Age Basis: The basis by reference to which the Insured's Attained Age is calculated; either ALB (Age Last Birthday) or ANB/ANBm (Age Nearest Birthday). ANB is the most common basis for Policies issued after 1995. ANB calculates the exact number of days from the reference date to the previous and next birthday and uses whichever is closest on that basis to determine age. For ANBm, if we are more than 6 months after the last birthday, use the next birthday as the age, otherwise, use the previous one.

The report parses the Premium Schedule into years (measured from the Start Date) and sums the Premium Payments due during each year.

Closing Report (PDF)

This report shows information about Closing Transactions for one or more Cases and is therefore relevant for Clients with the Closing module included. When selected in the Reporting dropdown, a link is shown to allow you to attach a header document (as PDF) and a footer document (also as PDF). Fields displayed in the report are:

Case Reference;
Insured(s) Last Name(s);
Policy Number;
Face Amount (with total);
Price Allocation Total: drawn from the table of amounts on the Price Allocation tab of the Closing Transaction (and totaled for all Cases in the report); and
Last Recorded Event: the last recorded Closing Event on the Case.

Funding (CSV)

This report generates funding information for Cases with an associated Closing Transaction. When selected in the Reporting dropdown, you are required to select a Payment Recipient (e.g., Seller, Broker, Agent) and a Closing Event. Fields displayed in the report are:

Case Reference;
Insured 1 Full Name;
Insured 2 Full Name;
Policy Number;
Payment Recipient;
Date Paid;
Amount Paid;
Payment Type; and
Closing Event Completed (date).

Maturities (CSV)

This report lists profit information on matured/maturing Cases. When selected in the Reporting dropdown, you are required to select a Valuation Template (used to determine valuation information which is displayed in the report), Underwriter Weightings (either Valuation or Actual Expected) and a date range for the Insured DOD. Fields displayed in the report are:

Case Reference;
Case Status (e.g., Maturity Claim Pending);
Face Amount;
The following fields for each of Insured 1 and Insured 2:
- DOD;
- LE At Maturity (i.e., how many months before/after the Insured’s LE did the DOD occur);
- Age at Death;
Purchase Cost;
Premiums Paid (drawn from the Premium History);
Fees Paid (drawn from the Fee History);
Purchase Other Costs;
Profit (calculated as on the Cost/Maturity/Disposal tab);
Realized IRR;
Maturity Total Amount;
NDB Payment;
Interest;
Return of Premium; and
Other Amounts.

Maturities (PDF)

This report lists profit information on matured and maturing Cases. When selected in the Reporting dropdown, you are required to select the same variable as for the CSV version. The resulting PDF is presented in landscape format. The report comprises four sections:

Summary

This lists the total number of Insured Lives, total face, total number of Policies and shows a table with these three data points broken down by Case Status (together with Average LE at Maturity and Average Age at Death).

Maturity Claim Pending

For all Cases with Status Maturity Claim Pending, this lists:

Case Reference;
Face Amount (with total);
Primary/Secondary Insured DOD;
Primary/Secondary Insured LE at Maturity; and
Primary/Secondary Insured Age at Death.

Maturity Claim Paid