Kasasa Interface

System Management System Management Kasasa Interface

This document provides a comprehensive guide to the Kasasa Interface within the FLEX system. It covers the processes for creating and receiving files for Kasasa, handling exceptions, and recreating history files.

1. Introduction to Kasasa Interface

Kasasa is a third-party software program that interacts with the FLEX system to assess member transactions and reward accounts with increased dividend rates and refunds. The interface facilitates the exchange of member and transaction data between FLEX and Kasasa.

2. Creating Files for Kasasa

Files are generated from the FLEX system and sent to Kasasa, typically as part of the End of Day (EOD) process. These files contain member history data.

2.1. Files Generated

The following files are created and placed on the i:Drive for Kasasa to retrieve daily:

  • BVCERT.TXT: Certificate Information
  • BVLNHST.TXT: Loan History
  • BVLOAN.TXT: Loan Information
  • BVMEMBER.TXT: Name Information
  • BVSHARE.TXT: Share Information
  • BVSHHST.TXT: Share History

2.2. Manual File Generation

To manually generate these files:

  1. Access the command line in the FLEX system.
  2. Type the command: CALL BV4000C
  3. Press Enter.

Note: Each time the program runs, the new files replace the existing ones on the i:Drive.

3. Receiving Files from Kasasa

Kasasa provides a monthly file, BVTYPE.TXT, which contains member accounts and the corresponding share type changes. This file is crucial for updating share types within FLEX to ensure correct dividend payments.

3.1. Prerequisites for Posting

  • Ensure the BVTYPE.TXT file has been received from Kasasa and placed on the i:Drive.
  • FLEX recommends posting this file prior to End of Month (EOM) and dividend posting to ensure accurate dividend calculations.

3.2. Determining Worksheet or Posting Run

To determine whether to run a worksheet or directly post the file:

  1. Access the command line in the FLEX system.
  2. Type the command: BV3010C
  3. Press F4.

Recommendation: FLEX strongly recommends running a worksheet (W) prior to posting (P).

3.3. Processing Kasasa ACH Files

Kasasa provides multiple ACH files containing reward transactions. These files are received separately but can be posted together.

3.3.1. Accessing ACH Processing

  1. From the System i Main Menu, navigate to ACH Processing.
  2. Select the Bancvue (Kasasa) case (identified as V: BANCVUE (KASASA)).

3.3.2. Receiving Files

  1. In the ACH Processing screen, click the Transmit button.
  2. The Initiate ACH Transmission window will appear.
  3. Transmission Type:
    • Ach Processor (Case): V – BANCVUE (KASASA)
    • Transmission: Receive ACH Transactions
  4. Transmission Options:
    • IDrive Folder: Enter BANCVUE (or the correct folder name).
    • IDrive File: Select BANCVUE.TXT from the drop-down (or enter the correct file name).
    • Effective Date: Enter the appropriate effective date for the transactions.
    • Post File: Select Don’t Post initially for receiving.
  5. Click Process to bring the file into FLEX.
  6. Repeat this process for any remaining files in the i:Drive folder, as files must be received one at a time.

Note: Reports will generate and store in Document Manager with a ‘V’ appended to the report name. The user data for this report is ACHERRMSV. This report should be blank. If an error message appears, the file was not received properly.

3.3.3. Posting Files

After all files have been successfully received:

  1. In the ACH Processing screen, click the Post button.
  2. The Post ACH window will appear.
  3. Post ACH Options:
    • Effective Date: Verify the effective date.
    • Settlement Date: Enter the settlement date of the file (may differ from the current date).
    • Post File: Select Debits and Credits.
    • Company: Select All Companies.
    • Post Today and Prior Settlement Dates Only: Check this option to post transactions for today and prior settlement dates.
  4. Click Post to process the files.

4. Handling Exceptions

During the initial processing of Kasasa files on FLEX, transactions may appear as exceptions with the reason “Account/Suffix not found in the SHAR or LOAN file.”

4.1. Correcting Exceptions

  1. When an exception occurs, the system will populate the Member Account field.
  2. The user must manually enter the correct Suffix for the member account.
  3. Once the account number and suffix are corrected, the system cross-references this data with previous Kasasa postings. Subsequent postings for the same account will not generate this exception.

5. Recreating Daily History Files

If there is a need to recreate loan and share history files for a previous date:

  1. Access the command line in the FLEX system.
  2. Type the command: BV4001C
  3. Press F4.
  4. Enter the specific date for which you want to recreate the files.

This action will create two files and place them on the i:Drive for retrieval by Kasasa.