Bank Match Method #1

Setting Parameters

Note: These instructions are for Credit Unions that do not receive a file from their state and send all their accounts to the state over the Internet.

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

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: Your State
   
   Note: If the State Code is "PA", the output file is ALLACCTS.TXT. The output file name for all other states is BMATCH.
   
   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 encrypted 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: All Accounts Method
   
   Note: Use All Accounts Method when the State does not send the Credit Union a file.
   
   Matched Accounts: Report All Accounts
   
   
   
   Test File: Do Not Create Test File
   
   Send Balances: Send Balances
   
   Account Status: Do Not Send Account Status
   
   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. You will be prompted with a message box that reads, "Continue with Bank Match File Creation?" Click Yes.
   
   
   
   
3. The Create Bank Match File dialog box will come up. Select either Create All Accounts File or Create Update Account File.
   
   
   
   Create All Accounts File - This will create a file containing ALL your members each time you run it. Check with your State FIFM Department if they want all accounts each time. As of the date of this document, MA, MD, NJ, PA and KY request All Accounts each time you create the file.
   
   OR
   
   Create Update Accounts File - This will create a file with only changed members since the last time the program was run. This method is normally used for all periods other than the First Period of the year. Example: The first time you run it each year, you would use the Create All Accounts File and then each subsequent period you would Create Update Account File.
   
   
4. 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. If you are located in PA, the file name will be ALLACCTS.TXT. In all other states, the file name will be BMATCH or BMATCH.ZIP.

You have now completed this tutorial.