Accounts AC
Accounts AC
Accounts (AC)
User Guide
Table of Contents
_Toc123563570
Document History............................................................................................................................................................................................4
Introduction .......................................................................................................................................................................................................5
Pre-requisites .............................................................................................................................................................................................. 5
Accounts .............................................................................................................................................................................................................6
Note ................................................................................................................................................................................................................ 6
Overview ....................................................................................................................................................................................................... 6
Blocked (Held) Funds ................................................................................................................................................................................ 6
AC.LOCKED.EVENTS version ................................................................................................................................................................... 7
ACCOUNT version ...................................................................................................................................................................................... 7
AC.LOCKED.EVENTS version ................................................................................................................................................................... 8
Online Account Closing .......................................................................................................................................................................... 10
ACCOUNT.ACCRUAL ............................................................................................................................................................................... 10
Category Codes and Interest Adjustments ....................................................................................................................................... 10
Accounts Menu .................................................................................................................................................................................... 11
Role Based Home Page ...................................................................................................................................................................... 12
Operations.................................................................................................................................................................................................. 13
View Account Record ......................................................................................................................................................................... 13
Edit ........................................................................................................................................................................................................... 14
View Transactions................................................................................................................................................................................ 14
Overview ................................................................................................................................................................................................ 15
Teller Operations ................................................................................................................................................................................. 15
Documents ............................................................................................................................................................................................ 16
Close the Account ............................................................................................................................................................................... 17
Account Close Simulation ................................................................................................................................................................. 17
Account Closure ................................................................................................................................................................................... 17
Linked contracts................................................................................................................................................................................... 19
Customer Accounts ................................................................................................................................................................................. 20
NOSTRO Account ..................................................................................................................................................................................... 21
Internal Accounts ..................................................................................................................................................................................... 21
Setting up a Nostro Account ...................................................................................................................................................................... 22
Customer Account ........................................................................................................................................................................................ 32
Internal Accounts .......................................................................................................................................................................................... 39
Close Accounts .............................................................................................................................................................................................. 41
List of Accounts ............................................................................................................................................................................................. 48
Shortcuts ..................................................................................................................................................................................................... 49
Document History
Comments:
23rd December 2022 – updated with new functionality and the corporate branding.
Introduction
Pre-requisites
To get the most out of this user guide, it is essential that you are familiar with the standard procedures regarding
navigating your way around the system. This includes items such as program access via Role Based Home Pages,
menus, data entry and editing, mandatory and multi‐level fields, committing details, and so forth. All of these are
described in detail in the Navigation user guide.
Accounts
Note
This user guide describes the banking capabilities of the Accounts (AC) module. For processes and procedures
pertaining to Retail Accounts (the AR module), refer to the Retail Accounts user guide.
All references in this document are for the AC module only.
Overview
Two types of accounts are held in the Banking system; these are customer accounts (for example savings) and internal
accounts (your institution’s general ledger accounts).
The category codes refer to the actual accounts in the General Ledger where transactions (customer and internal) will
be placed.
The category codes in the range 1000 to 9999 are defined at implementation and restricted.
These include any accounts related to a customer and are identified by account numbers of up to 14 digits including
the check digit (We use modulo 11 as the default formula for calculating the check digit. Other options are available).
It is not possible to open a customer account until the relevant customer base record and group interest and charges
conditions have been created.
In addition to the account number and the number of the customer base record to which the account relates, the record
contains details such as: Currency, Category, Limit, Account officer and so on. Customer details such as name,
nationality, residence, etc., are held in the customer base record and will be taken form that record as and when
required.
Internal accounts are defined in the range 10 000 to 19999.
The internal account numbers are made up by the key: currency code / category code / sequential number e.g.,
EUR/10000/0100.
These include any accounts related to the institution, such as cash, profit, and capital. Since there is no customer base
record related to Internal Accounts, details such as account title need to be specified when the account is created.
Internal Accounts are identified by codes specifically structured to include information defining the account as follows:
Currency ‐ Category‐ Subdivision within the main category classification.
To allow accurate and detailed MIS analysis, profit and loss data is not held in internal accounts but is kept at the lowest
level by use of specific category codes which are used by all applications to record profit and loss entries.
This file contains details of each amount to be locked in an account, with both start and end dates. These events are
recorded on the ACCOUNT application using the existing fields FROM.DATE and LOCKED.AMOUNT, which are no longer
available for direct input. The system now builds a ‘ladder; of values by date, automatically combining locked events
that cover the same periods and accommodates all increases and decreases. An event for zero amounts is automatically
created to take effect from the date after the last locked amount ends.
Depending on the settings of the CREDIT.CHECK field affecting the account in question, the system checks either the
WORKING.BALANCE against the highest amount locked or checks each AVAILABLE.BALANCE within the cash‐flow
period against each locked amount within the same period.
Whenever the balance falls below the locked amount (in accordance with the above rules) an override is generated to
warn of that fact. Note that the override does not indicate by how much the account balance is short.
AC.LOCKED.EVENTS version
The block on the account is in the amount of USD500, when set as a ‘reducing block’ the system updates the blocked
amount after the COB processed the loan repayment on a contract where the amount blocked reduces progressively
(in line with the outstanding principal).
ACCOUNT version
AC.LOCKED.EVENTS version
AC.LOCKED.EVENTS
Field Description
Transaction Reference ID A unique reference number that identifies a particular locking event.
The number is automatically generated by the system.
Description A free-format field describing the reason for locking the amount on
this record. This description is auto-generated as per the product
parameters defined (as the AC.LOCKED.EVENTS is auto-generated).
From Date This is the date on which the lock on the amount commences.
To Date This is the date on which the lock will end. If left blank, the event will
have no end date.
Locked Amount The amount of funds that is locked during each event.
Contract ID The contract reference, to identify which loan contract the amount is
held as security for.
The 'YES' or 'NO' optional field to decide if a blocked funds
Rc Retry
transaction should be captured by the RC framework and retried on
a pre-defined frequency or not.
Once entered, the value in this field cannot be changed.
‘Yes’ – the block on the account is handed over to the RC framework
and retried on pre-defined frequency.
This AC.LOCKED.EVENTS record can be reversed and in turn the
corresponding RC.DETAIL record set STATUS = "TERMINATED",
END.DATE='TODAY' and NEXT.RETRY.DATE= 'TODAY'.
Whether the balance is checked against WORKING.BALANCE or AVAILABLE.BALANCE depends on the input in the field
CREDIT.CHECK on the ACCOUNT, ACCOUNT.GROUP.CONDITION or ACCOUNT.PARAMETER.
Validation Rules
Field Description
A teller transaction against the locked amount generates this message to the user:
ACCOUNT.ACCRUAL
The purpose of the Account Accrual table is to provide the system with information at Company level about how and
when to process Accruals of interest and charges on Customer Accounts and whether interest capitalisation is inclusive
or exclusive of the balance on capitalisation date, the value dates of interest entries generated and the day on which
the entries are booked.
Interest Accruals may be processed daily or monthly, or it could be specified that no accrual is to be made. Account
charges may only be processed at calendar month end.
The periods of interest accrual could be specified at Account Group or Category Level for different Currency types
(foreign or local). For Accounts not covered by specified definition, default interest accrual periodicity could be defined
based on Account Currency type.
Dates for interest capitalisation are specified at group level in the Group Capitalisation table and for specific Accounts
in the Account Capitalisation table.
The ACCOUNT application is accessed through the following menus and sub‐menus.
Accounts Menu
▪ Account Applications (AR account)
▪ Facility Applications (AR account)
▪ AA Accounts (AR account)
▪ AC Accounts
o Live Accounts
o Pending Records
o Opened Today
o New Account
▪ New Current Account
▪ New Savings Account
▪ Etc.
▪ Inactive Accounts
o AA Accounts
o AC Accounts
▪ Closed Accounts
o AA Accounts
o AC Accounts
▪ Reports
o CGAP Savings Reports
▪ Savings Account Activity (CGAP A1)
▪ Teller Savings Report (CGAP A2)
▪ Active Savings Accounts by Branch (CGAP A3)
▪ Dormant Savings Accounts by Branch (CGAP A4)
▪ Upcoming Maturing Time Deposits (CGAP A5)
▪ Savings Concentration Report (CGAP A6)
Other Actions:
▪ Reset Inactive Accounts
▪ Current Accounts with Revolving Credit Facility
▪ Dividend Handling
▪ Messaging
▪ Savings Insurance Claim Processing
The landing page displays all the accounts held by the selected customer.
NOTE: AR accounts are at the top of the list, while AC accounts are reported towards the foot of the page.
Alternatively,
All-in-One Home Page>>Customers>>Search for Customer>>Accounts>>Select from menu under ‘Shortcuts’ and
actions/operations are performed by selecting from the icons to the right-hand side of the listed accounts.
The page also provides a variety of options to perform operations on the account/s. These are discussed here:
Operations
On the right hand-side of the account, the following icons are presented:
Edit
Overview
Teller operations
Documents
Edit
If the static information on the Account record is to be updated, select the ‘Edit’ option and process the changes.
Remember to have the changes to the record authorised so that these are reflected on the account.
(NOTE: DIRT Payable is the same as Withholding Tax Payable. The field label will be edited at your implementation to
reflect the terminology used at your institution.) Tax will be deducted from the dividends and paid over to the Tax
Authorities as per the instructions in your country. For more information, please see the chapter on Dividends and
Insurance in this guide.
View Transactions
This represents a statement of the account, detailing all transactions that were booked.
By clicking on the icon to the right of the transaction, the details are presented. Here one can see when the transaction
was processed, by whom, the contra entries, and so on.
Overview
The information on this screen aims to provide the bank user with as much information as possible. Click on the tabs
for more information on the various facilities that may be set up on the account.
When clicking on the (view details) icon next to the entry on the Monthly Activity section and then on the
(view transactions) icon next to the Daily Activity, the system presents a statement on the account:
Teller Operations
It is possible to access the Teller Menu to perform transactions against the selected account:
See the Teller user guide for descriptions of the various Teller type transactions.
Below is the input screen when ‘Cash Withdrawal’ is selected from the menu:
Documents
Documents are generated, for example, a welcome letter, statement of the account, certificate of interest, and so on.
These are stored in the document repository for each customer. It is possible to view and request documents by using
this menu option. Also see the chapter on Account Statements elsewhere in this document.
Users can also upload documentation. Once verified, the documents will be available for view. See the Document
Output and Document Scanning & Indexing user guides for more details.
this icon against the menu items is used to obtain the details. Select as required.
Account Closure
This is where we inform the system of how the account is to be closed and if any settlement charges are to be
applied. The Balances can be seen in the ‘Balances’ tab.
The balance details are found in the next tab, ‘Balance Details’:
When an account is closed the default posting restriction is in the range 90 to 95.
Linked contracts
All contracts that are linked to the account will be presented here, be it that the account is being held as security for a
loan (AC.LOCKED.EVENTS), a Standing Order, Direct Debit, a card, signatory, or mandate that still need to be
terminated/cancelled.
Customer Accounts
A customer ACCOUNT can be one of many different types, a simple current account, overdraft, or savings accounts and
many more. The strength of the Banking system lies in the flexibility within which new account types can be added to
it to meet the institution’s ongoing requirements.
This is a customer‐orientated system. An account is connected to a CUSTOMER record and thus the owner and address
details are not entered on the individual ACCOUNT. This eliminates the need for extensive maintenance of customer
information such as when a customer changes their address.
When the Banking system is installed, part of the implementation process is to configure the types of accounts the
institution wishes to offer and their characteristics. Typically, this would include the debit/credit interest rates, interest
and charges capitalisation frequencies, statement production cycle, charges, other account group conditions etc. Once
these key files are set up the addition of a new customer ACCOUNT is very simple.
▪ Posting Restrictions
▪ Referral Conditions
▪ Alternate Account IDs
▪ Mnemonic Codes
▪ Joint account holders
▪ Liquidation of interest to another account
▪ Charges capitalised to another account
▪ Interest and Charges settled in currencies other than the account currency
▪ Combining balances across accounts before interest calculations
▪ System information fields such as balances, etc.
An example of a regular share/savings account is shown below:
In the above example, the account 1064185 has a field ACCOUNT MNEMONIC, M100002-02 that can be entered into any
standard Transact ACCOUNT field and is translated automatically into the correct ACCOUNT number.
NOSTRO Account
NOSTRO account records have a key in the same format as a customer ACCOUNT and the account-servicing bank is
treated as a CUSTOMER for most purposes. It is identified by the CATEGORY code and the LIMIT.REF field containing
the word “NOSTRO”. As it is a shadow of the VOSTRO account maintained by the correspondent, the customer ID is
informational the real account owner is your institution. An example of a NOSTRO account is shown below:
When setting up a Nostro Account the customer of the ACCOUNT should not receive a statement, or debit/credit
advices. These should be re-directed to your reconciliation department. Create a print re-direct address for the
correspondent (e.g., US0010001.C-100002.PRINT.2 on DE.ADDRESS) then in DE.PRODUCT create a record for the
Nostro Account (e.g., US0010001.A-10065.ALL.ALL) this will prevent any advices for this account being sent to your
correspondent.
For information on the Reconciliation module, its capabilities and how it can assist your Finance Department in their
daily workflow please refer to the Nostro Reconciliation User Guide.
Internal Accounts
Internal accounts are not related to a CUSTOMER record, and are used for maintenance of cash accounts, accrued
profits, suspense accounts, tax, and capital accounts. Since there is no CUSTOMER record related to internal accounts,
details such as account title and short title need to be specified when the account is created. The account number of
an internal account consists of the currency, category, and a subdivision number. An example of a simple internal cash
account is shown below:
Ensure that code 8001 - Banks has been defined in this table.
Ensure that code 8000 - Banks has been defined in this table.
3. CATEGORY
Create CATEGORY 5001, called Nostro Account
4. ACCOUNT.CLASS
Use the parameters defined earlier to create the NOSTRO and BANK records in the ACCOUNT.CLASS
application.
6. Account
Create an account by entering ACCOUNT, (comma) in the command line
Click on the New Deal icon and complete the fields as described below
When all the details have been entered, click on the Commit icon
ACCOUNT version
NOTE: the ‘Y’ flag at RECONCILE ACCT field will mean consolidated entries on the account statement.
Field Description
Account Number This is the number of the account. The format is defined by your
institution and set up at the time of implementation.
Customer Number Specify the customer for whom the account is being opened. Select
the number from the drop-down list.
Category The category code is the unique identification number for this
product (in the GL) and allocated on configuration of your system, in
this example it is 5001 for a NOSTRO account.
Account Name This is the name that describes the account. You may use up to 35
characters.
Currency This specifies the currency in which all financial entries for this
account will be recorded. Select the appropriate code from the drop-
down list. The default is the local currency of your institution.
Identifies the Currency Market for exchange rate information for this
Currency Market
Account, in countries where different rates are quoted for the same
Currency.
The use of this field is only applicable in countries where the
exchange market defines different rates for the same Currency,
according to rules determined by the local authorities or central
bank.
A typical example would be Belgium, where foreign currencies are
quoted on the Regular Market and also on the Free Market. Different
sets of exchange rates exist for these two markets.
The Currency Market flag may also be used to denote notional
markets, i.e., where the User would like to define different sets of
exchange rates according to the type of product handled.
Limit Reference The system will default NOSTRO in this field once the record is
validated or committed,
Account Officer This is the main Account Officer responsible for the account. The
field will be populated with the ID of the account officer as defined
on the Customer Information File.
Alternatively, select an Account Officer from the drop-down list.
The details are created and maintained in All-in-One RBHP>>System
Parameters>>General>>General Parameters>>Account Officers
7. AGENCY
The Agency File contains settlement details of major customers and all banks irrespective of whether there is any
business connection. Details include any arrangements, account relationships and, where possible, the Agents
correspondent bankers for specific currencies. This information is entered centrally to supply Automatic Routing
instructions for remittances/cover to all banks and customers with whom your institution has numerous
dealings. This eliminates the need to re-enter the details at transaction level. It thus allows full advantage to be
taken of electronic delivery facilities by providing, automatically, the settlement agents for remittances/cover
involved in outward payments.
The absence of Agent's correspondent bankers’ information in this file will force the user to enter these details
each time at the transaction level.
Any Nostro account defined in this table is for information only and will not be used as a default Nostro by the
Transaction Processing Application which always uses the NOSTRO.ACCOUNT file.
The basic details of these banks and major customers must first be defined in the Customer file before the
creation of the Agent details will be allowed. Having created a Customer record, which is a Bank, it is advisable
to create an Agency record with the same key, and all available auto-routing details.
AGENCY version
Field Description
Nostro Acct No This is the number of the account opened in step 6 above. The format
is defined by your institution and set up at the time of
implementation.
Defines our actual Account Number in the Books of the Agent Bank
Our Ext Acct No
with whom a Nostro Account relationship exists. It is used to identify
the correspondent's statements related to the account.
Any details entered in this field will be accepted without further
validation and are for information only.
Validation Rules:
Up to 34 type A (alphanumeric) characters. Multi value field to define
actual Nostro account numbers. Associated with field
NOSTRO.ACCT.NO. (Optional input if Nostro Account details input,
otherwise not allowed.)
Holds IBAN of the OUR.EXT.ACCT.NO
Iban Our Ex Acc
If value is entered, it will be validated against IN.IBAN.STRUCTURE
file, else an equivalent IBAN will be retrieved from an external
account record with alternate account type set as “T24.IBAN”
Draft Advice Defines those bank accounts which require drawing advices to be
issued and sent to them when drafts are drawn on them.
Defines the Account Number of an account belonging to an Agent
Their Acct No
(correspondent) maintaining a Vostro Account in our Books.
The Currency of the Vostro Account will be checked to ensure that it
is OUR local currency. Where it is in a Currency other than local, an
override will be required.
The Customer number on the Account record must correspond to
the ID field of the Agent being defined.
Validation Rules:
2-16 numeric character Account number or 3-10 type MNE
(uppercase alpha or numeric or '.') character mnemonic. Multi value
field. (Optional input if Agent is defined as a bank and the Account
as a Vostro as per ACCOUNT.CLASS file. Otherwise not allowed.)
Defines the American Banks Association (ABA) unique identification
Aba Number
for banks in the U.S.
Within Funds Transfer, the SWIFT standard for Country codes has
been adopted. Therefore, the program tests for Residence = US, if
SWIFT is not being used this can be amended to test for the actual
code used.
Validation Rules:
4 numeric characters. Optional input if Agent is defined as a Bank (as
per ACCOUNT.CLASS file). Otherwise not allowed.
The Residence on the Customer record must be United States of
America.
Defines the Universal ID applicable to banks and some multi-
Univ Id
national Customers.
This identification is acknowledged throughout the world and thus
the field values are obtainable from a published user guide.
Validation Rules:
6 numeric characters. (Optional input if ABA number is blank,
otherwise not allowed.)
Defines the SWIFT confirmation address to be used on
Swift Conf Addr
inward/outward telex payments involving this Agent (bank).
It is used in the generation of S.W.I.F.T. Common Reference in
S.W.I.F.T. messages. If this field is not completed then invalid
S.W.I.F.T. messages may be generated for this addressee.
Validation Rules:
8 or 11 characters in the following format: a) Bank code: 4 type SSS
(uppercase alpha) characters. b) Country: 2 type SSS (uppercase
alpha) character country code. c) Location/ Bank code: 2 or 5
characters in the range A-Z and 0-9. (Optional input, otherwise not
allowed.)
The country will be checked to the COUNTRY Code file.
If an input is made and the Agent is not defined as a bank then an
override is required.
Test Signature Defines if testing arrangements exist with the Agent and if they hold
our authorised signatures.
Where a NOSTRO.ACCOUNT relationship is maintained with this
Agent, input must be T or B;
T = Telegraphic testing arrangements exist
S = Signature arrangements exist
B = Both conditions T and S exist
Customer Account
Overview
Various menu options are available for the creation of Customer Accounts. This is where we open the accounts of the
products that our institution offers our customers.
Access
All-in-One RBHP>>Customers>>Search for Customer>>Accounts
OR
Role Based Home Page>>Customer Services Agent>>Search for Customer>>Accounts
Procedure
1. Select the account type from the menu.
2. Click on the New Deal icon. The system will allocate the next available account number.
3. Enter the details as described below.
4. When everything has been completed click on the Commit icon.
5. It is important to remember to have the entry authorised before the record will be available for transactions.
Mandatory fields are identified by an asterisk to the left of the input area and needs to be filled with relevant data.
ACCOUNT version
Field Description
Account Number This is the number of the account. The format is defined by your
institution and set up at the time of implementation.
Customer Number Specify the customer for whom the account is being opened. Select
the number from the drop-down list.
Category The category code is the unique identification number of this product
and allocated on configuration of your system.
This is automatically allocated by the system and depends on the
menu option selected by you, for example 7313 is a regular share
and 6002 is a savings account.
Account Name This is the name that describes the account. You may use up to 35
characters.
The name defaults from the information as stored on the Customer
Information File and you can change the name of the account as
requested by the customer, for example HOLIDAY account, should
the customer wish to allocate different savings accounts for different
purposes.
Currency This specifies the currency in which all entries for this account will be
made.
Select the appropriate one from the drop‐down list.
The default is the local currency of the institution.
Account Officer This is the main Account Officer responsible for the account. The
value in the field will be populated with the ID of the Account Officer
as defined in the Customer Information File.
Alternatively, select the appropriate ID from the drop-down list. The
details are created and maintained in Administrator Menu>>System
Tables>>Account Officer.
Employee Number The system will default the Employee Number as maintained in the
Customer Information File. This is a no-input field and for
information purposes only.
Limit Reference If this product allows an overdraft facility and the customer has a
credit limit covering this account, enter the applicable limit reference
here.
Limits may be set up per customer, group, product, industry and/or
currency.
Should you leave this field blank, and a limit reference exists for this
product, the system will display the reference on committing the
record.
Blocked Reasons If this account is blocked, record this by selecting a reason from the
drop-down list. When the account is blocked as security for a loan,
the amount will be automatically blocked during the loans
processing (there is no requirement to repeat the block on the
account (which is done through AC.LOCKED.EVENTS described
elsewhere in this document)).
The block will prevent the account from receiving debit or credit or
both debit and credit transactions while in force.
Opening Date This is the date on which the account was opened. If you leave this
blank, then the system will default the current system date.
Dates are entered in the format DD-MMM-YYYY, for example 29
MAR 2021, or use the calendar provided.
Contains the value date of future credit and debit movements to the
Value Date
account for the purpose of cash flow processing.
Fields CREDIT.MOVEMENT to VALUE.DATED.BAL indicate all debit
and credit movements to the account valued on the date in this field.
Cash flow Balances are held here for all forward dated and value
dated account movements up to the number of calendar days
forward from today as specified on the 'CASH FLOW DAYS' field on
the ACCOUNT.PARAMETER file.
If a value dated entry (not forward dated), is made to the account for
a value date that is past the cash flow window, then this value date
will replace the old window end date and all cash flow balances will
be shown up to this new date.
Validation Rules:
Standard date format. This field forms a multi value set with fields
VALUE.DATE and field VALUE.DATED.BAL.
Dormancy period is tracked. The inactive period (per product) is set
Inactive Marker
up at implementation. Once an account reaches that period of
inactivity, a report is generated, and the account flagged accordingly.
The processes to reset an inactive account is described elsewhere in
this user guide.
The default value for share accounts is ‘Yes’. The system will track the
Calculate Dividend
daily closing balance for the purposes of calculating dividends.
Indicate whether the customer (member) would like Withholding
Tax Payable Y/N
Tax to be deducted from the dividend earned by selecting either Y or
N.
Insurable Y/N Indicate whether the balance on this account is to be tracked for
savings insurance purposes. The total insurable balances of this
customer will be tracked, and the overall position is to be added to
the Customer Information File>>Individual Customer>>Other Info
(stores the value from the legacy system) at the time of processing
an insurance claim.
Note: The Customer Information File setting takes preference over
the Account setting, to explain - the setting on the customer record
is ‘Yes’ and the setting on the account is ‘No’, insurance will be
calculated on this particular account.
However, if the setting on the customer record is ‘No’, insurance will
not be calculated even if you set the value of this field on the account
to ‘Yes’.
Current Year Dividend Points For Credit Union implementations: the system calculates and
displays the dividend points earned on this account during the
current year.
At the End of the Financial Year, the figure in this field is transferred
to the field below and dividend points are accumulated anew.
Dividends will be paid on the figure recorded in this field after the
Previous Year Dividend Points
AGM when the dividend will be declared. This figure will be stored
for the duration of the Financial Year.
For Credit Union implementations: the system calculates the
Savings Insurance Value
Insurance Value per age band and displays the values in these sets
of fields.
For more on dividend processing and handling, please refer to the user guide on Dividend Processing and Insurance
Processing.
Field Description
Joint Customer Should the account be a joint account between two or more
customers, each customer must be recorded as a customer on the
system. In other words, each customer will have a Customer
Information File and therefore a Customer Number. A relationship
needs to exist between the customers of a joint account.
Enter the Customer Number in this field.
Joint Notes This is a free-format field where you may record any relevant
information. The fields above are associated multi value to allow you
to record the data for each customer.
Should a customer leave the joint account, merely remove the multi
value set of fields that contain his/her data. The history file stores
details where you may refer in need.
The purpose of this version is not to provide card management, but to facilitate the ordering, issuing and status updates
of a plastic card to the customer/s of the account. An interface to the card production company will place the order
and when the card is issued, transactions processed on the card will be authenticated. This discussion assumes that the
interface with the card production company is in place and that the orders are placed when the batch job is processed
during the COB.
Field Description
ATM Card (Y/N) Indicate whether cards have been ordered/issued on this account.
ATM Card Number Enter the Card Number (one received from the card production
company or from existing stock)
ATM Cardholder The ATM Card Holder must be a customer on the system. Enter the
Customer Number or select from the drop-down list. Enhanced
search options are available at the icon adjacent to the field.
ATM Card Status Select the status of the card from the drop-down list. This list is
maintained in Administrator Manu>>System Tables>>ATM Status.
Statuses are: Ordered, Issued, Lost, Replaced, Closed, etc.
Last Status Update The system displays the date of the last card status update.
Max Card Balance This is the maximum withdrawal amount that the cardholder/s may
process against the card during any one day. This limit is typically
defined by the customer.
SIGNATORIES version
Field Description
Signing Instructions Indicate whether there are any signing instructions (mandate or
power of attorney) on the account by selecting ‘Y’ in this field.
Signatory Code/name Enter the Customer Number or if the signatory is not a customer of
your institution, then enter the signatory’s name.
Sign Pport/ID Type The system populates this field with the signatory’s Identification
details, if the signatory is not a customer of your institution, you will
need to enter the relevant information.
Sign ID/Ppport No The system populates this field with the signatory’s Identification Number,
if the signatory is not a customer of your institution, you will need to enter
the relevant information.
The system populates this field with the expiry date (if applicable) of the
Pport Expiry Date
Identification Document, if the signatory is not a customer of your
institution, you will need to enter the relevant information.
Date of Signing Enter the date on which the signing instructions were received.
DIARY version
Field Description
Date Enter the date on which the Notes are captured. Entries captured
here are for memo purposes only and will not generate any report as
is the case with DIARY Standing Order instructions.
The AUDIT Version displays audit details such as who was the inputter, who the authoriser, and so forth, which are not
available for entry or editing as they are automatically updated by the system.
Internal Accounts
Overview
The internal accounts refer directly to the accounts within your institution’s General Ledger. Great care should be
exercised when setting up or maintaining these, as the consequences will be far‐reaching in reporting the balances in
the financial books. Internal accounts are configured at implementation.
Access
All-in-One or Finance RBHP>>Finance>>Internal/Nostro Account >>New Internal Account
Procedure
1. Select the menu option.
2. Enter the Account Number. The format is CCYXXXXXXXXX. For example, the USD cash account for Till Two would be
entered as USD100000002.
3. Click on the New Deal icon.
4. Enter the details as described below.
5. When everything has been completed click on the Commit icon.
6. It is important to remember to have the entry authorised before the record will become “Live”.
Mandatory fields are identified by an asterisk to the left of the input area and needs to be filled with relevant data.
Field Description
Internal Account Number The key to the internal account number is:
Currency/category code/sequence number, for example
USD100000002, the system converts the input to
USD-10000-0002
In Multi Company deployments, the system will add ‘-0001’.
Category The category is identical to the category code in the account number
key.
Currency Enter the currency code, to be the same as the currency code in the
account number key. The system defaults to the local currency code
of your institution.
Account Officer Enter the ID of the account officer responsible for this account.
Opening Date This is the date on which the account was opened. If you leave this
field blank, the system will default the current system date in this
field. Dates are either in the format DDMMMYYYY such as
29MAR2021, 20210329 or selected from the calendar provided,
The AUDIT Version displays details such as who was the inputter, who the authoriser, and so forth, which are not
available for entry or editing as they are automatically updated by the system.
Close Accounts
Overview
This option allows you to close an account for any number of reasons.
This file contains details such as outstanding interest and charges and is used to indicate that an account is flagged for
closure.
The information is provided to help the user determine the entries which must be entered to bring the balance to zero
and allow automatic closing to take place.
Access
All-in-One Home Page>>Customers>>Search for Customer>>Accounts>>select the AC account and actions/operations
are performed by selecting from the icons to the right-hand side of the listed accounts.
Procedure
Linked contracts
All contracts that are linked to the account will be presented here, be it that the account is being held as security for a
loan (AC.LOCKED.EVENTS), a Standing Order, Direct Debit, a card, signatory, or mandate that still need to be
terminated/cancelled.
The AUDIT Version displays details such as who was the inputter, who the authoriser, and so forth, which are not
available for entry or editing as they are automatically updated by the system.
Account Closure
This is where we inform the system of how the account is to be closed and if any settlement charges are to be
applied. The Balances can be seen in the ‘Balances’ tab.
The balance details are found in the next tab, ‘Balance Details’:
When an account is closed the default posting restriction is in the range 90 to 95.
Field Description
Account Closure The number of the account selected to be closed is defaulted in the
ID bar.
When an ACCOUNT is flagged for closure, any entries processed to
the ACCOUNT require an override.
The ACCOUNT.CLOSURE.PARAM is also checked during account
closure and provides overrides if any based on the parameters set.
Closure Date This is the date that is specified for the interest and charges
capitalisation which is the start of the automatic closing process.
During the Close of Business (COB) batch processing on the Closure
Capitalisation date specified, or if this is a non-working day, on the
previous working day, the outstanding interest and charges are
recalculated and capitalised.
During COB processing the following day, if the ACTUAL and CLEARED
BALANCE are both zero, the account is closed.
If either BALANCE is not zero, the account remains open and interest
capitalisations are processed during every Close of Business run until
it can be closed.
When the account is closed, it is removed from the LIVE ACCOUNT
file and written to the ACCOUNT HISTORY (ACCOUNT$HIS) file with
a RECORD STATUS of CLOSED, a closing statement is produced, and any
remaining Standing Orders cancelled.
Posting Restrict Select a reason for closing the account from the drop-down list. You
may select a code between 90 and 99 (for the system to close the
account when the balance is zero).
Close Online When on-line closure is required, then select ‘Y’, when this field is set
to ‘Y’ the following actions will take place at the time of committing
the record:
1. The field CLOSED.ON.LINE in ACCOUNT application is set to ‘Y’
2. If the field CAPITAL.DATE in this application is set to a future date,
then an error message will appear stating that the CAPITAL.DATE
cannot be a future date.
If the record is subsequently deleted, then the earlier update in the
ACCOUNT application will be restored back to NULL.
If the SETTLEMENT.ACCOUNT is supplied, then, at the time of
authorisation of the ACCOUNT.CLOSURE record, the final settlement
will take place between the account that is to be closed and the
SETTLEMENT.ACCOUNT.
If the SETTLEMENT.ACCOUNT is not supplied, then a TELLER record will
be created in IHLD. On authorisation of the TELLER record, the
ACCOUNT.CLOSURE record will also be authorised, and settlement
entries generated by the system.
In both cases above, the interest and charges will be posted in an
intermediary account (internal account) mentioned in the
ACCOUNT.CLASS application as SUSACONLINE and the net balance in
the account will be settled.
Close Mode Select the mode by which the account will be closed. The balance in
the account needs to be liquidated to the beneficiary/account
holder. Options are:
Auto
Ft
Payment Order
Teller
Settlement Account Enter the number of the account to/from which the closing balance
must be transferred. In the event of specifying an internal account,
ensure that the ACCOUNT.CLASS has been defined as SUSACONLINE.
If a SETTLEMENT.ACCOUNT is specified, an override will be required if the
sum of the balance and outstanding interest and charges is negative.
If the SETTLEMENT.ACCOUNT belongs to a different CUSTOMER an
override will be required.
Charge Details
Charge Type Enter the applicable charge for closing the account. Charges are
defined in All-in-One RBHP>>Product Parameters>>General>>Fees –
select Commission (percentage) or Charge (fixed amount).
Charge Amount The system displays the charge amount once the record is validated
and can be manually overwritten.
During Close of Business batch processing, the actual interest and charges entries will be raised and posted
to the intermediary account, so that the balance in the intermediary account becomes zero.
If the SETTLEMENT ACCOUNT exists within the system an AC type FT (funds transfer) record will be
generated. Debit balances can be transferred by this type of transaction, the settlement account need not
have the same currency as the account being closed.
If the SETTLEMENT ACCOUNT does not exist in the system, a BC type FT is generated. Only local currency
accounts with credit balances will successfully generate these transactions. The FT will be automatically
authorised on successful validation, otherwise it will be put IHLD status.
During Close of Business the following working day, if the ACTUAL and CLEARED.BALANCE are both zero, the
ACCOUNT is closed.
If either BALANCE is not zero, the ACCOUNT remains open and interest capitalisation are processed during
every Close of Business until the account can be closed.
On processing the account closure, the system transfers the balance to or from the settlement account.
The account status will remain ‘open’ until one Close of Business process has been run if there are no
further transactions posted to the account.
The account will NOT be closed if there are any future-dated transactions.
Subsequent input to this record will allow the CAPITALISATION.DATE and SETTLEMENT.ACCOUNT to be
changed. Interest and Charges will also be recalculated.
Interest and Charges are calculated on the value dated balances and account activity statistics stored in
the ACCT.ACTIVITY file, considering all entries over the ACCOUNT up to and including the last Close of
Business processing.
Notes:
1. For new accounts no charges are calculated for the month in which the ACCOUNT is created.
2. No account charges are calculated for the month in which the account is closed unless the CLOSURE
CAPITALISATION date is the last day of the month.
3. No bookkeeping entries are generated by this application. All details contained in this file are for
information only.
4. The calculations do not take into account the effect of any transaction/s which have not yet taken place
but which are expected to happen before the CAPITALISATION DATE specified (e.g. Standing Orders
or regular interest capitalisation), or any transactions which have been processed since the last Close
of Business.
The user will have to re-enter the account closure instructions after the future-dated transaction has been
processed.
Note: In the event of the account being linked to a Loan or Deposit account, the system will also not permit
the closure unless and alternative account has been defined on the contract or the contract is settled first.
When the ACCOUNT is closed, it is removed from the live ACCOUNT file and written in the ACCOUNT
HISTORY file (ACCOUNT$HIS) with a RECORD.STATUS of ‘CLOSED’ and a closing account statement is generated.
Should there be an ATM card issued on this account, remember to change the ATM card status to 900
(delete/closed) in the ATM Card version of the account.
All Standing Order instructions, including Direct Debits are to be reversed from the account. See relevant
user guides for details on reversals.
The screen below displays the record after the Close Account Online record has been authorised.
The screen below displays the record after the Close of Business has been processed.
The AUDIT Version displays details such as who was the inputter, who the authoriser, and so forth, which are not
available for entry or editing as they are automatically updated by the system.
List of Accounts
Overview
The landing page presents the list of accounts, it is possible to filter the results by using the selection icon , for
example exclude a certain category of accounts.
Access
All-in-One RBHP>Accounts >>AC Accounts
Procedure
1. Select the menu option.
2. If you wish to filter, enter the search criteria, and click on the Find icon.
3. View the resulting enquiry on‐screen and manipulate as described in the Navigation user guide.
4. Close the enquiry.
Screen
When the enquiry displays, it will appear like the screen shown below.
This screen displays the Enquiry Actions allowing you to perform the functions such as print and save in a variety
of formats.
You are also able to filter the results by using the box on the screen as can be seen below:
You can view the Account or Customer details by selecting the option on the right side of the data in the enquiry.
View
Edit
Transactions
Documents
Selection
A screen like the one shown below displays, allowing you to filter the records for on‐screen enquiry or report:
Shortcuts
Live Accounts
This is an alternative menu option to display a list of accounts.
Pending Records
This is where the accounts awaiting authorisation are found.
Select the account record to be viewed, edited, authorised, or deleted (prior to authorisation) from this list.
Opened Today
The list of accounts that were opened today is presented here. The user has the option to view and edit the account
record, as well as view the transactions processed on the account.
New Account
This menu option can be used to open an account for a customer if access is not via the SCV.
Inactive Accounts
Inactive, also known as dormant, accounts are a significant risk to any financial institution.
Overview
This is an on-line report of accounts that reached the inactivity period (as set up in the COMPANY parameter or in
ACCT.GROUP.CONDITION where the period per product is defined in field INACTIVITY.MONTHS) and have been flagged as
inactive.
Access
All-in-One RBHP>>Accounts>>Inactive Accounts>>AC Accounts
Screen
The user us able to action the inactive accounts, by selecting from the icons to the right hand-side of the respective
records:
Reset dormancy
View transactions
Request a document.
Accounts are reactivated by running a special Account Inactive Reset program. The process is described below:
Access
In the Command Line, enter ACCT.INACTIVE.RESET or ENQ %ACCT.INACTIVE.RESET which will provide a list of inactive
accounts for you to select the account that you wish to reactivate from.
Procedure
1. Enter the account number for which the Inactive Marker is to be reset.
2. Click on the Edit icon.
3. Enter the reset date.
4. Click on the Commit icon.
5. Remember to authorise the record for the account to be reset.
6. Authorised ACCT.INACTIVE.RESET records remain on the file as an audit trial.
Screen
When we type the inactive account number, the screen as below will display:
Enter the value in the RESET DATE field and after authorisation of the record, the Inactive Account is reactivated.
Closed Accounts
Overview
This is a list of all closed accounts, the date on which these were closed as well as the reason for closure.
Access
All-in-One RBHP>>Accounts>>Closed Accounts>>AC Accounts
Screen
The enquiry information is presented as follows:
The landing page provides information on accounts already closed, pending closure (awaiting authorisation) as well
as accounts that were closed today.
You can also initiate the closing of an account from this page.
Reports
Overview
Account-related GCAP reports that are generated during the COB are available to view, print and download from this
page.
These reports include results of the accounts of both the AC and AR products.
Access
All-in-One RBHP>>Accounts>>Reports
Screen
Process
1. Select from the menu the report you wish to view/print/download
2. Enter the selection criteria
3. View/print/download the report
4. Close the screen
The report then displays the information as can be seen in this screen:
It is possible to drill down against the transaction entries to view the root transaction. When we look at the USD250
cash withdrawal in the 29th of March 2021:
This report includes the last interest amount capitalised, interest accrued to date and the date on which the last
transaction was processed to the account. When the account is held as security for a loan (AC.LOCKED.EVENTS) the
loan number will be provided as well.
Accounts that have been flagged as inactive (see chapter on inactive/dormant accounts elsewhere in this document)
will be provided in this report, per DAO.
The report can be used to contact the customers, confirm maturity instructions and cross-sell other products and
services.
FCY balances are converted to LCY, in the case of this report, the USD equivalent is in the Totals line.
Therefore, the balance outstanding on the line of credit will fluctuate. Debit interest is to be accrued on the daily
outstanding balance and capitalised at the frequency as determined by the institution, for example monthly, quarterly,
half yearly or annually.
This limit may be fixed or reducing. The limit is to be reviewed as defined in the LIMIT and the exposure against the
limit is reported daily.
▪ Category Code
▪ Account General Condition
▪ Account Debit Interest
▪ Account Credit Interest
▪ Group Capitalisation
▪ Account Accrual
▪ Limit Reference
Category Code
Access
In the Command Line, enter CATEGORY, (comma) and create a record for example, 6001 for Current Accounts as
record ID.
Note: Remember to include this category in the reporting lines of the General Ledger and Profit and Loss Statement.
In the screen above, record ID 1 represents the Current Account and the Category Code 6001.
Enter the values as appropriate in the fields. In this example, the interest on current account daily debit balances is
calculated at 8.75 % pa.
Note: Remember to authorise the record.
Enter the values as appropriate in the fields. In this example credit interest on current account daily balances is calculated
at 2.75 % on balances greater than USD50.
Group Capitalisation
Access
Administrator Menu>>Capitalisation Dates
Debit and Credit Interest can follow independent capitalisation dates and frequencies.
Note: Remember to authorise the record.
Account Accrual
Include the product category in the ACCOUNT.ACCRUAL application.
The purpose of the Account Accrual table is to provide the system with information at Company level about how
and when to process Accruals of interest and charges on Customer Accounts and whether interest capitalisation
is inclusive or exclusive of the balance on capitalisation date, the value dates of interest entries generated and the
day on which the entries are booked.
Interest Accruals may be processed daily or monthly, or it could be specified that no accrual is to be made. Account
charges may only be processed at calendar month end.
The frequency of interest accrual could be specified at Account Group or Category Level for different Currency
types (foreign or local). For Accounts not covered by specified definition, default interest accrual frequency could
be defined based on Account Currency type.
Dates for interest capitalisation are specified at group level in the Group Capitalisation table and for specific
Accounts in the Account Capitalisation table.
Access
In the Command Line, enter ACCOUNT.ACCRUAL,(comma) and update the record to include the category code of the
Current Account product.
This product is now ready for use, i.e., customer accounts of this product may now be opened. However, continue with the
steps on the next page for complete set up.
Limit Reference
We make use of the LIMIT application to allow credit facilities on accounts. Firstly, we need to define the Limit Reference.
Access
Limits Menu>>Limit Reference Codes
The Limit Reference is included in the standard configuration. Complete the relevant fields in need.
Note: Remember to authorise the record.
Enter the appropriate values in the fields. In the example above, a limit of USD 2000 is to be reviewed after one year.
The ID of the limit reference is comprised as follows:
CUSTOMER.NO-LIMIT.REFERENCE-SEQUENTIAL NUMBER
Tip: By using the Validate icon, the system will populate the values in accordance with the LIMIT parameters; change
only those necessary to meet the requirements of this customer.
Enter the value in the LIMIT REFERENCE field of the account record as can be seen above.
Note: Remember to authorise the record.
The account with revolving credit limit has now been set up and is ready for use.
Overrides on the limits may be controlled through the Security Management System.
The limit record now looks as follows:
Access
Limits Menu >> Liability Report
Procedure
1. Enter the customer number in the mandatory field.
2. Click on the Find icon.
3. View the record.
4. Close the enquiry.
Screen
Messaging
Overview
To facilitate special messages to or about customers on their accounts, the POSTING RESTRICTION table is utilised.
Access
All-in-One RBHP>>Product Parameters>>Accounts>>Account Tables>>Posting Restrictions
In this table, you will find option 6 - See Notes on Customer Info File.
The Customer History File and Account History File store the details of the captured and subsequent deleted messages.
Dividend Processing
For our Credit Union clients who pay dividends on members’ share accounts, the dividend processing procedures are
described in the Dividend Processing user guide.
Savings Insurance
Overview
Credit Unions can also opt to buy savings insurance for the members from the annual membership fees. While the
FI/ACL solution does not do the underwriting of the insurance, it is possible to define the age bands during which the
savings balances need to be tracked for claims processing.
The minimum balances are stored on each account and updated daily. The summary of all savings accounts held by
the customer is updated and stored on the Customer Information File, if the field INSURABLE has been set to ‘Yes’.
Statements on Accounts
Overview
Customers need a record of transactions on their accounts. It is possible to schedule the statement production as a
batch job, send the output to a printing/mailing company, or attach as PDF documents to a secure message to the
customer, be this via SMS, an attachment to an e-mail, or accessible from the channel applications. The statements
are also held in the customer document repository from where it may be viewed/printed at any time.
The Statement Narratives user guide provide details in how to configure the statements, including a single statement
for all accounts of the customer. The processes on how to view the statements are described here.
Access
All-in-One RBHP>>Customer>>SCV>>Accounts>>Documents or
All-in-One RBHP>>Customer>>SCV>>Documents
Procedure
Select the statement record and click on view.
You can also request a new statement to be generated from these links.
Parameters
The main parameters are maintained in EB.PARAM record ALL-MAX.SAV.BAL.EXCEEDED.
EXCLUDE.TXN.CODE The transaction codes to be excluded from the online check. Such transactions may cause
the maximum balance requirement to be breached.
WARNING.PERC.LIMIT The balance warning percentage (for reporting). Accounts with balances exceeding the
warning limit will be displayed in the report “Members Approaching Max Sav. Bal.”
Special Limits
In exceptional cases some members may have agreed balances more than the Credit Union’s limit, for example, they
may have held the balance before the regulations came into effect. The maximum saving balance for such members
can be set on Amend Customer >> Other Info tab.
Balance Checking
An error message is raised for credit transactions causing the maximum balance to be exceeded.
NOTE: for this to work, the record SYSTEM in ACCOUNT.PARAMETER needs to be updated as below:
The limit balance is calculated for a given member by adding balances of qualifying accounts. For joint accounts, the
check is based on with how many members the balance is shared with. For example, if an account is jointly held by two
members, then 50% of the account balance is considered for limit checking.
Reports
The two reports described below are displayed in the Business Overview home page is enabled in the parameter table.
They are updated through the Close of Business process.
NOTE: The batch job is set to ad-hoc by default and should be updated accordingly for the reports to be generated.
This report generates a list of members whose balances have exceeded the Minimum Savings Balance warning limit.
For example, assuming a warning limit of 90% and a maximum balance limit of €100,000 set in the parameter table.
This report would display all members with balances in the range €90,000 – €100,000 in qualifying accounts.
It is also possible that this enquiry may sometimes present members which balance is above the maximum balance
limit if certain transaction codes have been excluded from the limit checking mechanism as per parameter set up.
This enquiry acts as a warning tool. Credit Union users can use it to assess the risk of future incoming transactions being
blocked/rejected and contact the respective members to inform them accordingly.
In addition to the report, a task is generated to alert the user to contact members approaching the Maximum balance
limit.
This enquiry shows incoming external transfers, which have been rejected due to the maximum balance limit and funds
have been returned to the sending bank. Internal transactions, e.g., Cash deposit, Account Transfers, Loan
Disbursements, are blocked during commit and hence not rejected. Such blocked payments are not presented in this
enquiry.
Notes
Use this page to record your own notes.