Positive Pay File Formats

JP Morgan Chase Bank

Arvest

Harris Bank

"ATA/AALAS"	"9/17/2014"	196.2	101	N
"AZAR Resources Inc"	"9/17/2014"	2147.09	1000000000	N
"Cultura Technologies"	"9/17/2014"	5000	102	N

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

Mercantile Bank

Check	IssueDate	Payee	Account	Amount
102	9/17/2014	Cultura Technologies	1234567890	5000

Header row
.csv file

US Bank

1234567890	100	10000	9162014	IS	Action Truck Parts
1234567890	101	19620	9172014	IS	ATA/AALAS	ATA Secretary/Treasurer
1234567890	10002	214709	9172014	CN	AZAR Resources Inc	Tempstar Staffing

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)

123456789	1234567890	100	9/16/2014	10000	320	Action Truck Parts
123456789	1234567890	101	9/17/2014	19620	320	ATA/AALAS ATA Secretary/Treasurer
123456789	1234567890	10002	9/17/2014	214709	430	AZAR Resources Inc Tempstar Staffing

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

First Niagra

Account Number	Check Number	Check Amount	Check Date	Vendor Payee Name 1
1475929455	0000008876	000000091914	091916	MAXIM ENVIRONMENTAL
1475929455	0000008862	000000086576	091916	DELL WOOD ENGINEERING
1475929455	0000008825	000001758294	091916	IRWINDALE WOODS LOGISTICAL INC

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