on 07-09-2015 2:18 AM
fHi All,
I want to import bank statement in to byd system. From our bank we receiving in .CSV format. But system is allowing only BAI2 format to upload . My problem is How can we upload .csv file ? or How we can convert .csv file format to BAI2 file format
Thanks
Vijay
Hi Vijay,
SAP offers a variety of predefined national and international formats for electronic bank statements including MT940, BAI2 etc.
If you still want to add another format then those which we provided you can still do it through the Software Development Toolkit (SDK) which offers the possibility to implement the corresponding formats
Thanks
Lokesh Sharma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sukrutha,
Please refer to the help documents
In the help , we mention, that beyond what is offered in BAI2 , if you lockbox processor or bank has further specification , then please report an incident.
Also please find the below Lockbox specifications.
Format Description BAI2 – Lockbox
TABle of Contents
1 File Record details. 3
Closing notes: 11
This record type marks the beginning of the data and identifies both the source and destination of all data contained therein.
Record 1: Header record | ||||||
| FIELDNAME | POSITION | LENGTH | TYPE | FIELD DESCRIPTION | FIX/ |
1 | Record type indicator | 1 | 1 | N | "1" | F |
2 | Priority code | 2-3 | 2 | N | “01” | F |
3 | Customer’s account number | 4-13 | 10 | A | The item is the immediate destination for the Lockbox. This will contain up to 10 characters (use blank spaces to fill up excess space if less than 10 characters exist in this item). Most customers use left-justified, blank-padded right format | V |
4 | Bank Transit Routing number | 14-23 | 10 | A | The next item is the origin of the Transmission – transit routing. This item may contain up to 10 characters (again filling up all ten characters/spaces). Most customers will use left-justified, blank-padded right format | V |
5 | File Date | 24-29 | 6 | A | YYMMDD Deposit date | V |
6 | File time | 30-33 | 4 | A | HHMM Transmission Time | V |
7 | Filler | 34-80 | 47 | A | SPACE | F |
Elena Danielikova
This record type identifies the purpose, content and physical characteristics of the data. There is only one service record per transmission data set, and this record remains in effect until the end of transmission. The record 2 is not a mandatory record for lockbox importing. Some banks will utilize a record 2, others will not. Sometimes the information contained within this record will not adhere to the ‘proper’ definition, but rather be a restatement of the Record 1.
Record 2: Detail Header record | ||||||
| FIELDNAME | POSITION | LENGTH | TYPE | FIELD DESCRIPTION | FIX/ |
1 | Record type indicator | 1 | 1 | N | "2": record type | F |
2 | Customer’s account number | 2-11 | 10 | A | Ultimate destination: The item is the lockbox Destination / Origin reference code. | V |
3 | Bank Transit Routing number | 12-21 | 10 | A | The next item is the origin of the Transmission – transit routing. This item may contain up to 10 characters (again filling up all ten characters/spaces). Most customers will use left-justified, blank-padded right format | V |
4 | Reference Code | 22-31 | 10 | A | ‘0000000000’ (not used) | V |
5 | Service type | 32-34 | 3 | A | ‘400’ (not used) | V |
6 | Record size | 35-37 | 3 | A | ‘080’ (not used) | V |
7 | Blocking Factor | 38-41 | 4 | A | ‘0080’ (not used) | V |
8 | Format Code | 42 | 1 | A | ‘2’ (not used) | V |
9 | Filler | 43-80 | 38 | A | SPACE |
This record is used to reduce the size of ensuing detail records by carrying the required information that is common to all the detail records it precedes for a given deposit site.
Record 5: Detail Header record | ||||||
| FIELDNAME | POSITION | LENGTH | TYPE | FIELD DESCRIPTION | FIX/ |
1 | Record type indicator | 1 | 1 | N | "5": There can be many batches in a lockbox transmission. If there are four batches, there will be four 5 Records. | F |
2 | Batch Number | 2-4 | 3 | N | Batch Number | V |
3 | Batch Item Number | 5-7 | 3 | N | Batch Item Number | V |
4 | Lockbox Number | 8-14 | 7 | A | Most customers prefer to have the number left-justified and blank-padded right. However, the bank may require that you include significant ‘leading zeros’ if that is part of their own internal lockbox numbering scheme. | V |
5 | Deposit Date | 15-20 | 6 | A | YYMMDD | V |
6 | Customer Account number | 21-30 | 10 | A | Ultimate destination: Most customers will use left-justification and blank-padding right. | V |
7 | Bank Transit Routing Number | 31-40 | 10 | A | Origin code: Left adjusted and blank-padding right | V |
8 | Filler | 41-80 | 40 | A | Not used |
This record carries the data belonging to one remittance transaction. This record does not contain detail information common to all transactions.
Record 6: Detail record | ||||||
| FIELDNAME | POSITION | LENGTH | TYPE | FIELD DESCRIPTION | FIX/ |
1 | Record type indicator | 1 | 1 | N | "6": Record Type 6 can appear numerous times in the Lockbox file or in each batch, but only once per check. A new 6 Record marks the start of a new item number. Record 6 is the “Detail Record” which applies to a particular check in the Lockbox. | F |
2 | Batch number | 2-4 | 3 | N | The bank sets the rules for how a batch is defined. For example, some banks will deliver up to a maximum of 50 checks in one batch. If there are 51 checks in a lockbox, thus there would be at least 2 batches. | V |
3 | Batch Number Item | 5-7 | 3 | N | This will contain up to 3 characters (and must fill all 3 spaces). | V |
4 | Remittance Amount | 8-17 | 10 | N | This item will use 10 characters/spaces (use zeros if necessary in front of the amount). | V |
5 | Remitter Identifier | 18-26 | 9 | A | Transit Routing No. | V |
6 | Remitter Identifier | 27-36 | 10 | A | Account Number (10 characters / spaces). In the event that account numbers are less than 10 digits, customers will use left-justification and blank-padding right. | V |
7 | Check number | 37-45 | 9 | A | If the customer’s check number is greater than 9 characters, then customers will request the last 9 characters of the check number in this field. | V |
8 | Data Element for the Article | 46-80 | 35 | A | Not to be used | V |
For every bank transfer one This section contains all software requirements on a detailed level which is sufficient to serve as a basis for the later design work, and for tests verifying that the system fulfills its requirements.
At a minimum, these software requirements should include a description of every input into the system, of every output from the system, and of all functions performed by the system in response to an input or in support of an output in the sense of business motivated purposes.
This record provides a means of handling multi-invoice transactions. If a transaction contains one check for five or more invoices, this record is used to accommodate this additional data.
Record 4: Item record | ||||||
| FIELDNAME | POSITION | LENGTH | TYPE | FIELD DESCRIPTION | FIX/ |
1 | Record type indicator | 1 | 1 | N | "4": Record Type 4 can appear numerous times in the Lockbox file. Record 4 is the “Item Record” and it is used to hold one invoice each. . | F |
2 | Batch number | 2-4 | 3 | N | V | |
3 | Batch Item number | 5-7 | 3 | N | V | |
4 | Overflow type | 8-8 | 1 | A | In case, that the preceding record is a ‘4 record’, it contains 4, if the preceding record is of type 6, then there is a 6. | V |
5 | Sequence number | 9-10 | 2 | A | V | |
6 | End Indicator | 10-10 | 1 | A | A ‘9’ indicates the last record of a Lockbox (1 space). | V |
7 | Invoice numbers | 11-25 | 15 | A | Only 1 invoice number is placed into each 4 Record. The best field format convention would be to use left-justification, blank-padding right for the invoice number (as shown in the Record 4 above). | V |
8 | Payment amount per invoice | 26-35 | 10 | N | With leading zeros | V |
9 | Deduction amount per invoice | 36-45 | 10 | N | With leading zeros | V |
10 | External Reason code of the payment | 46-75 | 30 | A | Up to the next 30 character spaces are available for short text. They may be left blank if desired. | V |
This record marks the end of a batch of detail records and is used for balance and control purposes. Note that each batch has a unique, identifying set of sequential batch and item numbers.
Record 7: Batch Total record | ||||||
| FIELDNAME | POSITION | LENGTH | TYPE | FIELD DESCRIPTION | FIX/ |
1 | Record type indicator | 1 | 1 | N | "7": Record Type 7 appears only once per batch in the Lockbox file. Record 7 is the “Batch Total Record” which signifies the end of the batch within the lockbox. If you have five batches in a lockbox, you will have five 7 Records. | F |
2 | Batch number | 2-4 | 3 | N | Batch number | V |
3 | Batch Item number | 5-7 | 3 | N | Batch number item | V |
4 | Lockbox number | 8-14 | 7 | N | Customers will often use a left-justified and blank-padded right value. | V |
5 | Lockbox deposit date | 15-20 | 6 | A | YYMMDD | V |
6 | Number of remittances indicator | 21-23 | 3 | N | This should change based on the number of remittances in the lockbox file. | V |
7 | Remittance Dollar Total | 24-33 | 10 | N | It is filled with spaces or zeros to take up space. These items should be changed to reflect the batch totals from the checks on the 6 Records in the lockbox | V |
8 | Filler | 34-80 | 47 | A |
This record marks the end of all batches for a given lockbox and is used to balance all detail batches to the lockbox. The last service total record also contains the daily cumulative control information.
Record 8: Service Total record | ||||||
| FIELDNAME | POSITION | LENGTH | TYPE | FIELD DESCRIPTION | FIX/ |
1 | Record type indicator | 1 | 1 | N | “8”: Record Type 8 appears only once in the Lockbox file. Record 8 is the “Service Total Record” which signifies the end of all Lockbox bundles. | F |
2 | Batch number | 2-4 | 3 | N | V | |
3 | Batch Item number | 5-7 | 3 | N | V | |
4 | Lockbox number | 8-14 | 7 | N | V | |
5 | Lockbox Deposit date | 15-20 | 6 | A | YYMMDD | V |
6 | Number of Remittances Indicator | 21-24 | 4 | N | V | |
7 | Remittance Dollar Total | 25-34 | 10 | N | It is filled with spaces or zeros to take up space | V |
8 | Last record indicator | 35-35 | 1 | A | A ‘9’ indicates the end of the record | V |
9 | TM amount | 36-46 | 11 | N | Lockbox Dollar Total (not used) | V |
10 | MTD amount | 47-57 | 11 | N | not used | V |
11 | Filler | 58-79 | 22 | A |
This record marks the end of the data and includes the total number of records.
Record 9: Trailer record | ||||||
| FIELDNAME | POSITION | LENGTH | TYPE | FIELD DESCRIPTION | FIX/ |
1 | Record type indicator | 1 | 1 | N | “9”: Record Type 9 appears only once in the Lockbox file. Record 9 is the “Trailer Record” which signifies the end of the Lockbox file. | F |
2 | Number of records | 2-7 | 6 | N | V | |
3 | Filler | 8-80 | 73 |
This section contains all software requirements on a detailed level which is sufficient to serve as a basis for the later design work, and for tests verifying that the system fulfills its requirements.
At a minimum, these software requirements should include a description of every input into the system, of every output from the system, and of all functions performed by the system in response to an input or in support of an output in the sense of business motivated purposes.
Closing notes:
Attached with this file are several sample ‘BAI2’ format lockbox files.
Transmission Data Sequence
A typical transmission from the bank uses the eight standard record formats as follows:
One Lockbox, One Remittance Batch
(1) Immediate address header
(2) Service Record
(5) (6) (4) (6) (7) Single Lockbox, one batch
(8) Service Total
(9) Destination trailer
One Lockbox Account, Multiple Remittance Batches
(1) Immediate address header
(2) Service Record
(5) (6) (4) (4) (6) (6) (7) Single Lockbox, batch #1
(6) (4) (4) (6) (6) (7) Single Lockbox, batch #2
(8) Service Total
(9) Destination trailer
Multiple Lockbox Accounts, Multiple Remittance Batches
(1) Immediate address header
(2) Service Record
(5) (6) (4) (6) (4) (6) (7) Lockbox #1, batch #1
(6) (6) (6) (6) (6) (7) Lockbox #1, batch #2
(8) Service Total – Lockbox #1
(5) (6) (4) (4) (6) (6) (7) Lockbox #2, batch #1
(8) Service Total – Lockbox #2
(9) Destination trailer
Thanks
Lokesh Sharma
Hi Vijay,
SAP provided many predefined national and international formats for bank statements like MT940 DE, BAI2 US, MT940 China, MT940 DK, BAI2 AUS etc.
If you still need some new format then you can add it through Software Development Kit(SDK).
Thanks & Regards,
Anant Patel
SAP BYD FUNCTIONAL CONSULTANT
<content removed by moderator>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
I am also trying to use the MT940 payment format for UK and having small query as mentioned below
Issue 1 : All transaction details are coming in single row.
08_1 | 000000GBP000000440,00Aberdein Considine | CRBAGRAAXXX | GR | GR1601101250000000012300695 | Aberdein Considine |
However, we are expecting as
:20: IMP MT103 IAT
:32A: 111201GBP100.99
:50K:/90134236
:57D://SC201990
BENEFICIARY BANK NAME
BENEFICIARY BANK ADDRESS 1
BENEFICIARY BANK ADDRESS 2
BENEFICIARY BANK ADDRESS 3
:59:/1234577654
BENEFICIARY NAME
BENEFICIARY ADDRESS 1
Can you please help me to resolve this issue.
Thanks in advance
Govind Sharma
Hi Vijay,
ByDesign supports various standard format, e.g. BAI2. CSV is not really a defined format,
So you can:
1. either check with your bank, if they can provide the file in BAI2 format (or other for your country supported formats)
2. Define routines, that create BAI2 files out of your CSV file (Maybe with visual basic)
3. Or as suggest by Lokesh: Built your own format with our SDK.
From my experience I would assume, that your bank might provide you BAI2 files, if you ask them.
Best regards
Marlene Katzschner
ByD Platinum Engineering
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
I have an old version of instructions on how to upload a BAi2 document dated back in 2008. I'm looking for a current version or most recent. The old version doesn't seem to be working. Would you happen to have one? What i'm looking for is a sample BAi2 test file that i can use to demo to customer. I understand how it works, but need a a template on what a BAi2 format looks like. Would you be able to help?
Thank you in advance for the help.
BJ
Hi BJ,
I hope you are looking for the sample file if so ,
01,EBSTest,EBSTest,150623,0944,1,99,99,2,,,,,,,/
02,EBSTest,033165,1000887,150623,0944,AUD,,,,,,,,,/
03,284380,AUD,010,-802677,,,015,-762677,,,045,-762677,,,/
16,115,40000,Z,,,Lockbox Payment from 6015630,,,,,,,,,/
49,-762677,99,,,,,,,,,,,,,/
98,-762677,1,99,,,,,,,,,,,,/
99,-762677,1,99,,,,,,,,,,,,/
Please let us now how the upload works Still I am waiting for the solution
Thanks
Vijay
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.