Financial Reporting Reports

Report List

Possible available reports can include:

• Balance Sheet
• Balance Sheet - Current Volume Cash Flows
• Balance Sheet - Forecasted Activity
• Balance Sheet - New Volume
• Balance Sheet - Rates
• Balance Sheet - Statistics
• Budget Export
• Financial Detail
• Forecasting Status
• Historical Prepayment Summary
• Income Statement
• Instrument Detail
• Key Rates
• Liquidity - Detail
• Liquidity - Summary
• Prepayment Detail
• Ratios
• Supplemental Data
• Variance
• Weighted Average Life

Report Parameters

The parameters that appear with a financial reporting report can include the following:

As you work through the parameters, earlier selections sometimes determine which parameters are available later. For example, if you are creating a global Supplemental Data report, then the Organization parameter is hidden since global data is organization-independent.

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.

Account Templates

Select a template from the list to select accounts automatically. Select Setup to add, copy, modify, and delete templates.

Budget Data

Select Balance Sheet and/or Income Statement to include the data in the Budget Export report.

Chart Type

Select which data is the primary report source for the Variance report.

Data

Select Yield or Offering Rate to determine the type of rates to use in the Balance Sheet - Rates report.

Data Type

Select if you want to generate a report based on Pre-Allocated or Post-Allocated data.

Data Value

Select whether the report data is Month-End, Average, or Mix for the Balance Sheet report. For the Income Statement report, the choices are MTD, QTD, or YTD.

GL/Org ID Configuration

Select how the general ledger and organization ID data is configured. You can choose to separate the data or combine it in the Budget Export report.

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.

Include Manual Adjustments

Select this option to include manual adjustments to prepay data in the Historical Prepayment Summary report.

Include Subledgers

Select this option to include subledgers in the report.

Key Rates

Select the rates to include for the Key Rates report.

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

Organization

Select the organizations that you want to include in the report. Only those organizations that you are permitted to access appear in the list.

If you are using organization groups, then you can select to show the list by Hierarchy or Groups. This option is available for the Balance Sheet and Income Statement reports.

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 Columns

Select Add Column Data to define the specific columns of data and calculations that you can use for the Variance report results.

Select the Data Value, Data Source, and Time Frame for each column.

After you add at least two columns, then the Data Value of Calculation is available. You can select the Calculation Type options and the Highlight Adverse Variance option.

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. For the Variance report, Report Writer is an option.

Reverse Sign Options

Select one or more account types to reverse the signs for the data in the report.

Review Status

Select which review statuses to include in the Forecasting Status report.

Review Structure

Select one or more users to show the review structure in the Forecasting Status report.

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.

Statistics

Select the data items to show for each account in the Balance Sheet - Statistics report. When a particular data item is not available or appropriate for an account, it is suppressed.

Supplemental Data

Select either Organizational or Global items to include for the Supplemental Data report.

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
• - Forecast Month

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

What If Model

Select the model that the report data is pulled from.

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.