cancel
Showing results for 
Search instead for 
Did you mean: 

MT940 bank statment format

Former Member
0 Kudos

Hello,

I am working on a MT940 bank statement for UK.

Please find below the sample file from customer..

:20:20160922

:25:201119/11111111

:28:4/01

:60F:D160922GBP1360,80

:61:1609220922CP3952,80FFPC913000381

:86:999/00FPC68354 X XXXXXX        913000381         

/20BGCFrom: 09-01-18 20376333

:62F:C160922GBP2592,00

:64:C160922GBP2592,00

to get this working, what do i need to configure?

i was checking for the transaction type in fine tuning and they start with N* but in this file it is FFPC?

am i wrong somewhere?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

frank_jahnigen
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

Common External Transaction Codes characterising incoming/outgoing transactions in a bank statement block come pre-delivered and mapped to Payment Methods for respective country formats.

Applied Ext. Transactions Codes, however, can differ widely between localizations and according to house-bank specifications. Hence pertinent mappings should be modified and extended to suit specific requirements.

This can be achieved in fine-tuning-activity Automatically Generated Bank Statements / Edit import formats for automatic generated bank statements for import format MT940 UK.

Shown example indicates an incoming payment, possibly relating to a remittance advice.

Via Open Activity List / Fine-Tune navigate to said activity. For MT940 UK, add a suitable record for Ext. Transaction Code FFPC, Description, Debit/Credit: Increase, Payment Method: e.g. Payment Processing - Of Incoming Bank Transfer.

Hope this helps - Please mark the thread as answered/helpful if your query is answered.

Frank