Configuring MT940 Parser
When you choose a standard MT940 transaction parser, the Parser Configuration subtab of your format profile is automatically populated with the following 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 can read bank keywords and display them in a more readable format in the Memo field of the transaction record. If you select a standard MT940 transaction parser, you can define more keywords or edit existing ones. By default, the MT940 parser includes common keywords and descriptions used for SEPA transactions.
To configure the bank keywords:
-
Go to Setup > Accounting > Financial Institution > List.
-
Click View next to the financial institution record where you want to add or edit a format profile. 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 is no beginning and ending forward slash, the keywords cannot be converted properly. If the keywords appear in succession, a double forward slash must be present between the keywords. For example, /BENM//NAME/.
-
Description – Enter a description for the remittance code. This will be displayed in place of the remittance in the Memo field of the transaction record.
-
Transaction Field Mapping – Select the field where you want to map the remittance code.
Note:If the bank file contains keywords that are mapped to the same field, the parser will map 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.