BAI File Format Conversion - Treasury Software

Questions? Call us!
(866) 226-5732

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.

1. BAI2Excel™ - Convert BAI formatted files to csv/Excel
FROM

BAI File Conversion

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

BAI File Conversion - BAI2Excel buy now

Want full sample files?
BAI File from Bank
Converted BAI File - transactions
Converted BAI File - summary

2. Excel2BAI™ - Convert csv/Excel to BAI Files.
Create BAI Files

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 Creation - Excel2BAI buy now

Need more information?
Give us a call: 866-226-5732

About Treasury Software
Treasury Software is the leading provider of cash management and electronic payment solutions for businesses. Since our inception in 1999, we have maintained an ongoing commitment to provide secure, intuitive, cost effective solutions that are easy to install and easy to use. Because our development team includes experienced Certified Public Accountants, we understand the unique issues and challenges associated with the treasury management environment.

Microsoft Gold Partner
As part of our Microsoft Gold Certification, our software has been independently tested by Veritest/LionBridge.
Certification incorporates: customer satisfaction surveys, client references, software certification and employee certification and training.

In addition, our commitment to quality and customer support has earned us numerous awards and recognitions including The CPA Software News' Gold Cup Award for product excellence.

BAI File Conversions - Why Choose Us?