RD Accounting Tool
— the innovative product developed by RDTEX.
The product is intended to ETL and BI-systems functionality expands in the financial data line-by-line calculation area:
System Architecture
System Capabilities:
Independently create and immediately calculate the financial indicators sets (balance sheet items) based on the masks and account parameters
In calculating online, to use the data from the bank information systems, prepared DWH data, and the data of already calculated reports
Detail each indicator calculation, up to the personal accounts
Model the change in indicators after the data adjustments
Share the developed reports in the working groups (departments)
Upload the results to Excel (CSV), PDF
Use the indicators in DWH BI reports
Reporting on the balance structure in the context of the accounts analytical parameters: the account mask, currency and other configurable parameters (for example, segment codes, maturity of asset-liabilities, the financial groups’ codes, etc.)
The data reconciliation between the bank information systems
Accounting control and verification:
– balances analysis on the correspondent accounts;
– balance analysis in linked accounts;
– checking the balance sheet before closing the operation day
The accounting data reconciliation before
sending to the regulatory authorities
Benefits for Banks:
Rapid response to changes in the banking operations accounting, the new products’ introduction, etc.
Independently changing and testing the management accounting techniques
Reuse of already developed expressions
Load IT reduction
The changes’ prediction in the accounting system and the balance sheet data display
Ability to use for calculations both stored historical DWH data and “fresh” data online
The data preparation for calculations on the schedule and on the request
The ready Data Marts calculation for B2, WAY4, PIN DWH
An assistant in the formulas’ construction
Ability to check the calculation of each indicator, up to the personal accounts level
Reusing already developed indicators
