Design and Implementation of a Computer-Based Treasury Management System (A Case Study of Guarantee Trust Bank Plc)
Chapter One
OBJECTIVES OF THE STUDY
This study aims to develop system-based treasury management system software covering several areas such as foreign exchange, money loans, and their related derivation instrument. The system will be able to provide organizations with a sophisticated, multi-entity, multi-portfolio, multi-dealing room environment support of robust risk management and management information system (MIS). This will show the important of the management system (TMS) and the benefits of its uses in the treasury department there are;
- To automate treasury in any easy-to-use secure electron environment.
- To be able to re-deploy staff away from respective and essential introduction manual tasks and focus on managing cashing and risk efficiently.
- To discover cash management services for banks on the consideration of daily reports especially in balancing and crediting and account information
- To discover how a treasury management system (TMS) helps organizations in managing their daily complex treasury operation
- To manage a wide range of financial obligations within a single system.
CHAPTER TWO
LITERATURE REVIEW
INTRODUCTION
This literature will examine the perception that points towards the discussion of implementation of computer in treasury base management system.
In the course of writing this project work, so many relevant materials were consulted in order to X-ray the general acceptability of this research work. In a research of this nature and researchers alike, especially those whose work are certified because of their elaborate work carried out in their study, should not be left unextracted because this research project intends to generate and create information from existing knowledge that has so far been gathered.
Since the early 190s treasury management system has been assumed an increasingly greater importance in our economics lives with globalization it has become demanding that before.
According to Ravikumar (2007), defined computer based treasury as a client server based software that gather information from both internet and external sources then compile the data for purpose of analysis and decision making.
According to Masson (2002), from the Oxford advanced learner dictionary describe treasury as a government department or organization that control public money or a place where valuable things are stored.
According to Pentagon (1979), defined computer based treasury management system as an efficient management of liquidity and finance in business the responsibilities of treasury management include, management of cash, management of foreign exchange rate risk, providing long term and short term fund, maintaining relationship and liaison with financial lender, banker and investor (share holder).
The bank of America (July 2008), describe it as an integrated treasury and trade capabilities that include payable receivable and information reporting, liquidity management, concentration and investment services. Treasury and cash management have continue to evolved as a very strategic and critical function within the enterprises, while many companies are moving to new technologies to help manage the increasing flow of data and the importance of treasury and cash management spreadsheet remain the tools of choice of fact, according to a recent HSBC survey 79% of company still use spreadsheet in their cash management and treasury function and 42% still on rely on manual spreadsheet forecast, something with which 80% are dissatisfied.
According to Capuchin (2001) no single set of feature defined treasury management treasury encompasses many financial activities and the solution to automate these processes.
CHAPTER THREE
INTRODUCTION
SYSTEM ANALYSIS
Is the process of investigating a system, identifying problems and using the information to recommend improvements to the system. In system analysis more emphasis is given to understanding the details of an existing system or a proposed one and then deciding whether the proposed system is desirable improvement.
On the existing system most of the computer based treasury management system that is the operating system is likely to encounter some problem that will affect the financial management of the bank. Record keeping and material handling the existing system may be mismanaged due to insecurity and also some treasurer do not know how to handle their operating systems thereby making treasury work tedious for them. From the interview conduct shows that the system is expensive to make because it need continues updating, from the observation made training staff that is treasurers may cost bank much because some of the existing system did not have manual document on how to use the software thereby causing treasurer difficulty in terms of understanding the procedure on how to handle the system.
CHAPTER FOUR
SYSTEM IMPLEMENTATION AND PROGRAM
System implementation is the practical job of putting a theoretical into practice. It is also the construction of a new system and the delivery of that system into production meaning day to day operation.
In order to achieve fully implementation, of the newly designed system, it is good that the details and method of the implementation are properly communicated within the areas of interest that is:
CHAPTER FIVE
SUMMARY
The project achieve success in the area of banking sector by making treasures to be more reliable in their work and to make financial transaction to be more and effective and efficient for customer thereby reducing stress that is course by the existing system. Also, the new system has brought about efficient and effectiveness for in employee payroll and also in currency exchange and also to get information about some changes in order to face the challenges. Also time wasting has been reduced to the barest minimum if not totally eliminated.
CONCLUSION
This research work has gone a long way in many activities and several other associated means in this computer based treasury management system to create developed and implements to reduce the stress encountered by most treasures in banks. It has achieved its aim of automation by over riding the careful studies analysis and design to produce an executable system. It focuses on the open source and programming tools to accomplish a low cost, easy to deploy, easy to manage and efficient currency exchange. The system offers an integrated and user friendly electronic environment for recording.
Storing and managing the wide array of financial information process by the modern day treasury.
RECOMMENDATIONS
The following recommendation based on the research, discoveries are made to guide the bank on the implementation of computer based treasury management system, these include:
- A comprehensive training program should be organized by the bank to equip the staff by the basic principle of the new system
- If the feasibility study and report has been endorsed by the management then it is recommend that the IT technologies and programmer should be allowed to handle the affairs to the new system for the bank to ensure smooth run.
- The piece of the hardware and software used posses feature that will cope with trend in technology and expansion. Attempt should be made to acquire both hardware and software from the same vendor in case of break down in any part of the system.
- I also recommend that the project team should carry out a cost benefit against the cost involvement.
Finally, the new system is recommended to guarantee trust bank and also to any other banking sector to help them in management of the treasury.
REFERENCES
- Amuar D. (2002): Introduction to Treasury Management Ibadan: University Press
- Barrack T. (2002): On the Determination of the Public Debt Journal of Political Economy. Lagos Iks Press
- Capuchin, P. (2002): Critical for Selecting A Treasury Management System Cash GFlow Magazine. New Jersey Practice Hall Press.
- Laurie, M. (2002): The Next Generation of Treasury Management Oxford: Blackwell Press.
- Masson B. (2002): Data Processing And Information Technology London Dean Publication Ltd.
- Okochi, J. (2008): Key Responsibilities of a Treasury: Cape: Publisher Int. Ltd.
- Onga E. and Belcher M. (2004): What are the Technology Requirement of Corporate Treasury Today. London Wall Street Publishers.
- Parkis R. (2000): Optimal Fiscal and Monetary Policy in an Economic with Capital Journal of Monetary Economics, Harlow. McDonald and Evans Publishers http://www.wikipedia.com (August 2009)
