CECL Reports

Report List

Possible available reports can include:

• Borrower & Asset Quality
• CECL Data
• Economic Forecast
• Q Factor Detail
• Q Factor Summary
• Reserves Summary

Report Parameters

The parameters that appear with a CECL report can include:

As you work through the parameters, earlier selections sometimes determine which parameters are available later.

Accounts

Select the accounts that you want to appear in the report. Select All to show the full account list. Then, expand the subtotal lists so that you can select specific groups of accounts.

CECL Categories

Select one or more CECL categories to include in the report. If the Instrument Level Detail parameter is available and selected for the selected report, then you can only select one CECL category.

Data Type

Select if you want to generate a report based on Loans or HTM Investments data.

Discounted

Select this option if you want discounts to appear in the report results.

Economic Scenario

Select one or more economic scenarios that you want to include in the report. The report generates at the category level unless you select the Instrumental Level Detail option.

Note: This CECL field parameter can appear as a drop-down list or check box selections depending on the type of report that you are working with. If a check box list appears, then you can select more than one economic scenario.

Header/Footer

Select the header and footer information that appears on your reports when Excel is the selected Report File Type.

The application provides a default header for every report, but, when you select Setup, you can create, save, and reuse your own user-defined headers and footers.

When you open an Excel®-based report in Excel®, the header does not show until you open the Excel®Header and Footer Tools. Use the Excel® search feature to locate this tab quickly. If you save the report in Excel®, then you do not have to perform this action the next time that you open the file.

Instrument Level Detail

Select to show instrument-level detail in the report. If this parameter is selected, then the CECL Categories parameter only allows you to select one CECL category instead of multiple.

Layout and Formatting

Select options in this section to customize the look and feel of your reports. Depending on the report, customizations can include:

• Amount Formatting
• Font Size
• Include Average Column
• Include Total Column
• Number Decimal Places
• Page/Row/Column
• Rate Decimal Places
• Show GL Numbers
• Suppress Zeroes

Loss Type

Select to include Gross or Net losses in the report results.

Model

Select a model for the report results.

Organization

Select the organizations that you want to include in the report. This parameter is only available if your institution is set up as a holding company. Each organization must have an FDIC # entered on Setup > Organization to appear in the list.

Recipients

Select the names of the users who can receive a copy of the report from the provided list. You can send the current report to other users of the application via email.

Note: You cannot clear the name of the active user.

Report Cosmetics

Select a template to define the cosmetics of the report such as the formatting, background and font colors, lines, blank rows, and page breaks.

The application provides a default template for every report, but, when you select Setup, you can create, save, and reuse your own user-defined report cosmetics.

Report File Type

Select the output format for the report. For most reports, the choices are Excel and PDF. Some reports also offer delimited options such as Comma Delimited, Semicolon Delimited, or Fixed Column Width.

Save As Favorite

Select this option and provide a name for the favorite if you want to generate the same report again without redefining the parameters.

Share With

Select each user that you want to share the report with, and indicate whether the users have Read Only or Editable access to the shared favorite report. This parameter appears when you select the Save As Favorite option.

Time Frame

Select this field to open a calendar showing the months that you can select for the current report. Each time frame is assigned a color:

• - Historical Month
• - Current Month

You can also specify whether the selected months are Floating or Fixed. By default, the current month appears as a Floating time frame.

Note: When you set the time frame to Floating, the selected months move relative to the current month, or the month of the most recent successful update.

After defining all the report parameters, you are ready to generate the report. You can generate the current standard report now, if needed. You can also save the selected parameters, and then generate the report as a favorite.