Opening, Closing and Forward Available Balances in the SWIFT MT940 Format

In the SWIFT MT940 format specifications, there are four fields for balances: F60a Opening Balance, F62a Closing Balance (Booked Funds), F64 Closing Available Balance (Available Funds) and F65 Forward Available Balance. The aim of this article is to explain the meaning of each balance field and how they are calculated.

This will be illustrated through SWIFT MT940 statements sent to a financial institution authorised by account owner to receive it.

SWIFT MT940 sent to Bank authorized by account owner
SWIFT MT940 sent to Bank authorized by account owner

Two MT940 are sent to Midland bank authorized by Transglobal Corp to receive it. Balance fields are provided in each SWIFT MT940 format received. Considering the two messages is helpful to better understand how the balances are computed.

Balances in the first SWIFT MT940 format

The table below contains the fields that are transported in the first SWIFT MT940 format. For format of balances and line statements fields, please refer to the previous article or to the SWIFT MT940 format specifications. The main goal here is to explain how the balances are calculated. This account statement is sent on september 10.

Explanation Format Comments
Sender CHASUS33 The Sender BIC appears in header block (Block 1) in the MT940 Input and in the application block (Block 2) in the MT940 Output.
Message Type 940 The message type is the second field of the block 2.
Receiver MIDLGB22 The Receiver BIC appears in header block (Block 1) in the MT940 Output and in the application block (Block 2) in the MT940 Input.
Message Text This introduces the Text block (block 4). All the fields below are in the text block of the MT940 message.
Transaction Reference Number :20:REFCHAS12345 This is the Sender's Reference specific to this MT940. It is generated by CHASUS33.
Account Identification :25P:123-304958
CORPGB22
Mandatory and of format (in this case)
35x (Account)
4!a2!a2!c[3!c] (Identifier Code)
The BIC is provided here since the receiver is not the account owner.
Statement Number/Sequence Number :28C:123/1 Mandatory and of format 5n[/5n] for statement number/sequence number. Only one message is sent for this statement. The sequence number 1 might have been omitted.
Opening Balance :60F:C180910USD10000 USD 10000 is the opening balance on Sept. 10.
1st Transaction :61:180910C5000,NTRFNONREF//8951234
ORDER BK OF NYC WESTERN CASH RESERVE
USD 5000 is a credit entry with value date Sept. 10. Related funds are available right away since we are Sept. 10.
2nd Transaction :61:180913C2500,NFEX036960//8954321 USD 2500 is a credit entry with value date Sept. 13. The funds will be available only on Sept. 13.
3rd Transaction :61:180914C400,NDIVNONREF//8846543 USD 400 is a credit entry with value date Sept. 14. The funds will be available only on Sept. 14.
Information to Account Owner :86:DIVIDEND LORAL CORP
PREFERRED STOCK 1ST QUARTER 2009
Closing Balance :62F:C180910USD17900, 10000 + 5000 + 2500 + 400 = 17900. The closing balance on Sept. 10 is composed of money available on Sept.10 and money that will become available in the future.
Closing Available Balance :64:C180910USD15000, Closing Available Balance on Sept. 10 = Closing Balance - Funds available after Sept. 10.
Funds available after Sept. 10 = 2500 (VD Sept. 13) + 400 (VD Sept. 14) = 2900.
So we have 15000 = 17900 - 2900.
Forward Available Balance :65:C180913USD17500, Forward Available Balance on Sept. 13 = Closing Balance - Funds available after Sept. 13.
Funds available after Sept. 13 = 400 (VD Sept. 14)
So we have 17500 = 17900 - 400
Forward Available Balance :65:C180914USD17900, Forward Available Balance on Sept. 14 = Closing Balance - Funds available after Sept. 14.
Funds available after Sept. 14 = 0
So we have 17900 = 17900 - 0
Information to Account Owner :86:PRIME RATE AS OF TODAY 11 PCT
End of Message Text/Trailer
WP Data Tables

We see something pretty interesting about the balances. Funds can be booked on a account with different value dates. When funds are booked with a value date in the future, the funds become available only at value date. So the account owner cannot spend the money before value date.

Balances in the second SWIFT MT940 format

The table below contains the fields that are transported in the second SWIFT MT940 format. This second statement contains only one debit entry, but it affects the other balances as you can see below. This account statement is sent on september 11.

Explanation Format Comments
Sender CHASUS33 The Sender BIC appears in header block (Block 1) in the MT940 Input and in the application block (Block 2) in the MT940 Output.
Message Type 940 The message type is the second field of the block 2.
Receiver MIDLGB22 The Receiver BIC appears in header block (Block 1) in the MT940 Output and in the application block (Block 2) in the MT940 Input.
Message Text This introduces the Text block (block 4). All the fields below are in the text block of the MT940 message.
Transaction Reference Number :20:REFCHAS12654 This is the Sender's Reference specific to this MT940. It is generated by CHASUS33.
Account Identification :25P:123-304958
CORPGB22
Mandatory and of format (in this case):
35x (Account)
4!a2!a2!c[3!c] (Identifier Code)
The BIC is provided here since the receiver is not the account owner.
Statement Number/Sequence Number :28C:124/1 Mandatory and of format 5n[/5n] for statement number/sequence number. Only one message is sent for this statement. The sequence number 1 might have been omitted.
Opening Balance :60F:C180911USD17900, The opening balance on Sept. 11 USD 17900 is the closed balance of the previous day Sept. 10
1st Transaction :61:180911D7000,S202DRS/06553 USD 7000 have been debited from the account with value date of Sept. 11. It will impact the balances.
Closing Balance :62F:C180911USD10900, Closing Balance on Sept. 11 = Opening Balance on Sept. 11 - Funds debited on Sept. 11.
So we have 10900 = 17900 - 7000.
Closing Available Balance :64:C180911USD8000, Closing Available Balance on Sept. 11 = Closing Balance on Sept. 11 - Funds available after Sept. 11.
Funds available after Sept. 11 = 2500 (VD Sept. 13) + 400 (VD Sept. 14) = 2900.
So we have 8000 = 10900 - 2900.
Forward Available Balance :65:C180913USD10500, Forward Available Balance on Sept. 13 = Closing Balance on Sept. 11 - Funds available after Sept. 13.
Funds available after Sept. 13 = 400 (VD Sept. 14)
So we have 10500 = 10900 - 400
Forward Available Balance :65:C180914USD10900, Forward Available Balance on Sept. 14 = Closing Balance - Funds available after Sept. 14.
Funds available after Sept. 14 = 0
So we have 10900 = 10900 - 0
End of Message Text/Trailer
WP Data Tables

In conclusion, Opening and Closing balances are given for the statement date, but computed irrespective of the value dates. Forward available balances are always considered at a specific value date. To get the closing or forward available balance for a date, funds available after that date must be deducted from the total closing balance.

Simple amounts were used to make things easy and help you to follow the calculation of the different balances. If something is still unclear, please send your question through a comment. We will be happy to support.

9 COMMENTS

  1. Hi Paul, is there any restriction on number of entries a mt940 can have due to the fact that one mt940 can only have 2000 characters.
    Thanks
    Pramod

    • Hi Pramod,
      One single MT940 message can have up to 2000 characters.
      But you can send multiple MT940 for the same statement (See Statement Number/Sequence Number).
      If the number of entries is very high, you can send as many MT940 as required and increase the sequence number with each new message.
      You can theoretically send up to 99999 sequences for the same statement. That is more than enough in practice.
      BR, Jean Paul

  2. I have a question

    We generated MT940 statement for a date range (eg : 01-03- 2019 to 30-04-2019). It is split into multiple messages.

    In all the messages, the Intermediate Account opening balance tag (Tag 60M ) is always populating date as 01-03- 2019 and Intermediate Account closing balance(Tag 62M) is always populating as 30-04-2019, whereas the balances are populating as per the corresponding opening date and closing date of transaction in a message.

    Is this the correct functionality?” or 60M and 62M tags date should also update

    • Hi Anoop,
      Sorry for not answering before. I am very busy at the moment.

      To be strict, the date of the Intermediate Account opening balance tag (Tag 60M) should ideally take the date of the last (debit or credit) entry and the date of the Intermediate Account closing balance(Tag 62M) should also ideally take the date of the last (debit or credit) entry.
      That totally makes sense. In reality, people do not care that much about those dates as long as the balances are correct. What truly matters in a statement are the dates of the opening and closing balances.
      Dates of Closing Available Balance and Forward Available Balance are really important too. They must be correct. If you can easily fix the dates of intermediate balances, do it. Receivers won’t waste time asking themselves the same question.

      Regards,
      Jean Paul

  3. Hello, can you please assist in below case.

    While we send the statement that consists of two MT940 messages, the client doesn’t receve the second one. In both messages we use tag 62F showing closing balance, should it be 62M in first message? Can this be a reason that the client’s system can’t generate the second message? Also we put 64tag in both messages, can this be a reson for non receiving the second message?

    Thank you.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

MOST POPULAR