CitiDirect File Export ®
SWIFT MT940 Format Specifications
Citibank® e-Business
SWIFT MT940 Exporter This document describes CitiDirect SM SWIFT MT940 Format. This cash management Exporter extracts account balances and transactions into an ASCII data file. The data for exports comes from messages you retrieve from CitiDirect ® Online Banking. CitiDirect provides end-of-day positions for the selected customer accounts. Intra-day movements are not extracted into the file.
Custom Delimited Field Formats This section discusses the use of the custom delimited field format and provides syntax for each type of field Delimiters •
Each line begins with the tag number i.e. :86:
•
Each record ends with a CRLF
•
Each field ends with a comma (,)
Amount fields •
Amount fields display no decimal places
•
The decimal point is a comma and is always present
•
Debit entries are preceded by a debit indicator (i.e. “D”)
•
The number of decimal places depends on the currency, as per SWIFT
Date Fields •
Date format is YYMMDD
•
In Tag :61, the Value Date and Entry Date are displayed as follows: 9610031003 means October 3, 1996 is the Value and entry dates
SWIFT MT940 Export Layout Tag
Field Name
Required/Optional/ Conditional
Description and Format
:20: Transaction Reference Number
Required
•
:21:
Optional
Related Reference
•
• •
:25: Account Identification
Required
:28: Statement/ Page Number
Required
Alphanumeric (16) Debit or Credit is indicated by the D or C character prior to the amount within the MT940 (line 61, subfield 3).
•
Alphanumeric (35) Cash Account Number
•
The SWIFT rule is as follows:
•
Numeric (5)/Numeric (2). •
•
•
:60: Opening Balance
Alphanumeric (16) Originator’s Reference Number
Required
• •
k
The CitiDirect rule is as follows:
Since this number must be unique for one year, the year is prefixed to the entire number to ensure uniqueness. For example: 20011093, is equal to statement number 1093. The statement number is stored as 20011093, where 2001 represents the CCYY (format) followed by the statement number 1093. Only the statement number should be present in the export, not the CCYY. 5 is the maximum length for a statement number, i.e., 123/1 is a valid format for tag 28:. Tag :60F: is used for First Balance. Tag :60M: is used for Interim Opening. Balance Format is 1. Alpha (1a): k A positive balance is indicated by a credit indicator (“C”). A negative amount is indicated by a debit indicator (“D”). This is as per the SWIFT format. There are no signs ("+" or "-") used in this format. k Numeric (6n): k Statement Date. 2. Alpha (3a): k Account Currency (ISO code). 4. Numeric (15n): k Balance.
Tag
Field Name
Required/Optional/ Conditional
Description and Format
:61:
Statement Line
Optional
This field is used for each book entry: • Numeric (6) Line 1 (Value Date) • Numeric (4) Line 1 (Entry Date) • Alpha (2) Line 1, Debit/Credit k D=Debit, C=Credit, RC=Reversal of Credit (Debit entry) or RD=Reversal of Debit (Credit entry). • Alpha (1) Line 1 (Fund Code, Last character of currency code). • Numeric (15) Line 1 (Amount) • Alpha (1) Line 1 (Entry Method, Transaction Type Identification Code ‘S’, ‘N’ or ‘F’).· • Alphanumeric (3) Line 1 (Entry Reason, Transaction Type Code. When the Transaction Identification Code is ‘S’ the remaining characters must be in the range 100 - 999). • Alphanumeric (16) Line 1 (Customer Reference Number, Act Own Reference). • Two slashes (//) and Alphanumeric (16) Line 1 (Bank Reference, Act. Service Ref.) • Alphanumeric (34) Line 2 (Further Reference Number - If the further reference field begins with /CTC, then the format should be: k /CTC/NNN/Text Description where NNN is the transaction code and where Text Description is the further reference. k If no CTC codeword exists in further reference data field the default value of MSC (miscellaneous) is placed into the transaction code.
:86: Information to Account Owner
Optional
•
•
Tag 86 is a continuation tag that provides additional information to the account owner. It is not mandatory that all messages end with tag 86. A payment detail, Tag 86, has the following layout: :86:/PT/XX/YY/Description k :86 Field tag k /PT/ Product type always follows field tag 86 k /XX/Identifies type of payment FT Funds transfer FE Foreign Exchange MM Money Market SC Securities LC Letter of Credit BL Bills DE Data Entry TP Third Party
Tag
Field Name
Required/Optional/ Conditional
Description and Format
k
k
:62: Closing Balance
Required
•
:64: Closing Available Balance
Optional
•
Tag :62F: is used for Final Balance • Tag :62M: is used for Interim Closing • Balance Format is: 1. Alpha (1a): k A positive balance is indicated by a credit indicator (“C”). A negative amount is indicated by a debit indicator (“D”). This is as per the SWIFT format. There are no signs (“+” or “-”) used in this format. 2. Numeric (6n): k Statement Date 3. Alpha (3a): k Account Currency (ISO code) 4. Numeric (15n): k Balance
•
:65: Forward Available
Optional
/YY/Code that further describes the payment. Refer to your SWIFT user guide for a complete list of these codes. Description The SWIFT format allows 390 characters of description to clarify details of the payment.
•
•
•
Format is Alpha (1) Numeric (6) Alpha (3) Numeric (15). The first two characters of the currency code must be the same as the first two characters of the currency code specified in fields 60a and 62a. This field is used for each day available Format is Alpha (1) Numeric (6) Alpha (3) Numeric (15). SWIFT Rule: When there is more than one value date for the items booked to the account (in this or previous statement periods), this field will indicate the balance which will be available to the account owner on the date(s) indicated. CitiDirect Rule: Follow SWIFT Rule above if multiple balances with different value dates are present in file. k The balance carried over from the prior day MT940 is based on the following: 1. If tag 65: exists for current day use it, or if tag 64: exists use it, otherwise use 62F. The result is the same as Opening Available Balance.
SWIFT MT940 Exporter Example The following is a sample of the records generated when the SWIFT MT940 Exporter is run. Each record should be on one line. The example shows records on multiple lines because they do not fit on the page. :20:0962780369874800 :25:56987400 :28:200 :60F:C961003USDO,00 :61:9610031003CD3600,32NTRFBKTRUS3396600//101607CO200SAME DAY CR TRANSFER :86:/PT/FT/BO/B.T. NEW LIMITED THE STOCK EXCHANGE CENTRE, 9TH FL. 19/BN/ABC COMPANYC/0 CITI AUCK 23 CUSTOM STREE/Bl/5698700/OB/0103 TRUST COMPANY NEWYORK/CR/0022300 /PO/ 0732/RF/100496774200 :61:9610031003CD25400,83NTRFT0659A0000I1//111126CO200 SAME DAY CR TRANSFER :86:/PT/FT/BO/ABC COMPANY/BN/ABC COMPANYC/O CITI AUCK 23 CUSTOM STREE/BI/36988400/ PY//REC/AVOID DUPLICATION.15.00 FEE DEDUCTED/OB/0700 NATION BANKLTD/CR/ 0106252/PO/ 1000 :61:9610031003CD360000,00NTRFT0659I597700//194673S7200SAME DA Y CR TRANSFER :86:/PT/FT/BO/SELVES/BN/ABC COMPANY C/0 CITI AUCK 23 CUSTOMSTREE/81/36987400/OB/ 10933700 BANK OF NEW PO BOX 2392 WELLINGTON NEW/PO/1514/OK/10933700 BANK OF NEW :61:9610031003CD393700,00NTRFNETTRS779900//104068CO200 SAME DAY CR TRANSFER :86:/PT/FT/BO/OURSELVES/BN/ABC COMPANY C/0 CITIBANK AUCKLAND 23 CUSTOMSTREE/Bl/ 36987400/OB/01000 TEST BANK/CP/0047900/PO/0800/RF/ NETTRRS779900 :6l:9610031003CD40940l,66NTRFBA302500//111600CO200SAME DAY CR TRANSFER :86:/PT/FT/BO/DUTCH INDUSTRIES (MALAYA)BHD KUALA LUMPURMALAYSIA/BN/ABC COMPANY C/0 CITI AUCK 23 CUSTOMSTREE/BI/36987400/PY/IN SETTLEMENT OF INV NO.441430 SERV CHG .10.00/OB/0958 XYZBANK N.V./CR/0119000/PO/1040/RF/0958011196961000 :61:9610031003CD513700,69NTRFCO11000000034859//000080CT200SAME DAY CR TRANSFER :86:/PT/FT/BO/BOARD FINANCE CORP LTD/BN/ABC COMPANY /Bl/36987484/OB/36975300BOARD FINANCE CORP LTDIPO/0600 :61:9610031000CD888554,79NMSCNONREF//0708437801333100ACT TRANSFER CR :86:/PT/FT/PY/ACT TRANSFER ACCOUNT 56952548 NZDB - FLORIDA :62F:D961003USD516700,02 :64:D961003USD516700,02 :65:D961003USD516700,02
© 2002 Citibank, N.A. All rights reserved. August 2002
