|
BAI-Excel file conversions
Treasury Software provides the solution for banking professionals
and treasury managers who wish to work with BAI (Bank Administration
Institute) and BAI version 2 files in a Microsoft Excel environment.
The BAI format is the most commonly used file in inter-bank communication
of account balance and activity. Recently, it has also become a
popular format for bank-to-customer reporting for those corporate
customers with advanced needs.
1. BAI2Excel™ - Convert BAI files to csv/Excel
FROM
TO
Two comma delimited (csv) files - transactions and summary
Transactions
Summary
BAI2Excel provides an easy to use, affordable utility
to convert BAI files to comma delimited files (csv) which can be
opened in any version of Excel.
This solution converts all of the account activity contained in
the BAI file, and then prepares data in a tabular (row and column)
format, and appends each row with appropriate header information
including date, account number and days to clear (distributed time
frame).
In addition, the system signs the amount column (debit vs. credit)
based on the BAI code, and provides all of the fields associated
with each transaction, such as
· Date
· Amount
· Account Number
· ABA Routing Number
· Bank Reference
· Customer Reference
· Text
· BAI Code
· Funds Type
· Distributed: Immediate Availability
· Distributed: 1-Day Availability
· Distributed: > 1-Day Availability
Buy
BAI2Excel
2. Excel2BAI™ - Convert csv/Excel to BAI Files.
Create BAI Files
Want to originate BAI files? Now you can create BAI files.
Previously only included in the Banker's edition - now included
as a stand alone utility.
Import any or all of the following transactional fields to be included
in the BAI file:
· Date
· Amount
· Account Number
· ABA Routing Number
· Bank Reference
· Customer Reference
· BAI Code
There is no limit as to the number of accounts that are included
in the BAI file.
Buy
Excel2BAI
Need more information?
Give us a call: 866-226-5732
| 
