MT940 format

[Former Member]

Hi all

Can anyone send me the MT940 bank statement format. I m trying to upload the bank file but getting an error so I am wondering if the statement is in the proper format.

One or two lines of the bank statement can be pasted here in the reply.

Thanks in advance

Hrishi

[Former Member · Accepted solution]

Hi

Some times though you see all the details in your PDF file it may not get copied to your text file. Then the last line items may get ommited. Pls check whether you have got all the line items to your text file . Anyway I have copied a sample of MT940 as requested .

20:9400124543861549

:25:200053001

:28:437/1

:60F:C071012LKR1514683,29

:61:0710121012DR2863072,60NCHK103600//0000103600

/CTC/031/CITICHECK

:61:0710121012DR100912,50NCHK103524//0000103524

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007287032 103524

:61:0710121012CR2000,00NCHK142748//0000142748

/CTC/457/MICR CHEQUE DEPOSIT

:86:/PT/DE/EI/007162002 142748

:61:0710121012CR150000,00NCHK901125//0000901125

/CTC/457/MICR CHEQUE DEPOSIT

:86:/PT/DE/EI/007092001 901125

:61:0710121012CR7140,00NCHK617791//0000617791

/CTC/457/MICR CHEQUE DEPOSIT

:86:/PT/DE/EI/007010453 617791

:61:0710121012DR1423,99NCHK103534//0000103534

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007278063 103534

:61:0710121012DR2216,02NCHK103011//0000103011

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007278063 103011

:61:0710121012DR1743,99NCHK103177//0000103177

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007278063 103177

:61:0710121012DR3679,99NCHK103395//0000103395

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007278063 103395

:61:0710121012DR4432,00NCHK200615//0000200615

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007278063 200615

:61:0710121012DR1381538,40NCHK103567//0000103567

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007135204 103567

:61:0710121012DR7963,75NCHK103544//0000103544

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007205000 103544

:62F:D071012LKR2693159,95

:64:D071012LKR2693159,95

-

Revert if you need further assistance.

Niranjala

[Former Member · Accepted solution]

Hello Niranjan

The text file which I downloaded from the PDF does not have the line nos i.e 20, 25, 61, 86 etc. So i am wondering if there is some converter which I need to use before I upload the file in SAP. Though I am getting the error 62F line missing but I see the New Balance and AVL Balance at the end of the statement.

Wondering where I am going wrong. Is the file from the bank not in the correct format?

Waiting for ur replies....

Thanks in advance

Hrishi

[Former Member · Accepted solution]

Hi

Well, the file which u just gave me for reference works just fine. I am wondering what cud be worng in the file that I am using.

Thanks

Hrishi

[Former Member · Accepted solution]

Hi

If the file which I forwarded is working then pls compare those two and see where it has gone wrong. I think the issue is with the bank format. Pls re-check with the bank and see whether you have got the correct MT940 format.

Rgds

Niranjala

[Former Member · Accepted solution]

Well, the difference is that there there are no nos assigned to the lines. Is that something not correct?

An e.g from my file is as below-

19.SEP 2008 BALANCE BROUGHT FORWARD **1 CR

19.SEP 2008 EFT OUTGOING -22

ZZZZEFT OUT UTR

CITIINZZZZ TRF TO

XYZ PVT.

LTD. S000887

020-22222222

TRN REF NO:ZZZZ

19.SEP 2008 EFT OUTGOING -33

ZZZZEFT OUT UTR

CITINZZZZ TRF TO

ABC LTD PUNE

S0000415 02135-2222222

TRN REF NO:ZZZZ

NEW BALANCE **44CR

AVL BALANCE **44CR

Thanks

Hrishi

[Former Member · Accepted solution]

Hi

The format what you have forwarded cannot be from the Mt940 format. Just check with the bank and get it confirmed.

Regards

Niranjala

[Former Member]

Thanks a lot for ur quick reply Madhu.

I am getting the following error in FF.5-

Termination in statement no. 00000 of acc

closing record 62F missing

I am wondering where do I see 62F. Thats why I wanted a sample file.

Do u have a bank file in the MT940 format which has 2-3 lines with the opening and closing error?

Thanks and Regards

Hrishikesh

[Former Member]

Hi,

Just as shown in my prev. reply, check whether the 62F line is there above the 64 line.

It gives the closing balance of the page, so if you have more than one page, check you have the same number of counts of 60F as 62F.

\Madhu

[Former Member]

Hi,

You would need the following lines at the begining they are: start of the statement, acc. no, statement no/page, opening balance

:20:

:25:1000183752

:28:110/1

:60F:C081009USD1000,50

and the follwoing lines at the end: Closing balance of the page, statement closing balance

:62F:C080829USD52007698,68

:64:C080829USD52007698,68

It would be helpful if you can mention the error.

\Madhu