Enhancement of the FX Form I/IA Report — Consolidated Foreign Exchange (FX) Assets and Liabilities

March 4, 2015 BSP MEMORANDUM NO. M-2015-012 TO : All Universal/Commercial and Thrift Banks SUBJECT : Enhancement of the FX Form I/IA Report Consolidated Foreign Exchange (FX) Assets and Liabilities In an effort to address banks' concerns on maintaining DOS-based Personal Computers (PCs) for the purpose of reporting FX Form I and FX Form IA (hereinafter referred to as the Reports), banks will be allowed to submit reports in Comma-Separated Values (CSV) file format effective 6 April 2015. The following guidelines on the electronic submission of the reports shall be observed: 1. Beginning report week-ending 10 April 2015, banks shall submit the Reports either in CSV file format or Data Base File (DBF) format to give flexibility to the banks in the preparation of the reports. 2. The BSP-prescribed file structure which shall serve as the banks' guide in creating their CSV Report file are specified in Annexes A and B. A soft copy may be requested from the BSP-Department of Economic Statistics (DES), International Transactions Reporting System (ITRS) Group. 3. The CSV (GLFX.CSV) or DBF (GLFX.DBF) file of the reports shall be electronically submitted to the following email addresses: E-Mail Address Type of Reporting Bank [emailprotected] Universal/Commercial Banks (U/KBs) [emailprotected] Thrift Banks (TBs) 4. Banks may opt to continue using the existing Data Delivery Facility (DDF) operating on a DOS-based platform. However, since the DDF system is for future retirement due to the obsolescence of the DOS machine, the BSP shall no longer accept requests for installation of the said system. 5. The same existing penalties for late and/or incomplete/erroneous reporting prescribed under Section 103 Fines and Penalties of the Manual of Regulations on Foreign Exchange (FX) Transactions shall continue to apply for the FX Form I/IA reports, regardless of the reporting format used. For compliance. (SGD.) DIWA C. GUINIGUNDO Deputy Governor ANNEX A Guidelines on the Creation of the CSV Report File for the FX-Form 1 Note : 1. Population of report data in the CSV report file shall follow the guidelines as described in the "Manual of Instructions" of the FX-Form 1 Report (Revised 2006). 2. The first record must contain the FIELD NAMES as defined and in the same order as specified in this document. Value Formats : Date All date values must follow the format yyyyMMDD ( e.g. , 20140901). Numeric All numeric values must be unformatted ( e.g. , 100000.25, 1032, 0.001321) Character All character values must be enclosed in double quotation marks ( e.g. , "Juan T. Dela Cruz", "000-901-155-322", "Pedro's Hardware Supply") CSV File Structure for DES Report : Field Field Name Data Type Description Remarks Main Schedule No. Report 1 2 3 4 5 6 7 9 10 11 12 14* 1 BANKCDE Numeric(6,0) Bank code of This is a BSP provided x x x x x x x x x x x x x reporting bank. bank code. 2 REFDATE Numeric(8,0) Reference date Format: yyyyMMDD x x x x x x x x x x x x x of report. 3 FORMNO Character(5) Report schedule For "Main Report", value is x x x x x x x x x x x x x number. TRD00. For "Schedules", value is equal to the schedule number (e.g., Schedule 1 = "TRD01", Schedule 2 = "TRD02", etc.) 4 SEQNO Numeric(2) Item sequence Refer to BSP supplied x number. reference file for sequence number. 5 RECNO Numeric(3) Record number. Refer to BSP supplied x x reference file for record numbers. 6 TRANCDE Numeric(3) Transaction code. Refer to BSP supplied x x x x x x x x x reference file for transaction codes. 7 BNKCDE2 Numeric(12) Counter-party Refer to BSP supplied x bank code. reference file for bank codes. 8 CURRCDE Character(3) Transaction Refer to BSP supplied x x x x x x x x x x currency code. reference file for currency codes. 9 BOOKCDE Numeric(1) Book code. 1 - Regular x x x x x x x x x x 2 - FCDU 10 REFNO Character(15) Bank reference x x number for unregistered loan. 11 CDAN Character(10) BSP Debt x x Account No. for BSP registered accounts. 12 CRFCDE Numeric(1) Credit facility code. 1 - Short term x x 2 - Medium and Long term 13 DEBTCDE Numeric(10) Debtor code. Refer to BSP supplied x x reference file for debtor codes. 14 CREDCDE Numeric(12) Creditor code. Refer to BSP supplied x x reference file for creditor codes. 15 DUEDTE Numeric(8) Due date. Format: yyyyMMDD x x x 16 DESC40 Character(40) Other x x miscellaneous services for Schedule 5. Transaction description for Schedule 7. 17 CTRYCDE Numeric(3) Country code. Refer to BSP supplied x x x x x x x x reference file for country codes. 18 NAME Character(35) Name of x counterparty. 19 BENEF Character(35) Name of x beneficiary. 20 REMIT Character(35) Name of remitter. x 21 INVESTEE Character(35) Name of investee. x 22 TYPE1 Numeric(1) Type of investee. 1 - Bank x 2 - Non-bank 23 INVESTOR Character(35) Name of investor. x 24 TYPE2 Numeric(1) Type of investor. 1 - Bank x 2 - Non-bank 25 SECURITY Character(35) Name of securities x issuer. 26 TYPE Numeric(1) Counterparty type. x 27 DDATE Numeric(8) Deal date. Format: yyyyMMDD x x 28 DLCODE Numeric(1) Dealing code. 1 - With Philippine x x Dealing System (PDS) 2 - Outside PDS 29 PURCDE Numeric(1) N/A N/A 30 XPRTCDE Numeric(10) Exporter code. Refer to BSP supplied x reference file for exporter codes. 31 PAYMODE Numeric(1) Mode of payment. 1 - Letter of Credit (LC) x x x 2 - Documents Against Payment (DP) 3 - Document Against Acceptance (DA) 4 - Open Account (OA) 5 - Direct Remittance 9 - Others 32 FEECDE Numeric(1) N/A N/A 33 COMMCDE Numeric(7) Number of x transactions. 34 STATCDE Numeric(1) Import status 2 - Amendment x code. 4 - Self-funded 5 - Revision/Extension 6 - New 7 - Sight 8 - Deferred/Usance 35 DOCNO Character(20) Tax Identification x x x x x x x Number (TIN): - Debtor (Schedules 3 & 4) - Beneficiary (Schedule 5) - Investee (Schedule 6) - Exporter (Schedule 9) - Importer (Schedule 10) - Importer (Schedule 11) 36 LCNO Character(20) LC number. x x 37 RGIBRN Character(20) Record of Goods x x Imported/Bank Reference No. 38 BLDATE Numeric(8) Date of bill of Format: yyyyMMDD x x lading or date of acceptance of DA. 39 LCEXPDTE Numeric(8) Maturity date. x 40 IMPCDE Numeric(10) Importer code. Refer to BSP supplied x x reference file for importer codes. 41 COMMDESC Character(25) Tax Identification x x x x Number (TIN): - Creditor (Schedule 3 & 4) - Remitter (Schedule 5) - Investor (Schedule 6) 42 LCBNKCDE Numeric(12) N/A N/A 43 CURCD1 Character(3) N/A N/A 44 CURCD2 Character(3) N/A N/A 45 CURCD3 Character(3) N/A N/A 46 AMTREG Numeric(15,2) FX Regular amount. x 47 AMTFCD Numeric(15,2) FCDU amount. x 48 AMTTOT Numeric(15,2) Total amount x (Regular + FCDU). 49 AMTDOLR Numeric(15,2) Amount in US$ x x x x x x x x x equivalent. 50 AMTORIG Numeric(15,2) Amount in original x x currency. 51 FEEORIG Numeric(15,2) N/A N/A 52 FEEDOLR Numeric(15,2) N/A N/A 53 INTORIG Numeric(15,2) N/A N/A 54 INTDOLR Numeric(15,2) N/A N/A 55 PRINORIG Numeric(15,2) Principal payment x amount in original currency. 56 PRINDOLR Numeric(15,2) Principal payment x amount in US$ equivalent. 57 AMTUSD Numeric(15,2) USD amount. x 58 AMTJPY Numeric(15,2) JPY amount. x 59 AMTDEM Numeric(15,2) DEM amount. x 60 AMTCHF Numeric(15,2) CHF amount. x 61 AMTGBP Numeric(15,2) GBP amount. x 62 AMTEUR Numeric(15,2) EUR amount. x 63 AMTCAD Numeric(15,2) CAD amount. x 64 AMTAUD Numeric(15,2) AUD amount. x 65 AMTSGD Numeric(15,2) SGD amount. x 66 AMTOC1 Numeric(15,2) N/A N/A 67 AMTOC2 Numeric(15,2) N/A N/A 68 AMTOC3 Numeric(15,2) N/A N/A 69 AMTOTH Numeric(15,2) Other currency x amount in US$ equivalent. 70 TOTAMT Numeric(15,2) Total amount in x US$ equivalent. 71 EXCHRATE Numeric(15,2) Exchange rate. x 72 XRATE1 Numeric(11,6) JPY exchange rate. Exchange rate values x for both book codes 73 XRATE2 Numeric(11,6) DEM exchange rate. (1 - Regular, 2 - FCDU) x must be provided. 74 XRATE3 Numeric(11,6) CHF exchange rate. x 75 XRATE4 Numeric(11,6) GBP exchange rate. x 76 XRATE5 Numeric(11,6) EUR exchange rate. x 77 XRATE6 Numeric(11,6) CAD exchange rate. x 78 XRATE7 Numeric(11,6) AUD exchange rate. x 79 XRATE8 Numeric(11,6) SGD exchange rate. x * Schedule 14 For SDC CSV File Structure for SDC Report : Field Field Name Data Type Description Remarks Schedule No. 8 13 1 BANKCDE Numeric(6,0) Bank code of This is a BSP provided x x reporting bank. bank code. 2 REFDATE Numeric(8,0) Reference date Format: yyyyMMDD x x of report. 3 FORMNO Character(5) Report schedule For "Main Report", value x x number. is "TRD00". For "Schedules", value is equal to the schedule number (e.g., Schedule 1 = "TRD01", Schedule 2 = "TRD02", etc.) 4 BOOKCDE Numeric(1) Book code. 1 - Regular x 2 - FCDU 5 TRANCDE Numeric(3) Transaction code. Refer to BSP supplied x reference file for transaction codes. 6 PARTY Character(35) Counterparty. x 7 TRNSID Character(1) Transaction ID O - Outright x S - One end 8 SVLDTE Numeric(8) Spot value date. Format: yyyyMMDD x 9 RATE1 Numeric(11,6) Spot exchange rate. x 10 FVLDTE Numeric(8) Forward value date. Format: yyyyMMDD x 11 RATE2 Numeric(11,6) Forward exchange rate. x 12 CURCD1 Character(3) Currency code: Refer to BSP supplied x reference file for currency - Bought codes. (Schedule 8) - Others 1 (Schedule 13) 13 AMTBT Numeric(15,2) Amount bought. x 14 CURCD2 Character(3) Currency code: Refer to BSP supplied x reference file for currency - Sold (Schedule 8) codes. - Others 2 (Schedule 13) 15 AMTSD Numeric(15,2) Amount sold. x 16 RECNO Numeric(3) x 17 AMTUSD Numeric(15,2) USD amount. For RECNO = 50: x USD Net FX Position. For RECNO = 60: US$ equivalent of USD Net FX Position. 18 AMTJPY Numeric(15,2) JPY amount. For RECNO = 50: x JPY Net FX Position. For RECNO = 60: US$ equivalent of JPY Net FX Position. 19 AMTDEM Numeric(15,2) DEM amount. For RECNO = 50: x DEM Net FX Position. For RECNO = 60: US$ equivalent of DEM Net FX Position. 20 AMTCHF Numeric(15,2) CHF amount. For RECNO = 50: x CHF Net FX Position. For RECNO = 60: US$ equivalent of CHF Net FX Position. 21 AMTGBP Numeric(15,2) GBP amount. For RECNO = 50: x GBP Net FX Position. For RECNO = 60: US$ equivalent of GBP Net FX Position. 22 AMTEUR Numeric(15,2) EUR amount. For RECNO = 50: x EUR Net FX Position. For RECNO = 60: US$ equivalent of EUR Net FX Position. 23 AMTOC1 Numeric(15,2) Other currency 1 For RECNO = 50: x amount in US$ Other currency 1 Net FX equivalent. Position. For RECNO = 60: US$ equivalent of Other currency 1 Net FX Position. 24 AMTOC2 Numeric(15,2) Other currency 2 For RECNO = 50: x amount in US$ Other currency 2 Net FX equivalent. Position. For RECNO = 60: US$ equivalent of Other currency 2 Net FX Position. 25 CURCD3 Character(3) Other currency x code 3. 26 AMTOC3 Numeric(15,2) Other currency 3 For RECNO = 50: x amount in US$ Other currency 3 Net FX equivalent. Position. For RECNO = 60: US$ equivalent of Other currency 3 Net FX Position. 27 AMTOTH Numeric(15,2) Amount of Other For RECNO = 50: x Currency (aside Other currency (aside from from currency code currency code 1-3) Net FX 1-3) in US$ Position. equivalent. For RECNO = 60: US$ equivalent of Other currency (aside from currency code 1-3) Net FX Position. 28 TOTAMT Numeric(15,2) Total amount in NOTE: For use ONLY on the x US$ equivalent. following record numbers: For RECNO = 60: Total amount. For RECNO = 70: US$ equivalent of unimpaired capital. For RECNO = 80: Ratio of Net FX Position to unimpaired capital. ANNEX B Guidelines on the Creation of the CSV Report File for the FX-Form 1A Note : 1. Population of report data in the CSV report file shall follow the guidelines as described in the "Manual of Instructions" of the FX-Form 1A Report (Revised 2011). 2. The first record must contain the FIELD NAMES as defined and in the same order as specified in this document. Value Formats : Date All date values must follow the format yyyyMMDD ( e.g. , 20140901). Numeric All numeric values must be unformatted ( e.g. , 100000.25, 1032, 0.001321) Character All character values must be enclosed in double quotation marks ( e.g. , "Juan T. Dela Cruz", "000-901-155-322", "Pedro's Hardware Supply") CSV File Structure for DES Report : Field Field Name Data Type Description Remarks Main Schedule No. Report 1 2 3 4 5 6 7 9 10 11 1 BANKCDE Numeric(6,0) Bank code of This is a BSP provided x x x x x x x x x x x reporting bank. bank code. 2 REFDATE Numeric(8,0) Reference date Format: yyyyMMDD x x x x x x x x x x x of report. 3 FORMNO Character(5) Report schedule For "Main Report", value is x x x x x x x x x x x number. TRD00. For "Schedules", value is equal to the schedule number (e.g., Schedule 1 = "TRD01", Schedule 2 = "TRD02", etc.) 4 SEQNO Numeric(2) Item sequence Refer to BSP supplied x number. reference file for sequence number. 5 RECNO Numeric(3) Record number. Refer to BSP supplied x x reference file for record numbers. 6 TRANCDE Numeric(3) Transaction code. Refer to BSP supplied x x x x x x x x reference file for transaction codes. 7 BNKCDE2 Numeric(12) Counter-party bank Refer to BSP supplied x x x x x x code. reference file for bank codes. 8 CURRCDE Character(3) Transaction Refer to BSP supplied x x x x x x x x x currency code. reference file for currency codes. 9 BOOKCDE Numeric(1) Book code. 1 - Regular x x x x x x x x 2 - FCDU 10 DEBTCDE Numeric(10) Debtor code. Refer to BSP supplied x x reference file for debtor codes. 11 CREDCDE Numeric(12) Creditor code. Refer to BSP supplied x x reference file for creditor codes. 12 DESC40 Character(40) Other miscellaneous x x services for Schedule 5. Transaction description for Schedule 7. 13 CTRYCDE Numeric(3) Country code. Refer to BSP supplied x x x x x x x x reference file for country codes. 14 BENEF Character(35) Name of beneficiary. x 15 REMIT Character(35) Name of remitter. x 16 INVESTEE Character(35) Name of investee. x 17 TYPE1 Numeric(1) Type of investee. 1 - Bank x 2 - Non-bank 18 INVESTOR Character(35) Name of investor. x 19 TYPE2 Numeric(1) Type of investor. 1 - Bank x 2 - Non-bank 20 SECURITY Character(35) Name of securities x issuer. 21 TYPE Numeric(1) N/A N/A 22 XPRTCDE Numeric(10) Exporter code. Refer to BSP supplied x reference file for exporter codes. 23 PAYMODE Numeric(1) Mode of payment. 1 - Letter of Credit (LC) x x x 2 - Documents Against Payment (DP) 3 - Document Against Acceptance (DA) 4 - Open Account (OA) 5 - Direct Remittance 9 - Others 24 STATCODE Numeric(1) Import status code. 2 - Amendment x 4 - Self-funded 5 - Revision/Extension 6 - New 7 - Sight 8 - Deferred/Usance 25 LCNO Character(20) LC number. x x 26 RGIBRN Character(20) Record of Goods x x Imported/Bank Reference No. 27 BLDATE Numeric(8) Date of bill of lading Format: yyyyMMDD x x or date of acceptance of DA. 28 IMPCDE Numeric(10) Importer code. Refer to BSP supplied x x reference file for importer codes. 29 LCEXPDTE Numeric(8) Maturity date. x 30 DUEDTE Numeric(8) Due date. Format: yyyyMMDD x 31 LCBNKCDE Numeric(12) N/A N/A 32 AMTREG Numeric(15,2) FX Regular amount. x x 33 AMTFCD Numeric(15,2) FCDU amount. x x 34 AMTTOT Numeric(15,2) Total amount x x (Regular + FCDU). 35 AMTDOLR Numeric(15,2) Amount in US$ x x x x x x x x equivalent. 36 PRINORIG Numeric(15,2) Principal payment x amount in original currency. 37 PRINDOLR Numeric(15,2) Principal payment x amount in US$ equivalent. 38 AMTORIG Numeric(15,2) Amount in original x x currency. 39 EXCHRATE Numeric(15,2) Exchange rate. x 40 DOCNO Character(20) Tax Identification x x x x x x x Number (TIN): - Debtor (Schedules 3 & 4) - Beneficiary (Schedule 5) - Investee (Schedule 6) - Exporter (Schedule 9) - Importer (Schedule 10) - Importer (Schedule 11) 41 COMDES Character(25) Tax Identification x x x x Number (TIN): - Creditor (Schedules 3 & 4) - Remitter (Schedule 5) - Investor (Schedule 6) 42 COMCDE Numeric(8) Number of transactions. x