Release updates

We are pleased to inform you about the new SOFiE update "V6.07.03 (2024-03-26)" dated March 26^th 2024, end of afternoon .

New SDMX Schema v1.0.10 for AnaCredit

The SDMX schemas v1.0.10 have been published and will be applicable for the reference date of April 2024 (included).

Please pay attention to the fact that:

• Reference dates from September 2023 to March 2024 (included) have to be submitted in the v1.0.9.
• Reference dates from April to August 2023 (included) have to be submitted in the v1.0.8.
• Reference dates until March 2023 (included) have to be submitted in the v1.0.7.

We are pleased to inform you about the new SOFiE update "V6.07.03 (2024-01-23)" dated January 23rd 2024, end of afternoon .

New CAA Reports

Implementation of 4 new reports for the "Commissariat Aux Assurances" (see this CAA document for more information.)

Our dedicated SOFiE Helpdesk is available for any other technical question at (+352) 355 66 - 600, or by E-mail : sofie.lux@worldline.com.

CSSF Reports using S3 protocol

Implementation of a complete dedicated flow in the SOFiE client for better management of all CSSF reports using the S3 protocol.
Reports using S3 already handled will remain available via the historical flow, in addition to being considered in the new dedicated flow.
This new feed will be available from the following 2 channels, depending on your choice:

• ATLAS (GUI mode)
• SOFiE (batch mode only)

A full description of this new feed will be provided in a forthcoming communication.

We remain available to support you in setting up the service using the CSSF S3 protocol (reporting@cetrel-securities.lu).

We are pleased to inform you about the new SOFiE Sort update "V6.06.00 (2023-05-30)" dated May 30th, 2023.

Version control enhancements v1.0.7 and v1.0.8 for AnaCredit
Version control improvements for v1.0.7 or v1.0.8 depending on the reporting period of AnaCredit reports.

CSSF S3 Report
Handling of the latest CSSF reports using its new S3 system:

• SFDR Report
• CSDR7 Report
• SCI Real Estate information Report

Cetrel-Securities are available to assist you in the implementation of this service (email: reporting@cetrel-securities.lu).

This update will include bug fixes and technical updates.

(e.g: support of next LuxTrust CA: LTEPCA)

New schema SDMX v1.0.8 for AnaCredit
The SDMX schemas v1.0.8 have been published and will be applicable for the reference date of April 2023 (included) onwards. Please pay attention to the fact that previous reference dates have still to be submitted in the v1.0.7.

CSSF EACIND Report
As a reminder you can use SOFiE Sort to transmit the new XBRL EACIND report to the CSSF using its new S3 system. We are available to assist you in the implementation of this service (reporting@cetrel-securities.lu).

This update concerns an alignment of available tables for COFREP reports as well as of available values of field "Accounting version" with the CSSF naming convention.

You will find all information in the Reporting Handbook and in the latest version of the CSSF naming convention.

1. BCL - New table S1.5 layout 4:

Please take note of the circular letter ST.22-0449 of the BCL regarding the introduction of the new table S1.5 layout 4 from the reporting referring to December 2022. 

The related documents can be consulted on the BCL website: S 1.5 "Information on interest rates in EUR".

The TEST channel will be available with the BCL as of November 16 (using the TEST Context in your SOFiE client).

Please note that this is a TEST channel and S1.5 layout 4 can only be sent in PRODUCTION mode from January 1, 2023.

2. CSSF - EBA V3.2 taxonomies           

Please take note of the implementation of the new naming conventions concerning the reports for credit institutions using the naming convention "COFREP".

You will find this information in the Reporting Handbook and the latest version of the CSSF naming convention.

This update will be available only for the SOFiE Sort version 6.05.03 and concerns an update for AnaCredit reports for BCL.

New schema SDMX v1.0.7 for AnaCredit

Linked to the circular-letter form BCL new XSD v1.0.7 will be mandatory for AnaCredit as of September 25, 2022. The old XSD is no longer valid as of this date.

(Re)submissions of reports for past periods will have to respect this new version of the XSD for any submission from September 25, 2022.

The changes to the FATCA editor are a follow-up to the newsletter published by the "Administration des Contributions Directes",  (Direct Tax Administration), aka ACD  on April 7th, 2022: "https://impotsdirects.public.lu/fr/archive/newsletter/2022/nl07042022.html".

You will find all the information regarding FATCA reports as processed by the DTA: "https://impotsdirects.public.lu/fr/echanges_electroniques/FATCA.html".

This version includes an update concerning the V160-F files (CDDP6 report) sent to the BCL (Banque Centrale du Luxembourg).

Update of the postal address, e-mail address and phone number of the Sofie helpdesk following the Worldline rebranding.

Correction of the nomenclature of OTHREP and OTXREP files. The character 'dot', for example, is now supported in the free part of the file name.

In addition, the Sofie client now uses a third level in the version number.

Fixed a bug that could cause the Sofie client to crash on very rare occasions.

The SOFiE client uses version 2.17.1 of the log4j library. It fixes important security flaws discovered at the end of 2021.

We are pleased to inform you about the new SOFiE Sort update dated 26th October, 2021.

This update will be available only for the SOFiE Sort version 6.03 and concerns new reports for BCL and CSSF.

New feature in version 6.03 :

1-      New regulation ECB/2020/59 (CDDP6)

CDDP6 documentation is available on the BCL website.

All these reports will be added to the existing SOFiE VIRT package.

2-      New BCL circular 2021/244

Among the impacted reports, the following reports have technical changes:

-       S 1.8 "INFORMATION ON SECURITIZATION TRANSACTIONS CARRIED OUT BY CREDIT INSTITUTIONS":
https://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/S0108/S0108_L2_XML_2021.zip

-     TPTBB "SECURITY BY SECURITY REPORTING - BALANCE SHEET DATA" :

-     TPTBBL Layout 5 Luxembourg entity:
https://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/TPTBB/TPTBBL_L5_XML.zip

 -     TPTBBN Layout 5 Luxembourg entity and its foreign branches:
https://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/TPTBB/TPTBBN_L5_XML.zip

For other reports, the technical version (XSD schema version) has not changed, only the business version (layout) has changed.

BCL has not yet communicated a revocation date for the old XSD.

3-      New schema SDMX v1.0.6 for AnaCredit

New XSD v1.0.6 will be mandatory for AnaCredit as of January 25, 2022. The old XSD is no longer valid as of this date.

4-      New CSSF Circular-CODERES 21/13

Changes in CSSF-CODERES Circular 21/13 result in a new OTHREP-BNNNN-XXXXXXXXXXXXXXXXXXXX_LU_SRF070002_EACIND_2022-01-31_yyyymmddhhmmssnnnn report that will be included in the existing SOFiE ESPT package.

As we already mentioned in our previous communications, all these changes will only be available on SOFiE 6 series.

It is therefore imperative that you update to the latest version of the 6 series. As a reminder, it is not possible to switch from version 5 to version 6 automatically.

More information is available on Sofie's website and more particularly this document.

Please do not hesitate to contact our SOFIE helpdesk in case of technical questions at +352 355 66 – 600 (option 1), or by E-mail: Sofie.lux@six-payment-services.com .

On July 5th, 2021, a new version of the CRS v2 report editor was released. An error in the creation of "Zero reporting" reports has been corrected and a simplified user guide describing the creation of such a report has been published in the "Support / Documentation" section.

On June 29th 2021, a new version of the FATCA v3 report editor was released. The values 222222222 to 777777777 are now accepted to inform why a TIN is not filled in. Please refer to the FATCA documentation on the ACD’s website for more information.

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 14th, 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 28th, 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 27th, 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 19th, 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 28th and May 14th.

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 14th, 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 15th , 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 31st, 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.