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

Bank Positive Pay File


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:


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