on 2008 Nov 21 4:09 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.