Commission Applying
- Lango: Language and translation manager
Commission Sheets
By paying the premium, you are entitled 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 contract number in insurance company" and the commission payment entry is paired with a commission calendar line, the system will add "insurance contract number in insurance company" 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
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
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
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 Individual Insurance Contract (IPZ)
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 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 of 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 Matching
The user starts the function Automatic Matching. In the commission payment items, there are data from commission sheets, according to which the system searches for commission calendars for matching. By matching, 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 period of the commission calendar is filtered according to the period of the commission sheet – e.g. if it is 9/7/2021 – 9/8/2021 in the commission sheet (the decisive date from the commission sheet is Period From, in our case 9/7/2021), it selects the line of the commission calendar, 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 Setup 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 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 = NO (is closed), proceeds from the last closed line.
If there are still open rows before this line, it is necessary to pair them manually, the system will not automatically match 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, 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 checked and matched manually by the user. On the unpaired line in the Apply section, it will run the function Apply Entries.
The system opens the form for manual rematching.
The form is filtered to the leasing contract number, insurance company and open flag. 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. commission calendar lines) 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 add to 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 User ID deletes again.
The paired entry is ready for posting.
Post 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 matching. The remainder (balance) remains on the commission payment line for further pairing.
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 settlements 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 for which there is a variant, the system does not report an error and allows the 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, when manually matching, the system will ask if there is a mismatch in the amount whether the commission calendar needs to be approximated.
The user can reply No and post partial matching as well. The remainder (balance) remains on the commission payment line for further pairing.
If they answer Yes, the system recalculates the commission calendar based on the incoming commission.
Cancel Apply
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 Apply.
After approval, the system creates a cancellation line for the selected detail entry and recalculates the balance. The posting date on the line resulting from canceling the settlement is the "working date".
Completion 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 number 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, adds the following from the commission sheets:
Draft No.
Insurance Company Contract No.
Example:
The insurance contract does not specify the contract number of the insurance company. From the commission sheet, the system filled in the payment item by import.
After pairing (manual or automatic), the system will add the data to the fuse header.
Matching 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 the matching of payments with each other.
For example, the commission comes in higher than it should be,
Subsequently, the entire commission paid will be cancelled and the correct amount will be paid (a more common case)
Subsequently, the cancellation will be cancelled in a different amount
Example: Cancel the full amount:.
By mistake, a higher commission of 243.83 came.
User re-paired. Subsequently, a repair came from the insurance company.
Procedure:
Cancel settlement – this will reopen payment entry 243.83
After importing the commission sheet correction entries, it is necessary to settle the payments with each other. The user selects 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 a commission Approximation, it is necessary to recalculate after undoing 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 correct payment entry 219.45
Because it matches the period, the insurance company contract number, and the amount, the items can be matched automatically.
Fleet Contract Commission Payment
Some insurance companies do not send commission sheets. The user creates a summary payment manually. The pairing character in this case is Fleet Contract / Insurance Framework Agreement No.that the user enters on the Master Agreement tab.
The system writes the number from the framework agreement into the insurance contract.
The commission for the fleet/framework agreement of the insurance company is manually entered by the user into the Insurance Commission Payments, or by using the import line.
The pairing characters in this case are Insurance Company Framework Agreement No., period and amount. The payment 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 entry number.
The user starts Automatic Matching.
If the total amount from the insurance contracts matches the total 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 run for manual selection Apply Entry.
Example:
For December, the payment came 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 20.12. for 414.52.
The system did not match the items during the 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 Sheet
In the event that there was a commission in the commission sheet for arranging an insurance policy (post-leasing, non-leasing) for which there is no insurance contract, 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 up 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 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 a commission calendar row in this one as well. In case there is at least one line with the flag in the commission calendar Open = No (Not checked), the insurance contract cannot be deleted.
Cancel Line Calendar for Insurance Company – Real Insurance
If the user cancels the Sent Line in the calendar to the insurance company, the system registers the cancellation flag and the date of cancellation.
If the basis for commission calculation is Actual Insurance (i.e. calendar rows 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 commission for already active policies.
For example, for the rates in the SET000019 set, it 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 set a new definition Valid For Enter For All Contracts.
I must have the new definition of commission on the set 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 specify 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 a commission calendar according to the new definition.