Lloyds Bordereau Report Explained

TPA Reporting with Report Builder - Lloyd’s Bordereau Report

Last updated: 4/14/2020

Overview 

 This support document will walk the user through the steps for the following items: setting the Reserve fields and Recovery fields correctly, how to add Reserve Amounts and Recovery Amounts to a claim, how to run the standard Bordereau Report, how to build various versions of the “Standard” report in the Report Builder, and a detailed explanation of the fields.

 Entering Recovery Types

 It is important to note that the Report Builder – Lloyd’s Bordereau only functions properly when the proper Reserve Types and Recovery Types are set up in the user’s system and used on all relevant claim records.  The Reserves and Recovery Types should be set up as follows:

Reserve Types:

• “Adjuster Fees” set up as “Expense” Reserve Type
• “Attorney coverage Fees” set up as an “Expense” Reserve Type
• “Defense Fees” set up as an “Expense” Reserve Type
• “Expenses” set up as an “Expense” Reserve Type
• “TPA Fees” set up as an “Expense” Reserve Type
• “Bodily Injury” set up as an “Indemnity” Reserve Type

 Recovery Types:

• A Recovery Type starting with “Deductible” for the Deductible Recovery figure column(s)
• A Recovery Type starting with the “Salvage” for the Salvage Recovery figure column(s)
• A Recovery Type starting with “Subrogation” for the Subrogation Recovery figure column(s)

 Follow the steps outlined below to add the Reserve Types and Recovery Types to your system.

 Adding Reserve Types:

1. Go to the Settings tab in FileTrac, and click the bookmark within labeled Reserve Types

2. Check the box adjacent to the blank field, and type in the Reserve Type as desired

3. Select the Category by clicking the drop-down and selecting either Expense or Indemnity

4. Click Add/Save Changes

  Continue adding each type of Reserve until all have been added and are showing in the Reserve in the box.

 Adding Recovery Types:

1. Go to the Settings tab in FileTrac, and scroll down to locate the section Recovery Types at the bottom
2. Check the box and input the Recovery Type in the field
3. Click Add/Save Changes

 Continue adding each type of Recovery until all have been added and are showing in the Recovery Types listYou can change the order of either the Reserves or the Recovery Types by selecting Move Up/Move Down.  

 Standard Lloyd’s Bordereau Report

 This is a valuable reporting tool available to you that allows you to build various versions of the standard Lloyd’s Bordereau.  To run the Standard report, follow the steps outlined below: 

1. Click on the Reports tab
2. In the Custom Reports Builder section, click on Report Builder – LLOYD’S Bordereau

To find out more details about the TPA Reporting with Report Builder, click on the blue link at the top of the page in FileTrac (shown below) in order to evaluate which choices in the report may be right for you. The TPA Reporting with Report Builder-LLOYD’s Bordereau provides a detailed list of the available fields and the information contained in each.

To run the report “As Is”, including “All” for each category, the only thing you will need to do is select the date ranges and then select the format for the report. See the illustration below: 

3. Click the calendar and select the date range

4. Click the radio button to Select the Report Format

5. Click on View Report

 Creating a Lloyd’s Syndicate Variant on the StandardWhile there is a “Lloyd’s Standard” Bordereau reporting format, each Lloyd’s syndicate wants their own special version or variant on the standard.  If you would like to make your own selections for the report, see the instructions below. Once your selections have been made for the report, you can save the report to be used again in the future.  Follow the instructions below to learn how to limit the search fields and learn more about each field so that you can create an accurate report. 

1. Select the Client Company from the drop down. To customize the report you can make a selection for Client Company.   In making a selection, the “All Values” will no longer be selected and the report will only pull information for the companies that are added to the “Selected Values” field.   
2. Click on the company from the list of values
3. Click Add 
4. Once you have added a company to the list it will appear in the Selected Values field. You can continue selecting additional companies to add them to the report by repeating steps 1-3 for each additional company.
5. Click the dropdown bar to select the Client Rep, otherwise “All” will remain selected.
6. Click the calendar to select the Report Period Start Date.  This field defines the beginning of the “Reporting Period” on which the report is run.
7. Click the calendar to select the Report Period End Date. This field defines the end of the “Reporting Period” on which the report is run.
8. Click the calendar to select the “As of” Date. This field defines the virtual date on which the report is run. In other words, it asks the report to show the figures and information “as of” the selected date. This means that financial transactions - such as changes to a Reserve amount or Reserve Payments against a specific Reserve - will not show if they are dated later than the “As of” Date entered here.
9. Click the dropdown field for Claim Split Type to select how claims should be split regarding their liability in the system, where applicable. There may be multiple rows displayed for each individual claim, depending on how the Claim Share or Underwriter Split is set up for the corresponding claim. See more information for Claim Split Types in the section below.
10. Customize Field Selection:  Making NO selections here will output the FULL Lloyd’s Standard Bordereau. Making any selection will output ONLY those field selections, in the order that you have them arranged.
11. After selecting an available field, click the Add button.
12. The above selection will then appear in the Selected Fields. You can continue to add fields in this manner by repeating steps 10-11 for each desired field. Also, you can change the order of the Selected Fields by clicking on a selection and then opting with the buttons Move UP or Move DN. You can also delete a selection if needed by highlighting the selection and clicking on the Del button.
13. Click the dropdown bar to Customize Sort Order. This allows the user to select in what order the rows of information will output on the report, which are sorted according to the selected field. Making NO selection will output the information in no specific order. To select a field here, it must be included in the selected fields from the Customize Field Selection above or errors may occur!
14. Click the dropdown bar to select a Tab Breakout. This allows the user to select a specific field on which to breakout the report output into multiple tabs of an Excel Workbook. For example, if the output needed to be an Excel Workbook in which the claims on each tab were a different Year of Account, the “Year of Account” selection from this dropdown would be appropriate.
15. Click the Use Filter tab to apply the filters that were chosen in the steps above.
16. Select the Format for your report by clicking on the corresponding radio button.
17. Click the View Report tab
18. And finally, to save these filters so that the report can be run again later, click Save Report at the top right corner of the page. Once a report is saved here, you can click the Load Saved Report to run it again when the time comes.

 Claim Split Types

The Claim Split Type field selects how claims should be split regarding their liability in the system, where applicable. Depending on the selection here, there may be multiple rows displayed for each individual claim, based on how the Claim share or Underwriter Split is set up for the corresponding claim. Listed below are the three available selections and a description of each:

    Entire Claim – There will only ever be a single row output for the entire claim. All applicable identifiers will be those applicable to the entire claim and all Reserve figures will be 100% of the value for the entire claim.

     Claim Share Split – There will be a row output for each party set up on the Claim Share screen for the specific claim. Identifiers, such as Client Claim #, may apply differently to different individual parties on the Claim Share. All Reserve figures will consider the percentage of liability, set up under the Claim Share for the applicable party. For example, if two parties are set up on the Claim Share screen as 65% and 35% and there is a Reserve figure of $100 for the entire claim, then there would be two rows output for the claim.   One row would show a $65 Reserve figure and the other would show a $35 Reserve figure.

     Contract/Treaty Syndicate Split – This works similarly to the Claim Share Split, except the split shares are defined on the level of the Contract applied to the claim and not the individual Claim Share itself.

Designer’s Notes: Breakdown of Reserve Figures and Contract/Treaty Syndicate SplitIt is possible to associate specific claims in the system with a specific Contract/Treaty for the particular Client Company to which the claim belongs. Each Contract may be set up with one or more Underwriting Companies that share a percentage of the liability for the Reserves and the associated payments on the claims associated with that Contract/Treaty. For example, let’s suppose that a claim is associated with Contract 2014 under its Client Company: Contract 2014 may be set up to have 70% of the responsibility for the Reserves/Payments to “Megacorp Underwriters” and 30% of the responsibility to “XYZ Company”. When certain selections are made to run the Report Builder – Loss Run or Report Builder – Spreadsheet Bordereau, the claim would be listed twice. The first time under “Megacorp” with each of the Reserve/Payment figures computed at 70% of their total value for the claim and again under “XYZ” with each of the Reserve/Payment figures computed at 30% of their total value for the claim.

Designer’s Note: Contract/Treaty Underwriters Setup and the Contract/Treaty Exception Report

A Contract/Treaty can, in theory, by set up with any number of Underwriters. When setting up the Underwriters for a Contract/Treaty, however, one must be sure to set them up so that the total percentages for the entire Contract are equal to 100%. There is no validation currently in place on the screen on which the Underwriters are configured. We have provided a report to allow any Contractors/Treaties on which the total liability between Underwriters is not equal to 100%. This is in the link labeled Contract/Treaty Exception Report, positioned above the selection criteria on the page for the Report Builder – Lloyd’s Bordereau.

 Lloyd’s MI Reporting

 This report is designed to allow generation of MI metrics for Lloyd’s syndicates.  

1. Click on the Reports tab
2. Click on LLOYD’s MI Reporting (at the bottom of the page)

To find out more details about Lloyd’s MI Reporting click on the blue link at the top of the page in FileTrac labelled “Reporting with Lloyd’s MI Reporting”

To run the report as is, which includes “All” for each category, the only thing you will need to do is select the date range and select the format for the report. See the illustration below:

3. Select the Start Date and End Date

4. Select Report Format

5. Click on View Report

To customize the report follow the instructions below:

1. Click on a Client Company. In making a selection, the “All Values” will no longer be selected and the report will only pull information for the companies that are added to the “Selected Values” field (steps 2 and 3, below).
2. Click on the Add button
3. The selection will be shown in the Selected Values field for Client Company
4. Use the same method to make selections for the Syndicate by clicking on a Syndicate name
5. Click the Add button
6. The selection will be shown in the Selected Values field for Syndicate
7. Click on the calendar to select the Start Date. This field defines the beginning of the “Reporting Period” on which the report is run.
8. Click on the calendar to select the End Date.  This field defines the end of the “Reporting Period” on which the report is run.
9. Click the dropdown field for Claim Split Type to select how claims should be split regarding their liability in the system, where applicable. Depending on the selection here there may be multiple rows displayed for each individual claim, based on how the Claim Share or Underwriter Split is set up for the corresponding claim. See more information in the section above for Claim Split Types.
10. Select the Format for your report by clicking on the corresponding radio button.
11. Click the View Report tab
12. To save these filters so that the same report can be run again later, click Save Report at the top right corner of the page. Once a report is saved here you can click the Load Saved Report to run it again when the time comes.