Wells Fargo Account Reconcilement (Positive Pay) Option

14.18.1 Wells Fargo Account Reconcilement Overview

pc/MRP Versions 7.54D and higher contain the Wells Fargo account reconcilement (Positive Pay) option. This option allows companies to create a file containing all checks written during the date range selected. The file, named Batchxxx.arp, can then be sent over the internet to Wells Fargo. If you implement this program with Wells Fargo, Wells Fargo will only cash checks that have been registered via one of your Batchxxx.arp files. If a check is not in any of your Batchxxx.arp files or the amount of the check differs from the registered check, Wells Fargo will call your company, asking if you wish them to cash the check

14.18.2 Wells Fargo Account Reconcilement Settings

Prior to sending your first batch, you must enter your batch settings as follows:

Last Batch Number pc/MRP will automatically increment the number, you can however start at a number higher than 1. If you leave the Last Batch Number at 0 when you generate your first batch, pc/MRP will automatically name the batch file "Batch1.ARP".

Remote ID (RID) Enter the Remote ID that Wells Fargo assigns your company.

Batch ID (BID) Enter the Batch ID that Wells Fargo assigns your company.

Export File Path Press the ellipsis button to the right of the Export File Path text box to locate the drive and directory you would like the Batchxxx.arp to be deposited into. The path displayed within the field will be relative to the pc/MRP main folder. An empty field means that the files will be created within the pcmrpw folder.

Request a Confirmation File Check the Request a Confirmation File check box if you wish Wells Fargo to send back a confirmation file containing the check numbers included in your batch.

14.18.3 Creating a Wells Fargo Account Reconcilement Batch File

1. If you have not entered the pc/MRP chart of account number for your company's checking account, do so now by pressing the add button. You can enter more than one Wells Fargo Bank account. If you have entered the Wells Fargo Account(s), select the accounts you wish to create a batch file for by checking the respective check boxes.

2. Enter the Start and End Dates (Wells Fargo's program does not mind if you accidentally send the same check number again).

3. Press the Save Defaults button to save the above settings as your default settings.

4. Press the Generate button to create the file.

5. Log into your Wells Fargo Internet account and send the file you just generated.

14.18.4 Viewing your Wells Fargo Account Reconcilement Log

Pressing the View Log, will bring up your Wells Fargo account reconcilement log shown above.

· The first line of any batch contains the word "Start" followed by the batch number, the starting date and ending date.

· Had you selected a confirmation file the next line would contain your confirmation record (none shown on the above example)

· The second and third lines in the above example contain your sign-on and header records.

The detail records would consist of the following:

· Characters 1 through 10 contain the check number (0000007977)

· Characters 11 through 16 contain the check date (01/15/02).

· Characters 17 through 26 contain the bank account number.

· Characters 30 through 39 contains the check amt (0000006411 = $64.11).

To view a specific batch number or check number, open up the log file, select Search and enter the batch number or check number.  The individual batch files themselves can be viewed using Windows Notepad.