Brick & Associates ALM Download

This document provides instructions for utilizing the Brick & Associates ALM Download functionality within the FLEX system. This feature allows credit unions to generate various financial files and reports for Asset/Liability Management (ALM) purposes.

Accessing Brick & Associates

To access the Brick & Associates module:

• Navigate to the GL/Accounting section in the FLEX Main Menu.
• Expand the ALM sub-menu.
• Select Brick & Associates.

Available Functions

The Brick & Associates menu provides the following options:

• Build Certificate Totals by Maturity Date File
• Build Yield-Cost Statement Download File
• Financial Statement Download Setup Report
• Setup Financial Statement Download

Setting Up Financial Statement Download

The Setup Financial Statement Download option allows you to configure the general ledger (G/L) accounts that will be included in your financial statement downloads.

Configuration Steps:

1. Initiate Setup:
   • From the Brick & Associates menu, click Setup Financial Statement Download.
   • The Brick F.S. Download Setup screen will appear.
2. Configure Categories/Line Numbers:
   • Line Number: This field identifies the specific category being configured (e.g., Line Number 1 for “Cash, Bank & FRB DEP”).
   • G/L Account From/To:
     • Enter the range of general ledger accounts that correspond to the current category.
     • If only a single G/L account is associated with the category, enter the same account number in both the From and To fields.
     • After entering the G/L account(s), press F1 to update the entry.
   • Continue Next Line (for Non-Sequential Accounts):
     • If a category requires multiple, non-sequential ranges of G/L accounts (e.g., 79500 to 79503 and 79506 to 79508), additional sequences must be added.
     • Place a Y in the Continue Next Line field.
     • Press F6 to Add. This action will save the current record and clear the fields.
     • Re-enter the Line Number.
     • Change the Sequence Number to the next sequential number (e.g., 1).
     • Enter the next range of G/L accounts.
     • Repeat this process, incrementing the Sequence Number for each additional account range used within the same line number/category.
   • Types for Share, Loan, Cert, MMA:
     • If applicable, enter the relevant types (e.g., for Shares, Loans, Certificates, Money Market Accounts) that coincide with this category.
   • Security Codes (if needed) for Loans:
     • If applicable, enter any security codes for loans that coincide with this category.
3. Navigate Categories:
   • Press Page Down to move to the next category/line number.
   • It is not mandatory to complete all categories/line numbers; only configure those relevant to your credit union.
4. Save and Exit:
   • Periodically Update: FLEX recommends periodically updating and exiting to ensure data is successfully saved.
   • Once all necessary categories are completed:
     • Press F1 to Update.
     • Press F3 to Exit the setup screen.

Generating Files and Reports

After completing the financial statement download setup, you can generate the desired files or reports from the FLEX Main Menu.

Generation Options:

• Build Certificate Totals by Maturity Date File:
  • This file will be generated and sent to the i: Drive in the Brick folder.
• Build Yield-Cost Statement Download File:
  • You will be prompted to enter the desired month for the Brick Yield Cost Download.
  • The file will be generated and sent to the i: Drive in the Brick folder.
• Financial Statement Download Setup Report:
  • A Brick F/S Setup Listing report will be generated and archived to Document Manager.

File Upload Instructions

• Contact your Brick representative for specific instructions on uploading the generated file(s) to their system.

Support

• For any questions or assistance, please contact FLEX Back Office Support.