Commission Sheets
Payment of insurance premiums entitles you 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.
...
If the policy header does not contain "insurance company contract number in insurance company" and the commission payment entry is matched paired with a commission calendar line, the system will add "insurance company 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 (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 Datadata
Insurance Company Year Amount
Information Datadata
Regular Insurance Company Amount
Information Datadata
Calculation Period
Information Datadata
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 (IPZ)
If you want to create IPZ, you need to enter 1 or Create
...
If there is a commission sheet in the required format, the user will run it on the Insurance Commission Payment Entries report Import Commission:.
...
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 executes starts the function Automatic PairingMatching. In the commission payment items of insurance commission payments, there is are data from commission sheets, according to which the system searches for commission calendars for matching. By pairingmatching, it will add data from insurance contracts
...
The insurance company is entered by the user when uploading commission sheets.
The period of the commission calendar period is filtered according to the period of the commission sheet – e.g. if the commission sheet shows 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 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 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 NumbersAnd it 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 = NOT NO (is closed), proceeds from the last closed line.
If there are still open rows before this line, they must be re-pairedit is necessary to pair them manually, the system will not automatically pair match them.
Unpaired items have an amount in the column Balance and a check mark in the column Opened.
...
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.
...
Items that have not been automatically matched by the system can be manually 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 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 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 complete on 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 starts 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 pairingmatching. The remainder (balance) remains on the commission payment line for further matchingpairing.
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 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 that exists 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:
...
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 rematchingwhen manually matching, the system will ask if there is a mismatch in the amount whether 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-pairingmatching as well. The remainder (balance) remains on the commission payment line for further matchingpairing.
If he answers 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 settlementApply.
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 No. contract number in the Insurance Companyinsurance 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 adds the following from the commission sheets:
...
The insurance contract does not include specify the contract number of the insurance company's contract number. The system has . From the commission sheet, the system filled in the payment item from the commission sheet by import.
After pairing (manual or automatic), the system fills in will add the data on 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, there is a higher commission 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 entire full amount:.
By mistake, a higher commission of 243.83 came.
User re-paired manually. Subsequently, a repair came from the insurance company.
...
Cancel settlement – this will reopen payment entry 243.83
After importing the commission sheet correction entries of the commission sheet, it is necessary to settle the payments with each other. The user marks 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 unraveling 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 the correct payment entry 219.45
Because it matches the period, the insurance company contract number, and the amount match, 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 matching pairing character in this case is Fleet Agreement Contract / Insurance Framework Agreement No.that the user enters on the Framework Agreements Master Agreement tab.
From the framework agreement, the 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 in into the Insurance Commission Payments, or by using the import line.
The matching pairing characters in this case are Insurance Company Framework Agreement No., period and amount. The remittance 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 item entry number.
The user starts Automatic PairingMatching.
If the total amount from the insurance contracts matches the sum 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 start run for manual withdrawal selection Apply Entry.
Example:
For December, the payment was made 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 December 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).
...
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 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 up for creating individual insurance policies.
...
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 a commission calendar line row in this one as well. In case there is at least one line with a the flag in the commission calendar Open = No (uncheckedNot 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 date.
If the basis for the commission calculation is Real Actual Insurance (i.e. calendar lines rows for the insurance company), then you need to run the action – Commission Calculation.
...
The insurance company will also change the amount of the commission for already active policies.
For example, for the rates in the SET000019 set, SET000019 it increased the commission on all insurance contracts (not just newly created ones).
...
After the change from the commission from the insurance company, it is necessary to introduce set a new definition Valid For Enter For All Contracts.
New I must have the 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
...
When running the task, it is possible to set specify filters for the selection of insurance contracts to be recalculated:
...
According to the assignment, the batch job deletes the original commission definition and loads the new definition. Subsequently, it calculates the a commission calendar according to the new definition.
...