AM Best Online Help

Select Options - Reinsurance Wizard

Select options to enhance the layout of your Reinsurance custom report.

• Select Totals Option (optional): This option is available when By Filing Company report type is selected with only one part and one year.

• Select Types of Reinsurance (Schedule S only) (optional): The results are limited to the type selected.

• Select File Layout:

• • File Layout: Select a default layout option for your custom reports.

  • • Single Sheet: Custom report data appears on one worksheet and sorts by Reinsurer/Cedents or Section/Line. The Section /Line option is only available when one year and one part are the selected options.

    • Multiple Sheet: Select from filing year, data year or part for your custom report data to appear on multiple worksheets. Sort by reinsurer/cedents or section and lines.

    • Flat File: one record per company, with each report component and data field placed in separate columns. Use the Flat File method for pivot tables.

    • Report Dimensions: this information gives you the total number of worksheets, maximum number of rows, and columns for the selected report options.
      Note: there is a 200 tab limit

• Select Formatting Options:

• • Numeric Data Format

  • • Decimal Places: Select the number of digits to appear after the decimal place for all the financial data. By selecting zero, there will be no decimal places in the number.

    • Use Thousands Separator: Format financial numbers on your report with commas. Separate the number (in groups of three digits) with a comma.

    • Use Dollar Sign: Include a dollar sign with financial data.

    • Negative Numbers: Select a format for the negative financial data.

1. • Data Alignment

   • • Financial Data: Select if you would like the financial data to be left, center, or right aligned. Right is the default selection.

     • Non-Financial Data: Select if you would like the non-financial data to be left, center, or right aligned. Left is the default selection.

   • Row and Column Headings - Set the font style for row and column headers.

   • Data - Set the font style for data.

   • Text Control

   • • Wrap column headers - Format column headers to appear on multiple lines in a cell.

     • Autosize columns - Use this feature to automatically adjust the column width to match the widest data item in the column.

 

Summary