Welcome

To

Bankmaster Training

IntroductionIntroductionBankmaster systemBankmaster system

•Integrated Integrated •Accounting Accounting •Transaction Handling,Transaction Handling,•Customer services,Customer services,•Managerial reportingManagerial reporting

Account NumbersAccount Numbers CC C MM NNNNNN CC C MM NNNNNN

SS DSS D

CURRENCY REFERENCECURRENCY REFERENCE

CONTROL ACCOUNT REFERENCECONTROL ACCOUNT REFERENCE

MEMORANDUM ACCOUNT REFERENCEMEMORANDUM ACCOUNT REFERENCE

CUSTOMER REFERENCECUSTOMER REFERENCE

SUB-ACCOUNT REFERENCESUB-ACCOUNT REFERENCE

CHECK DIGITCHECK DIGIT

The General Ledger has a hierarchical The General Ledger has a hierarchical structure with three levels of structure with three levels of

accounting:accounting:

1.1. Control Account Number (CCC).Control Account Number (CCC).

2.2. Memorandum Account Number Memorandum Account Number (CCCMM).(CCCMM).

3.3. Detail Account Number Detail Account Number (CCCMMNNNNNN(SS)(D)).(CCCMMNNNNNN(SS)(D)).

Bankmaster Data FilesBankmaster Data Filesmain:main:

1.1.Customer Register Customer Register

2.2.General LedgerGeneral Ledger

3.3.Bank DiaryBank Diary

4.4.Transaction History Transaction History --

TPS TPS Transaction Processing Transaction Processing

SystemSystem

Link betweenLink between delivery systemsdelivery systems &&Their databaseTheir database

It receives transactions captured It receives transactions captured by a delivery system, processes by a delivery system, processes

them, and updates the database.them, and updates the database.

TPS (Cont’d)TPS (Cont’d)

Delivery Systems & DatabaseDelivery Systems & Database

ExamplesExamples

•Branchpower Branchpower

•ATMs (Automatic Teller ATMs (Automatic Teller Machines)Machines)

•POS (Point of Sale Systems)POS (Point of Sale Systems)

•Bankmaster - DatabaseBankmaster - Database

Delivery Systems to the TPSDelivery Systems to the TPS

Network

TPS

Bankmaster

Database

BPW

ATM

BANK

Menu Security System Menu Security System Program (MSS)Program (MSS)

• Provides facilities to restrict access to Provides facilities to restrict access to BankmasterBankmaster programs. programs.

• All users must enter the system All users must enter the system through through MSSMSS

MSS (Cont’d)MSS (Cont’d)

Some Features provided by MSS:Some Features provided by MSS:

• User Identification & Password ProtectionUser Identification & Password Protection

• Menu DefinitionMenu Definition

• Partition Timeout/LockoutPartition Timeout/Lockout

• Sending Messages Between Users & Sending Messages Between Users & PartitionsPartitions

• Changing PasswordsChanging Passwords

• User List InformationUser List Information

• Security LoggingSecurity Logging

•Menu Security Maintenance Menu Security Maintenance Program (MSSMNT)Program (MSSMNT)

–Create, amend, view users set up Create, amend, view users set up on the system.on the system.– Create, amend, view the Master Create, amend, view the Master menu and sub menus.menu and sub menus.

MSS (Cont’d)MSS (Cont’d)

EasidataEasidataA program which allows static data A program which allows static data

within Bankmaster to bewithin Bankmaster to be

• Maintained (Insert, Amend, Delete), Maintained (Insert, Amend, Delete),

• inquired or inquired or

• reported on.reported on.

Easidata (cont’d)Easidata (cont’d)

• Parameter files define the fields on the Parameter files define the fields on the data file that will be accessed. data file that will be accessed.

• To indicate to Easidata which data file is To indicate to Easidata which data file is to be maintained, the user inputs the to be maintained, the user inputs the name of the relevant parameter file.name of the relevant parameter file.

Easidata (cont’d)Easidata (cont’d)SOME FACILITIES:SOME FACILITIES:

• InsertInsert

• AmendAmend

• DeleteDelete

• InquiryInquiry

• Global ChangesGlobal Changes

• ReportingReporting

Overnight RunsOvernight Runs

Audit Trail ProgramAudit Trail Program

• The Audit Trail program should be run at The Audit Trail program should be run at the End of every Day.the End of every Day.

• It checks that all the postings to the It checks that all the postings to the system, on the particular day on which it is system, on the particular day on which it is run, is BALANCE.run, is BALANCE.

Audit Trail Program Audit Trail Program (Cont’d)(Cont’d)Input to Audit Trail program:Input to Audit Trail program:• Daily Transaction files (TR00BB.nnnFIL) Daily Transaction files (TR00BB.nnnFIL)

merged and sorted into an index file merged and sorted into an index file (ZZD0DATA) in the following order of (ZZD0DATA) in the following order of priority: Account number, Posting date priority: Account number, Posting date Value date Transaction type Batch Value date Transaction type Batch numbernumber

• General Ledger File.General Ledger File.

Audit Trail Program Audit Trail Program (Cont’d)(Cont’d)

Control/Memo groupControl/Memo group

Opening balanceOpening balance (GL) (GL) ++ Daily total value Daily total value (Transaction (Transaction

File) File) == expected balanceexpected balance

Daily total value Daily total value (GL) (GL)

= = actual balanceactual balance

If these two figures do not match the system is not balanced and If these two figures do not match the system is not balanced and must be investigated.must be investigated.

Audit Trail Program Audit Trail Program (Cont’d)(Cont’d)Other Tasks:Other Tasks:• Update Control or Memo Balances.Update Control or Memo Balances.• It checks the calculation of the expected balance figure.It checks the calculation of the expected balance figure.• It checks that each currency balances.It checks that each currency balances.• It maintains the LOWEST BALANCE field for savings It maintains the LOWEST BALANCE field for savings

accountsaccounts• Marks an account dormant if not transacted for a Marks an account dormant if not transacted for a

specific period of time.specific period of time.• Tags A/c due for Interest ApplicationTags A/c due for Interest Application

Audit Trail Program (Cont’d)Audit Trail Program (Cont’d)SummarySummary

General Ledger(GL) File

Merged Daily Transaction Files

Tags a/c forInterest application

Maintains lowest balance Of savings a/cs on GL

Tags a/c dormant

Update control/Memo balances

On GL

Audit Trail

Today’sTransactions For each acc.

Opening balance+Actual bal. for

Each acc.

Audit Trail Program (Cont’d)Audit Trail Program (Cont’d)SummarySummary

• The audit trial always produces a report.The audit trial always produces a report.

• TaggingTagging– Interest due on non working days.Interest due on non working days.– Statement due on non working days.Statement due on non working days.

• Maintains balanceMaintains balance– Average balances (week to date, m-2-d, y-2-d)Average balances (week to date, m-2-d, y-2-d)– Lowest balances for savings accounts.Lowest balances for savings accounts.

• Marks acc. As dormantMarks acc. As dormant

• Reconciliation “EXPECTED” Vs “ACTUAL” balancesReconciliation “EXPECTED” Vs “ACTUAL” balances– Highlights any inconsistencies.Highlights any inconsistencies.– Updates the balances.Updates the balances.

End of TrainingEnd of Training

Thank You Thank You