Import Insurance Portfolio From Insurance Company

Importing a Trunk from an Insurance Company

Function Importing a Trunk from an Insurance Company processes the file in MS-Excel and populates the second part of the subform rows (marked with the number 2).

The user modifies the file sent from the insurance company to a uniform form intended for import.

The user starts the import function from the Insurance Statement Card via Check Reports and Importing a Trunk from an Insurance Company (Import Insurance Portfolio From Insurance Company)and selects the prepared file.

The system reads the lines in the file and looks for matching keys in the first part of the line:

• Draft No.

  • If the field is filled in on the contract, it is used for matching and reconciling the trunk

• Customer Name

  • This is not a key figure, it is only informative

• Financing Contract No.

  • Key Data for Trunk Reconciliation

• Insurance Company Month Amount

  • Key information for reconciling the trunk if the amount of the premium is different OC marks the field Different Amounts = Yes

• VIN (VIN)

  • Used for trunk matching and reconciliation

• Car Registration Plate No.

  • Used for trunk matching and reconciliation

• Insurance Company Contract No.

  • Usually, in OC, the field on insurance contracts is empty. It is filled on the basis of import from the trunk from the insurance company

• When importing the trunk repeatedly, the system does not check or overwrite the original and new value of the field, the original value remains on the Insurance Contract Card.

After the import was completed, the OC performed the following actions (the resulting import status):

• For rows with a full match, it fills in the data from the imported file and flags Paired Entry = Yes

  • The row for the main insurance policy with the add-on will be marked as matched if the amount of the imported record is the same as the amount of the insurance premium to the insurance company for the main policy or with the sum of the premiums of the main policy and all its add-ons

• For rows with the same key but different amounts, flag Different Amounts = Yes

• Afield Different Amounts Will Remain Value No if the amount of the difference is within the limit Statement Variances (field in Insurance Settings)

• Added to the end of the imported rows where it did not find a matching key. The first part is empty (no rows were found loaded into the report from the OC)

• Rows for which there was no record in the import file have the second part empty.

The user checks for any:

• Differences Column Different Amount = Yes

• Unpaired Rows Column Paired Entry = No

Statements with different amounts or unpaired lines cannot be issued.

After verification, the user will ensure that errors in the insurance contracts or in the insurance portfolio are corrected. The responsible user issues the approved trunk. This is then the source of reports for the payment of insurance premiums. (The issuance of the statement is described in the chapter below).