Please enable JavaScript.
Coggle requires JavaScript to display documents.
s2 Bordereau (a) Specify templates to allow translation of a received…
s2 Bordereau
a) Specify templates to allow translation of a
received Excel file into a format suitable for
uploading data into Synergy
Assign one or more brokers whose files need to be uploaded with each template
Validate the content/context of the uploaded file and ensure all a) reference data relationships are maintained and b) applicable business rules followed
c) Load the received data onto the binder level;
Specify when uploading, a) the sender (Broker), b) bordereaux type, c) template to be used and d) location of the file.
A file with an extension of .xls or .xlsx can be selected when specifying the bordereau location.
SUMMARY upload Synergy with broker emailed files, onto staging area, validate accept/fail data content, progress monitoring of submitted data: bordereaux files for: policies, premiums, claims, premiums-cash, claims-cash, reports.
5 Bordereau types
(supported June 2012):
...
Declaration Bordereau of new policies written against a specific Binder by a Broker;
Premium Payment Bordereau of payments in respect of declared policies;
Claims Declaration Bordereau with reserve and payment movements, across 4 key areas:
Claim overview – providing the claim reference, and basic information relating to the claim.
Reserve Movements – changes to the reserves for this claim (indemnity, fee and recovery). These are on a per-movement basis, not a total to date basis.
Payment Movements – details on all anticipated payments (payments that have been advised that will be paid). This includes details on the paid to date and outstanding figures.
Claims Cash – details on payments that have actually been paid, including an indicator on whether these have been reconciled against any of the advised payments
Claim Payment Bordereau of settlements against declared claims.
Property Import providing schedules of properties and their covers for import into the Property Rating screen
b) Manage and control uploaded content prior to merging with the binder level data;
.
Select a template
A range of bordereau can be grouped for a single action upload to staging, validate, thenload as a batch against the binder level data.
Browse to provide the local or network location of the spreadsheet to be tested.
Select ‘Run Test’ to load the file and parses
(as per source definitions in the template).
If parsing successful then the parsed fields are shown in the results grid. This is non-editable and dynamically structured depending on the definition of the fields in the selected template
If errors occur these are presented to the user in a pop-up message, and testing ends with a ‘Fail’ status.
Attach file to the Binder.
When loading a batch the system will ensure they are loaded in the correct order to prevent any failures due to missing references
Review log file of major action performed during the bordereau upload
d) Undo reconciliation and remove payments.
..
Review any missing data from the upload;
Remove any data from the staging tables if loaded in error (and status will be set to ‘Removed’)
Revalidate the bordereau against the Synergy application tables
Load bordereau into the main application tables (not available for "Property Import Bordereau" as its goes directly into the Property-Rating_screen)
Remove incorrectly loaded bordereaux from staging.
Existing accounting functionalities automatically reconcile any payments against existing policies.