NEW: Insurer Statement

 

You can now access the Insurer /  Broker Statement from within the insights module.

 

Here is a quick recording of where to access this report: Insurer Statement Report. (The recording has no sound).

 

Go to insights, select Reports and then choose the Financials section.  There is a report called Insurer Statement, shown here:

 

 

By clicking on the report link, you will open up the latest insurer statement, (eg. If its June, Junes statement will open).

The latest Insurer Statement report will be visible at the start of each month, usually by the 3rd. (for example, June 2022 Insurer Statement will be visible here by July 3rd, 2022. 

 

It looks like this:

 

 

Here is a guide to the information in the insurer statement, which are numbered in the above visual.

 

 

This graphic displays the total Accounts Payable for that month. If you use the black module for the reconciliation, this is the amount that you are looking to reconcile there and pay to the insurer. 

 

 

If you wanted to slice the reports to view the granular data, use the Slicers at the top of the report to do so.  For example, if you want to find a specific policy number, use that slicer to view that information or if you wanted to see Condo policies only, you can use the Line of Business slicer.

 

 

You can export the statement to save to your records/systems outside of the platform OR to upload to the black module, if you do your reconciliations there.

 

Note that the verbiage in this report advises that you must save as .xlsx format for the import to work in black. Here' s how to do that.

 

• Hover the mouse anywhere over the above table, in the report.
• The below sub menu appears and you select the  …
• Menu opens, select Export Data.

 

 

• You will then get to choose which data that you want to export and the format that you can choose from.
• TO USE IN BLACK you must choose Summarized Data and save a .xlsx.
• Select Export.

 

 

 

To understand the terms in this (and all!) of our reports, we put definitions in the Data Dictionary, however for ease here is the definitions used in this piece to understand the relevant of the dates.

 

 

 

 

Yes, as mentioned above, if you follow the Export instructions shown you will receive the statement in the correct format to allow it to be imported into black and the reconciliation will work the same.

 

 

Yes, once the new Insurer Statement report is available, you will see that when you are adding a new statement into black you will have the option to pick from Integrated (New format - using the insights report) or Legacy (Current process where you receive the statement by email). Just choose the right one for the process that you are following.

 

 

Yes, there will be prior months Insurer Statements here for you to review.  We have already provided past months reports into this feature, so if you do want to Export them and add them to black from this, you can use the Export function  in the report to export a prior months statement. Then use Integrated option to add it to black Statements (as it will be in the new format).

 

 

Around the 3rd of every month, you will be able to view the latest statement.