Skip to Content
0
Dec 26, 2007 at 06:05 PM

Bank Positive Pay File

181 Views

Has anyone developed a postive pay file export using query. I know how to get a listing of checks for a day but I am trying to figure out how to export the values all as one string with padded zeros. Example of the layout:

Sample line of layout:

10028xxxxxxxxxx00000260912007122000001196000

explanation of layout

10028=control nbr

xxxxxxxxxx=bank account number

0000026091 = check number 26091

20071220 = date of check

00001196000 = value of check in this case 11,960.00

Any help is greatly appreciated