Outstanding claims (opening)

Data Format

• Dates must be DD/MM/YYYY or Excel Serial format
• Amounts should be numbers (no currency symbols)

Required Columns

Ensure your file has headers matching these names (not case-sensitive):

• Class(or 'CLASS')
• Sub Class(or 'SUB CLASS')
• Claim No.(or 'CLAIM NO.')
• SCL(or 'SCL')
• Year(or 'YEAR')
• UW Year(or 'UW YEAR')
• Policy Cover From(or 'POLICY COVER FROM')
• Policy Cover To(or 'POLICY COVER TO')
• Risk Cover From(or 'RISK COVER FROM')
• Risk Cover To(or 'RISK COVER TO')
• Date Reported(or 'DATE REPORTED')
• Date of Loss(or 'DATE OF LOSS')
• Policy No(or 'POLICY NO')
• Insured(or 'INSURED')
• Agency(or 'AGENCY')
• O/S Grs. Reserve(or 'O/S GRS. RESERVE', 'osGrossReserve', 'Outstanding Reserve', 'Gross Reserve', 'O/S Reserve', 'Opening Reserve', 'Begin Estimate')
• Amount Paid(or 'AMOUNT PAID')
• Q/S Treaty(or 'Q/S TREATY')
• Mandatory(or 'MANDATORY')
• 1st. Treaty(or '1ST. TREATY')
• 2nd Treaty(or '2ND TREATY')
• Facult. RI(or 'FACULT. RI')
• Fac Ob. RI.(or 'FAC OB. RI.')
• XOL(or 'XOL')
• O/S Net Reserve(or 'O/SNET RESERVE')