Please note: The examples below are for the purposes of demonstrating the changes and they may not exactly match your statement entries. Samples of the changes will be shown in red to illustrate behaviour before and in blue after the enhancement.
1) HSBCnet Reports and Files Download standard reports
| MT940 format - Report IDs MTG1A and MTG1C | |||||||
|---|---|---|---|---|---|---|---|
| Change description by Tag | MT940 is enhanced to provide more detail as well as to adhere to current SWIFT Standards.
MTG1C will replace MTG1N |
||||||
| Tag 20 Reference Number - Current
Tag 20 - New |
Transaction date in YYMMDD format Unique reference in alphanumeric beginning with ‘AI’ |
||||||
| 25 Account Number | No change | ||||||
| 28C Account Delivery Statement and Sequence Number - Current
28C - New |
5 digit Julian date format number and 3 digit sequence number- 5!n/3!n 5 digit incremental by 1 statement number and 5 digit sequence number - 5!n/5!n |
||||||
| 60F Opening Balance | No change | ||||||
| 61.1 Value date | No Change | ||||||
| 61.2 Entry date | No Change | ||||||
61.3 Debit/Credit Indicator |
|
||||||
| 61.4 - Funds Code - Current 61.4 - New |
Funds code not supported Funds code included (3rd letter of currency code, eg CNY - 1!a |
||||||
| 61.5 | No change | ||||||
| 61.6 | No change | ||||||
| 61.7 - Customer Reference - Current
61.7 - New |
Spaces padding customer references up to 16 characters
No spaces padding customer references
|
||||||
| 61.8 - Bank Reference - Current 61.8 - New |
Spaces padding bank references up to 16 characters No spaces padding bank references |
||||||
| 61.9 - Supplementary Detail - Current 61.9 - New |
Not Supported Optionally populated depending on transaction type |
||||||
| 86 Information to the account owner about transaction | No change | ||||||
| 62F Closing Balance | No change | ||||||
| 64 - Closing Available Balance - Current
64 - New |
Closing Available Balance not supported Closing Available Balance supported - 1!a6!n3!a15d (D/C Mark)(Date)(Currency)(Amount) :64:C210914INR1229,47 |
||||||
| Final Tag 86 - Information to Account Owner about the statement as a whole - Current
Final Tag 86 - New |
Information to Account Owner about Statement not supported
Information to Account owner about Statement supported |
||||||
| BAI2 End of Day Format - Report IDs BAI2C, BAI2R | |
|---|---|
| Change description by Record and field | BAI2 is enhanced to remove static data values |
01 File Header Receiver ID - Current All other fields in 01 record 01 record Current |
HSBC India’s BIC reported, eg. “HSBCINBB’
IN+Customer ID, eg INGIN123456789
No change 01, HSBCINBB,INGIN123456789,210412,1343,1,80,1,2/
|
02 Group Header All other fields in 02 record 02 record Current |
IN+Customer ID, eg INGIN123456789 No change 02,INGIN123456789, HSBCINBB,1,210401,,,2/
|
| 03 Account Identifier and Summary Status | No change |
|
16 Transaction Detail Text - Current Text - New |
Begins with static ‘POST DATE’ and the date eg POST DATE 01/04/2021 followed by the narrative Only the narrative appears |
|
16 record - Current
|
16,399,72200,,R8uYCMEgt2N00001,kSdRJ8D00001,POST DATE 01/04/2021
16,399,72200,,R8uY CMEgt2N00001,kSdRJ8D00001,/ORDP/SCOTT M |
| 49 record Value date | No Change |
| 98 record Value date | No Change |
| 99 record Value date | No Change |
| CSV format - Report IDs CVG1A and CVG1C | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Change description by Column |
CSV is enhanced to provide additional T flag column to indicate T for Transactions or BT for Balance and Transactions.
CVG1C will replace CVG1N |
|||||||||||||||||||||||||
All current Columns UNIQUE_ID through to HOLDAMT |
No change | |||||||||||||||||||||||||
Column TFLAG Current Column TFLAG New |
Not supported Supported, column name is ‘TFLAG’ and possible values are ‘T’ ‘BT’ or ‘B’. T is for Transactions, BT is for Balance and Transactions and B is for Balance. |
|||||||||||||||||||||||||
|
CSV format current:
CSV format New:
|
||||||||||||||||||||||||||
| MT942 & MT940 | |||
|---|---|---|---|
| Transaction Type - 61.6 NTRF |
Customer Reference - 61.7 CUSTOMERREFERENC |
Bank Reference - 61.8 BANKREFERENCE |
Narrative - 86 NARRATIVE |
| :61:1902040204CP0,53NTRFCUSTOMERREFERENC//BANKREFERENCE :86:NARRATIVE LINE 1 UP TO 65 CHARACTERS NARRATIVE LINE 2 NARRATIVE LINE 3 NARRATIVE LINE 4 UP TO 6 LINES |
|||
| BAI2 Intraday & End of Day | |||
|---|---|---|---|
| Transaction Type - 16 195 |
Customer Reference - 16 CUSTOMERREFERENC |
Bank Reference - 16 BANKREFERENCE |
Narrative - 16 Test Field NARRATIVE |
| 16,195,4900,,BANKREFERENCE,CUSTOMERREFERENC,NARRATIVE LINE 1 UP TO 16 RECORD LIMIT 88,REMAINDER OF NARRATIVE LINE 1 88,NARRATIVE LINE 2 NARRATIVE LINE 2 NARRATIVE LINE 2 88,NARRATIVE LINE 3 NARRATIVE LINE 3 NARRATIVE LINE 3 88,NARRATIVE LINE 4 UP TO 6 LINES |
|||
2) HSBCnet Report Writer customised reports
| MT940 format | |||||||
|---|---|---|---|---|---|---|---|
| Change description by Tag | MT940 is enhanced to provide more detail as well as to adhere to current SWIFT Standards. | ||||||
|
Tag 20 Reference Number - Current
Tag 20 - New |
Transaction date in YYMMDD format Unique reference in alphanumeric beginning with ‘AI’ |
||||||
| 25 Account Number | No changes | ||||||
| 28C Account Delivery Statement and Sequence Number | No change | ||||||
| 60F Opening Balance | No change | ||||||
61.1 Value date |
No change | ||||||
61.2 Entry date |
No change | ||||||
61.3 Debit/Credit Indicator |
|
||||||
| 61.4 - Funds Code - Current 61.4 - New |
Funds code not supported Funds code included - 1!a |
||||||
| 61.5 | No change | ||||||
| 61.6 | No change | ||||||
| 61.7 - Customer Reference - Current 61.7 - New |
Spaces padding customer references up to 16 characters No space padding customer references |
||||||
| 61.8 - Bank Reference - Current 61.8 - New |
Spaces padding bank references up to 16 characters No spaces padding bank references |
||||||
| 86 Information to the account owner about transaction | No change | ||||||
| 62F Closing Balance | No change | ||||||
| 64 Closing Available Balance - Current 64 - New |
Closing Available Balance not supported Closing Available Balance supported - 1!a6!n3!a15d (D/C Mark)(Date)(Currency)(Amount) :64:C210914INR1229,47 |
||||||
| Final Tag 86 - Information to Account Owner about the statement as a whole - Current Final Tag 86 - New |
Information to Account Owner about statement not supported Information to Account owner about statement supported |
||||||
| BAI2 End of Day format | |
|---|---|
| Change description by Record and field | BAI2 for both Statements and Balances is enhanced to provide more detail |
01 File Header Receiver ID - Current All other fields in 01 record 01 record Current |
IN+Customer ID, eg INGIN123456789
No change 01, HSBC,INGIN123456789,210412,1343,1,80,1,2/
|
02 Group Header Sendeer ID - Current All other fields in 02 record 02 record Current |
No change 02,INGIN123456789,HSBC,1,210401,,,2/
|
| 03 Account Identifier and Summary Status
Account Number and Currency Code Existing Fields: New Additional Fields: |
No change
No change
|
|
03 record - Current
03 record - New |
03,26104268301101,CNY,010,23074,,/
03,26104268301101,CNY,010,23074,,/ |
|
16 Transaction Detail Funds Type - Current Funds Type - New All other fields in 16 record |
‘V’ for Value date appears followed by the Value date, even when the Value date is the same as the Post date and As-of-Date in the 02 record. eg ‘V’ followed by the Value date will only appear if it is different from the Post date and reporting date. No change |
|
16 record - Current 61.4 - New |
16,399,96200,V,210914,W69EiK1aZsc,DP68OTX00001,/OR/CNH2 16,399,96200,,W69EiK1aZsc,DP68OTX00001,/OR/CNH2 |
49 Account Trailer |
This algebraic sum of all amount fields in 03, 16, and 88 records, including + or - towards a total does not include 03 record fields 102 and 402. The sum will now also include 102 and 402 No change |
| BAI2 Intraday format | |
|---|---|
| Change description by Record and field | BAI2 for both Statements and Balances is enhanced to provide more detail |
01 File Header Receiver ID - Current All other fields in 01 record 01 record Current |
IN+Customer ID, eg INGIN123456789
No change 01, HSBC,INGIN123456789,210412,1343,1,80,1,2/
|
02 Group Header Sender ID - Current All other fields in 02 record 02 record Current |
IN+Customer ID, eg INGIN123456789
Static text ‘HSBC’ reported for Sender ID
02,INGIN123456789,HSBC,1,210401,,,2/
|
| 03 Account Identifier and Summary Status
Account Number and Currency Code Existing Fields: New Additional Fields: |
No change
No change
|
|
03 record - Current 03 record - New |
03,001012004001,INR,010,100787582,,/ 88,030,9999641828,,,040,100787582,,,060,9999641828,,/ 88,063,0,,,072,0,,,074,0,,/ 88,075,0,,,100,84700,,,102,,2,/ 88,400,72700,,,402,,2,/ |
|
16 Transaction Detail Funds Type - Current Funds Type - New All other fields in 16 record |
‘V’ for Value date appears followed by the Value date, even when the Value date is the same as the Post date and As-of-Date in the 02 record. eg ‘V’ followed by the Value date will no longer appear. No change |
|
16 record - Current 61.4 - New |
16,399,96200,V,210914,W69EiK1aZsc,DP68OTX00001,/OR/CNH2 16,399,96200,,W69EiK1aZsc,DP68OTX00001,/OR/CNH2 |
49 Account Trailer |
This algebraic sum of all amount fields in 03, 16, and 88 records, including + or - towards a total does not include 03 record fields 102 and 402. The sum will now also include 063, 102, and 402 No change |
Appendix - Field Locations by File Format
| MT942 & MT940 | |||
|---|---|---|---|
| Transaction Type - 61.6 NTRF |
Customer Reference - 61.7 CUSTOMERREFERENC |
Bank Reference - 61.8 BANKREFERENCE |
Narrative - 86 NARRATIVE |
| :61:1902040204CP0,53NTRFCUSTOMERREFERENC//BANKREFERENCE :86:NARRATIVE LINE 1 UP TO 65 CHARACTERS NARRATIVE LINE 2 NARRATIVE LINE 3 NARRATIVE LINE 4 UP TO 6 LINES |
|||
| BAI2 Intraday & End of Day | |||
|---|---|---|---|
| Transaction Type - 16 195 |
Customer Reference - 16 CUSTOMERREFERENC |
Bank Reference - 16 BANKREFERENCE |
Narrative - 16 Test Field NARRATIVE |
| 16,195,4900,,BANKREFERENCE,CUSTOMERREFERENC,NARRATIVE LINE 1 UP TO 16 RECORD LIMIT 88,REMAINDER OF NARRATIVE LINE 1 88,NARRATIVE LINE 2 NARRATIVE LINE 2 NARRATIVE LINE 2 88,NARRATIVE LINE 3 NARRATIVE LINE 3 NARRATIVE LINE 3 88,NARRATIVE LINE 4 UP TO 6 LINES |
|||