BAI-to-Excel file conversion with BAI2Excel™

Treasury Software provides a solution for banking professionals and treasury managers who wish to work with BAI (Bank Administration Institute) 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.

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
·Bank Reference
·Customer Reference
·Text
·BAI Code
·Funds Type
·Distributed: Immediate Availability
·Distributed: 1-Day Availability
·Distributed: > 1-Day Availability


Our award-winning software is easy to use and easy to install.

In addition, we provide:

·Responsive customer support, including personal phone support (optional).
·An established company with a track record of success.
·Affordable and reasonable licensing plans.
·Software that fits your business.
·Highly documented, mature programs with an on-line KnowledgeBase.
·Ease of installation - solutions can be installed at individual workstations.
·Easy and intuitive solutions- We are a Microsoft Certified Partner and fully support exporting to Excel (via csv).

Licensing:

BAI2Excel is available as part of our Bank Reconciliation Software. Click here for information on Bank Reconciliation Pricing and Licensing.

Notes:
·Custom programming is not included. Please contact a representative for a guaranteed fixed price quote.


How to order:

You can order directly through our online store.

Need more information?
Call toll free: 866-226-5732

BAI - Visit BAI.org for file standards

Site Map

Home - Positive Pay - Bank Reconciliation - BAI Conversion - ACH Software