Wells Fargo Account Reconcilement (Positive Pay) Option
You are looking at an old Manual of pc/MRP,
the Complete MRP Inventory/Accounting Package.
Please click below for
the latest pc/MRP Manual
Please click below to
reach the pc/MRP Main Page
14.18.1 Wells Fargo Account Reconcilement Overview
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
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
- Batch ID (BID) Enter the Batch ID that Wells Fargo assigns
- 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
- 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
- Enter the Start and End
Dates (Wells Fargo's program does not mind if you accidentally send the
same check number again).
- Press the Save Defaults
button to save the above settings as your default settings.
- Press the Generate button
to create the file.
- Log into your Wells Fargo
Internet account and send the file you just generated.
14.18.4 Viewing your
Wells Fargo Account Reconcilement Log
the View Log, will bring up your Wells Fargo account reconcilement log shown
- 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.