Configuring MT940 Parser
When you choose a standard MT940 transaction parser, the Parser Configuration subtab of your format profile automatically shows a list of common bank keywords.
|
Remittance Code |
Description |
Transaction Field Mapping |
|---|---|---|
|
/EREF/ |
End to End Reference |
Transaction Number |
|
/BENM//NAME/ |
Beneficiary Name |
Transaction Payee |
|
/BENM//ID/ |
Beneficiary ID |
Transaction Payee |
|
/BENM/ |
Beneficiary |
Transaction Payee |
|
/CRED/ |
Creditor |
Transaction Payee |
|
/CSID/ |
Creditor ID |
Transaction Payee |
|
/DEBT/ |
Debtor |
Customer Name |
|
/INV/ |
Invoice |
Invoices |
|
/ORDP//NAME/ |
Name of the Debtor |
Customer Name |
|
/ORDP//ID/ |
Debtor ID |
Customer ID |
|
/ORDP/ |
Ordering Party |
Customer Name |
|
/PREF/ |
Payment Reference |
Transaction Number |
|
/ULTD//NAME/ |
Ultimate Name |
Transaction Payee |
|
/ULTB/ID/ |
Identification of the Ultimate Counter Party |
— |
|
/ULTC/ |
Ultimate Creditor |
Transaction Payee |
|
/ULTD/ |
Ultimate Debtor |
Customer Name |
|
/ACCW/ |
Counterparty Account and Bank |
— |
|
/ADDR/ |
Address |
— |
|
/CHGS/ |
Charges |
— |
|
/COAM/ |
Compensation Amount |
— |
|
/EXCH/ |
Exchange Rate |
— |
|
/IREF/ |
Instruction ID |
— |
|
/ISDT/ |
Settlement Date |
— |
|
/KREF/ |
Client/Orderer Reference |
— |
|
/MARF/ |
Mandate ID |
— |
|
/NBTR/ |
No. of Transactions in the File |
— |
|
/OCMT/ |
Original Amount |
— |
|
/OTHR/ |
Interest Compensation |
— |
|
/ORDT/ |
Original Due Date of the Collection |
— |
|
/PURP/ |
Purpose Code |
— |
|
/ |
Structured Remittance Information |
— |
|
/REMI//CD/ |
Creditor Reference Type Code |
— |
|
/REMI/ |
Remittance Information |
— |
|
/RTRN/ |
Return Reason |
— |
|
/SVCL/ |
Identification Code of the Scheme |
— |
|
/BBK/ |
Beneficiary Bank ID |
— |
|
/IBK/ |
Intermediary Bank |
— |
|
/OBK/ |
Ordering Bank ID |
— |
|
/CD/ |
Purpose Code |
— |
|
/ID/ |
Identification |
— |
Configuring Bank Keywords for the MT940 Parser
The MT940 parser reads bank keywords and shows them in a more readable format in the Memo field of the transaction record. If you select a standard MT940 transaction parser, you can add or edit keywords. By default, the MT940 parser includes common keywords and descriptions for SEPA transactions.
To configure the bank keywords:
-
Go to Setup > Accounting > Financial Institution > List.
-
Next to the financial institution record where you'd like to add or edit a format profile, click View. For more information, see Format Profile Creation.
-
On the Financial Institution page, click the format profile you want to edit.
-
On the Format Profile page, click Edit.
-
Under the Parser Configuration subtab, enter new keywords or edit the existing ones:
-
Remittance Code – Enter the keyword used in the bank statement file.
Each keyword must start and end with a forward slash “/”. If there's no slash at the start and end, the keywords won't convert properly. If the keywords appear in a row, use a double forward slash between them. For example, /BENM//NAME/.
-
Description – Enter a description for the remittance code. It'll show up in the Memo field instead of the remittance.
-
Transaction Field Mapping – Select the field where you want to map the remittance code.
Note:If the bank file has keywords mapped to the same field, the parser maps the field to the first keyword in the file.
Example:
Bank File
Memo Field
:61:1507310731C257,97NTRFEREF//0001500002870
:86:/EREF/1234567890ABCD/BENM//NAME/XYZ Corporation
:86:/REMI/PURCHASE OF GOODS/ISDT/2012-12-30:86:/CSID/4500900868
End-to-end Reference: 1234567890ABCD, Beneficiary Name: XYZ Corporation, Remittance Information: Purchase of Goods, Settlement Date: 2012-12-30, Creditor ID: 4500900868
-
-
Click Save.