|
Analytical subsystems & settings |
|
The following analytical tools are implemented in ABS B2:-
- Express analysis at the form level: the capabilities of filtering, grouping, calculating aggregate functions; of producing reports of various formats (including Excel, Word, dBase, Paradox);
- Integration with MS Excel analytic subsystems (see Analysis Function Library (balance.xla)" below);
- The projection of the appearance of and posting documents ("Expected Documents") for each transaction based on a predetermined flow schedule (for example, expected documents of loan repayment, of growth in interest, of repaying debt for settlement and cash services, etc.). Based on actual balances, footings, expected documents, Treasury's analytical reports are produced;
- FX Position report which shows an opening balance, a closing balance, and footings of FX position accounts.
1 Calculation and Analysis of Bank's Ratios
This subsystem enables ratios R1 to R13 to be calculated manually or automatically as at any accounting date with taking account of calculation rules effective on this date.
For multibranch banks, in order to calculate the ratios for the legal entity as a whole, в branches' balance sheets (balances and footings) transmitted in a special format of ABS B2 files are downloaded in the Head Office.
A ratio value may be installed manually (in such case, the ratio will not be calculated but rather the value installed manually will be used).
2 Analysis Function Library (balance.xla)
There has been developed the Analysis Function Library with the aids of which functions access is effected to ABS B2 database from MS Excel taking account of the rights of access to accounts established at the ABS level. A function (or a set of functions) is a template with the list of conditions under which a value on a specified date returns from the database to the relevant report cell.
Using the Analysis Function Library, the following reports in MS Excel have been implemented:-
- Ratio calculation with the function of modeling changes in ratios depending on change in a balance sheet;
- The calculation of the rate of allowances on the consolidated correspondent account with the National Bank of Ukraine;
- Bank's FX position control (R13);
- The analysis of bank's income and expenses;
- The analysis of balance sheets of correspondent banks (based on files #01 and #02 of statistical reports to the National Bank of Ukraine).
Note: Using the above reports as examples, the bank may develop its own analytical reports with no participation of the developers.
|
