Overview

This document is created to assist TPA’s with the entire process within FileTrac and explain some recent changes that have taken place system wide. We will walk through the steps to accomplish everything from setting up authority levels for their users, entering Client Companies and Contracts, setting up Claim Shares, creating a Reserve Account which mirrors the bank account, setting Reserves, entering payments and/or recovery amounts, printing checks and voiding checks.

Steps Involved:

Enter Contract Information in the Client Company.
Creating/Verifying Reserve Types on the Settings page.
Create a Reserve Account.
Include the Contract # on each Claim.
Setup the Claim Shares for each claim.
Set Reserves and Recovery for each claim.
Enter Payments and/or Recoveries.
Run the Exception Report.
Run the Bordereaux Report.

Recent Changes

If you are an existing FileTrac customer using the TPA module you will notice some changes that have taken place. Now that the new Strict TPA rules have been implemented you will no longer have the ability to back date payment entries and checks. You will notice that the date will auto populate with today’s date rather than allowing you to enter a date in this field. You will also only be allowed to make a change to a reserve for the previous month’s record within the first 15 days of the new month; and you will only be allowed to make one change.

All reserve changes made within the first 15 days of the following month will be reflected on 11:58pm on the last day of the prior month. You will also be able to enter payments for the previous month only within the first 15 days of the following month. These payments will be reflected on 11:59pm on the last day of the prior month. There is no restriction to the number of payments that can be added to the previous monthly only that it must be done within the first 15 days.

We have also added the ability to “Close Out” the month. Once the Bordereaux has been closed the system will no longer allow changes to the prior month’s reserves or payments even if it is still within the 15 day window. This is done by selecting the Client Company name from the Companies page. You can either manually closed out the month or once the 15-day window expires for the month it will automatically close. To close it manually before the 15-day window ends click on the CLOSE Month Year BDX link.

You will then see the pop-up warning reminding you that once you close out the month you will not be able to enter reserves or payments for that month.

Once the month has been closed out you will notice the information on the tab changes to show the month and year of the closed Bordereaux and the name of the person that closed the reporting period as shown below.

Entering Contracts

It’s important to make sure the contract details are correctly entered under the correct Client Company and that the dates are correct. FileTrac will alert the user anytime a file is created where either the Policy Start Date or the Date of Loss are not in line with the dates of the contract. The system will allow the claim to be created but will give you a pop-up box as a notification.

To enter the Contract, follow the instructions below

Open the list of client companies by clicking on the Companies tab.
Click on the name of the Company that the contract needs to be added to.

3. Click on Contracts.

4. Click on New Contract.

5. Enter the contract details in each field. Selecting a Default Branch for the contract will allow for this contract to be selected on your claims. This will not automatically populate but will be listed in the drop-down box on the Edit Claim page.

Setting Reserve and Recovery Types

When your system is initially setup by FileTrac there will be some default Reserve Types populated in your system. You may need to add to the types of reserves in your system if required by your client. To enter additional Reserve Types in your system, go to the Settings Page and click on Reserve Types to jump to this section.

The screenshot below represents some common reserves. It is important to keep in mind that the reserve name and the category for the reserve must be accurate for the reports to populate correctly. Reserve types must be set in this section to be available for use within a claim.

How to Add Reserve Types

Adding Reserve Types is done on the Settings page under the Reserve Type section.

Check the box adjacent to the blank field, and type in the Reserve Type.
Select the Category by clicking the drop-down and select either Expense or Indemnity.
Click Add/Save Changes.

Continue adding and saving each type of Reserve until all have been added.

How to Add Recovery Types

Adding Recovery Types is done on the Settings page under the Recovery Type section.

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 list.

You can change the order of either the Reserves or the Recovery Types by selecting Move Up/Move Down.

User Authority Levels

The FileTrac default for Authority Levels is set at unlimited. An Admin User will need to go into the user’s profile and adjust the limits for each user. Authority can be limited for Aggregate Indemnities, Aggregate Expenses, Reserves and Payments. If there is no value typed in a field, then the user has no limits set. A blank field = no limit; however, a payment cannot be entered that is greater than the Reserve Amount that is set.

How to set the Authority Limits for a User

Click on Personnel Manager from the main screen in FileTrac.
Locate the User and click on their Name.
Click on User Authority Setup near the top of the page.
In the appropriate column type in the Users Amount of Authority.
Once you have finished entering the fields click Update User Authority.

Entering Contracts and Claim Shares in Claims

It’s important to remember that the contracts will not automatically populate on the claim. This information can be added at the time the claim is created or can be added or changed in the Edit Claim page under the Primary Insured’s Information section.

To navigate to the Edit Claim page

Click on Manage Claims
Locate the correct File # in the list or use the search to locate the correct file and click on the File #. Clicking on the blue file # opens the Edit Claim page where you can then add the contract/treaty.

Claim Shares can only be added once the claim has been created. The system will not allow you to create claim shares that do not equal 100%. If you are receiving an error, please verify that the shares equal 100.

To enter the claim share

First click on Claim Shares from the Edit Claims page.

The Client Company will default as the first on the contract/treat at 100%. As you begin adding other companies in the claim share you will notice that the % of share will accordingly.

How to enter additional companies that share in this claim

Check the “Add New Claim Share” box
Select the Company Name
Select the Contact
Enter the Client Claim #
Select the Contract/Treaty
Enter the Policy #
Enter the share % this company is responsible for
Click Save Claim Share

Continue repeating the above steps until all have been entered.

Deductibles

Deductibles are only stored in the claim edit page under the coverage information section. This feeds to the financials screen for the deductible. This is the only place the deductible can be created. To enter the deductible in a claim, follow the instructions below:

From the main screen in FileTrac click on Manage Claims
Scroll down to the Coverage Information Section
Enter the amount of the deductible
Scroll to the bottom of the page and Save the changes

Setting Reserves & Entering Payments

The Financials section is where you will be able to set Reserves, Make Payments, Void Payments, and access the Check Manager section. Managing payments should be done through the Reserves and Payment section rather than the Check Manager section. A Payment is money going out and a Recovery is money coming in. There are two levels of payments on a claim. The initial payment takes into consideration the deductible.

This is the reason, if you are going to void a payment, the pop up asks the question if you want to take into consideration the deductible. The second level authentication is because you are not only affecting the payment but also the reserves when you void the check.

Click on Manage Claims
Click on the $ symbol next to the corresponding File #

From the Financials page you can Set Reserves, Make Payments, enter Recovery Amounts and utilize the Check Manager. (See more information on Check Manager later in this document.)

How to set Reserves

Click the dropdown to choose from the list of Contacts on a claim. (All Contacts on a claim will appear in the drop-down list. This allows you to create separate reserves for each contact.)
Click the drop-down and select the Reserve Type. (The Reserve Types are pulled from those that were entered on the Settings page. For additional instructions on setting up the Reserve Types scroll to the section named Creating Reserve Types in Settings.)
Enter the Incurred Amount of the Reserve. (This would be the expected or approved maximum amount. Payments entered that exceed this amount will not be allowed and the Reserve Amount would need to be reset.)
Click on Submit Reserve Changes.

Once a reserve is entered you can now enter payments.

How to enter a Payment

Click on Payments under Make Payment in the “Set Reserves” section.

2. Today’s date will auto populate in the Payment Date field.

3. Enter the Amount to be issued. If you are entering a “Cash Call” select the Cash Call check box.

4. Select who the payment is Payable to.

5. Include the Invoice # if you have one. (This is not a mandatory field.)

6. Include the Tax ID if needed. (This is not a mandatory field.

7. Include the Check #, otherwise *PENDING* will appear on the payment log or “AUTO” will appear if the account is setup to automatically generate the next check #.

8. You may include a Memo to describe what is included in this payment.

9. Check mark “Apply Payment to Deductible” if applicable this payment should be applied to the deductible and mark Generate Check if you would like to generate the check from the system.

10. Click Submit Payment

The payment will show in the payment history section once it has been submitted.

If a check is written and the check # was not available at the time of entering the log, then you will need to go into the Check Manager to enter that Check # later. This document will walk through these steps later in the Check Manager section below.

How to Print checks:

Checks can be printed from the Financial Payment history screen. Once the payment has been entered you will then choose either Print or Generate from the Actions column next to the corresponding entry. In the scenario sample below this account has been setup to populate the Check # at the time the check is generated. If you do not want to auto generate the check # and need to manually enter the number this can be accomplished, but for the purpose of this scenario the check # will auto populate. (For more information on Reserve Account settings see the section for Creating Reserve Accounts in this document.)

Payment #1 - When entering the payment if you marked to Generate the Check the entry will display with the check # which was the next in the sequence (or it will display the check # that was manually entered) and the Actions columns will give you the option to Print the check.

Payment #2 - If you did not mark to Generate the Check upon entering the payment the entry will display and the check # will BE shown as *AUTO* if the system is numbering the checks or the check # that was manually entered will be displayed and you will have the option under Actions to Generate or Void the check.

The ability to Void an entry from this page is only allowed if the check has not yet been generated.

To void a payment where a check has already been generated this would need to be accomplished from the Check Manager screen and the check would be voided rather than the entry. A sample of a voided check is shown in the first row of the screenshot below. Notice the Actions Column shows Voided and the history shows when the check was voided. (See more on voiding checks below.)

To Generate the check

Click Generate.
Select the correct Account from the drop-down.
Click the Generate button

Voiding Payment Entries & Checks

A payment entry can only be voided if a check has not yet been generated.

How to Void a Payment Entry or a Check

Click on Payments for the Reserve Type where the payment that you want to void exists.

2. If the check has not yet been generated, you may void the payment by clicking on Void. If the check has been generated Void will be grayed out and you will not be able to void the entry from this page. Skip to Step 3 to void a check.

Two pop ups will appear. See the two screenshots below. The first, “Does this Payment also need to be VOIDED under the Deductible?” If you want it to apply to the deductible Click OK. If you do not want it to apply to the deductible click Cancel.

The second pop up, “We have auto-filled the data entry area above with the information for your VOID. Please review and click Submit Payment to save the VOID entry!” This is letting you know that the information has been auto filled based on the information from the selected payment to be voided.

It is prompting you to double check your work to make sure you do in fact want to void this payment because this will affect the financials for the claim. Click OK.

3. If the Check # has been generated click on Check Manager

4. Click Void for the correct Check #.

The system will maintain a record in the Checkbook Register of the original entry and the voided entry.

Creating a Reserve Checking Account

To access the page to setup a Reserve Checking Account you will need to click the link from the Settings page. The Reserve Checking Account creates a mirror image of your actual account but does not link to a live bank account. Payments made in the financial reserves section of a claim will be reflected in your FileTrac Reserve Checking Account. From within the Reserve Checking Account, you can set the beginning check number, records deposits, adjustments, record money transfers to this account, and record money transfers from this account.

How to set up your Reserve Checking Accounts

Click on Settings.
Click on Reserve Checking Accounts.
From within the Reserve Checking Accounts Section, Click Here to Configure the accounts.

4. Check Add New Account.

5. Enter the Company Name.

6. Enter the Bank Name.

7. Enter the Routing #.

8. Enter the Account #.

9. Enter the Address.

10. Include any pertinent info in the Notes section.

11. Click Save Changes at the bottom of the page.

Once the account has been added you will now see where you can enter the first Check # if you would like the system to begin numbering the checks. You can also leave this unchecked and manually enter the check numbers. You will also notice the link to enter Deposits and Adjustments.

To enter a Deposit, Adjustment or Transfer to or from this reserve account, follow the instructions below:

Click on Settings.
Click on Reserve Checking Accounts.

3. Click Here to Configure.

4. Locate the correct account in the Manage Accounts page and click on Deposits & Adjustments.

5. Click on the Calendar to select the date.

6. Select the Type of Adjustment from the drop-down (Deposit, Adjustment, Transfer TO this Account or Transfer FROM this Account).

7. Enter the Amount.

8. Enter a Note (not a mandatory field).

9. Click Save.

The adjustment will appear in the list of saved adjustments and can be marked Reconciled. Once the entry has been reconciled the check box will be replaced with the date it was reconciled.

To Reconcile an adjustment, follow the steps below

Check the box in the Reconcile column of the adjustment that is being reconciled.
Click Save Reconciled Transactions.

Check Manager

The Check Manager is found in the Financials section of a claim and exists for the purpose of printing checks and recording Check #’s. This information feeds directly into the Reserve Checking Account. Currently, Check Manager does not connect to a live bank account but will link to the Reserve Account setup in FileTrac. The Check Manager section is strictly a place that you can manage your finances from within FileTrac, enter a check # if it was unavailable at the time the payment entry was entered and print checks.

If a payment is entered and the check number is not available at the time of the entry, the check number will need to be entered after that information is received some time later. The instructions below are to add a check number sometime after the original entry. In this example the payment has already been created and is only missing the check number.

Click on Manage Claims.
Click on the $ symbol next to the corresponding File #.

3. Click on Check Manager.

4. Notice the date will auto populate with today’s date and cannot be changed.

5. Choose the correct Account from the drop-down.

6. Enter the Check #.

7. Choose the Payment or combine payments by choosing more than one.

8. Select the Payee

9. If the check is being mailed and an Address is in the file you will have the option to select the Addressee next to the Payee’s name.

10. Verify the Check Amount.

11. Click Save Check.

The Checkbook Register screen will pop up and you will see the check listed. You can now click the Printer Icon to print the check or if a mistake was made you have the option to Void the check.

The Lloyd’s Bordereaux Report

As a TPA Client the Lloyd’s Bordereaux Report is found in your list of reports in the Custom Report Builder section of the Reports page.

Above the field selection box you will notice two blue links, one for TPA Reporting with Report Builder – LLOYD’S Bordereaux and Contract/Treaty Exception Report. It’s important to run the Contract/Treaty Exception Report prior to running the Lloyd’s Bordereaux and clear any exceptions prior to running the Lloyd’s Bordereaux.

How to run the Contract/Treaty Exception Report

Click the blue link Contract/Treaty Exception Report.

The above screenshot provides details provided by the exception report and will list any records not equaling 100%. All incorrect entries need to be corrected and the exception report should be rerun until no exceptions are shown on the report as depicted in the screenshot above.

It’s important to understand the fields for the Lloyd’s Bordereaux report, where this data is pulled from. The TPA Reporting with Report Builder – LLOYD’s Bordereaux details can be accessed directly from within FileTrac as shown below.

Data Fields for Lloyd’s BDX:

Bordereau Column	Populates from
% Ceded	This is pulled from the % Ceded field on the New Claim / Edit Claim screen.
Agreement No.	This field populated differently depending on what selection is made from the Claim Split Type drop-down. When Claim Share Split is selected, this field will pull first from the Agreement # field, of the Contract / Treaty associated with the individual row of the Claim Share on the given Claim. If the Agreement # field is not populated, the Contract UMR value will be used instead. When the other options are chosen, this field will pull from the Agreement # field of the Contract / Treaty associated with the Claim on the New Claim and/or Edit Claim screen. If the Agreement # field is not populated, the Contract UMR value will be used instead. Further, if the Contract UMR field is not populated with the associated Contract / Treaty, the Contract Code value will be used instead.
Amount Claimed	This is pulled from the Amount of Claim field on the New Claim / Edit Claim screen.
Assigned Adjuster	This is pulled from the Assign Adjuster drop-down on the New Claim / Edit Claim screen.
Assigned Manager	This is pulled from the Assign Manager drop-down on the New Claim / Edit Claim screen.
Assigned Supervisor	This is pulled from the Assign Supervisor drop-down on the New Claim / Edit Claim screen.
Auto Coverage	This is pulled from the Auto Coverage field under the Automotive Information section of the New Claim / Edit Claim screen.
Auto Damages	This is pulled from the Auto Damages field under the Automotive Information section of the New Claim / Edit Claim screen.
Auto Make	This is pulled from the Auto Make field under the Automotive Information section of the New Claim / Edit Claim screen.
Auto Model	This is pulled from the Auto Model field under the Automotive Information section of the New Claim / Edit Claim screen.
Auto VIN	This is pulled from the Auto VIN field under the Automotive Information section of the New Claim / Edit Claim screen.
Auto Year	This is pulled from the Auto Year field under the Automotive Information section of the New Claim / Edit Claim screen.
Bordereau Month	This is the month of the Report Period End Date parameter selection.
Bordereau Year	This is the four-digit year of the Report Period End Date parameter selection.
CAT Name	This is derived from the CAT Code field on the New Claim / Edit Claim screen. If the CAT Code value includes a dash (“-”), this column will populate everything following the dash. If there is no dash, this column will be empty.
Cause of Loss Code	This is pulled from the Claim Cause Code field on the New Claim / Edit Claim screen.
Certificate Reference	This is pulled from the Policy # field on the New Claim / Edit Claim screen.
Certificate Reference 2	This is pulled from the Alt Policy # field on the New Claim / Edit Claim screen.
Change this Month Fees	This is the change in the Incurred Amount of any Reserve lines with the Reserve Types configured as Expense. The changes are those which occur during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Changes taken into account include new Reserve entries added, new Reserve Payments made, and changes to existing Reserve entries.
Claim First Notification Acknowledgement Date	This is derived based on the Report Date of the “Initial Acknowledgement Letter” Report under the Claim.
Claim Not Paid as Within Excess	This is pulled from the Claim Not Paid as Within Excess checkbox on the New Claim / Edit Claim screen.
Claim Reference	This is pulled from the File # field on the New Claim / Edit Claim screen.
Claim Reference 2	This is pulled from the Secondary File # field on the New Claim / Edit Claim screen.
Claim Status	This is pulled from the Status of the Claim as displayed on the Edit Claim and Manage Claim screens in the system.
Claim Status Open/Closed (period start)	This is based on data recorded in the background of the system when creating, closing, and reopening a Claim. The Report Period Start Date and “As Of” Date parameter selections are then taken into account, using this data to derive the final output for this column in the report. Possible output values are “Open” and “Closed”. If the Claim was first created during the reporting period, this column will output “Reported in Period”.
Claim Status Open/Closed (period end)	This is based on data recorded in the background of the system when creating, closing, and re-opening a Claim. The Report Period End Date and “As Of” Date parameter selections are then taken into account, using this data to derive the final output for this column in the report. Possible output values are “Open” and “Closed”.
Claimant Address	Pulls directly from Claimant Address (line 1) on New Claim / Edit Claim screen.
Claimant Address FULL	Pulls directly from the Claimant Address (line 1), Claimant City, Claimant State, and Claimant ZIP fields on the New Claim / Edit Claim screen.
Claimant Country	Pulls directly from Claimant Country on New Claim / Edit Claim screen. If blank, this will default to “USA” on the report.
Claimant Name	If populated, this pulls from the Claimant Company field on the New Claim / Edit Claim screen, otherwise it pulls from the Claimant First Name and Claimant Last Name fields.
Claimant Postcode	Pulls directly from Claimant ZIP on New Claim / Edit Claim screen.
Class of Business	This is pulled from the Policy Type field on the New Claim / Edit Claim screen.
Client Claim Reference	This field populated differently depending on what selection is made from the Claim Split Type drop-down. When Claim Share Split is selected, this field will pull first from the Client Claim # field of the individual row of the Claim Share on the given Claim. When the other options are chosen, this field will pull from the Client Claim # field on the New Claim and/or Edit Claim screen.
Complaint (Y/N)	This is populated based on whether there are any Complaint records saved on the Notes screen for the corresponding Claim, s of the “As Of” Date parameter selection set when running the report.
Construction Type	Pulls directly from Construction Type drop-down on New Claim / Edit Claim screen.
Contract Expiry	This field populated differently depending on what selection is made from the Claim Split Type drop-down. When Claim Share Split is selected, this field will pull from the Contract End Date field of the Contract / Treaty associated with the individual row of the Claim Share on the given Claim. When the other options are chosen, this field will pull from the Contract End Date field of the Contract / Treaty associated with the Claim on the New Claim and/or Edit Claim screen.
Contract Inception	This field populated differently depending on what selection is made from the Claim Split Type drop-down. When Claim Share Split is selected, this field will pull from the Contract Start Date field of the Contract / Treaty associated with the individual row of the Claim Share on the given Claim. When the other options are chosen, this field will pull from the Contract Start Date field of the Contract / Treaty associated with the Claim on the New Claim and/or Edit Claim screen.
Country of Treatment	Set to “---”
Coverholder Name	This field populated differently depending on what selection is made from the Claim Split Type drop-down. When Claim Share Split is selected, this field will pull first from the Client Company selected in the Contract Coverholder field, of the Contract / Treaty associated with the individual row of the Claim Share on the given Claim. If the Contract Coverholder field is not populated, the Client Company value selected will be used instead. When the other options are chosen, this field will pull from the Client Company selected in the Contract Coverholder field of the Contract / Treaty associated with the Claim on the New Claim and/or Edit Claim screen. If the Contract Coverholder field is not populated, the Client Company value will be used instead. This is populated from the Company Code field for the associated Client Company record. If the Company Code field is blank, the Company Name will be output in its place.
Coverholder PIN	This field populated differently depending on what selection is made from the Claim Split Type drop-down. When Claim Share Split is selected, this field will pull first from the Coverholder PIN field, of the Contract / Treaty associated with the individual row of the Claim Share on the given Claim. When the other options are chosen, this field will pull from the Coverholder PIN field of the Contract / Treaty associated with the Claim on the New Claim and/or Edit Claim screen.
Date Claim Amount Agreed	This is derived based on the Report Date of the “Proof of Loss” Report and/or the “Settlement Agreement” Report under the Claim.
Date Claim Denied	Pulls directly from the Date of Denial on New Claim / Edit Claim screen. It should be noted that this field will only be available when the Claim Denied checkbox is checked, indicating the denial of the Claim.
Date Claim Made	Pulls directly from Date of Received on New Claim / Edit Claim screen.
Date Claim Withdrawn	Pulls directly from date field corresponding to Claim Withdrawn on New Claim / Edit Claim screen.
Date Claims Paid	This is based on any Reserve Payments under any Reserve Types configured as Indemnity dated during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. This date will be the date of the newest Reserve Payment entry to fit the criteria outlined.
Date Closed	If the Claim Status is closed, this report column is populated with the date closed as set in the system.
Date Coverage Confirmed	Pulls directly from Date Policy Confirmed on New Claim / Edit Claim screen.
Date Fees Paid	This is based on any Reserve Payments under any Reserve Types configured as Expense dated during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. This date will be the date of the newest Reserve Payment entry to fit the criteria outlined.
Date First Reserve Established	This metric is calculated based on the first Reserve line set on the Claim. This is derived from the Reserve lines under each specific Claim. When new Reserve lines are added to each Claim, the system automatically date-stamps these Reserves in the background, recording exactly when each Reserve is set. This metric is calculated based on the date the first Reserve line is set on each Claim. When this date is within the selected reporting period, the average difference between this date and the Claim Date Received on the Edit Claims screen is returned.
Date of First Contact	Pulls directly from Date of First Contact on New Claim / Edit Claim screen.
Date of Inspection	Pulls directly from Date of Inspection on New Claim / Edit Claim screen.
Date of Loss (from)	Pulls directly from Date of Loss on New Claim / Edit Claim screen.
Date of Loss (to)	Pulls directly from Date of Loss on New Claim / Edit Claim screen.
Date of Reservation of Rights	Pulls directly from the Date of Reservation of Rights on New Claim / Edit Claim screen. This is located next to the Reservation of Rights checkbox on the New Claim / Edit Claim screen.
Date of Subrogation	Pulls directly from Date of Subrogation on New Claim / Edit Claim screen. This is located next to the Subrogation Possibility checkbox on the New Claim / Edit Claim screen.
Date of Treatment	Set to “---”
Date Reopened	This is based on data recorded in the background of the system when creating, closing, and re-opening a Claim. The Report Period Start Date, Report Period End Date, and “As Of” Date parameter selections are then taken into account, using this data to derive the final output for this column in the report.
Deductible Amount	Pulls directly from Deductible on under the Coverage Information section of the New Claim / Edit Claim screen.
Deductible Basis	If the Deductible Basis field is visible and/or available in the Coverage Information section of the New Claim / Edit Claim screen, the report will pull information from it.
Denial	If the Claim Denied checkbox is available on the New Claim / Edit Claim screen, and it is checked this field will be set to “Y”, otherwise it will be set to “N”.
Diary Date	If the claim record is NOT “Closed” this will return the Date Due as displayed on the Manage Claims screen. For “Closed” claim records, this will be left blank.
Driver Company	If there are any Contacts under the Claim with the Contact Type of “Driver”, this will list the Contact Company of the first “Driver” listed on the Claim. The Contact who is marked as the Primary with the Contact Type of “Driver” is considered the “first”. If there are “Driver” Contacts, but none are marked as Primary, the first of them entered into the system will be used as the “first”.
Driver Description	If there are any Contacts under the Claim with the Contact Type of “Driver”, this will list the Contact Description of the first “Driver” listed on the Claim. The Contact who is marked as the Primary with the Contact Type of “Driver” is considered the “first”. If there are “Driver” Contacts, but none are marked as Primary, the first of them entered into the system will be used as the “first”.
Driver First Name	If there are any Contacts under the Claim with the Contact Type of “Driver”, this will list the Contact First Name of the first “Driver” listed on the Claim. The Contact who is marked as the Primary with the Contact Type of “Driver” is considered the “first”. If there are “Driver” Contacts, but none are marked as Primary, the first of them entered into the system will be used as the “first”.
Driver Last Name	If there are any Contacts under the Claim with the Contact Type of “Driver”, this will list the Contact Last Name of the first “Driver” listed on the Claim. The Contact who is marked as the Primary with the Contact Type of “Driver” is considered the “first”. If there are “Driver” Contacts, but none are marked as Primary, the first of them entered into the system will be used as the “first”.
Ex Gratia Payment	There is a checkbox available to on the Reserve Payment screen for Reserve lines of any Reserve Type configured as Indemnity. This checkbox designates that Reserve Payment as an “Ex Gratia Payment”. If there are any Indemnity Reserve Payment entries for a given Claim dated on or before the “As Of” Date parameter selection of the report criteria, the Ex Gratia Payment column will output “Y” for that Claim record. Otherwise, the Ex Gratia Payment column will output “N”.
Expert Address	Address (line 1) for the “Expert” record in the Claim Contacts area for the given Claim. See Designer’s Note below.
Expert Country	Country for the “Expert” record in the Claim Contacts area for the given Claim. See Designer’s Note below. Note that if this field is left blank in the system, it will default to “USA”.
Expert Firm / Company	Company, if populated, for the “Expert” recond in the Claim Contacts area for the given Claim. See Designer’s Note below. If the Company is not populated, the field will default to the Last Name, then First Name of the Claim Contact.
Expert Notes	Reserve Payment Note field for the last Reserve Payment made to the “Expert” in the system. See Designer’s Note below.
Expert Postcode / ZIP	ZIP for the “Expert” record in the Claim Contacts area for the given Claim. See Designer’s Note below.
Expert Reference No	Contact Code for the “Expert” record in the Claim Contacts area for the given Claim. See Designer’s Note below.
Expert Role	Contact Type for the “Expert” record in the Claim Contacts area for the given Claim. See Designer’s Note below.
Expert State	State for the “Expert” record in the Claim Contacts area for the given Claim. See Designer’s Note below.
Insured Address	Pulls directly from Insured Address (line 1) on New Claim / Edit Claim screen.
Insured Address - FULL	Pulls directly from the Insured Address (line 1), Insured City, Insured State, and Insured ZIP fields on the New Claim / Edit Claim screen.
Insured City	Pulls directly from Insured City on New Claim / Edit Claim screen.
Insured Country	Pulls directly from Insured Country on New Claim / Edit Claim screen. If blank, this will default to “USA” on the report.
Insured Name	If populated, this pulls from the Insured Company field on the New Claim / Edit Claim screen, otherwise it pulls from the Insured Last Name field.
Insured Postcode / ZIP Code	Pulls directly from Insured ZIP on New Claim / Edit Claim screen.
Insured State	Pulls directly from Insured State on New Claim / Edit Claim screen.
ISO Code	This is pulled from the ISO Code field on the New Claim / Edit Claim screen.
Line of Business Code	This is pulled from the Statutory LOB Code field on the New Claim / Edit Claim screen.
Litigation (Y/N)	This is pulled from the In Litigation? Checkbox on the New Claim / Edit Claim screen. If checked, this is populated with “Y”; otherwise “N”.
Lloyd’s CAT Code	This is derived from the CAT Code field on the New Claim / Edit Claim screen. If the CAT Code value includes a dash (“-”), this column will populate everything previous to the dash. If there is no dash, this column will populate with the entire CAT Code value.
Lloyd's Risk Code	Pulls the value selected in the RISK Code drop-down on the New Claim / Edit Claim screen.
Loss City	Pulls directly from the City field under the Loss Location section of the New Claim / Edit Claim screen.
Loss Country	Pulls directly from Country field under the Loss Location section of New Claim / Edit Claim screen. If blank, this will default to “USA” on the report.
Loss County	If the County field is available under the Loss Location section of the New Claim / Edit Claim screen, the report will pull directly from it to populate this column.
Loss Description	Pulls directly from Loss Description on New Claim / Edit Claim screen.
Loss Location Address	Pulls directly from the Street Address field under the Loss Location section on the New Claim / Edit Claim screen.
Loss Location Address - FULL	Pulls directly from the Street Address, City, State, and ZIP fields under the Loss Location section on the New Claim / Edit Claim screen.
Loss Location Postcode / ZIP Code	Pulls directly from the ZIP field under the Loss Location section on the New Claim / Edit Claim screen.
Loss State	Pulls directly from the State field under the Loss Location section on the New Claim / Edit Claim screen.
Loss Type	Pulls directly from Loss Type on New Claim / Edit Claim screen.
Loss Unit	Pulls directly from Loss Unit on New Claim / Edit Claim screen.
Medical Plan	Set to “---”
Medicare Conditional Payments	On the Contact Edit screen for the Primary Claimant on the Claim, there is a field labelled Medicare Conditional Payment, from which this report field is populated.
Medicare Eligibility Check Performance	On the Contact Edit screen for the Primary Claimant on the Claim, there is a set of option button labelled Medicare Eligibility Check. The “Y” and “N” carry through from these option buttons.
Medicare MSP Compliance Services	On the Contact Edit screen for the Primary Claimant on the Claim, there is a set of option button labelled Medicare Compliance Svc. The “Y” and “N” carry through from these option buttons.
Medicare Outcome of Eligibility Status Check	On the Contact Edit screen for the Primary Claimant on the Claim, there is a checkbox labelled Medicare Eligibility. When this checkbox is checked, this field displays “Y”, otherwise the field displays “U”.
Medicare United States Bodily Injury	If there are any Reserves on the Claim set that are of the Reserve Type “Bodily Injury”, this field displays as “Y”, otherwise, “N”.
Name / No of Vehicle	Set to “---”
Notification Date	Pulls directly from the Date Received field on the New Claim / Edit Claim screen.
Occupancy	Pulls directly from Occupancy on New Claim / Edit Claim screen.
Original Currency	Set to “USD”.
Paid Previously - Adjusters Fees	This is the total amount of Reserve Payments under the “Adjusters Fees” Reserve Type dated before the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid Previously - Attorney Coverage Fees	This is the total amount of Reserve Payments under the “Attorney Coverage Fees” Reserve Type dated before the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid Previously - Defense Fees	This is the total amount of Reserve Payments under the “Defense Fees” Reserve Type dated before the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid Previously - Expenses	This is the total amount of Reserve Payments under any Reserve Types configured as Expense dated before the reporting period, except for the following Reserve Types: “Adjusters Fees” “Attorney Coverage Fees” “Defense Fees” “TPA Fees” As with other fields, the reporting period is defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid Previously - Fees	This is the total amount of Reserve Payments under any Reserve Types configured as Expense dated before the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid Previously - Indemnity	This is the total amount of Reserve Payments under any Reserve Types configured as Indemnity dated before the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid Previously - TOTAL	This is the total amount of Reserve Payments under ALL Reserve lines dated before the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid Previously - TPA Fees	This is the total amount of Reserve Payments under the “TPA Fees” Reserve Type dated before the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - Adjusters Fees	This is the total amount of Reserve Payments under the “Adjusters Fees” Reserve Type during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - Attorney Coverage Fees	This is the total amount of Reserve Payments under the “Attorney Coverage Fees” Reserve Type during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - CASH CALL	This is the total amount of those Reserve Payments marked as “Cash Call”, under ALL Reserve Types, during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - Defense Fees	This is the total amount of Reserve Payments under the “Defense Fees” Reserve Type during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - Expenses	This is the total amount of Reserve Payments under any Reserve Types configured as Expense during the reporting period, except for the following Reserve Types: “Adjusters Fees” “Attorney Coverage Fees” “Defense Fees” “TPA Fees” As with other fields, the reporting period is defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - Fees	This is the total amount of Reserve Payments under any Reserve Types configured as Expense during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - Indemnity	This is the total amount of Reserve Payments under any Reserve Types configured as Indemnity during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - TOTAL	This is the total amount of Reserve Payments under ALL Reserve lines of the Claim during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid This Month - TPA Fees	This is the total amount of Reserve Payments under the “TPA Fees” Reserve Type during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid to Date - Adjusters Fees	This is the total amount of Reserve Payments under the “Adjusters Fees” Reserve Type both during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid to Date - Attorney Coverage Fees	This is the total amount of Reserve Payments under the “Attorney Coverage Fees” Reserve Type both during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid to Date - Defense Fees	This is the total amount of Reserve Payments under the “Defense Fees” Reserve Type both during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid to Date - Expenses	This is the total amount of Reserve Payments under any Reserve Types configured as Expense dated during and prior to the reporting period, except for the following Reserve Types: “Adjusters Fees” “Attorney Coverage Fees” “Defense Fees” “TPA Fees” As with other fields, the reporting period is defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid to Date - Fees	This is the total amount of Reserve Payments under any Reserve Types configured as Expense both during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid to Date - Indemnity	This is the total amount of Reserve Payments under any Reserve Types configured as Indemnity both during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid to Date - TOTAL	This is the total amount of Reserve Payments under ALL Reserve lines of the Claim both during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Paid to Date - TPA Fees	This is the total amount of Reserve Payments under the “TPA Fees” Reserve Type both during and prior to the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Patient Name	Set to “---”
PCS Code	If the PCS Code field is available on the New Claim / Edit Claim screen, the report will pull directly from it to populate this column.
Peer Review Date	This metric is based on the whether the Claim is marked as having been “Peer Reviewed”. In order to mark a Claim as “Peer Reviewed”, use the checkbox on the Diary Notes screen when saving a relevant Note in the Claim. The date of the note input when recording the “Peer Review” will be saved as the date of the “Peer Review” itself. If a Claim has more than one date for Peer Review, the most recent will be used as long as it is before the Report Period End Date and “As Of” Date parameter selections.
Policy Form	If the Policy Form field is available on the New Claim / Edit Claim screen, the report will pull directly from it to populate this column. Note the Policy Form field may alternatively be labelled as Loss Form Written Under. Also note that, if the field is configured as a drop-down, only the “code” portion of the information shown in the drop-down selections will populate into the Policy Form column output onto the report..
Policy or Group Ref	This populates directly from the Policy # on the New Claim / Edit Claim screens.
Prior Incurred - 3 Months	This output field will only populate for those Claim records that are reported as having Closed during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. In other cases, the field will be blank. When populated with a value, this is the historical Total Incurred amount for the Claim as derived from recorded data for 3 months prior to the selected “As Of” Date parameter selection when running the report. For further detail on the Total Incurred, please see the details about the Total Incurred output column.
Prior Incurred - 6 Months	This output field will only populate for those Claim records that are reported as having Closed during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. In other cases, the field will be blank. When populated with a value, this is the historical Total Incurred amount for the Claim as derived from recorded data for 6 months prior to the selected “As Of” Date parameter selection when running the report. For further detail on the Total Incurred, please see the details about the Total Incurred output column.
Prior Incurred - 12 Months	This output field will only populate for those Claim records that are reported as having Closed during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. In other cases, the field will be blank. When populated with a value, this is the historical Total Incurred amount for the Claim as derived from recorded data for 12 months prior to the selected “As Of” Date parameter selection when running the report. For further detail on the Total Incurred, please see the details about the Total Incurred output column.
Prior Incurred - 24 Months	This output field will only populate for those Claim records that are reported as having Closed during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. In other cases, the field will be blank. When populated with a value, this is the historical Total Incurred amount for the Claim as derived from recorded data for 24 months prior to the selected “As Of” Date parameter selection when running the report. For further detail on the Total Incurred, please see the details about the Total Incurred output column.
Rate of Exchange	Set to “---”
Recovery this Month - Adjusters	This is the total amount of Recovery entries, regardless of
Fees	Recovery Type, under any Reserve lines of the Claim of the under the “Adjusters Fees” Reserve Type during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery this Month - Attorney Coverage Fees	This is the total amount of Recovery entries, regardless of Recovery Type, under any Reserve lines of the Claim of the under the “Attorney Coverage Fees” Reserve Type during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery This Month - Deductible	This is the total amount of Recovery entries, with a Recovery Type beginning with “Deductible”, under ALL Reserve lines of the Claim during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery this Month - Defense Fees	This is the total amount of Recovery entries, regardless of Recovery Type, under any Reserve lines of the Claim of the under the “Defense Fees” Reserve Type during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery this Month - Indemnity	This is the total amount of Recovery entries, regardless of Recovery Type, under any Reserve lines of the Claim of the under any Reserve Types configured as Indemnity during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery this Month - TPA Fees	This is the total amount of Recovery entries, regardless of Recovery Type, under any Reserve lines of the Claim of the under the “TPA Fees” Reserve Type during the reporting period, as defined in the Report Period Start Date and report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery This Month - Salvage	This is the total amount of Recovery entries, with a Recovery Type beginning with “Salvage”, under ALL Reserve lines of the Claim during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery This Month - Subro	This is the total amount of Recovery entries, with a Recovery Type beginning with “Subrogation”, under ALL Reserve lines of the Claim during the reporting period, as defined in the Report Period Start Date and Report Period End Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery to Date - Deductible	This is the total amount of Recovery entries, with a Recovery Type beginning with “Deductible”, under ALL Reserve lines of the Claim before and during the reporting period, as defined in the Report Period End Date and “As Of” Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery to Date - Salvage	This is the total amount of Recovery entries, with a Recovery Type beginning with “Salvage”, under ALL Reserve lines of the Claim before and during the reporting period, as defined in the Report Period End Date and “As Of” Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Recovery to Date - Subro	This is the total amount of Recovery entries, with a Recovery Type beginning with “Subrogation”, under ALL Reserve lines of the Claim before and during the reporting period, as defined in the Report Period End Date and “As Of” Date parameter selections when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reason for Denial	Pulls directly from the Reason for Denial on New Claim / Edit Claim screen. It should be noted that this field will only be available when the Claim Denied checkbox is checked, indicating the denial of the Claim.
Refer to Underwriters	If the Refer to Underwriters checkbox is available on the New Claim / Edit Claim screen, and it is checked this field will be set to “Y”, otherwise it will be set to “N”.
Reporting Period (End Date)	The exact Reporting Period End Date selected when running the report.
Reporting Period Start Date	The exact Reporting Period Start Date selected when running the report.
Reservation of Rights	If the Reservation of Rights checkbox is available on the New Claim / Edit Claim screen, and it is checked this field will be set to “Y”, otherwise it will be set to “N”.
Reserve - Adjusters Fees	This is the total amount of outstanding Reserves under the “Adjusters Fees” Reserve Type as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reserve - Attorney Coverage Fees	This is the total amount of outstanding Reserves under the “Attorney Coverage Fees” Reserve Type as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reserve - Defense Fees	This is the total amount of outstanding Reserves under the “Defense Fees” Reserve Type as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reserve - Expenses	This is the total amount of outstanding Reserves under any Reserve Types configured as Expense, except for the following Reserve Types: “Adjusters Fees” “Attorney Coverage Fees” “Defense Fees” “TPA Fees” This Reserve Amount figure is as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reserve - Fees	This is the total amount of outstanding Reserves under any Reserve Types configured as Expense as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reserve - Indemnity	This is the total amount of outstanding Reserves under any Reserve Types configured as Indemnity as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reserve - TOTAL	This is the total amount of outstanding Reserves under ALL Reserve Types as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reserve - TOTAL (Prior to Period)	This is the total amount of outstanding Reserves under ALL Reserve Types as of the Report Period Start Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Reserve - TPA Fees	This is the total amount of outstanding Reserves under the “TPA Fees” Reserve Type as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Risk City	Pulls directly from the City field under the Loss Location section of the New Claim / Edit Claim screen.
Risk Country	Pulls directly from Loss Country on New Claim / Edit Claim screen. If blank, this will default to “USA” on the report.
Risk Expiry Date	Pulls directly from Policy End Date on New Claim / Edit Claim screen.
Rick Inception Date	Pulls directly from Policy Start Date on New Claim / Edit Claim screen.
Risk Location Address	Pulls directly from the Street Address field under the Loss Location section of the New Claim / Edit Claim screen.
Risk Location Address - FULL	Pulls directly from the Street Address, City, State, and ZIP fields under the Loss Location section on the New Claim / Edit Claim screen.
Risk Location ID	Pulls directly from the Location ID field under the Loss Location section of the New Claim / Edit Claim screen. If no value is entered in the system, the report will output “---”.
Risk Location Postcode / ZIP Code	Pulls directly from the ZIP field under the Loss Location section of the New Claim / Edit Claim screen.
Risk Period Narrative	Set to “---”
Risk State	Pulls directly from Loss State on New Claim / Edit Claim screen.
ROW NO	Automatically outputs the “row number” for this record in the report output.
Section No.	This is pulled from the Policy Section field on the New Claim / Edit Claim screen. If the field is not populated, the column will output as “---”.
Settlement Currency	Set to “USD”.
State of Filing	Pulls directly from the Insured State on the New Claim / Edit Claim screen.
Sums Insured Amount	This is the sum total of the Coverage fields under the Coverage Information section of the New Claim / Edit Claim screen, typically labelled as “Coverage A”, “Coverage B”, etc.
Surplus Lines State Tax	Set to “---”
Total Incurred	This is the total Incurred amount for all Reserves under any and all Reserve Types as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Total Incurred - Fees	This is the total Incurred amount for those Reserves under any Reserve Types configured as Expense as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
Total Incurred - Indemnity	This is the total Incurred amount for those Reserves under
	any Reserve Types configured as Indemnity as of the “As Of” Date parameter selection set when running the report. Note that this field will be split according to the selection in the Claim Split Type drop-down.
TPA Name	The Adjustment Company Name as originally set up in FileTrac. This cannot be changed by the user, please contact FileTrac Support if there is any issue with this field. There are sometimes customizations in place to have the TPA Name output column vary by the specific Branch Office in FileTrac to which the Claim is assigned. Questions on this can be directed to FileTrac Support.
Transaction Type	Set to “Claim” on all records.
Treatment Type	Set to “---”
Type of Insurance	Set to “Direct”
UMR	This field populated differently depending on what selection is made from the Claim Split Type drop-down. When Claim Share Split is selected, this field will pull first from the Contract UMR field, of the Contract / Treaty associated with the individual row of the Claim Share on the given Claim. If the Contract UMR field is not populated, the Contract Code value will be used instead. When the other options are chosen, this field will pull from the Contract UMR field of the Contract / Treaty associated with the Claim on the New Claim and/or Edit Claim screen. If the Contract UMR field is not populated, the Contract Code value will be used instead.
Year of Account	This field populated differently depending on what selection is made from the Claim Split Type drop-down. When Claim Share Split is selected, this field will pull from the Year of Account field of the Contract / Treaty associated with the individual row of the Claim Share on the given Claim. When the other options are chosen, this field will pull from the Year of Account field of the Contract / Treaty associated with the Claim on the New Claim and/or Edit Claim screen.

The Report Builder - Lloyd’s Bordereaux 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 Standard

While 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.

Select the Client Company from the drop down. To customize the report, you can select for Client Company. In selecting, 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.
Click on the company from the list of values.
Click Add.
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.
Click the dropdown bar to select the Client Rep, otherwise “All” will remain selected.
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.
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.
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.
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.
Customize Field Selection: Making any selection will output ONLY those field selections, in the order that you have them arranged. To auto fill the standard Lloyd’s BDX fields click the QUICK LOAD: LLOYD’s Standard BDX and all standard report fields will populate in the Selected Fields.
After selecting an available field, click the Add button.
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.
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!
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.
Click the Use Filter tab to apply the filters that were chosen in the steps above.
Select the Format for your report by clicking on the corresponding radio button.
Click the View Report tab
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 Split

It 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 located in the TPA Financial reports section.

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

Click on a Client Company. In selecting, 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).
Click on the Add button.
The selection will be shown in the Selected Values field for Client Company.
Use the same method to make selections for the Syndicate by clicking on a Syndicate name.
Click the Add button.
The selection will be shown in the Selected Values field for Syndicate.
Click on the calendar to select the Start Date. This field defines the beginning of the “Reporting Period” on which the report is run.
Click on the calendar to select the End Date. This field defines the end of the “Reporting Period” on which the report is run.
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.
Select the Format for your report by clicking on the corresponding radio button.
Click the View Report tab.
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.

The Complete TPA Process in FileTrac