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

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



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