Positive Pay File Formats

• 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 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

Wels 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