Share this: Twitter Facebook. Like this: Like Loading Related content you might be interested in:. Leave a Reply Cancel reply. Follow :. Search Topics Search for:. Get notified about future blog updates.
Begins File. The file header marks the beginning of a file. It identifies the sender and receiver of the transmission, and it describes the structure of the file. Begins Group. The group header identifies a group of accounts that are from the same originator and includes the same as-of-date and as-of-time. Begins Account. This record identifies the account number and reports activity summary and account status information.
Summary information may be accompanied by an item count and funds availability distribution. Within Account. This record is used for transmission of detail transaction information. Transaction detail may include two reference numbers and a free-form alphanumeric text. A Continuation record is used when data exceed the maximum physical record length, or whenever it is desirable to continue data into an additional record.
Military format ; sender time zone Times are stated in military format through Some processors use to indicate the end of the day. Be prepared to recognize as end-of-day when receiving transmissions. Identification number defined by the sender. The data records in the screenshot above are depicted in the below excel sheet. With different colour coding for various key elements, I shall try to explain what do they mean. The file records with 01, 02 and 03 contain the basic information with regards to Bank Routing No Bank Key.
Statement generation date, Statement date, Bank Account no. The file records with 88 always contain some extra information about the preceding record. In the above screenshot, the records with 88 after the 03 record, contain information about Closing Balance, Total Debits and Total Credits. Each one of these transactions is represented by a unique transaction type.
For example, for Checks Out, for Interest Income, etc. We use these transactions to trigger the various postings in the FI — General Ledger. If some extra information is there about a particular transaction, the data record 16 will follow with a 88 data record See below. Using this information, for example, an incoming check from a customer can be used to clear the invoice.
The records 49, 98, 99 appear at the end. These signify the closure records of the Bank Statement. Visit my Facebook page www.
A crisp document, which is very useful to anyone who is looking to configure EBS and probably also use Search String functionality. Hi Ajay. Thanks for this useful document. In the EBS you used in your example, there's no date field on line 16 but in my case we have a value date appearing on line In a scenario I want to use this date as the document's posting date. Can you please guide where in BAI2 config the mapping of different fields is maintained so that I could try changing that config.
Nice presentation, as usual it is very informative. Good document and got a basic idea about how the BAI file format is. Skip to Content. Ajay Maheshwari. October 20, 2 minute read. What appeared as cumbersome all these years, is actually very interesting and logical To begin with, I would like to start with a very basic topic — Interpreting the BAI2 file. With different colour coding for various key elements, I shall try to explain what do they mean The file records with 01, 02 and 03 contain the basic information with regards to Bank Routing No Bank Key.
We use these transactions to trigger the various postings in the FI — General Ledger If some extra information is there about a particular transaction, the data record 16 will follow with a 88 data record See below.
Using this information, for example, an incoming check from a customer can be used to clear the invoice The records 49, 98, 99 appear at the end. I hope this simple explanation helps you to understand the basics of BAI2 file. Alert Moderator. Alerting is not available for unauthorized users. 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? 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. Want full sample files? Workgroup-Automation includes 5 workstation licenses. Upgrade, Downgrade or Cancel at any time. Monthly fees are guaranteed.
0コメント