Creating an Average Daily Balance or Cost of Funds Report

You can create customized average daily balance reports that list ADB balances for accounts and dates you specify. Reports can include actuals, ADB calculation results or cost of fund calculation results for the current or prior period, quarter or year.

Note: You need to define a report only once, but you can change the report layout at any time. Once defined, run the report at any time using AD290.

To create an average daily balance report

  1. Access Average Daily Balance-Cost of Funds Report Setup (AD50.1).
  2. Select the report you want to change or create a new report.
  3. Define the report information using the following guidelines:
    Period: Effective Date or Period, Year

    Select either an effective date or a period. If you select the effective date, the report will include the calculated values for the same relative date in other periods. If you select a period and year, the report will include the calculated values for the period ending date.

    For example, if your quarter ends on March 31 and select an effective date of March 15, you can customize your report to include comparisons of the balances as of December 15.

    If you select period 3 of last year, you can customize your report to compare the balances for the period end dates.

    Note: In order to run a report for an effective date, you must have run AD190 for that date.
    Report Layout

    Select from the predefined values available in each column field. Then type the headings for each column grouping.

Followup Tasks

After you define a report, you can run it at any time using ADB-Cost of Funds Report (AD290). Running an Average Daily Balance or Cost of Funds Report