The setup of the specs for the Positive Pay file is in Accounts Payable – Setup - A/P Preferences

 

You may add blank spaces where necessary.  This example shows a blank space of two characters.

 

You may add fixed characters before or after a defined column.  Ex. Add four zeros before the check#.

 

 

These positions are not the positions on the text file but are used to define the columns.  Ex. If the Bank Account# is 10 positions in the Accounting System but the bank format requires 12 positions, add two zeros before the bank account#.

 

 

Enter the path\ filename to be defaulted on the screen of the Create Positive Pay option.

 

 

 

 

 

 

 

Void Code:  Enter the void code required by the bank.  This example shows the bank format requires a code of “2” if a check was voided (column#2). 

 

Remove all spaces in bank account#:  Check this if your bank account# in SGA has spaces in between the numbers to separate the divisions of it, but the bank requires it to be one complete number without spaces.

 

Include decimal in amount:  Includes a decimal point to separate cents in the amount.

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 


You may select a range of check numbers and/or check dates.

 

The path\filename that is defaulted here was part of the setup as shown above.   You may change it here if you wish.

 

When OK is clicked, the Positive Pay file will be created.

 
 

 

 

 

 

 


The following file was created from the above specs.

 

 

006100024032   000001016200000318565701192004

006100024032   000001016300000098505001192004

0061000240322  000001016400000005595401192004

006100024032   000002292400000001118801192004

006100024032   000002292500000046312501192004

006100024032   000002292600000004375401192004

006100024032   000002292700000014741901192004

006100024032   000002292800000009519001192004

006100024032   000002292900000013000001192004

006100024032   000002293000000011900001192004

006100024032   000002293100000440948801192004

 

Pos 1-12               = Bank Account#

Pos 13                   = Void Indicator

Pos 14-15             = Blank

Pos 16-25             = Check# (right justified/zero filled)

Pos 26-37             = Amount (right justified/zero filled)

Pos 38-43             = Check date (mm/dd/yyyy)