Bank Reconciliation > Bank Reconcilition Reports

Overview: Positive Pay is a form of fraud protection offered by banks. You must set up Positive Pay with your bank before using in the system. After you process a check run (A/P, Payroll, Revenue), the positive pay system will allow you to upload the check register information to your bank. If the cleared check does not match the upload, the bank will not process the check. NOTE: Draft payments or ACH payments that create an E-check number in the Check History will not be included on the Positive Pay file for your bank.

Setup:

1.In order to create the positive pay file in the correct format for your bank, in Export Positive Pay File, select the Format for positive pay

2.Then, in Bank Account, on the MICR Check option tab, you must fill in the Bank account number and the Routing number even if you are using preprinted checks. The positive pay file uses the information that is specified in those fields.

Creating a Positive Pay File:

1.Go to Bank Reconciliation/Reports/Export Positive Pay File

2.Select the Bank Code that the Positive Pay File will be created for.

3.Select the correct Positive Pay Format.

4.Select the Check Number range and, if necessary, the Check/Void Date Range

5.The system will ask you where to save the file, select a location and click on Save.

See Folder Transfer/Compare for more information on saving to a local folder in the cloud environment.

6.The file is ready to send to your bank through your normal Positive Pay bank system.

NOTES

•See Check Register Listing for the steps to run a check register for the positive pay files you create.

•See Alerts for information on automatically uploading the file to the bank.

•Use the drop down list option to view all the bank formats. Use the contains field to search for the positive pay format desired.

•You may notice that some banks have more than one file format name. This is because different branches may have different requirements. You will need to work with your bank to see which format they will accept.

This is not a complete list. The formats below have special notes:

Number	Bank Name	Special Notes
0	General	Uses first 10 characters of the Bank Description found on the Bank Account Maintenance > General tab for the Bank Code being generated.
1	Bank One	Uses first 20 characters of the Bank Description found on the Bank Account Maintenance > General tab for the Bank Code being generated.
2	Wells Fargo-Acct 17-26	Uses first 10 (this refers to using the first 10 characters of the Bank Description found on the Bank Account Maintenance > General tab, in which to get the account number from). See NOTE below.
3	Bank of America	Uses first 12 (this refers to using the first 12 characters of the Bank Description found on the Bank Account Maintenance > General tab, in which to get the account number from).
6	Frost	Uses first 9 (this refers to using the first 9 characters of the Bank Description found on the Bank Account Maintenance > General tab, in which to get the account number from).
10	Amegy Bank	This file does not include voided and reissued checks.
17	Regions Bank	This is also accepted by Plains Capital Bank
28	Huntington	This file does not include voided and reissued checks
46	Wells Fargo-Acct17-31	The account number in this field is 15 characters long and comes from the MICR Check Options > Account Number field.
51	JP Morgan Chase-CSV-7	This is similar to the 13-JP Morgan Chase-CSV-6 except for the number of columns.
60	JP Morgan Chase - CSV-8	This is similar to the 13-JP Morgan Chase-CSV-6 except that for CPE column F should be blank

**NOTE for Formats 2 and 46

Enter a RID to create a $$ADD header record (leave blank to not have one).

Enter a BankID to create a *03 header record.

Export Positive Pay file

Export Positive Pay file