Overview of Temenos T24 Model Bank • TE TEME MENO NOS S EDUC EDUCAT ATIO ION N CENT CENTRE RE
Warning: This document, is protected by copyright law and international treaties. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of TEMENOS Holdings NV Unauthorized reproduction on or distribution of this presentation or any portion of it, may result in severe civil and Copyright © 2004 TEMENOS HOLDINGS NV criminal penalties, and will be prosecuted to the maximum extent possible under under applicable law.” Information in this document is subject to change without notice.
Copyright © 2006 TEMENOS HOLDINGS NV
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
1
Temenos T24 Functional features
•
Temenos Teme nos T24 T24 is a prod product uct for for intern internati ationa onall financ financial ial serv service ices s market
•
It ha has s co comp mpre rehe hens nsiv ive e fu func ncti tion ons s –
Integration
–
Timely (both in batch and real time)
–
Multi-currency
•
It has co core fu functi tio onality
•
It has opt optio iona nall Ap Appli lica cati tio ons
Copyright © 2005 TEMENOS HOLDINGS NV
While Temenos T24 boasts of a ‘disruptive technology’, technology’, it also draws upon the rich functional features that have been developed over the years. This makes it one of the most advanced software software products in the world to meet the needs of the financial services market. There are certain facets of the software, which are ‘Core’ and which all banks which wish to use Temenos T24 have to procure. The ‘Core’ includes, among others, applications such as CUSTOMER, ACCOUNT, LIMIT, the Security management system, various utilities, the messaging systems (DELIVERY). Most business modules such as LOANS.AND.DEPOSITS, LOANS.AND.DEPOSITS, MORTGAGE, FOREX, SWAPS, SECURITIES, DERIVATIVES etc are optional and banks may procure them based on their business requirements.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
2
Open Standards
• Te Teme men nos T2 T24 ru runs on on – Open hardware • Scalable architectu architecture re that permits permits adding adding further servers as as volumes expand
– Open user interface through browser, HTML and XSLT – Open connectivity through XML and Web services – Open database
Copyright © 2005 TEMENOS HOLDINGS NV
Temenos T24 is based on open standards. This means that clients can select the best vendor vendor or environment to suit their own own needs – whether this is low cost, high performance, local support or any other factor. If this changes in the future, they can switch vendor without altering their investment in TEMENOS T24. This will provide true longevity to their chosen system. T24 can run on jBase or on Oracle database or any other database which the clients are comfortable with. Large banks have also been concerned about scalability and also resilience of the software. T24 has been able to address these concerns by an architecture which provides for multiple application/database servers at various levels. Additional processing capacity can be added by simply adding more servers. The architecture also ensures that there is no single point of failure.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
3
Temenos T24 Functional Architecture
Web
Call Centre
Channel Services
Mobile
Version
Browser
Presentation
Web Svcs
IVR
Enquiry
Security Management System Static
Contact History
Retail
Customer
Overview
Trust /Private
Profitability
Preferences and Groups
Treasury
Corporate
General
Asset Management
FX
Trade Finance
Performance Modeling…
Nostro Recs
Money Market
Commercial Loans
Confo matching
Fiduciaries
Swaps
Guarantees
Fixed deposits Brokerage
FRA
Cash Management
Repos
Syndicated Loans
Capital Markets
Leasing
Image
Futures/Options
Bills
Document mgt
Wealth Management Accounts DDA, checks, cards, statements, charges, sweeps, direct debits
Mortgages / loans Teller Mutual Funds*
Order processing Corporate Actions…
Planning
MC/ MB
Dev Toolkit
General Ledger
Accounting Accounting
Multi Currency
Programming
MIS / P rofitability
Language,
Database
CORE Support Modules
Workflow Exception STP Dispo
Funds Transfer Euro Past Due Intermediary comp Tax
Risk Limits / Collateral Market Risk
Delivery Swift / FIX Print / Telex / Other
Security Management System Copyright © 2005 TEMENOS HOLDINGS NV
We have an overview of the Temenos T24 banking system here. The Core part part of Temenos T24, is the most essential essential part, around around which the optional optional modules are are built. Security Management Management System System over encompasses the core and optional modules.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
4
Temenos T24 Technical Architecture
Web
Call Centre
Channel Services
Mobile
Version
Browser
Presentation
Web Svcs
IVR
Enquiry
Security Management System Static
Contact History
Retail
Overview
Trust /Private
Customer
Profitability
Preferences and Groups
Corporate
Treasury
General
Wealth Management Accounts
T24 Server
Asset Management
FX
Trade Finance
Performance Modeling…
Nostro Recs
Money Market
Commercial Loans
Confo matching
Fiduciaries
Swaps
Guarantees
Fixed deposits Brokerage
FRA
Cash Management
Repos
Syndicated Loans
Capital Markets
Leasing
Image
Futures/Options
Bills
Document mgt
DDA, checks, cards, statements, charges, sweeps, direct debits
Mortgages / loans Teller
Order processing Corporate Actions…
Mutual Funds*
Planning
MC/MB
Dev Toolkit
General Ledger
Accounting Accounting
Multi Currency
Programming
MIS / Profitability
Language,
Database
CORE Support Modules
Workflow Exception STP Dispo
Funds Transfer Euro Past Due Intermediary comp
Risk Limits / Collateral Market Risk
Tax
Delivery Swift / FIX Print / Telex / Other
Security Management System Copyright © 2005 TEMENOS HOLDINGS NV
This is the standard T24 architecture that has been used for many years. It remains unchanged. unchanged. T24 Server will hold T24, jBASE, OFS and TEMENOS CONNECTOR server installations. TC Server is the entry point for requests into T24. It is in the T24 server, that all the business logic is held and the actual validation of data happens at this server.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
5
Temenos T24 Technical Technical Architecture Architecture - Resilienc Resilience e e l a c S
n o i t a t n e s e r
Multi-channel
MQ APIs Excel etc.
Browser
GIB Internet
Web Services
Enterprise Console
API – Java and COM
Other connectivity
P
Network Dispatcher
e l a c S
NO SINGLE POINT OF FAILURE
y t i v i t c e n
Web Server • Apache Tomcat •IBM Webs Sphere •Oracle Application Server
Web Server
n o C
L
T24 Browser component
M
Load Balancer
X
e l a c S
n o i t a c i l p p A
e l a c S
Presentation
Presentation
Presentation
Linux, IBM I/Z Series, HP, Unix, Windows C object code
NON-STOP
e s a b a t a
No batch Non Stop! Oracle, DB2, J4 Cluster Installation
D
Copyright © 2005 TEMENOS HOLDINGS NV
Presentation layer enables T24 to receive in put from various sources such as Browser, B rowser, Interfaces such as an ATM interface , java programs, or from any other third party software. Connectivity Layer is where the Web Servers are installed. Apache Tomcat, IBM Websphere, Oracle Application Server are web servers supported by Temenos T24. This server is used to publish web pages on to the Internet Explorer The T24 Browser component and the Tem enos Connector Client are deployed on these web servers. The Network Dispatcher is a third party software, used for load balancing. Its Its job is to receive messages from IE or any other source source of input and route it to any one of the available web servers. It will maintain the request that it receives in a queue and send it to any one of the available T24 application servers. servers. The same logic applies to the responses as well. One of the commonly used load balancers is IBM’s MQ. T24 Server : Each of these servers will contain a separate T24 (without bnk.data directory), jBASE, OFS and and TEMENOS CONNECTOR server installations. TC Server Server is the entry point for requests into T24. It is in the T24 server, that all the business logic is held and the actual validation of data happens at this server. Database Server : T24 is database da tabase independent, and supports different databases, including Oracle and DB2. It is in this database server that Oracle/DB2/J4 is installed. This is where the T24 data will reside in XML XML format. Oracle/DB2 databases support clustering and therefore a single Oracle/DB2 installation can can be done across multiple servers. J4 does not support clustering and therefore only one database server can be used if J4 is to be used as a database
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
6
CORE COR E - CUST CUSTOME OMER R
Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
Customer centric
All descriptive details of Customer stored centrally centrally Address, Industry, Sector, Status, Target… Preferential treatment in products can be set based on Customer grouping Customer level static changes automatically change change consolidation of A/L and P/L Customer record needed for anyone with whom the Bank deals More in session on CUSTOMER…
Accounting General Ledger MIS / Profitability
MC/MB Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
7
The CUSTOMER Application Application contains contains basic information information (static data) relating to any "Customer" with whom the bank has dealings. It is central or “Core” to the system. All management information, services are organised around Customer record. The CUSTOMER Application contains all the basic information about any "Customer“ "Customer“ (entity) with whom the bank has dealings dealings with. with. It need not be a ‘Customer’ in the conventional conventional sense of the word. In this sense, a customer base record will need to be opened for correspondent correspondent banks, brokers, guarantors etc., as well as for current and savings account holders.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
7
CORE COR E – Acc Account ounting ing Static
Contact History
CATEGORY
Accounts 01000 010 00 - 199 19999 99
Contracts
Overview
Customer
Profitability
Customer Accounts Current accounts
01000 - 9999 01000 1000 - 1999
Vostro accounts Nostro accounts Saving accounts
2000 - 2999 5000 - 5999 6000 - 6999 10000 – 1999 10000 19999 9 10000 1000 0 – 10999 10999 11000 1100 0 – 1999 19999 9
Not possible to accrue interest
LD and MM Sub-blocks range
21000 – 2199 21000 21999 9 21001 2100 1 – 21029 21029
Deposits Takings
21050 – 2107 21050 21074 4 21075 2107 5 – 21084 21084
Loans Placements
50000 – 5999 50000 59999 9 50000 5000 0 – 50999 50999
Interest paid
51000 – 5199 51000 51999 9 52000 5200 0 – 5299 52999 9
Interest received Commission
Product related PL
Non Product related PL
60000 and above 60000 – 6099 60000 60999 9 62000 6200 0 – 62999 62999
50000 500 00 - 699 69999 99 Accounting General Ledger MIS / Profitability
Possible to accrue interest
Internal Accounts Cash accounts Fixed Assets, Suspense etc
20000 200 00 - 499 49999 99
Profit & Loss
Preferences and Groups
MC/MB Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Salaries Operating expenses
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
8
One of the important aspects of T24 is that all dealings with customers are classified either as ‘Accounts’ or ‘Contracts’. The main difference between an Account and a Contract is an Account permits the balance to be debit or credit from time to time, time, whereas in any particular contract, while the balance may change from time to time, its sign will not change from the original – viz debit will not be allowed to become credit and credit credit into debit. debit. At the end of the contract, the balance onl y become NIL. Customers have different types of Accounts such as, Current Accounts, Savings Accounts, Margin Accounts and so on. We also have internal accounts, which are bank’s own accounts that maintain “base” information not held anywhere else in the system, e.g.. Cash, Capital & Reserves, Premises & Furniture, Departmental and other Suspense Accounts, Tax awaiting Payment to Authorities etc. Customers may have Contracts such as, Money Ma rket deals, Securities contracts, Loan contracts, Letters of Credit, Foreign Exchange deals deals and so on. It may be observed that in all these contracts, the initial sign never changes to the other sign There are also Profit and Loss Accounts (Categories in T24), which are basically of two types. Firstly, there are ‘Product related’ income or expense. E.g.., Interest on Loans, Commission on LC, Charges Ch arges on Current Account etc. The second type of income/expense is overheads, which are not product related. Salaries, Rent, Electricity, etc. fall under this group. All these product groups are differentiated differentiated from each other by using suitable CATEGORY code
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
8
CORE – Account Accounting ing entries entries Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
STMT.ENTRY
Entries affecting Account balances
RE.CONSOL. SPEC.ENTRY
Entries affecting all other Assets & Liabilities
CATEG.ENTRY
Entries affecting PL Heads
ASSETS & LIABILITIES
PROFIT & LOSS Accounting General Ledger MIS / Profitability
MC/MB Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
9
All transactions transactions / contracts create the the relevant accounting accounting entries entries across the clients accounts and for the banks own internal records. Entries are automatically generated for authorised transactions. Accounting entries are classified as STMT.ENTRY, CATEG.ENTRY and RE.CONSOL.SPEC. ENTRY. Combination of these entries are possible and happen. Though entries are generated only after authorisation of transactions, debits to accounts affect the balances after the input is committed (at unauthorised stage itself). Entries affecting Account balances balances are stored stored in STMT.ENTRY file by the system – be it Customer account account or Internal Internal account Entries affecting P & L heads heads are stored in CATEG.ENTRY CATEG.ENTRY file. In T24, we do not open `accounts’ for profit and loss heads. All other entries are stored in RE.CONSOL.SPEC.EN RE.CONSOL.SPEC.ENTRY TRY
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
9
CORE – Genera Generall Ledger and other reports reports Static
Contact History
Entries affecting Account balances
Entries affecting all other Assets & Liabilities
Entries affecting PL Heads
Accounting General Ledger MIS / Profitability
Overview
Customer
Profitability
Preferences and Groups
STMT.ENTRY
ASSETS & LIABILITIES Key Consolidation based On Customer and Application information REPORT CREATION HEADER LINE COLUMN …………... …………..…
RE.CONSOL. SPEC.ENTRY
CATEG.ENTRY
MC/MB Multi Currency Workflow
CORE Support Modules
PROFIT & LOSS Key Consolidation based On Customer and Application information Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
10
The financial data resulting from transactions, have been consolidated by the system according to the selection criterion defined in CONSOLIDATE.COND file. The T24 concept does not have General Ledger accounts, but the selection criterion criterion of CONSOLIDATE.COND CONSOLIDATE.COND enable us us also to create reports, respectively lines. Before creating lines, we need to create the columns and the header.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
10
CORE – Multi Company Company (MC) Vs Multi Multi Book (MB) Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
• Mo Mode dell Ban Bank k use uses s Mul Multi ti Bo Book ok • Fe Feat atur ures es of MB MB/M /MC C are are:: – A financial entity (Branch/Dept) can be opened as Company or a Book – Possible to produce independent balanced books at financial entity level – Financial reports are automatically created at entity level – Automatic InterInter- Entity accounting accounting at transaction transaction level – Flexible Consolidated Reporting (entities can be grouped and reported)
Accounting General Ledger MIS / Profitability
MC/MB Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
11
Single Company, Multi Company and Multi Book are three ways in which financial accounts can be held in T24. Under Single Company, the entire bank is considered as one accounting entity and all financial files are common. If branch wise consolidation consolidation of accounts is desired, it is achieved by defining individual branch / accounting entity using DEPT.ACCT.OFFICER. Under Multi company set-up, each branch or accounting entity is considered as a separate separate company. company. While Customer record record is optionally shared, financial files are unique to each company. Accounts and Contracts are unique to each company. Model Bank follows follows the third approach – Multi Book, where financial financial level data is stored in same same database, but but identified separately separately using COMPANY.CODE field in in each Account Account and Contract. Contract. It allows independent financial entities to produce independent balanced books while sharing sharing the same financial financial data files files – CUSTOMER and NOSTRO NOSTRO ACCOUNT It is relatively simple to move customer accounts and contracts from one branch to another without closing and reopening them
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
11
CORE – Multi Company Company (MC) Vs Multi Multi Book (MB) Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
• Dif Differe ference nces s betwe between en MC & MB (Func (Functio tiona nality lity)) – In MC it is possible to have a different local currency for each financial entity. In MB, the local currency has to be the same across all financial entities. – In MB it is possible to transfer accounts/contracts from one entity to another. This is not possible in MC. – MB allows closure and merger of branches – Foreign Exchange Positions are consolidated for all entities in MB whereas it will be available only at independent entity level in MC.
Accounting General Ledger MIS / Profitability
MC/MB Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
12
Customer accounts and contracts can be transferred from one Company to the other, without actual closure. Their Ids will continue to be same Possible to transfer select or even all Customer accounts and contracts to another Company Inter book accounting automatic Loan input at HO, and belongs to HO. Proceeds transferred to Customer’s Current account in USD with Branch 3 Accounting entries entries automatically automatically passed at H.O Debit Loan Loan Credit Inter-Branch Inter-Branch Account Account Branch 3: USD12800-0011-0001 Accounting entries entries automatically automatically passed at Branch 3 DR. Inter-Branch Account : HO USD-12800-0001-0011. CR. Current Account of Customer
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
12
CORE – Multi Company Company (MC) Vs Multi Multi Book (MB) Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
• Dif Differe ference nces s betwe between en MC MC & MB MB (Archi (Architec tectur ture) e) – In MB Financial level data is held in a single database for all entities whereas in MC financial level data is held in separate table for each entity – In MB financial level data from different entities can be e asily combined. While this is possible possible in MC, it is less efficient. – In MB customer accounts do not have to be identified by a branch code as in MC, so it is possible for all accounts in each group of branches to follow the same structure.
• Not Note e – It is als also o possi possible ble to use use a co combin mbinati ation on of MB MB & MC MC
Accounting General Ledger MIS / Profitability
MC/MB Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
13
13
CORE CO RE – Lim Limits its Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
• In Model Model Bank, Bank, Limits Limits can can be be establis established hed at Customer Customer leve levell and Customer group level • Limits can be establ establishe ished d at Produ Product ct and and sub prod product uct levels levels – Multiple limits may be given to a Customer for the same Product / sub product
• Limits can be option optionally ally made vari variable able,, in line line with with underly underlying ing collateral value • While attach attaching ing Limits Limits to to accoun accounts ts to allow allow overd overdrawa rawal, l, it could could be attached to single or many accounts • Mo More re on se sess ssio ion n on on Limi Limits ts… …
Accounting General Ledger MIS / Profitability
Multi Multi Book Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
14
When a bank does a transaction with a Customer, it is exposed to different types types of risks – Risk towards an an individual or groups of of customers; Countries or groups of countries; Currencies; Commodities Setting a limit for a client allows the lender to control exposure to that client and to monitor its own overall position. For example, before a loan is made to a customer, a limit must be set up specifying the maximum amount that that the bank considers it prudent to lend that customer. customer. The limit will enable the clients transactions to be processed without problem providing the transaction falls within the agreed limit. The application will also allow clients to draw facilities in different currencies and will re-calculate the outstanding outstanding amounts into the currency of the limit. Setting up limits also allows a bank to monitor its exposure to its clients by product, e.g. Forex and by sub-product, e.g. a limit for spot. The lender can also monitor its exposure exposure by commodity, commodity, e.g. Industry Industry code, or by country or currency. A reducing or non-revolving non-revolving Limit does not not have its value value restored when when a Transaction is repaid. A Non-reducing or revolving limit is always maintained at the sanctioned levels. A limit may be fixed or variable dependin depending g upon it being being allowed allowed to change in line with changes in collateral value. T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
14
CORE CO RE – De Deli live very ry Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
•
Delivery refers to generation of Advices/Messages in T24.
•
Delivery is an integral part of Core T24 which is closely closely linked to the transactions input through various modules.
•
Predefined messages/advices generated on authorisation of transaction are sent to the destination without user intervention.
•
The relevant messages produced as per predefined mapping and formatting (from the field input in transaction to the pre defined fields/SWIFT tags) are sent through appropriate channels viz Print, SWIFT etc.
•
The channel/ mode (carrier) of delivery can be configured systemwide and up to the Customer or account level. Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
15
15
CORE CO RE – De Deli live very ry Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
• Howe However, ver, ifif any of the set up up of addre address, ss, carrier carrier,, mapping mapping or or formatting specifications are incorrect, the message will go into Repair. • Mess Messages ages in ‘Repair ‘Repair’’ can be resub resubmitted mitted after makin making g necess necessary ary corrections. • A well well mappe mapped d and and forma formatted tted deliv delivery ery messa message ge will will be be automatically sent to the t he delivery channel/interface unless they have been specifically put on “HOLD”
Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
16
16
CORE COR E – Deli Deliver very y Static
Contact History
Customer
Overview
Profitability
Preferences and Groups
Types of advices Statement of Accounts
Delivery Deal slips
advices
Statements
Deal confirmation slip
Delivery advices to Customers,
Sent to
Printed and handed over
Other banks about various events
Account
across the counter
Can be outward or inward through
holders
1. Cust Custome omerr rec record ord ope openin ning g
Swift or Print or Telex
periodically
2. Is Issu suin ing g Dra Draft fts s
1. Re Remi mitt ttin ing g funds funds
3. Te Tell ller er tran transac sacti tion ons s
2. Rei Reimbu mburse rsemen mentt instr instruct uction ions s 3. Rat Rate e chang change e advi advice ce
Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
17
For accounts, Statement of accounts are sent periodically by Print or Swift For other applications, applications, it is possible to advice the client client of a transaction through Deal slip and/or Delivery advice. Deal slips are printed and issued across the counter
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
17
CORE COR E – Deli Deliver very y Static
Contact History
Customer
Overview
Profitability
Preferences and Groups
Delivery advices Normal
Soft
Delivery
Delivery
Rules for production of messages on
Rules for production of messages user
authorisation of transaction are
definable.
hard coded.
Content of message is user definable. Preview of message possible during Input.
Limited scope to change the contents of the produced message.
Ability to override the defined rules at transaction level Available for specified modules (Trade Finance, Guarantees etc)
Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
18
18
CORE – Static tables tables related to CUSTOMER CUSTOMER Static
Contact History
Overview
Customer
RELATION
CUSTOMER STATUS
Profitability
Preferences and Groups
COUNTRY
CUSTOMER
RELATIONSHIP MANAGER
LANGUAGE INDUSTRY TARGET
Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
SECTOR
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
19
The above diagram diagram illustrates the various static tables tables that are linked to the CUSTOMER file. These are maintained through Administrator menu Later on in CUSTOMER session we will make use of these tables. COUNTRY table contains the static details of each individual Country, Country, for example, Country Name, Currency Code(s) etc. This is used to indicate residence and nationality of a Customer DEPT.ACCT.OFFICER : Identifies the main Account Officer responsible for the Customer. It is useful for relationship management and also for MIS purposes SECTOR table helps grouping of customers at a top level for several purposes. The sector is commonly used to define the ‘Legal Status’ of the customer i.e.., Individual, Public Company, Company, Government, Corporation, Trust etc. INDUSTRY table defines the activity or business the customer is involved in. RELATION table is used to specify the various types of relation that could exist between one Customer and another. TARGET table helps group Customers for future marketing purposes
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
19
CORE – Static tables tables related to Holidays Holidays Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
Static details of each country like Name, Currency code, Consumer goods index etc
COUNTRY REGION
Week ends, non week end holidays for each region of every country year and month wise defined here. All T24 applications check this during Input
HOLIDAY
Validation for events falling on holidays holidays
Helps define upto 99 Regions within a Country where public holidays holidays differ from other parts of the Country. Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
20
These are maintained through Administrator menu. When we input transactions, we will see how the System makes use of these tables. COUNTRY: Contains static details of each Country, for example, Country Name, Currency Code etc. Dummy Country codes may be used used for entities entities that do not have an official Country code but have a Currency Code, for example, the European Currency Unit. HOLIDAY: This table is used to indicate the public holidays for each Country, or Region within a Country, for the calendar year over which the bank's current business is spread. User must indicate, for each Country or Region, the public holidays and which days of the week make up the weekend. All T24 Application will refer to this table during input validation to check that that if any dates entered by the User are holidays holid ays and/or to raise an override o verride to accept any contract event that fall on a Holiday. It is also used to determine the delivery date, by taking non-working days into consideration.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
20
CORE – Static tables tables related to Currency Currency Static
Contact History
Overview
• Numeri Numeric c Ccy Code
Customer
Profitability
COUNTRY • Upto 99 markets to
• Decimal Places for rounding all calculations • Interest Day Basis
Preferences and Groups
quote different rates
CURRENCY PARAM
• Precious Metal
• Consolidated into 9 markets
• Equivalent Currencies
CURRENCY
• Country Code
CURRENCY MARKET
• Bas Base e Ccy Ran Rank k
FORWARD RATES For each Currency & Market, forward exchange rates as premium / discount to the Spot rate for different Rest periods. To get the Rest date,
• Bid and Offer rates for different periods • Interest tolerance for MM • Used for automatic roll over
value in Rest period is added to SPOT date. date. Used for Tolerance check and Rebate revaluation Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
PERIODIC INTEREST Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
21
These are maintained through Administrator menu When we input transactions, transactions, we will see how the System makes use use of these tables CURRENCY.PARAM: Contains common details for each Currency to ensure that the the same numeric code and no of decimals decimals are used on different currency files in a multi company environment. Currency name and Interest Interest basis basis maybe changed at individual Currency file level. Numeric currency code, an alternate to Currency code, can only be changed on this file. Once a record has been authorised, number of decimal places cannot be changed. In In the field EQUIVALENT.CCYS relationship must be established to enable currencies to b e used as interest or charge currencies on any accounts set-up for the main currency. If two currencies are involved in a conversion, then the currency with the lowest rank will take preference as base currency CURRENCY.MARKET: Possible to create create different market market rates for for the same same currency - Separate rates for Notes / Travelers Cheques etc. Consolidation keys keys are formed market wise. Markets beyond 9 will be consolidated with the market type of the first digit digit – example example 10 with 1. 1. FORWARD.RATES: The Rest periods can can be defined either in months, e.g. 1 month, or in days, e.g. 7 days, 15 days etc. To calculate the date of the rest period, the system will add to the SPOT date the value defined in the field REST.PERIOD. If the Rest period is defined in months and the calculated calculated date falls on a non working day, the date is moved forward to the next next working day. day. If, however, this next working day falls in the next month, the system will instead move BACKWARD to the previous working day in the same month.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
21
CORE COR E – Int Intere erest st related related – INT INTERES EREST T BASIS Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
Different Interest day basis for calculation of interest possible depending on the method followed for calculating number of da ys in interest period and days in a year For example, if Interest Basis B (366/360) is selected, then the interest calculation would look as follows:Principal Amt x Rate x 366 / 360 A1 Additional interest earned in February calculated on last day A2 Additional interest interest earned in February calculated on penultimate day Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
22
In the options specified above the number on the left (Days) (Numerator) represents the number of days basis for multiplying on the top line of the interest calculation. Whilst number on the right (Denominator) (Denominator) is the basis for dividing on the bottom line of the interest calculation and represents the number of days in the year.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
22
CORE COR E – Floa Floatin ting g interest interest – BASI BASIC C INTEREST INTEREST Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
BASIC RATE TEXT Currency and Interest effective date part of ID
BASIC INTEREST
Possible to set a negative interest rate for MM Possible to give positive or negative spreads Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
23
BASIC.INTEREST: This table allows various frequently used floating Rates, e.g. Base Rate, Prime Rate, Overnight Rate etc., to be defined separately for each Currency and stored in in a central place where they can be accessed, as required, by various Temenos T24 Applications. Applications. 'Prime records' with the same Interest conditions conditions can be linked directly to a Basic Interest ID in this table, rather than defining the Interest Rate details on each transaction or contract record. For example, if the overdraft interest conditions for Currency Accounts are related to the base rate, each current Account or group of Accounts (when conditions are applicable at group level), should refer directly to the Basic I nterest Rate ID defined in this table and not contain the value of the rate in itself. When a rate change takes place, the user will then need to update only the Basic Interest Rate IDs defined in this table with the new rate(s) and the date on which it is to become effective. This will then automatically update all the transaction/contract records which are tied to each Interest ID. A description of each rate is held in the BASIC.RATE.TEXT BASIC.RATE.TEXT table to to allow the user user to easily identify identify each one of the Basic Interest Interest Rate table ID's.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
23
CORE – Floatin Floating g interest interest – PERIOD PERIODIC IC INTEREST Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
PERIODIC INTEREST
Bid rate is for Deposits Offer rate is for Loans Generated daily. Back dated changes are also possible Used for automatic roll over, Interest Tolerance checking for MM
Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
24
This table is used used for “LIBOR” type rates rates of this nature . Rates vary depending on the length of time and for Bid and Offer purposes. For Loans and Deposit contracts that are linked to PERIODIC.AUTOMATIC option, user will define a schedule for rate reviews. At the scheduled scheduled dates the system system will refer to this table table and automatically “pick up” the relevant rate and apply that to the contract until the next review date. This table maybe automatically automatic ally updated/interfaced updated/inter faced daily with an external feed such Reuters, or maintained manually by the user. PERIODIC.INTEREST keys keys are generated generated daily by the System. It is possible to effect changes in rates of dates prior to system date. As a result, all contracts contracts which had had accessed the the (changed) (changed) key at an earlier date, will recalculate interest based on the changed interest rates PERIODIC.INTEREST will be used by applications such as Foreign Exchange to default interest rate on Forward contracts using the Interest revaluation method or the Money Market applications to perform automatic Rollover. It is also used to check interest rate tolerances, based on pre-set parameters, parameters, in MM contracts.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
24
CORE – Genera Generall Charges for Accounts Accounts Static
Contact History
Overview
Customer
Profitability
TURNOVER TURNOVER
NUMBER NUMBER OF OF CREDIT CREDIT
BALANCE BALANCE REQUIREMENT REQUIREMENT
ACCOUNT ACCOUNT STATEMENT STATEMENT CHARGE CHARGE
Preferences and Groups
CREDIT CREDIT
GENERAL GENERAL CHARGE CHARGE
INTEREST INTEREST STATEMENT STATEMENT
TRANSACTION TRANSACTION CHARGE CHARGE
ADDITIONAL ADDITIONAL DEBIT DEBIT INTEREST INTEREST
GOVERNMENT GOVERNMENT MARGIN MARGIN Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
NUMBER NUMBER OF OF DEBIT DEBIT
TURNOVER TURNOVER DEBIT DEBIT
CORE Support Modules
Risk Limits / Collateral Market Risk
HIGHEST HIGHEST DEBIT DEBIT Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
25
The charges applied to an account will vary from Bank to Bank and from different categories of account. For example: 1) charges may relate to volume of turnover and defined in the files NUMBER.OF.DEBIT and NUMBER.OF.CREDIT or 2) charges may be applied applied to the issue of statements statements and defined defined in the file ACCT.STATEMENT.CHARGE Several such charge tariff structures may be stored in the file GENERAL.CHARGE . A particular GENERAL.CHARGE GENERAL.CHARGE record record could be linked linked to a group group of accounts, say all current accounts, or all current accounts of UK residents or even to an individual account
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
25
CORE – Charges and Commission Commission for other other applications applications Static
Contact History
Accounting General Ledger MIS / Profitability
Overview
Multi Book Multi Currency Workflow
Customer
Profitability
CORE Support Modules
Preferences and Groups
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
26
FT.COMMISSION.TYPE: Each Commission Type can be defined as a flat amount or as one which varies according to the amount. In the latter case different percentages percentages can be be defined for different different Bands or Levels of transfer amounts. Minimum and maximum Commissions can be specified for each Band or Level together with overall minimum or maximum commission charges. Commissions in local currency must be entered and special foreign currency Commissions can also be defined CALC.TYPE: FLAT, LEVEL and BAND: Assume a deal of Principal 100,000 USD where commission is calculated based on the Principal. The commission type type record specifies specifies an applicable applicable rate of of 2 per cent up to 10,000 and 1.5 percent over 10,000. If Band is specified for all sub value groups, 2 calculations will be performed, i.e. 2% on 10,000 1.5% on 90,000. If Level is specified for all sub value groups, 1 calculation will be performed, ie. 1.5% on 100,000. If Flat is specified, the basic Flat Amount will be applied.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
26
CORE – Corre Correspondent spondents s and Relationships Relationships Static
Contact History
Overview
Customer
Profitability
Preferences and Groups
AGENCY records are established to record Standard Settlement Instructions for Correspondent Banks or Customers for currency wise settlement. • Credit Suisse wants all USD paid to Merrill Lynch, New York. • David Brown PLC wants all EUR paid to Deutsche Bank, Frankfurt.
Obviates need to re-enter details at transaction level
Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
27
27
Preferential grouping Static
Contact History
Overview
Customer
Profitability
• Possible Possible to group group custo customers/ac mers/accoun counts ts interest/charge conditions
Preferences and Groups
for
setting up setting
of
• Examples – Interest rate of 1.75% p.a. is applicable on all Savings Accounts however Staff Savings Accounts carry interest of 2% p.a. – Commission for Draft Issue is 1.5% of the transaction value subject to a minimum of £ 5. For high net-worth net-worth clients, clients, the percentage is reduced to 1%. – Basic Rate Tax of 20% applicable for credit interest on accounts/deposits held by Individuals, Sole-Proprietors & Partnerships (not applicable for Corporates).
Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Copyright © 2005 TEMENOS HOLDINGS NV
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
28
28
Temenos T24 Customisation scope Parameters & Conditions
Local Reference Fields
Temenos T24 Screen Design (Version)
Implementation Tape
Enquiries & Reports
Default field data
User defined Routines
Customised Temenos T24 Copyright © 2005 TEMENOS HOLDINGS NV
Every bank has its own unique needs/requirements from the software. While Temenos has built `Model banks’, banks would still like to configure the system to have their own choices of conditions, and hold additional additional information, would would like to have user friendly screens with default conditions and above all get their own reports other than the standard enquiries and reports. Temenos T24 is highly parameter driven and gives the banks a host of choices across modules. This calls for a project type of implementation out of a product. Temenos T24 is flexible enough enough to allow all these. Thus Temenos T24, though a product, tends to be completely unique at each location.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
29
Temenos T24 Pre configured Model Bank Standard Parameters & Conditions
Essential Local Reference Fields
Temenos T24 Implementation Tape
Over 550 Versions
Over 50 Enquiries & 50 Reports
Default field data
Over 100 Delivery set up
Pre configured Model Bank With business process for all Banking operations Copyright © 2005 TEMENOS HOLDINGS NV
Model Bank is generic T24 and does not contain local development It uses Core T24 fundamentality to run bank business It suggests a T24 process for each banking operation It Contains over 550 Versions 350 Enquiries 50 COB Reports and 100 Deliveries Set-up Model Bank led approach of implementation cuts down the implementation implementation time to a great extent
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
30
Model Mod el Bank - Cont Content ents s
Channel Services
Desktop
Version
Browser
Presentation
Enquiry
Security Management System Static
Contact History
Customer
Overview
Profitability
Preferences and Groups
Retail
Treasury
Corporate
General
Accounts
FX
Trade Finance
Nostro Recs
Cheques, Statements, charges, sweeps, Direct debits
Money Market
Commercial Loans
Confo matc matching hing
Securities
Guarantees
Funds Transfer
Mortgages / loans
(Own book)
Syndicated Loans
Past Due Tax
Teller
Image
Fixed deposits
Document mgt Accounting General Ledger MIS / Profitability
Multi Book Multi Currency Workflow
CORE Support Modules
Risk Limits / Collateral Market Risk
Delivery Swift Print / Telex / Other
Security Management System
Copyright © 2005 TEMENOS HOLDINGS NV
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
31
31
Temenos T24 Functionality or
Transaction Input
Authorizer
Queries Security Management Management System System
RDBMS APPLICATION LOGIC
Temenos T24 Core Close of Business
Validation
UNAUTHORIZED
AUTHORIZED
Static Data
Product Interest Rates Commissions Currency etc...
Risk Management
Credit Risk Market Risk Collateral
Accounting
Messages/Clearing
Print
SWIFT SID Interface Custom Interfaces
Accruals Maturity Control Reporting Revaluation
General Ledger Debits/Credits MIS / Profitability
Regulatory Reporting
Copyright © 2005 TEMENOS HOLDINGS NV
Any Temenos T24 T24 operation passes through through SMS and reaches Core. Core. Relevant Static Data are used and limits limits / working balances balances are checked and updated before authorisation in case of debits (and after authorisation authorisat ion in case of credits). The deal is then authorised by a user other than the original initiator (Maker and Checker concept being used). Then the respective delivery delivery messages messages are generated, generated, required accounting entries generated. All Batch processes processes are typically typically performed during during COB (Close of Business) for generation of reports, effecting accruals, carrying on necessary revaluations etc.
T24 Model Bank Introduction Introduction (T2MBIN-R5) - Overview
32