cancel
Showing results for 
Search instead for 
Did you mean: 

How to Import Bank Statements in Byd

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

lokesh2
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

Hi Lokesh,

                 Thanks for the way to proceed.

0 Kudos

Hi Lokesh ,

Could you please share a document/Process if you have any , as to how do we proceed with Lock box functionality in ByD.

I have tried BAI2 format which work prefect in ECC but not in ByD

Thank you

Sukrutha

lokesh2
Advisor
Advisor
0 Kudos

Hi Sukrutha,

Please refer to the help documents

  1. Configuration: Lockbox
  2. Lockbox Batches Quick Guide

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

  1. 1.1             Header record. 3
  2. 1.2             Service record. 4
  3. 1.3             Detail Header record. 5
  4. 1.4             Detail record. 6
  5. 1.5             Item record. 8
  6. 1.6             Batch Total record. 9
  7. 1.7             Service Total record. 10
  8. 1.8             Trailer record. 11

Closing notes: 11

1 File Record details

1.1 Header record

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

  1. No.

FIELDNAME

POSITION

LENGTH

TYPE

FIELD DESCRIPTION

FIX/
VARIABLE

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

 

1.2 Service record

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

  1. No.

FIELDNAME

POSITION

LENGTH

TYPE

FIELD DESCRIPTION

FIX/
VARIABLE

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

 

1.3 Detail Header record

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

  1. No.

FIELDNAME

POSITION

LENGTH

TYPE

FIELD DESCRIPTION

FIX/
VARIABLE

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

 

1.4 Detail record

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

  1. No.

FIELDNAME

POSITION

LENGTH

TYPE

FIELD DESCRIPTION

FIX/
VARIABLE

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.

 

1.5 Item record

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

  1. No.

FIELDNAME

POSITION

LENGTH

TYPE

FIELD DESCRIPTION

FIX/
VARIABLE

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

 

1.6 Batch Total record

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

  1. No.

FIELDNAME

POSITION

LENGTH

TYPE

FIELD DESCRIPTION

FIX/
VARIABLE

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

 

1.7 Service Total record

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

  1. No.

FIELDNAME

POSITION

LENGTH

TYPE

FIELD DESCRIPTION

FIX/
VARIABLE

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

 

1.8 Trailer record

This record marks the end of the data and includes the total number of records.

Record 9: Trailer record

  1. No.

FIELDNAME

POSITION

LENGTH

TYPE

FIELD DESCRIPTION

FIX/
VARIABLE

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

0 Kudos

Thanx a lot Lokesh !

Answers (2)

Answers (2)

Former Member
0 Kudos

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>

Govind_Sharma
Participant
0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

Hi Marlene,

             Thanks. Let me work for you suggestions.

Former Member
0 Kudos

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

Former Member
0 Kudos

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