Skip to Content
Author's profile photo Ajay Maheshwari

EBS – How to interpret a BAI2 file

Hello Reader,

I would like to share the knowledge I gained around Electronic Bank Statement (aka EBS) processing. After avoiding it for several years, finally the time turned on me. 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. There are many other prevalent formats for EBS like MT940 / Multi Cash Format, etc.

The BAI2 file is a plain text file (.TXT Format), which contains values / texts one after the other. Hence, interpreting that becomes a bit tedious. Usually, one should request a BAI Statement Guide from the Bank / End Client to interpret the BAI2 file. A Sample BAI2 Statement Guide is attached at the end of this document

For now, I will make an attempt to explain what and how does a BAI2 file contain. Other Bank statement formats (MT940, etc.) also have a similar science surrounding them

This is how a BAI2 bank statement file looks like.

/wp-content/uploads/2015/10/1_814333.jpg

With the help of colour coding, lets understand how to interpret the key elements in the above file.

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

/wp-content/uploads/2015/10/2_814362.jpg

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., Opening Balance, etc

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

The file records beginning with 16 contain the transactional information – Checks In / Out, Wires In / Out, Bank Charges, Bank Interest, etc. Each one of these transactions is represented by a unique transaction type. For example, 475 for Checks Out, 354 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). The 88 record usually serves the purpose of “Note to Payee” wherein Invoice Reference or some Unique reference about the transaction is stored. Using this information, for example, an incoming check from a customer can be used to clear the invoice

/wp-content/uploads/2015/10/3_814363.jpg

The records 49, 98, 99 appear at the end. These signify the closure records of the Bank Statement.

I hope this simple explanation helps you to understand the basics of BAI2 file.

The link to download the BAI2 Statement Guide is here: BAI2 File Format Guide 091208.doc – Google Drive

Please do share your feedback on the same and we can improve it

SAP ERP Financials – Controlling SAP ERP Financials  – Asset Accounting

Regards

Ajay Maheshwari

Visit my Facebook page www.facebook.com/madaboutsap

Assigned tags

      30 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thank you Ajay, Wonderful.

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer
      Blog Post Author

      Thanks for the feedback Sam

      Author's profile photo Former Member
      Former Member

      Thank you!

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer
      Blog Post Author

      Thanks Atul

      Author's profile photo Former Member
      Former Member

      Thanks for sharing the knowledge sir.

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer
      Blog Post Author

      you are welcome Anurag!

      Author's profile photo Santanu Das
      Santanu Das

      Thanks Ajay.

      Precise & Crisp.

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer
      Blog Post Author

      Thanks Santanu

      Author's profile photo Sanil Bhandari
      Sanil Bhandari

      Hi Ajay

      A crisp document, which is very useful to anyone who is looking to configure EBS and probably also use Search String functionality.

      Excellent as usual 😎

      Regards

      Sanil

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer
      Blog Post Author

      Thanks Sanil for the feedback

      Author's profile photo Mukthar Ali Ahamed N
      Mukthar Ali Ahamed N

      Thanks Ajay..It is very useful.

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer
      Blog Post Author

      Thanks Mukhtar and Salaam!!

      Author's profile photo Vijay V
      Vijay V

      Hi Ajay,

      Very good document to understand BAI2 file format. Thanks for sharing, really appreciate.

      Regards

      Vijay

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer
      Blog Post Author

      Thanks Vijay

      Author's profile photo Moazzam Mubarak
      Moazzam Mubarak

      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 16. 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.

      Thanks

      Moazzam

      Author's profile photo Former Member
      Former Member

      Great piece of work as usual.

      I am highly obliged to you for your knowledge along with great sharing passion.

      Thanks a lot

      Regards

      Pankaj Agrawal

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer
      Blog Post Author

      Thanks Pankaj for the feedback

      Author's profile photo Manjunath v
      Manjunath v

      Thank you Ajay for sharing.

      Author's profile photo Former Member
      Former Member

      Hi Ajay,

      Nice document. thanks for sharing the knowledge.

      Regards

      Karthik

      Author's profile photo Former Member
      Former Member

      Ajay

      In fact  every concept you share carries/adds up to concrete learning curve, here we go - 5 stars, This particular post gave more clarity on BAI2- Thanks for being so kind

      Author's profile photo Former Member
      Former Member

      Ajay,

      Nice presentation, as usual it is very informative.

      Regards,

      Ravi

      Author's profile photo venkatakasi Reddy Polu
      venkatakasi Reddy Polu

      Thank u Ajay for sharing ur knowledge wit us.

      Author's profile photo Sagar Reddy Kunta
      Sagar Reddy Kunta

      Thanks for sharing the information. 🙂

      Author's profile photo Former Member
      Former Member

      Hi Ajay,

      Can you teach me how to convert that txt format to this BAI format?

      Thank you.

      Regards,

      Sharon

      Author's profile photo Suresh Vemuru
      Suresh Vemuru

      Nice Ajay,

      Is there any blog like this for MT940?

      Regards
      Suresh

      Author's profile photo Former Member
      Former Member

      Wonderful explanation by Ajay. Thanks sir.

       

      Author's profile photo Former Member
      Former Member

       

      Thank you Ajay, It's really helpful.

      Author's profile photo Daniel Kokkiligadda
      Daniel Kokkiligadda

      Please tell me about lock box concept please take over session sir my humbled request

      Author's profile photo Suresh Kumar
      Suresh Kumar

      Hi Ajay,

       

      Good document and got a basic idea about how the BAI file format is. Could you please help me to understand the EBS and how can we do practise using FF_5 through IDES. Are we able to try for results in EBS in IDES?.

      Author's profile photo Ranjan Kumar Nahak
      Ranjan Kumar Nahak

      Nice documents..