BAI to 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.
Looking to create BAI2 files? See BAI File Creator
BAI-2-Excel - Convert BAI formatted 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 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
BAI File Format Specifications
Includes license and support.
| Desktop | |
|
BAI-2-Excel - convert BAI and BAI2 formatted files. |
$29.95/mo |
In-place licensing - No need to re-install software
If you've already installed/configured our software, there's no need to re-install!
Simply enter the license codes - and you're all set.
If you're unsatisfied with our solutions --for any reason-- within the first 30 days, we will return your full purchase price. No small print. No questions asked. Your unconditional satisfaction is our guarantee.
Apply 100% of your license fees to a platform or edition upgrade within 12 months of your system purchase - or as long as you maintain a support contract.
Subscription licenses includes full phone support throughout.
Optional extended annual support for perpetual licenses: Desktop - $99; All other versions - approximates 18.5% of system price (see on-line store for exact price)
Immediate Electronic Delivery of software. Licenses at time of payment. There are no shipping or handling charges.
A discount is available when purchasing more than one program ( please contact sales).
Customer Billing Portal
(866) 226-5732
