The system has the capability of creating a positive payment file (by Running Report Positive Pay) that would be forwarded to your bank to enable them to confirm the validity of the checks after they have been printed. A registry entry is required to specify the account number and security code designated by the financial institution your checks are drawn on.
Both system and manual checks (recorded in the AP Journal) will be included in the Positive Pay report, as will live PR Checks.
Testing Your Registry Entries
The system does not verify the validity of registry entries. Be sure to test your registry entries after completing them to verify that they are functioning correctly.
Setting Values are Uppercase-Lowercase Sensitive:
The Setting Value is case-sensitive: be sure that you enter the value exactly as specified in the documentation. If the documentation specifies a value of true, do NOT enter True or TRUE.
Id: sys-positive-pay-glaccount-glentity
If more than one report will be produced, the Id must include the GL Account (and, optionally, the GL Entity combination) this file will be created for. Note that even if you do not specify an entity, a dash must follow the GL Account Id. The GL Account and Entity (if applicable) this should be the same combination that you enter when running checks. If your checks are run against multiple GL Account/Entity combinations, a registry entry should be created for each one for which positive pay reporting is desired.
Name:
Briefly describes this entry. This field is optional but highly recommended if your firm is producing positive pay reports for multiple branches or operating companies.
Setting Key: accountno Setting Value: accountnumber
where accountnumber is replaced by the number of the bank account at your financial institution.
Setting Key: securitycode Setting Value: security_code_from_bank
where security_code_from_bank is replaced by the code specified by your bank. Not all banks require a security code.
Setting Key: filename Setting Value: yourfilename^date^^time^.ext
The filename format should be used if multiple branches are running this report. Typically, the extension is set to txt. The file will be created in the working directory where the SAM Pro executable v.exe is running. If you do not use this option, the system will prompt you to select a name and directory for this file.
The ^date^ and ^time^ tokens enable you to automatically imbed the date and time the file is run. This will prevent existing reports from being overwritten.
Example: filename=mypositivepay^date^^time^.txt
Setting Key: format Setting Value: formatname
We currently support Fleet Maine, Mellon, WellsFargo, NationalCity, Bank of America, Harris, and Frost.
BBT is supported in Version 9.1 and above.
Setting Key: Format Setting Value: WellsFargo
The following additional registry options are required for positive pay reporting with Wells Fargo:
Setting Key: RID Setting Value: AAAAAAAA
Eight characters, uppercase alphanumeric, as specified by your bank.
Setting Key: BankId Setting Value: #####
5 numeric characters, as specified by your bank.
Setting Key: BatchId Setting Value: ’XXXXXX’
Must begin and end with a single quote. The other characters must be uppercase alphabetic.
This registry supports a custom layout requested by a specific SAMPro user.
Id: sys-positive-pay
Setting Key: Format Setting Value: WellsFargo2
Setting Key: AccountNo Setting Value: as provided by the bank
Setting Key: BatchId Setting Value: format as provided by the bank
Setting Key: filename Setting Value: yourfilename^date^^time^.cvs
The filename format should be used if multiple branches are running this report. The filename should be set to .csv for Wells Fargo2. The file will be created in the working directory where the SAM Pro executable v.exe is running. If you do not use this option, the system will prompt you to select a name and directory for this file.
The ^date^ and ^time^ tokens enable you to automatically imbed the date and time the file is run. This will prevent existing reports from being overwritten.
The following additional registry option is required for positive pay reporting with Mellon:
Setting Key: CompanyName Setting Value: AAAAAAAAAA
Ten characters, as specified by your bank.
The sys-positive-pay registry entry needs to contain the following lines for FifthThird Bank:
Setting Key: Format Setting Value: FifthThird
Setting Key: AccountNo Setting Value: 10 digit account number
Setting Key: BankId Setting Value: 3 digit bank id
The following registry options are is required for positive pay reporting with Bank of America:
Setting Key: Format Setting Value: BankOfAmerica
Setting Key: AccountNo Setting Value: #######
Note that the Account Number should contain 7 digits as specified by the bank.
This release supports Bank Of America Positive Pay Reporting w/ Payee Information. This functionality is enabled via the following registry:
Id: sys-positive-pay
Setting Key: Format Setting Value: BankOfAmericaPayee
The AccountNo and BatchId registry options are also required when this Format is specified.
This release adds Positive Pay reporting for RBC (Royal Bank of Canada). The following registry entries are required:
Id: sys-positive-pay-glaccount-glentity
If more than one report will be produced, the Id must include the GL Account (and, optionally, the GL Entity combination) this file will be created for. Note that even if you do not specify an entity, a dash must follow the GL Account Id.
Setting Key: Format Setting Value: RBC
This registry is required for RBC positive pay. The Check Reference Name is included in the Positive Pay file. The following additional registry options are required for positive pay reporting with Royal Bank of Canada.
Setting Key: RID Setting Value: TransitBatchNo
Enter the Transit/Batch Numbers as specified by your bank. This field defines the Transit/Batch Number (Referenced in Batch Header Record, Transaction Record, Batch Trailer Record).
Setting Key: BatchId Setting Value: ClientNumber
Your Client Number as specified by RBC (Referenced in File Header Record).
Setting Key: AccountNo Setting Value: AccountNumber
Where AccountNumber is replaced by the number of the bank account at your financial institution. This field is referenced in the Batch Header Record, Transaction Record and Batch Trailer Record.
Setting Key: TestFileHeader Setting Value: StringForTestHeader
Enter the StringForTestHeader exactly as specified by RBC in the Setting Value. The system will use the TestFileHeader if the Test box on Report Positive Pay is checked.
Setting Key: ProdFileHeader Setting Value: StringForProdHeader
Enter the StringForProdHeader exactly as specified by RBC in the Setting Value. The system will use the ProdFileHeader setting if the Test box on Report Positive Pay is clear.
Required options for sys-positive-pay for Harris Bank:
Setting Key: Format Setting Value: Harris
Setting Key: AccountNo Setting Value: #######
Note: the Account number can be up to 7 digits.
Required options for sys-positive-pay for Frost National:
Setting Key: Format Setting Value: FrostNational
Setting Key: AccountNo Setting Value: #########
Note: account number must be 9 digits as specified by bank.
Required options for sys-positive-pay
Setting Key: Format Setting Value: PNC
Setting Key: AccountNo Setting Value: ##########
Note: account number must be 10 digits as specified by bank.
Modifications made to skip check number 0 and report amount field as decimal field with decimal point are also included in this release.
Required options for sys-positive-pay:
Setting Key: Format Setting Value: SunTrust
Setting Key: AccountNo Setting Value: up to 13 digit number
Note: account number may be up to 13 digits as specified by bank.
Required options for sys-positive-pay for Bank One::
Setting Key: Format Setting Value: BankOne
The sys-positive-pay registry entry needs to contain the following lines:
Setting Key: Format Setting Value: JPMorganChase
Setting Key: AccountNo Setting Value: Account # supplied by JPMorgan Chase
The account number may contain a maximum of 20 digits.
The sys-positive-pay registry entry needs to contain the following lines:
Setting Key: Format Setting Value: WilmingtonTrust
Setting Key: AccountNo Setting Value: up to 10 digit account #
Setting Key: FileName Setting Value: ARPDDPRxxxx.TXT
where "xxxx" represents the last 4 digits of the account number.
Setting Key: Format Setting Value: PeoplesUnited
Setting Key: AccountNo Setting Value: as provided by the bank
Setting Key: FileName Setting Value: AccountNo.flf
Where AccountNo is replaced by the number provided by the bank, followed by the .flf extension.
The following registry options are required:
Setting Key: Format Setting Value: DollarBank
Setting Key: AccountNo Setting Value: as provided by the bank
The filename registry is optional. If you do not use this option, the system will prompt you to select a name and directory for this file.
The following registry options are required:
Id: sys-positive-pay
Setting Key: Format Setting Value: AnchorBank
Setting Key: AccountNo Setting Value: as provided by the bank
The filename registry is optional. If you do not use this option, the system will prompt you to select a name and directory for this file.
The following registry options are required:
Id: sys-positive-pay
Setting Key: Format Setting Value: BBT
Setting Key: AccountNo Setting Value: as provided by the bank
The filename registry is optional. If you do not use this option, the system will prompt you to select a name and directory for this file.