Bank Match Method #2

Receive Bank Match File From the State

Note: These instructions are for Credit Unions that receive their Bank Match (FIDM) file from TIER TECHNOLOGIES INC. over the Internet and then upload the BMATCH file they created back to them. This method is predominately used in Ohio.

Good Idea: Before you begin, create a BMATCH folder on your local C drive or your network drive (H) for the files.

Receive Your Bank Match File from the State

Follow these directions to receive the bank match file.

1. Connect to the Internet and log into http://fidmalliance.tier.com.
   
   
2. Enter the Username and Password provided by Tier Technologies.
   
   
   
   
3. Enter your organization's TIN # and select the Submit button.
   
   
4. Use Method 2 - Match Accounts Method - Download and Upload.
   
   
5. Select Download which will take you to a new window.
   
   
6. Click Download. Your browser will prompt you to save the file. Locate your BMATCH Directory on your "C" or "H" drive and click Save.
   
   
7. You may close the Internet browser.
   
   
8. Follow the instructions from Tier Technologies to extract the file.

You completed the first session of this tutorial.

Setting the Parameters:

Follow these directions to set the parameters for the Bank Match Program.

1. From the Master Menu, select 3 - Reports Menu, 6 - Additional Reports Menu, D - Regulatory Reports Menu and 2 - Bank Match Creation.
   
   
   
   
2. Review the Parameters. Here is some recommendations for setting your parameters.
   
   
   
   Sort Key: Control/Account #
   
   Option Selected: All Control Groups
   
   Print Detail: Print Totals Only on Report
   
   
   
   State Code: OH - Ohio
   
   Drive Information:
   
   Note: The files are created on the hard drive. The Drive Information only applies when you copy the files created to another drive.
   
   Drive Letter: A:\
   
   Drive Type: 5 = Single File or 6 = Single File (WinZip)
   
   Encryption Password: Only applies when you select Drive Type 6 = Single File (WinZip) above.
   
   If you leave the encryption field blank, no encryption will take place and no password is needed to unzip the file.
   
   If you are using an old version of WinZip and you enter an Encryption Password, the processor will need to enter the same Encryption Password to unzip the file.
   
   If you are using WinZip Version 9.0 or greater and you enter an Encryption Password, WinZip will encypt the data using AES 128 encryption and the processor will need to enter the same Encryption Password to unzip the file.
   
   
   
   Single File Copy Path: Enter the Drive Letter and the directory name where you want the Bank Match File to be created. Example: C:\BMATCH\. You can use the Browse button (...) to locate the directory.
   
   
   
   Click the Match Method/Other Options tab.
   
   
   
   
   
   Match Method: Match Accounts Method - Variable
   
   Enter the File Name by clicking on the browse button and finding the file you need. Example: C:\BMATCH\OHMMDDYY.TXT.
   
   
   
   Record Separators: Match File does not contains Separators
   
   Matched Accounts: Report Only the Matched Accounts
   
   
   
   Test File: Do Not Create Test File
   
   Send Balances: Send Balances
   
   Account Status: Send Account Status - Opened/Closed
   
   Negative Balance Indicator: Put Negative Sign After Number
   
   

You have now set up your parameters for this program.

Running the Bank Match Program

Delete Old Files from System

Follow these steps to delete old bank match files from your system.

1. Click Create/Disk Options menu and select Delete All Magnetic Files from Hard Drive.
   
   
   
   
2. You will be prompted with a message box that reads, "Are you sure you want to continue with the Bank Match Deletion Process?". Click Yes.
   
   
   
   
3. When the deletion process is complete, click OK on the message box.
   
   

Create Bank Match Media File

1. Click the Create/Disk Options menu and select Create Files.
   
   
   
   
2. Click OK when reach the Process Completed message box.
   
   

Print Report (Optional)

Note: If you do not print this report now, you will lose the ability to print it later. This report prints a list of all accounts for every member. It can be very long depending on the number of members in your Credit Union.

Follow these directions to print the Bank Match Report.

1. Click Reports and select Print C.U. Bank Match Report.
   
   
   
   
2. Click OK on the Report Printed message box.
   
   
   
   Note: If you spooled the report, click Yes to view the spooled report when the program completes.
   
   

Copy Bank Match Files to Disk

Follow these directions to copy the bank match files to a disk.

1. Click Create/Disk Options menu and select Copy Bank Match Files to Disk.
   
   
   
   
2. On the Copy Single File prompt, click Yes.
   
   
   
   Note: If you have selected a different Drive Type than Single File, you will prompted to enter diskettes. Based on the size of the drive when you create the file, you will be asked for a certain number of disks. Click Yes on the prompt below and follow the steps that come up by the way of message boxes.
   
   

The file is now available to be attached to your email. It should be located in the BMATCH directory of your "C" or "H" drive. The file name will be BMATCH or BMATCH.ZIP.

Follow the instructions from Tier Technologies, Inc to upload the file.

You have now completed this tutorial.