Page Comparison

JP Morgan Chase Bank

Arvest

Harris Bank

•  No header row
• .csv file
• Columns: Vendor name, check date, dollar amount, check number, void flag

Mercantile Bank

•  Header row
• .csv file

...

US Bank

•   No  No header row
• .csv file
• Columns: Bank account number, check number, dollar amount, check date, void flag (ISsued, CaNcelled), vendor name, vendor second name

 Wells Fargo Bank (CEO)

•  No header row
• .csv file
• Columns: Bank routing number, bank account number, check number, check date, dollar amount, check status (320=issued; 430= void), vendor name second vendor name

Wachovia Bank

RECONCILIATIONHEADER0000000123456789000000271839100011                          

00012345678900000000100000001000020140916Action Truck Parts                    

00012345678900000000101000001962020140917ATA/AALASATA Secretary/Treasur        

00012345678900000010002000021470920140917AZAR Resources IncTempstar Sta  

•  header row
• .txt file
• Bank account number; check number; dollar amount; check date; vendor name; vendor second name

Wells Fargo

 $$ADD ID= BID=''                              

*0300000000001234567890

000000010009161412345678903200000010000Action Truck Parts

00000010109171412345678903200000019620ATA/AALAS 

00001000209171412345678903700000214709AZAR Resources Inc

•  2 header rows: batch load data; bank account number
• .txt file
• Check number; check date; bank account number; check status (32=issued; 37=void); dollar amount; vendor name

 Wells Fargo ARP

 *03000000000012345678900

000000010009161412345678903200000010000Action Truck Parts

000000010109171412345678903200000019620ATA/AALAS

000001000209171412345678904300000214709AZAR Resources Inc

•  header row
• .txt file
• Check number; check date; bank account number; check status (32=issued; 43=void); dollar amount; vendor name

Wells Fargo ARP Enhanced

...

*03000000000012345678900
00000001000916140000012345678903200000010000Action Truck Parts                                                                                                                                               
00000001010917140000012345678903200000019620ATA/AALAS                                                                                                                                                        
00000100020917140000012345678903200000214709AZAR Resources Inc 

•  header row
• .txt file
• Check number; check date; bank account number; check status (32=issued; 43=void); dollar amount; vendor name

COBANK

C999001898765434 RA 00000095100001812015051016

Image Added

First Niagra

•  No header row
• .ASCII file
• Columns: bank account number, check number, dollar amount, check date,Payee name

Attached are positive pay formats files as of 3.13.58.0 version of ERP. The file names represent the format files.

Image Added