|
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 file format version 2 files in a Microsoft Excel
environment.
The BAI file 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.
TO
Two comma delimited (csv) files - transactions and summary
Transactions
Summary
BAI2Excel provides an easy to use, affordable utility
to convert BAI format 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 |
· BAI Code |
| · Amount |
· Text |
| · Account Number |
· Funds Type |
| · ABA Routing Number |
· Distributed: Immediate Availability |
| · Bank Reference |
· Distributed: 1-Day Availability |
| · Customer Reference |
· Distributed: > 1-Day Availability |
Want full sample files?
BAI File
from Bank
Converted
BAI File - transactions
Converted
BAI File - summary
Want to originate BAI files? Now you can create BAI formatted 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 format:
| · Date |
· Bank Reference |
| · Amount |
· Customer Reference |
| · Account Number |
· BAI Code |
| · ABA Routing Number |
|
There is no limit as to the number of accounts that are included
in the BAI file.
BAI File Conversions - Why Choose Us?
BAI
File Creation - Excel2BAI?: buy now
Need more information? Give us a call: 866-226-5732
| 
