Release updates

On April 7th, 2021, a new and improved version was put online. It concerns an update of the COFREP report naming convention and the new accepted tables (SFRTBX, CFRTBX, CGSIIX, MRDECI, SMRTLA, CMRTLA) as well as the support of version 1.0.5 of the Anacredit report validation XSD, which comes into force on 1 July 2021 and replaces version 1.0.4.

On 15 February 2021, a bugfix regarding the sending of SGOREP reports was made available. It is labelled "V6.02 (2021-02-15)".

New features for SOFiE-Business customers:

• Support of a new file type (SECU) for the “Centre Commun de la Sécurité Sociale” (CCSS). The CCSS will communicate more information on this subject directly to its affiliates at a later date.
• Various minor corrections

News about SOFiE-SORT customers:

• Two new reports for the “Commissariat Aux Assurances ” . (See this CAA document for more information.)
•     ‘Rapport distinct Solvabilité 2 de l’entreprise’ (RSE) with “Déposant“= Company
•     ‘Rapport distinct Solvabilité 2 de l’entreprise (narrative part)'. (N11) with “Déposant“= Company
• Availability of business feedbacks from the “Banque Centrale du Luxembourg” regarding the ANACREDIT report (FDBBUSI)
• Ability to control two different XSD versions in parallel for the ANACREDIT report
• Various minor corrections

On November 14^th, 2020, an updated version of the SOFiE V5.26 & V6.01 client were made available. These two versions contain the same functionalities and differ only in the Java Runtime used. The version 5 series will no longer be maintained after 2020. Please refer to the chapter above for more information.

This update includes the following new features:

• FDBTECH files from BCL are now supported. They replace the former BCLFBR files.
  
• Minor corrections

On October 14, 2020, two new versions of the SOFiE client were made available, "5.26" and "6.01". These two versions contain the same functionalities and differ only in the Java Runtime used. The version 5 series will no longer be maintained after 2020. Please refer to the chapter above for more information.

This update includes the following new features:

• Implementation of version 2 of the CRS schema and FATCA changes
• AnaCredit - IDA report follow-up AnaCredit conference of 27/28 February 2020
• Minor corrections

On September 22 ^nd, 2020, the list of entities that can send OTXREP files to the BCL was expanded.

On March 10th, 2020, an updated version of the Sofie client has been made available.

This version contains:

• Reports to the CAA (Commissariat Aux Assurances) that alreday suported the file formats "xls" now also support "xlsx".

On January 28^th, 2020, a version of the SOFiE client was made available to users, "5.25".

This version contains :

• Availability of reports covered by the 19/731 CSSF circular (direct link). Please contact Cetrel-Securities for more information.
• Several minor corrections

On November 27^th, 2019, a version of the SOFiE client was made available to users, "5.25".

This version contains :

• The list of supported tables related to COFREP reports has been updated. Please contact Cetrel-Securities for more information.
  
• Several minor corrections

On September 19^th, 2019, a version of the SOFiE client was made available to users, "5.24".

This version contains :

• Availability of the SUFREP report for the CSSF
• Availability of reports F24, F25, ... F32 for the CAA
• Update of the V0115 report layout for the BCL
• Several minor corrections

On June 19, 2019, version "5.23" of the SOFiE client was made available.

There are only a few minor changes.

The binary "wget.exe" has been updated.

The screen that displays error messages when a file does not validate via the GUI now contains the Sofie version number and the connected SOFiE identifier.

It incorporates the latest amendments made to the previous version, "5.22", on March 28^th and May 14^th.

As a reminder, these are the following points:

The agreement naming the reports sent by the financial institutions to the BCL, and to the CSSF in copy, has been updated.

Entities of type "P" can now send all S* and TPTB* reports, such as S0001, S0213, TPTBBL, TPTBBN.

The agreement naming the reports sent by the financial institutions to the BCL, and to the CSSF in copy, has been updated.

These are the "S0103", "S0106", "S0213" and "TPTOBS" files of the OPCT package.

The "reporter type" field now accepts values 1, 5, 6, A, B, I, K, O, P and S.

The "declarant type" field now accepts values 1, 5, 6, A, B, I, K, O, P and S as well as NAF.

On May 14^th, 2019, an update to version 5.22 of the Sofie client has been released.

The naming convention for the reports sent by the financial institutions to the BCL, and to the CSSF in copy, has been updated.

Every S* and TPTB* report can now be sent by an entitiy tpe "P", e.g S001, S0213, TPTBBL.

The naming convention for reports sent by the financial institutions to the BCL, and to the CSSF in copy, has been updated.

These are the "S0103", "S0106", "S0213" and "TPTOBS" files of the OPCT package.

The "reporter type" field now accepts values 1, 5, 6, A, B, I, K, O, P and S.

The "declarant type" field now accepts values 1, 5, 6, A, B, I, K, O, P and S as well as NAF.

The naming convention for these files is described in this document, published in October 2018:

http://www.bcl.lu/en/Regulatory-reporting/Fonds_Investissement/Instructions/Electronic_transmission_IF_EN.pdf

Please note that SOFiE does not currently support the value “NAF”  as a "type reporter" yet.

• Update « statistiques des fonds d'investissement » report (S2.13) for the BCL – SOFiE update mandatory for the latest BCL recommendations
• Availability of the « Prélèvement et versement indirects de billets libellés en EUR par l'intermédiaire d'un tiers » report (S 1.12-L) for the BCL - Package FINT
• The PRED and LMDI files have been added to the CETB package   
  
• improvements in the parameter editor
  
• Updating the verification rule for the AnaCredit reporting agent code
  
• updating the list of document types accepted for DOCREP reports
  
• other small improvements

This version implements a set of corrections and adaptations including in particular

- For FATCA documents, the impossibility to load the TIN field with 9 zeros for cases where a Tax Identification Number (TIN) could not be obtained. The Tax Administration now only accepts 9 capital letters "A" or code "#NTA001#".

- A mandatory update of the SOFIE client before December 1, 2018 to align with the latest security recommendations.

SOFiE-SORT: Two new values (X and T) have been added to the list of possible values for the "final version" field in the file name of COF reports.

A new BCL report is supported: SHSGRP.

SOFiE-SORT: New table names added to COF reporting.

Some minor bug fixes.

- ANA Credit report: validation pattern for the agent code has been set to ^[A-Z]+[A-Z0-9]+$

- Files are process in alphabetical order when processed in batch mode.

SOFiE-SORT-Crypt users may save the active user certificate to a flat file. This should simplify things when sending the certificate to the CSSF.

Some minor bug fixes.

• This new version supports layout 4 of the TPTBBN and TPTBBL reports. For more information, please visit this page on BCL’s website.
• The naming convention for AnaCredit reports has been adapted (field MessageID). For more information, please visit this page on BCL’s website.
• New Ca certificates from Digicert are now included. AN update of the SOFiE client software is requested in order for it to work as of March 15^th , 2018.

This new SOFiE version includes the new MIFID II TAF rules. Effective from that date, only the TAF file name will be controlled.

Concerning the EME reports, table W22 is now supported. (Please see page 14 in the following document )

The older version of the TAF reports are extended even after December 31^st, 2017.

Content: Bug fixed fixed in the TAF 2 report editing GUI ((Mifid /Mifir)

• Support for new TAF reports (MiFID 2/MiFIR)
• New graphical editor for TAF reports (MiFID 2/MiFIR) (see doc in pj)
• Support for the new BCL AnaCredit report (see http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/AnaCredit/index.html)
• Ability to use batch mode to send production and test files at the same time
• Possibility to define, for GUI mode, a default folder where to look for files to send, send or decrypt.
• Create a backup of files essential to the current SOFiE profile
• Displaying the SOFiE contract type used in the graphical user interface
• Minor corrections

• The new file naming convention for FATCA feedback file is now supported. The ACD will start sending them as of September 26th, 2017.

The CRS report editor now allows any value in field “Account number” when “Account Number Type” is set to “OECD605: other”.

• Content check on V0115 files has been activated (CDDP reports V1.15)
• Update on processing rules of TRAM files
• Bug concerning sending of FTCA and CRS files in batch mode an Production context has been fixed

• Updated configuration - V0115 report for CSSF/BCL

• Fixes in the following editors: Fisep, FATCA2 and NCD/CRS
• Deployment of the TAF II GUI
• Update of the extended COREP

Some minor bug fixes in the CRS editor.

Bugfix concerning the sending of CRS reports

(SOFiE-BUSINESS)
This update mainly includes taking into account the editor level and the reports of the new common norms for declaration (NCD or CRS, Common Reporting Standard) from Administration des Contributions Directes.

(SOFiE-S.O.R.T.)
It also includes the notion of alternative investment fund managers (type A) at the level of the fund reports (S0103 and S0213).

If your SOFiE application is configured to be updated automatically during the setup. As of the afternoon of 29th march 2017, your SOFiE login screen, main window, and the “Help – About” menu should display “V5.17 20170329”. Otherwise a manual update will be necessary (see the manual for more details).

This update is optional but recommended in the frame and context of this new norm.

• FATCA version 2 editor has been updated
• New reports supported towards CAA (RSO, FRI, RNx). Please contact Cetrel-Securities for more information.
• Some minor bugfixes

• Fix of a bug. In some cases, SOFiE worked fine but wouldn’t write any log file.

• FATCA report: Support o version 2 as defined by the Luxemburgish tax administration (ACD: Administration des Contributions Directes). You will find more information about FATCA 2 on the ACD’s website on the following page: “FATCA”  (French only).
• Minor bug fixes

• New data collection CDDP BCL.
• Adding of the report solo EAC (SEACXX – COREP extended).
• Set up of the naming convention for the Solvency 2 report “group”.
• Some minor bug fixes

Because of a bug, when trying to send an erroneous file , the error messages were not shown in the popup window when using the GUI and were not written to the log file. The bug has been fixed.

Some minor bugfixes.

The encryption parameters for the U1.1 reports were updated. Only the customers sending these files (name: U11REP) have to update their SOFiE client installation.

• The following category codes are now accepted for a GIIN code : LE, SL, ME, BR, SP, SF, SD, SS and SB.
• A US formatted TIN has to be a sequence of nine numbers only. The value ‘000000000’ is accepted to indicate an unknown TIN.

• Bug fix concerning the feedback files from CAA (Commissariat Aux Assurances), see naming convention version 1.01 under : http://commassu.lu/upload/files/504/CAA_FNC_v101.pdf
  
• New table Z22 allowed for EDP reports (see CSSF naming convention version 1.27,page 15 : https://www.cssf.lu/fileadmin/files/Reporting_legal/transport_securisation_reporting)/Convention_de_nom.pdf )

• New reports related to the CSSF circular 15/624.
• The new BCL - insurance corporations reports related to the BCL circular 2015/239
• Suppression of the unnecessary extensions related to the CAA sending.
• Correction regarding the BCL validation rules: the pool factor value must be greater than 0.
• New naming conventions of the BCL reports CDDP (files V0000 – V9999).
• some minor bug fixes and enhancements

Please contact our helpdesk for more information.

Bugfix in the FATCA editor, also known as FATCA GUI, of your SOFiE Business license: The installation of this correction is compulsory if you wish to use this functionality. If you have to send a FATCA file, we kindly ask you to wait until your SOFiE has been upgraded to version 5.10 in order to do your input via the graphical interface to prepare your FATCA reports. If you are not using this functionality, you can wait for the next release that is foreseen in January 2016

As usual, some minor enhancements and bugfixes have been included.

Please contact our helpdesk for more information.

Bugfix in the FATCA editor, also known as FATCA GUI, of your SOFiE Business license: The installation of this correction is compulsory if you wish to use this functionality. If you have to send a FATCA file, we kindly ask you to wait until your SOFiE has been upgraded to version 5.10 in order to do your input via the graphical interface to prepare your FATCA reports. If you are not using this functionality, you can wait for the next release that is foreseen in January 2016

As usuals, some minor enhancements and bugfixes have been included.

Please contact our helpdesk for more information.

• Fix a bug concerning the password change procedure
• Fix a bug concerning the log file not being written under some circumstances
• Fix a bug in the FATCA editor (aka FATCA GUI) when modifying saving an existing "Zero reporting" file.
• Minor improvements in the FATCA editor.
  

Please contact our helpdesk for more information.

• Fix a bug concerning the encryption of S0216 and S0217 files.
  

Please contact our helpdesk for more information.

• Reports towards the CAA (Commissariat aux Assurances). For more information, please refer to Cetrel-Securities web page.
• Concerning the reports sent to the BCL, hte content of these ones is now also tested in addition the their name: S0001, S0101, S0104, S0105, S0108, S0205, S0208, S0209, S0401, S0216, S0217. 
  
• Sofie user's may now resend the installation report when requested so by our helpdesk. It contains some usefull information for debugging purposes. (see menu Tools-> Installation report, then clieck on the "Send" button.
• A bug has been fixed which caused some installation files to be corrupted when running more than one instance of the client software on a same computer.

Please contact our helpdesk for more information.

• Support new report S 1.9 «Information on CNY (renmibi) operations»:  S0109 (package  FINT): http://www.bcl.lu/en/reporting/credit_institutions/S19_en/index.html
• Naming convention has been adapted to the latest definiton from CSSF (version 1.19 to 1.21):http://www.cssf.lu/fileadmin/files/Reporting_legal/transport_securisation_reporting/Convention_de_nom.pdf

Please contact our helpdesk for more information.

Version 5.06 has been merged into version 5.07.

• Support new layouts of reports:  S0214 (package  TTRT): http://www.bcl.lu/en/reporting/Securisation_vehicules/S214_en/index.html .
• Support new layouts of reports:  S0215 (package  TTRT): http://www.bcl.lu/en/reporting/Securisation_vehicules/S215_en/index.html .
• Support new layouts of reports:  TPTTBS (package  TTRT): http://www.bcl.lu/en/reporting/Securisation_vehicules/Reporting_SBS_SVS/index.html

• Support of new S0302 reports, which replaces report S0401:
  http://www.bcl.lu/en/reporting/credit_institutions/S32_en/index.html
• Support of new reports:  S0103, S0106, S0213, TPTOBS (package OPCT): http://www.bcl.lu/fr/reporting/Fonds_Investissement/index.html 
  
• Bugfix in IBS editor(TPTIBS report). Filed "shareholderCountry" should only be present for liabilities, not for assets.

• Support of new S0216 et S0217 reports:http://www.bcl.lu/en/reporting/issuing_companies/index.html
  
• Support of layout 0 and 1 of reports S0101, S0104, S0105, S0108, S0205, S0208, S0209: http://www.bcl.lu/en/reporting/credit_institutions/index.html

• Bugfix concerning declarant identification for TPTBBL, TPTBBN, TPTBHR, TPTBHN reports:
  http://www.bcl.lu/en/reporting/credit_institutions/Reporting_SBS/index.html

• Bugfix: TPTIBS reports, both layout 0 and 1, were blocked due to a configuration error.

• The major enhancement in version 5.02 is the support of layout 2 for the TPTIBS report to the BCL. For more information, please go to BCL's dedicated web page.
• This version also includes some minor bug fixes.

SOFiE-SORT: New values added to COF reporting's final version tag in the filename (X,T).

Support of the new BCL report "SHSGRP".

Some minor bug fixes.

• Bugfix: malformed requests sent to server

• TPTBNR reports are sent to CSSF and BCL (before BCL was the sole recipient).
• COFFBX reports (CSSF response to a COFREP) are compatible.
• Fix of the connexion issue "redirected too many times (20)" which impacted some SORT-CRYPT accounts.
• Fix of a display issue in the login screen on Solaris systems.
• Fix of update issues in batch or run_gui mode.

• Windows 8.1 compatibility
• Java 7 compatibility
• Simplified network configuration. In particular, the LDAP communications are established through a HTTPS tunnel. The opening of port 389 is not needed anymore.
• The legal reporting COFREP (Prudential reporting scheme regarding capital adequacy in xbrl format 2014 )  , AIFREP (alternative investments funds )  for CSSF/BCL are supported
• The new Sécurité Sociale identifiers for companies registered under  the owner’s name are supported
• Display of caps-lock and  num-lock status in login screen
• Error messages enhancements
• Password synchronization in batch mode on system without graphical interface is supported
• OTHREP reports with an extension of 4 characters are no longer allowed.