Bai2 File Format Wells Fargo
Comma delimited files are a method by which you can manually download account data into many types of spreadsheet applications. Windows Usb Driver Location. Please contact Wells Fargo Online.
Share: BAI2 Balance Reporting Specification The BAI2 file format (preceded by BAI1) was developed by the Bank Administration Institute (BAI) as a cash management balance reporting specification. In 2008, the BAI transferred copyright ownership of the BAI file format to the Accredited Standards Committee X9, Inc.
ASC X9 has developed a next generation standard called the Balance Transaction Reporting Standard (BTRS). The BAI2 specification established a common format for exchanging data. Balance reporting transmissions include data describing hundreds of different types of account activity, ranging from securities transactions to lockbox deposits. Each transaction, summary or balance classification has been assigned a uniform type code.
The type code uniquely identifies the type of activity or balance being reported. Type codes are three-digit numbers used to identify the types of data reported. Codes are either Status, Summary or Detail.
Hi, I'm uploading a Bank statement of format BAI2 which contains information for several accounts for the same bank. The file has trans for 2 accounts. I can load up the files successfully from the both accounts but it what does is that in the 2 accounts it creates 2 'statement'. So in the end I have 4 statements instead of 2. I would expect that if I imported the file from Account 'A' it would only import the transactions in under the 03 section of the file for account 'A' and ignore the transitions in the other 03 section for Account 'B' and creates one bank statement. I would expect that if I imported the file from Account 'B' it would only import the transactions in under the 03 section of the file for account 'B' and ignore the transitions in the other 03 section for Account 'A' and creates one bank statement.
If any one has an ideal how this can be done or if even AX supports it (BAI2 does) that would be great. Below are is a sample of the file that I'm uploading 01,WELLS Fargo,Companyname,1,1,,,2/ 02,Companyname,WELLS Fargo,1,130829,,,2/ 03,Account_A,USD,010,+692434,,,015,+684434,,/ 16,475,8000,,Check Paid 621,,/ 49,8000,3/ 03,Account_B,USD,010,+104196478,,,015,+24305777,,/ 16,175,8000,,Deposit,,/ 16,41,,some sample transaction text,,/ 1,4/ 1,2,9/ 1,1,11/ Thanks, Seamus.