Subledger for financial instruments
As one of the leading direct banks in Germany and the market leader in online security business for modern investors, comdirect bank AG offers brokerage, banking and advisory services, in which more than 1.8 million private customers place their trust.
Initial situation and project assignment
In addition to brokerage, the deposit business plays an important role. Due to the resulting balance sheet structure, the bank’s own securities (Depot-A) business has a large volume. In order to meet the growing regulatory requirements and to eliminate the inefficiency and increased error-proneness of manual processes, a project was set up to implement an integrated financial architecture for the financial instruments subledger. The new IT architecture is intended to automate inventory management as well as measurement/valuation in accordance with IFRS and HGB and posting in line with HGB (German Commercial Code). This provides a basis for automating numerous external and internal reports in the finance, risk management, treasury and controlling departments.
Project content and approach
To begin with, we clarified comdirect’s requirements in workshops and, on this basis, derived the range of necessary functionalities. As a result, we developed a solution comprising the three modules zeb.control.risk - Trading, zeb.control.accounting - Hedge and zeb.control.accounting - PostingEngine. The modules required further development in order to include the posting logic according to HGB as well as securities lending transactions.
comdirect supplied the data required for valuation/measurement by setting up an input interface. This interface automatically supplies the master, transaction and market data in accordance with the standardized mapping rules of the Trading module. The data is then processed internally at zeb, providing the Hedge module and the posting engine with all the relevant information. In order to also store the data from the zeb modules in the comdirect data warehouse, interfaces were set up that allow for information to be transferred via the database. For posting HGB business transactions in SAP, the system also generates an RFBIBL file as part of the daily process, which is then transferred to the SAP general ledger.
All processes (e.g. for the data import and export) were set up by means of zeb.control’s job management in such a way that the job scheduling software used by comdirect can automatically call up batches. This enables the bank’s IT operations to carry out daily processes in a simple and convenient manner.
Following the technical installation of the three software modules, we carried out the specific configuration together with comdirect. In the Trading module, this involved defining portfolios and creating reports, whereas in the Hedge module it included creating hedge configurations and building a portfolio hierarchy. For correct posting in SAP, account mapping was defined in the posting engine, taking into account not only general parameters of a business transaction but also comdirect-specific parameters per transaction.
Architecture sketch for the structure of the DWH model of comdirect
Based on modern zeb.control software, we developed a financial architecture which automatically carries out a daily valuation/measurement in accordance with both HGB and IFRS as well as posting in accordance with HGB for the financial instruments subledger. The valuation or measurement results is centrally available in the comdirect data warehouse to various user groups for further applications and analyses. With this modern and multi-GAAP-capable subledger solution, comdirect has a modern banking architecture that meets all the requirements and creates the basis for promptly complying with all accounting and regulatory requirements in the future.