VBANK : Full Retail Banking System
Classified Debts System
Corporate Loans System
Forex Dealing System
Client Profile System
- Banking Division hierarchy
- Proposed Visits
- Visits/Entertainment Monitoring
- Balance Sheet Analysis
- Business Development Officers for the following :
Geographical
Client
- Client Follow Up Monitoring
- Business Quoted For
- Company Hierarchy for the Group Subsidiary scenario although
utilises a 3 dimensional setup for allocation
- Product Limit monitoring (3 levels) namely :
SYSTEM MAIN FUNCTIONALITY
Each branch runs a client / server environment but is linked to other branches for client
information access, account enquiries and on-line updates.
Daily “End of Day Audit Trail Reports” reflect transactions captured in each branch
as well as those for remote branches allowing easy branch-to-branch reconciliation.
VBANK caters for the following product functionality and will allow for different
interest rate matrixes for the same product type:
INTEREST BEARING CLIENT INVESTMENTS:
SAVINGS / TRANSMISSION
NOTICE DEPOSITS
- One day call deposits
- 32 day
TERM DEPOSITS
- 60-day term deposits
- 88-day term deposits
FIXED DEPOSITS
- 6 month fixed deposits
- 12 month fixed deposits
- 24 month fixed deposits
SUBSCRIPTION SHARES
INDEFINITE PERIOD SHARES
INTEREST EARNING ADVANCE PRODUCTS:
MORTGAGE BONDS
- Clients
- Staff / Directors
- Commercial Property
INVESTMENT LOANS
SHORT TERM LOANS
- Study Loans
- Personal loans
VBANK’s Software modules are structured around product groups with the same functionality being
treated according to the same criteria. It revolves around the following three key elements:
FACILITY MATRIX : Product types
INTEREST RATE MATRIX : Product interest rates
CIF MATRIX : Client information file
FACILITY MATRIX
Each product type has its own facility code which contain indicators that control how the logic of the software
treat issues like Interest Accruals, Interest Capitalisations, Interest rate changes, reporting and other functionalities
relevant to that product type. The most significant element linked to this matrix is the Interest Rate Matrix.
Service charge matrixes can be set up per product and new functionality includes tiered, categorised and graded rate
matrixes which can be set up based on capital balances of accounts. A specific product type can be set up differently
for the same type of facility. For example, one type of savings account can have a different capitalisation matrix to
another type of savings account with its own rate structure.
INTEREST RATE MATRIX
This matrix “tells the system” at which rate a product type will be processed at any given date. A history of rate
changes and the dates on which they were effected is stored for future reference by the system. All interest calculations
are based on N.A.C.M. formulae and accrual transactions are passed monthly at the end of each month to every
account with capitalisation entries taken into account at the same time. Interest accruals are calculated on a daily basis
and passed monthly at the end of the month.
CIF MATRIX
This matrix refers to the personal particulars, contact particulars, and marital status etc. of a client and caters for both
an “individual” and a “company” type differentiation of a client. It also allows for extensive client identification and
grouping via identification numbers with helpful search modules to group clients with the same identification
numbers thereby reducing the possibility of duplication at capture. This functionality serves for input to reserve bank
requirements for IT3.
DEBIT ORDERS / PREMIUM DEDUCTIONS
The system caters for the execution of Internal Debit Orders between advances and funding facilities. It also caters
for External Institution payments. Each of these incorporate functionality for service fee matrixes. Internal debit orders
are categorised between Salary Linked and Date Linked. The system will automatically pass the necessary debit
and credit transactions to the respective accounts if possible. Full log reporting is available for audit purposes covering
exceptions. External institution payments functionality will ensure that the necessary accounts are debited and will produce
a list keyed by External Institution for payout totals per external institution.
SUPPORT
· Remote modem support is available to cater for service requirements
· A 24-hour help line with resources to cater for all system technical assistance is available
· The system is locally developed to Southern Africa ensuring on-site response time is reduced for support
SYSTEM DETAIL FUNCTIONALITY
MORTGAGE ADVANCES
· Comprehensive screen enquiry function
· Help screen - Installment calculation at interview stage
· System driven calculations of installments, taking into account insurance term of the advance, current rate etc.
· System driven activation of installments are per advance type :
Ordinary Loan
Building Loan
· Comprehensive bond registration module
· Facility provides for :
- Classification for identification and management in terms of payments or credits
- Grading of Bonds according to Risk
- Grading in terms of Interest Rate allocation
- Reschedule activation / deactivation
- Insurance activation / deactivation
- New valuation inputs
- Replacement Value insurance functionality
- Revaluation management within prescribed time cycles
- Interest suspended / ceased management for problem loans
TERM DEPOSIT : 60 DAYS / 88 DAYS
· Rate management as per date invested over period of term
· Provides the facility to select :
Payment by cheque at end of term
System driven rollover / reinvestment at end of term
· Capturing of maturity notification on rollover investments
· Maturity management :
Provides user with cheque particulars
Indicates interest and capital portion
· Comprehensive Management / Audit / Risk Reports
SAVINGS
· Monthly interest accrual with system driven capitalisations
· Risk management features :
Reporting within transaction level authority parameters
Overdrawn account status
Dormancy management / reporting
On screen blocks on closed accounts / dormant accounts
· Comprehensive Management / Audit / Risk Reports
FIXED DEPOSITS : 6, 12 & 24 MONTHS
· Daily / Monthly interest accrual to end of term
· Comprehensive management of maturity including:
Reporting on cheque amount to clear
Reporting on unclaimed maturities
· Management of rates according to date invested
· Comprehensive Management / Audit / Risk Reports
The system caters for early redemption of these investments due to
special circumstances. e.g. client becomes deceased.
SHARE INVESTMENT : SUBSCRIPTION SHARES
· Monthly Interest accrual with system driven yearly capitalisation
· Risk management features :
Reporting within redemption level authority parameters
Overdrawn account status
Unclaimed share management / reporting
On-screen blocks on closed accounts / unclaimed accounts
Reporting of large exposures
· Comprehensive maturity management
· Comprehensive Management / Audit / Risk Reports
SHARE INVESTMENTS : INDEFINITE PERIOD SHARES
· Monthly Interest accrual with system driven processing / reporting on dividends
· Parameterised actioning on dividends
· Dividend actioning captured indicating :
Transfer to other facilities (automatic system function)
Payment by cheque
Reinvestments to same facility
· Risk management features :
Reporting within redemption level authority parameters
Reporting of large exposures
· Comprehensive maturity management
· Comprehensive Management / Audit / Risk Reports
NOTICE DEPOSITS : 1 DAY / 32 DAY
· Daily rate management and interest accrual
· System driven rate change as and when rates change
· Maturity notification capture which caters for part or full notification
· Comprehensive maturity management
· Comprehensive Management / Audit / Risk Reports
SHORT TERM LOAN ADVANCES
· Comprehensive screen enquiry function
· Insurance activation / deactivation
· Help screen : Installment calculation at interview stage
· System driven calculations of installments, taking into account insurance
· Term of the advance, current rate etc.
· System driven activation of installments at capturing
· Comprehensive Arrear / Rescheduling management
· Comprehensive Management / Audit / Risk Reports
INVESTMENT LOANS
· Multiple linking of security account structure
· Blocking of accounts held as security
RISK MANAGEMENT
VBANK provides a host of new functionalities, which facilitate risk management and reporting features.
The framework designed for the infrastructure of VBANK has considered carefully, the link between the integrity
and validation of data that is input by the user and the processing of that data in order to produce meaningful
risk management reports. Other considerations included in this framework help to automate the data collection
process for additional management reporting. For example, a salary-linked Debit Order is processed automatically
when the client’s salary deposit transaction is captured ensuring that funds from the salary are firstly offset against
debit orders to be serviced , before the client has the ability to withdraw funds from the account.
DATA CAPTURING
INPUT CONTROL
· Account number hash control and Batching with totals
· Mandatory capturing of key input fields
· Wide range of checks on key input fields, including date ranges, ID number range checks and other comprehensive
input checking
· Enhanced CIF inputs which include features like :
Differentiation of individual / company type clients
Marital status
Male / Female indicator inputs
Employment category inputs
Multiple ID number inputs companies / CC’s etc.
Identification feature on existing ID numbers
· Stop blocks on processing to account with closed status, those held as security, dormant accounts, overdrawn
accounts etc.
The software allows only certain transaction types, depending on the current status of the account being processed
e.g. Fixed Deposits will only allow redemption transactions after the maturity date has been reached.
ACCOUNT MANAGEMENT
· Enhanced account balance enquiry screen : second page providing all relevant account management information
· New alpha search / ID number search facilities
· Complete new report sets for each facility type
· Installment calculation module on screen
· Range of stop status and warning messages on screen for enquiry staff, indicating :
Dormant Status
Unclaimed Status
Closed account Status
Held as Investment Loan Security Status
Overdrawn Status
SYSTEM FUNCTIONALITY FOR ENHANCED RISK CONTROL
BONDS
· Calculates installments at registration capture stage
· Activates installments as per loan type automatically at the correct dates
· Levies HO / GLA insurance at registration yearly at June against the Replacement Value carried by the system
· Caters for both Security Value as well as Replacement Value
· Defaults Maturity Dates at registration
· Institutes global installment changes with each rate change
· Allows the changing of bond facility types for interest actioning onarrear bonds
· Allows rescheduling actioning and reporting
· Bond Classification maintenance is incorporated for purposes of regulatory reporting requirements from the SARB
· Risk Grading has been included in this module for comprehensive management of Bonds
SHORT TERM LOANS
· Calculates installments at registration capture stage
· Activates installments as per loan type automatically
· Levies short term loan insurance at registration capture stage
· Allows for non-conventional loan periods
· Defaults maturity dates at registration
· Institutes global installment changes with each rate change
· Short term loans can be classified similarly to Bond Classification
INDEFINITE PERIOD SHARES
The following functionality forms the basis for this product type :
Provides dividend actioning report at dividend payout month-ends
Transfers dividends to relevant accounts as per client request
Reports dividends due by cheque
Reports dividends due for reinvestment in INDEFINITE PERIOD SHARES
Defaults maturity dates at investment capture stage
SUBSCRIPTION SHARES
The system automatically flags as unclaimed 7 days after maturity and stops processing as well as reports any
overdrawn status and stops processing of debit type transactions. Unclaimed sub shares can then be managed
(reactivated) by authorised users.
SAVINGS
The system automatically flags as dormant when no client transactions are recorded for 90 days and stops processing
as well as reports any overdrawn status and stops processing of debit type transactions. Dormant Savings accounts
can then be managed (reactivated) by authorised users.
FIXED DEPOSITS
The system reports maturities for actioning, indicating interest / capital balance to be cleared by cheque. It defaults
maturity dates at investment and allows for the capturing of the investment amount when opening an account all within
the same module.
TERM DEPOSITS
VBANK reports maturities for actioning, indicating interest / capital balance to be cleared by cheque, institutes
rollover, if requested, passing entries automatically by moving interest to capital and reinvesting the sum total for the
next term. It also defaults maturity dates at investment for payout / rollover and allows for the capturing of the investment
amount when opening an account all within the same module.
NOTICE DEPOSITS
Maturities are reported for actioning, interest / capital balances to be cleared by cheque are indicated
(after the notice period has been processed). Maturity dates are defaulted at the processing of the notice given.
INVESTMENT LOANS
VBANK allows for the capturing of accounts to be held as security, instituting blocks to stop processing to these
accounts. Multiple accounts can be set up to cater for a secured amount against a single investment loan.
ACCESS CONTROL
VBANK provides for a comprehensive range of access controls, only allowing access to certain program modules and
reports per seniority and delegated authority from menu level and in certain instances, right down to field level.
The system caters for a 90 day password expiry period and keeps history on all passwords per Access I.D. preventing
users from choosing a previously used password. Only supervisory type users are able to re-instate users who have been
excluded from the system due to either typing in their passwords three times incorrectly or selecting a menu item three
times for which they do not have the appropriate access. All incidents, including re-instating and clearing of users
are logged. Reporting is therefore available right down to the workstation where the incident occurred, giving full audit
tracking in terms of security.
Access to and changes on, key data fields, are now reported. Missing key data fields are also reported for actioning.
RECOVERY
On-line backup procedures form part of each day-end process. Tape stream backup is an additional option to cater for the
storing of offsite data.
REPORTING
REPORTING : BONDS
Capital Balance > 80% of Valuation Amount
Capital Balance > Bond Amount Plus 20%
Monthly Installment < Interest Accrued for the Month
Capital Balances Above R 200,000.00
Capital Balance > 0 and Bond has no Installment
Missing Key Data Fields
Bond Amount > Valuation Amount
Nil Balance Accounts not Flagged as Closed
HO/GLA Insurance Deactivated
Accounts with Positive Balances
Age Analysis (Maturity)
Valuation Analysis
Group Exposure
Number of New Accounts and Amounts : Current Month
Monthly Installment > Credits Processed for the Month
Installment Profile
Standing Data Changes
Other Mortgage Advance Management Reports Include the following :
BOND ARREAR ACCOUNTS REPORT
BOND REPAYMENT ANALYSIS REPORT
BOND CLASSIFICATION REPORT
BOND RISK GRADING REPORT
HOUSEHOLDERS INSURANCE REPORT
GROUP LIFE ASSURANCE REPORT
REPORTING : INDEFINITE PERIOD SHARES
Redemptions Per Category
Overdrawn Accounts
Account Balances Per Category
Age Analysis (Maturity)
Nil Balance Accounts not Flagged as Closed
Number of New Accounts and Amounts : Current Month
Investment Time Profile
Standing Data Changes
Other I.P.S. Management Reports Include the following :
I.P.S. SUMMARY REPORT
REPORTING : FIXED DEPOSITS
Payments Per Category
Overdrawn Accounts
Account Balances Per Category
Age Analysis (Maturity)
Nil Balance Accounts not Flagged as Closed
Number of New Accounts and Amounts : Current Month
Standing Data Changes
Other Fixed Deposits Management Reports Include the following :
FIXED DEPOSITS SUMMARY REPORT
REPORTING : TERM DEPOSITS
Payments Per Category
Overdrawn Accounts
Account Balances Per Category
Age Analysis (Maturity)
Nil Balance Accounts not Flagged as Closed
Number of New Accounts and Amounts : Current Month
Standing Data Changes
Other Term Deposits Management Reports Include the following :
TERM DEPOSITS SUMMARY REPORT
REPORTING : INVESTMENT LOANS
Accounts With Credit Balances
Capital Balance > Linked Security Account Balance
Capital Balance > 0 and No Linked Security Account
Nil Balance Accounts not Flagged as Closed
No Linked Security Account
Security Analysis By Facility
Security Cover - Capital Balance > 90% Of Security
Number of New Accounts and Amounts : Current Month
Standing Data Changes
REPORTING : SAVINGS
Withdrawals Per Category > R 5,000.00
Overdrawn Accounts
Account Balances vs Dormant Account Balances
Dormant Accounts : Dormancy Time Profile
Nil Balance Accounts not Flagged as Closed
Number of New Accounts and Amounts : Current Month
Standing Data Changes
Accounts with Capital Balances < Minimum Balance
Accounts with Capital Balances < Service Fee
Debit Order Exception Report
External Institution Payment Exception Report
REPORTING : SUB SHARES
Redemptions Per Category
Overdrawn Accounts
Account Balances vs Unclaimed Account Balances
Age Analysis (Maturity)
Nil Balance Accounts not Flagged as Closed
Number of New Accounts and Amounts : Current Month
Standing Data Changes
REPORTING : NOTICE DEPOSITS
Payments Per Category
Overdrawn Accounts
Account Balances Per Category
Age Analysis
Nil Balance Accounts not Flagged as Closed
Number of New Accounts and Amounts : Current Month
Standing Data Changes
REPORTING : SHORT TERM LOANS
Capital Balance > Loan Amount
Monthly Installment < Interest Accrued for the Month
Capital Balances Above R 10,000.00
Capital Balance > 0 and Loan has no Installment
Missing Key Data Fields
Nil Balance Accounts not Flagged as Closed
Accounts with Positive Balances
Age Analysis (Maturity)
Debit Order Reversal (RD CHEQUES)
Group Exposure
Number of New Accounts and Amounts : Current Month
Monthly Installment > Credits Processed for the Month
Installment Profile
Standing Data Changes
Other Short Term Loan Management Reports Include the following :
S/T LOAN ARREAR ACCOUNT REPORT
S/T LOAN REPAYMENT ANALYSIS REPORT
S/T LOAN ARREAR/REPAYMENT REPORT
S/T LOAN CLASSIFICATION REPORT
S/T LOAN INSURANCE REPORT
REPORTING : ACCESS CONTROLS
Workstation List
User Profile Current Menu Access Status
User Profile Access Maintenance
Expired Passwords
Passwords Due To Expire
User History Log
Users Cleared / Re-Instated Log
REPORTING : OTHER MANAGEMENT
PARAMETERISED ACCOUNT SUMMARY (MARKETING REPORT)
EXPIRED ACCOUNTS REPORT
SYSTEM GENERATED TRANSACTIONS REPORT
CATEGORISED FACILITIES REPORT
RATE GRADED FACILITIES REPORT
DEBIT ORDERS EXECUTED REPORT
DEBIT ORDER REPORT (ACTIVE)
EXTERNAL INSTITUTIONS PAYMENTS EXECUTED REPORT
EXTERNAL INSTITUTIONS PAYMENTS REPORT(ACTIVE)
REPORTING : ENQUIRIES
LOCAL PARAMETERISED STATEMENTS
(To Normal or pre-printed stationery)
GLOBAL STATEMENT ENQUIRY (For Remote Branch Accounts)
(To Normal or pre-printed stationery)
REPORTING : LISTINGS AND GENERAL
Installment Change Notification Listing
(Available on rate changes)
IT3 EXCEPTION REPORT
IT3 CERTIFICATE (SPECIFIC) to clients
IT3 EXTRACTION (BRANCH DATA)
IT3 CONSOLIDATION S.A.R.S.
UTILITIES - PRINT LABELS
BRANCH FILE LISTING
FACILITY FILE LISTING
RATE HISTORY FILE LISTING
S/FEE CHGS./RATES FILE LISTING
DEBIT ORDER REPORTS
EXTERNAL INSTITUTIONS LISTING
DEBIT ORDER SERVICE FEE LISTING
PRINT AUDIT TRAIL
C.I.F. FILE LISTING
TECHNICAL SPECIFICATIONS / REQUIREMENTS
Core
application developed as component run time modules.
Database platform
:
Btrieve ver. 6.15 / Pervasive (All)
Minimum Hardware Requirements
: P3
Processor
40 GB Hard disk
256 MB RAM
Operating Systems Supported
: DOS
3.30 or higher
Windows 95 or higher
Windows NT
Networks Supported
:
Netware 4.15 or higher
Windows Server 95 / 98 / 2000 / NT / XP
Operating Environment
Locally : Centralised database / Decentralised Processing
Remotely : Decentralised database / Decentralised Processing
This enables enquiries / transaction processing for clients at local branches
to continue even if communication errors occur.