Book of Business – Report (There is a pdf copy of this training guide available within this guide - see Attachments) This is a Power BI report available via the insights module. Tabular report that contains the following: * Policy sales * Written premium * Brokerage commission * Brokerage commission % of …
Quote Analysis Report Guide This report is used for quote tracking and displays the following: * Prospective customer demographics * Closing ratio * Lockout ratio * Drop-off ratio * Total quotes * Second page contains tabular and quote specific details. (shows/converts what time the quote was done in loca…
New Business Policy Details – Report (There is a pdf copy of this training guide available within this guide - see Attachments) This is a Power BI report available via the insights module. This is a tabular report that shows only new business policy sales. Tips * If you forget which criteria you use…
Book Of Business Dashboard Report Report showing Policy Count for various categories like * Discovery method * Risk Location * Carrier * Age Group Tips * You can click on any of the fields within the visuals and the report will recalibrate with only those results showing. For example; if you wa…
Retention Analysis Report NEW REPORT - September 2021 : * Policy Retention rates by year. * Premium Retentions rates by year. * Slicers at the top enable you to slice via Carrier, primary contact Province or Policy Type . * Table format at the bottom of the report provides a year by year % rate. Remembe…
You can use the Trial Balance OR Transaction and Payment Reconciliation report to identify tax liabilities. Trial Balance report A swift and exact report is available for the Tax Liabilities, and that is the Trial Balance report. You will see when you are in that report that you will have a 'slicer' which allo…
Transaction & Payment Reconciliation Report Guide * Tabular report that contains details about both transactions and payments for the brokerage. * Displays Company fee, Interest Fee and other Fees (NSF) * Updated daily. Where is it? Open Insights module, click on Reports and open 'Transaction & Payment Rec…
Renewal Report Guide This Renewal Report provides you with the following data: * Dataset showing in-force policies as at custom date. * PIF Count. * PIF Premium. * Written Annual Premium. * Slicer allows you to display policies that were in force as at a chosen date. * Property Risk Province and City availa…
To export a report to Excel * Hover the mouse anywhere over the a table or visual, within a report. * The below sub menu appears and you select the ... icon. * Menu opens, select Export Data. * Save as a File Format of your preference, and Select Export. Note: It is worth mentioning that the report has t…