Commission Sheets
Payment of insurance premiums entitles you to a revenue commission. The insurance company will make commission sheets available. The user downloads the commission sheets and modifies the commission sheet to a uniform format in excel.
Structure Commission Sheet in XLS format:
Insurance Company Contract No.
If the policy header does not contain "insurance company contract number" and the commission payment entry is matched with a commission calendar line, the system will add "insurance company contract number" to the policy header.
Draft No.
Some insurance companies use insurance policies as a key figure
Period From
Start of the commission period to which the payment relates
Period TO (Period To)
End of the commission period to which the payment relates
Financing Contract No.
Some insurance companies use insurance policies as a key figure
Insurance Comapany Framework Agreement No.
Can be a key figure in fleet contracts
Commision Amount
Key Data for Automatic Matching
Commission Percentage (Commission %)
Information Data
Insurance Company Year Amount
Information Data
Regular Insurance Company Amount
Information Data
Calculation Period
Information Data
Posting Date
Once matched, it is listed as the settlement date
Individual Insurance Contract Type (IPZ)
To differentiate the type of individual fuse. It is important in the automatic creation of an individual insurance policy from the incoming commission
Insurance Product No.
Information data, relevant for filtration during manual leveling
Create IPZ (Create Individual Insurance Contract)
If you want to create IPZ, you need to enter 1 or Create
Some insurance companies do not send commission sheets. In these cases, the user manually enters the lines (according to the bank statement) into the form Insurance Commission Payment Entries.
If there is a commission sheet in the required format, the user will run it on the Insurance Commission Payment Entries report Import Commission:.
The system opens a dialog window for selecting an insurance company.
It then selects the appropriate file:
The system has imported items from the commission sheet into insurance commission payment entries.
If the periodicity is not specified in the commission sheet, it will be added to the insurance commission payment item automatically from the Period From and Period To.
He's got a problem with February, he can't count 1M!
During the calculation, the tolerances – intervals are entered:
Quarter - period 3M is detected if "Period to" – "Period from" is in the interval 88 – 93 days
Half a year - period 6M is detected if "Period to" – "Period from" is in the interval of 170 – 190 days
Year – period 365 – 366 days
Automatic Pairing
The user executes the function Automatic Pairing. In the items of insurance commission payments, there is data from commission sheets, according to which the system searches for commission calendars for matching. By pairing, it will add data from insurance contracts
The basic key for pairing is always insurance company, period and amount commission.
The insurance company is entered by the user when uploading commission sheets.
The commission calendar period is filtered according to the period of the commission sheet – e.g. if the commission sheet shows 9/7/2021 – 9/8/2021 (the decisive date from the commission sheet is Period From, in our case 9/7/2021), selects the commission calendar line, where FROM <= 9/7 and TO>= 9/7 - we have calendars from 9/7 to 8/8, which suits
The system assesses the amount of the commission according to the set deviation (+-Insurance Settings Deviation – Commission Payment Deviation).
The system pairs in the following steps:
It searches for a commission calendar by insurance company, period, commission amount, and one of at least one of the keys:
Insurance Company Contract Numbers
Draft Numbers
Financing Contract Numbers
Searches by Insurance Company, Period, Insurance Company Framework Agreement Numbers And it will only pair if it fits Amount of all insurance contracts for the given framework.
Only open lines of the commission calendar for matching are accepted. If a row is already marked Open = NOT (is closed), proceeds from the last closed line.
If there are still open rows before this line, they must be re-paired, the system will not automatically pair them.
Unpaired items have an amount in the column Balance and a check mark in the column Opened.
Insurance Commission Payment Entry Detail
The user can view the paired items in detail of what they were paired with. Selects the line with the payment entry and runs the function Detailed Entries.
Manual re-pairing
Items that have not been automatically matched by the system can be manually checked and matched by the user. On the unpaired line in the Apply section, it will run the Apply Entries.
The system opens the form for manual rematching.
The form is filtered to the leasing contract number, insurance company and flag open. The user can edit the filter as needed. It is possible to add another filter.
As soon as the user finds one or more items (i.e. lines of the commission calendar) to which he wants to associate the commission, he marks one line or in the field Choose marks multiple rows and executes the function Set Settlement Identification.
The system will complete on the marked line Selected = Yes and User ID.
If the user makes a mistake, he can delete the identification again – just run the function again on the marked line with the identification Set Up Identification. On this second start, the system starts User ID deletes again.
The paired entry is ready for posting.
Posting a settlement
After finding the lines that apply the commission payment entry, the user runs the Post settlement.
A user can also post a partial pairing. The remainder (balance) remains on the commission payment line for further matching.
If the user has marked the insurance policy on the contract for which it is created for pairing Change Copy, the system reports an error and does not allow the settlement to be posted.
The user has to check who created the change copy and agree on taking over or canceling the change copy and then restarting it Post Application.
If the user has marked for pairing an insurance policy on a contract that exists variant, the system does not report an error and allows settlement to be posted, but invalidates the variant so that it cannot be activated:
Commission Approximation
If it is a commission that can be changed by the insurance company during the course of the commission and the user wants to recalculate the commission calendar based on the change in the amount of the incoming commission, it is necessary to enter a check mark in the Approximation field in the commission definition.
In this case, in the case of manual rematching, the system will ask if the commission calendar needs to be approximated if there is a mismatch in the amount match.
The user can reply No and post partial re-pairing. The remainder (balance) remains on the commission payment line for further matching.
If he answers Yes, the system recalculates the commission calendar based on the incoming commission.
Cancel settlement
Paired items can be unpaired again by the user and released for new pairing. The user opens the detail item they want to undo and executes the function Cancel settlement.
After approval, the system creates a cancellation line for the selected detail entry and recalculates the balance.
Addition of data from the commission sheet
In the case of insurance contracts, users do not know when creating a contract Draft No. or Insurance Contract No. in the Insurance Company. However, this information is provided by the insurance company in the commission sheet.
During settlement, the system checks whether these data are empty in the insurance contract and if so, it fills in the following from the commission sheets:
Draft No.
Insurance Company Contract No.
Example:
The insurance contract does not include the insurance company's contract number. The system has filled in the payment item from the commission sheet by import.
After pairing (manual or automatic), the system fills in the data on the fuse header.
Pairing payments with each other – cancellation from the insurance company
In case of additional correction of an erroneous line from the commission sheet, it is necessary to use matching of payments with each other.
For example, there is a higher commission than it should be,
Subsequently, the entire commission paid will be cancelled and the correct amount will be paid (more common case)
Subsequently, the cancellation will be in a different amount
Example: Cancel the entire amount:.
By mistake, a higher commission of 243.83 came.
User paired manually. Subsequently, a repair came from the insurance company.
Procedure:
Cancel settlement – this will reopen payment entry 243.83
After importing the correction entries of the commission sheet, it is necessary to settle the payments with each other. The user marks a row with a negative amount and executes the function Apply Payment
In the dialog box, selects the payment entry that belongs to the negative line and confirms OK
For both paired payments, the open check mark will disappear.
If, of course, it was set to commission Approximation, it is necessary to recalculate after unraveling in order to adjust the commission calendar.
You need to check the definition of commission over the insurance policy.
And recalculate the commission.
The commission calendar has been recalculated to the original amount.
Apply the correct payment entry 219.45
Because the period, insurance contract number, and amount match, the items can be matched automatically.
Commission Payment for Fleet Contract
Some insurance companies do not send commission sheets. The user creates a summary payment manually. The matching character in this case is Fleet Agreement / Insurance Framework Agreement No.that the user enters on the Framework Agreements tab.
From the framework agreement, the system writes the number into the insurance contract.
The commission for the fleet/framework agreement of the insurance company is manually entered by the user in the Insurance Commission Payments, or by using the import line.
The matching characters in this case are Insurance Company Framework Agreement No., period and amount. The remittance date is actually the posting date of the payment.
The user can filter only the framework agreement of the insurance company and the posting date (= payment date in the import file) or the item number.
The user starts Automatic Pairing.
If the total amount from the insurance contracts matches the sum amount in the payment item for the insurance company's framework agreement, the system will automatically match and mark the payment item Open = No.
If the payment amount for the fleet contract does not match, automatic matching is not performed and the user must start for manual withdrawal Apply Entry.
Example:
For December, the payment was made only for insurance policies, until 20.12.2020 it is 721.34.
There are already two more insurance policies in the database for the December period after December 20 for 414.52.
The system did not match the items during automatic matching – the total amount does not match, there is a total of 1,135.86 in DB (compared to 721.34 in the payment item).
The user has to perform manual application – start the Apply Entries function and use the Set Settlement Identification Selects the corresponding rows:
The system continuously calculates from items with the set Applies-to ID Amount to settle and Balancethat remain to be used.
When the available amount is used, it starts Post Application.
If the surcharge for the remaining period of December is subsequently received from the insurance company. It is possible to start automatic matching of the additional payment in December.
Creating an Individual Insurance Policy from a Commission List
In the event that there was a commission in the commission sheet for arranging an insurance policy (post-leasing, non-leasing) for which no insurance contract exists, the user can create an individual insurance contract after verification.
In Insurance Settings, the basic framework agreement type and the default individual contract duration must be set for creating individual insurance policies.
If more payments have been received from the insurance company for mediated insurance policies (block for post-leasing), the items can be processed in bulk.
The user can mark it by running the function. Or by selecting in the Create Individual Insurance Contract column:
After marking one or more lines, the user runs the Create Individual Agreement function.
The system creates an individual insurance contract in the status Preparation, in which he writes the data from the insurance commission payment line and creates a commission calendar, where the amount of the term commission is the amount of the commission received. The type of framework agreement and the duration given by the insurance settings - see the default tab.
The insurance contract is in the following state Preparation, the received commission can be paired with the commission calendar line in this one as well. In case there is at least one line with a flag in the commission calendar Open = No (unchecked), the insurance contract cannot be deleted.
Cancel Line Calendar for Insurance Company – Actual Insurance
If the user cancels the Sent Line in the calendar to the insurance company, the system registers the cancellation flag and the cancellation date.
If the basis for the commission calculation is Real Insurance (i.e. calendar lines for the insurance company), then you need to run the action – Commission Calculation.
Change of commission definition on Active Insurance Contracts – Recalculation of revenue commission (R 4027100)
The insurance company will also change the amount of the commission for already active policies.
For example, for the rates in the set, SET000019 increased the commission on all insurance contracts (not just newly created ones).
Previously, the set had a standard commission from the insurance company's product.
After the change from the commission from the insurance company, it is necessary to introduce a new definition Valid For Enter For All Contracts.
New definition of commission on the set I have to have in the field "Valid for" = All contracts in order to recalculate the commission on existing contracts as well. Otherwise, the definition will only apply to new insurance policies
The user runs the Recalculate Insurance Revenue Commission batch job.
When running the task, it is possible to set filters for the selection of insurance contracts to be recalculated:
Insurance Company No.
Insurance Product No.
Framework Agreement No.
Framework Agreement Type
Set No.
Rate No.
status
According to the assignment, the batch job deletes the original commission definition and loads the new definition. Subsequently, it calculates the commission calendar according to the new definition.