Upload Bordereaux

• Upload incoming risk, claim and payment bordereaux from spreadsheet 
• Import data from underwriting / administration systems or reporting databases
• Select section / class of business the bordereau is associated
• Easily map columns to a consolidated data layer when you are setting up incoming data for the first time
• drop down menus support you in mapping columns from source to target
• The solution remembers previous mapping for future bordereaux within the same contract agreement. 
• Map values to a standard list for consistency and easier reporting
• With all data standardised to a common format this will save time enabling you to support increasing data sets.
• File physical spreadsheet within the solution for ref.
• MI and data visualisation show bordereaux processing (i.e. percentage processed, timing, number overdue etc.)

Data Quality

• Prebuilt data quality and validation rules (i.e claims must have associated policy, adjustments must have a corresponding new business or renewal transaction, expiry before inception and validation etc.)
• Users can also easily define additional data quality and business rules with no coding required. (i.e. exclude specific makes and models of vehicles when setting up contract agreement business rules).
• Based on the predefined set of data quality rules the solution carries out data cleansing and will display errors based on severity which can be exported to excel.  
• The data quality layer reports and flags all failed or missing fields.
• Only high severity rules will prevent you from moving on to the transformation stage.
• If there are high severity data quality and validation issues the bordereaux will need to be amended and revalidated
• Supports Lloyds Premium, Claim, and Risk standard V5 and regulations such as Flood Re.
• Bordereaux data quality is assured and MI and data visualisaton dashboards track results.  

Credit Control / Account Reconciliation

• Reconcile against uploaded risk and payment bordereaux
• The credit control position is presented based on contractual agreement terms set up in binder management
• Reports show risks which are overdue for payment (If no payment bordereaux then you can manually mark items as paid.)
• For outgoing payment bordereaux – confirm which items to include then produce payment bordereaux
• Export a list of payment items so this can be reviewed by brokers
• MI and data visualisaiton dashboards show financial reconciliation and processsing (i.e. payed amounts, outstanding payments, timing etc.)

Bordereaux Production

• Out-going bordereaux templates includes all Lloyds manadatory reporting standards
• User can also select additional columns required by insurers / MGA's
• Create bordereaux export and file within the solution
• Respond to data format changes and additional data requirements with ease
• MI and data visualisaton dashboards show out-going bordereaux processing (i.e. percentage sent, timing, number overdue etc.) 

Audits

• Record insurer / coverholder audits
• Create recommendations against audits
• Track actions against recommendations
• MI and data visualisation dashboards show when audits are due, completed and progress against recommendations etc.

• Control files log all activity for clear audit trail
• Dashboards giving operational details (i.e. user activities, when changes have been made etc.)

Bordereaux Analytics - Data Visualisation Dashboards and MI Reports

• Dashboards showing binder composition and bordereaux processing
• Alerts highlight warnings (ie. when binder limits are being approached)
• Prebuilt reports for operational and regulatory reporting (i.e. Conduct Risk and Solvency II)
• The solution enables reporting across entire binder portfolio