DESIGN AND IMPLEMENTATION OF A COMPUTERIZED
FINANCIAL ACCOUNTING SYSTEM
FOR A HOTEL INDUSTRY
(A CASE STUDY OF MODOTEL HOTEL, OKPARA AVENUE, ENUGU)

ABSTRACT
The importance of financial accounting is gradually being recognized as germane to prudent management of any business firm. This has necessitated the need for the computerization of structured operations of the financial managers structured operations are known with certainly for instance, the computation and decisions based on financial ratios.
This project, therefore is a case study of Modotel Hotel. It describes the computerization of the financial accounting of the hotel as packaged for its clients. Thus this study gives a detailed methods for the development of an optimal financial database for hotel industry as well as the software required for the computation and tabulation of different financial ratios.

ORGANIZATION OF WORK
This work is sub-divided into seven chapters, starting with chapter one, chapter one shows the problem and its setting. Purpose of study, aims and objectives, scope and limitation assumptions and definition of terms.
The second chapter deals with literature review. Third chapter was concerned with description and analysis of existing system.
Chapter four was concerned with the design of the new system, system specification and information requirement of new system.
Chapter five deals with implementation of the system, sixth chapter deals with documentation, which is more or less, like a manual for the program.
Finally, the seventh chapter dealt summary, conclusion and recommendations.
The project work also have references for further study.

TABLE OF CONTENT
CHAPTER ONE
1.0 INTRODUCTION
1.1 STATEMENT OF PROBLEM
1.2 AIMS AND OBJECTIVES
1.3 DELIMITATION OF SCOPE
1.4 LIMITATION
1.5 ASSUMPTION
1.6 DEFINITION OF TERMS

CHAPTER TWO
LITERATURE REVIEW

CHAPTER THREE
3.0 DESCRIPTION AND ANALYSIS OF THE EXISTING SYSTEM
3.1 FACT FINDING METHODS
3.2 ORGANIZATIONAL STRUCTURE
3.3 OBJECTIVES OF THE EXISTING SYSTEM
3.4 INPUT, PROCESS AND OUTPUT ANALYSIS
3.5 INFORMATION FLOW DIAGRAM
3.6 PROBLEM OF THE EXISING SYSTEM
3.7 JUSTIFICATION FOR THE NEW SYSTEM

CHAPTER FOUR
4.0 DESIGN OF THE NEW SYSTEM
4.1 OUTPUT SPECIFICATION AND DESIGN
4.2 INPUT SPECIFICATION AND DESIGN
4.3 FILE DESING
4.4 SYSTEM FLOWCHART
4.5 PROCEDURE CHART
4.6 SYSTEM REQUIREMENTS

CHAPTER FIVE
5.0 IMPLEMENTATION
5.1 PROGRAM DESIGN
5.2 PROGRAM FLOW CHART
5.3 PSEUDO CODES
5.4 SOURCE PROGRAM
5.5 TEST RUN

CHAPTER SIX
6.0 DOCUMENTATION

CHAPTER SEVEN
RECOMMENDATION AND CONCLUSION
REFERENCE
CHAPTER ONE
INTRODUCTION
Finance is the life wire of any business organization. It is required for the execution of production, sales and administration of a business operation. As a discipline, finance is concerned with the acquisition and administration of the use of the firms funds as well as profit planning and control financial analysis is inevitable for the effective planning and control of any firm.
To effectively plan for the future, the financial manager should be able to asses the financial position of the firm and relates this to its confronting investment opportunities. Since funds are scarce, financial analysis helps the financial manager to assess the returns on investment accruing from ploughing the firms assets and thereby efficiently allocate resources.
However, financial accounting is the employment of the firms balance sheet and income statement to establish some relationship between one figute and another in order to highlight the strengths and weakness of the concerned business. The balance sheet of a firm is also called the financial position because it shows the position of the business in monetary term at a given point in time while the income statement show how the position depicted by the balance sheet has been attained. The results of financial analysis are normally expressed as financial ratios which could be broadly classified as liquidity, leverage, activity and profit ratio. The suppliers of the firm’s funds and the investing public are usually interested in these ratios. But the nature of interest expressed on the firm determines the ratios to be emphasized by each concerned parts. This implies that different people emphasize on different ratios and as a result financial analysis means different thing to different people.
For instance, creditors are interested on those ratios which measure the ability of the form to service their debts and pay the principal as and when due while the equity owners are interested on the profitability ratios. The financial manager occupies a unique position in the firm as he should be able to computer interpret and explain these ratios to various interest groups in the firm when the firm requires funds from outside sources, the financial manager should be able to use the relevant ratio to convince investors to supply their funds. Also the financial manager should be able to justify the reasonableness of some investment or project being under taken by management before the shareholders.
However, the cost involved in the employment of a financial manager makes it mandatory for small-scale companies to engage the services of a financial consultants. The increased use of high-speed computers in various facets of business should popularize the use of financial ratios in business decision. This is because computer would provide the necessary equipment to handle problems associated with voluminous maze of financial data due to lack of time or more.
This study therefore, aims at the development of a data base for financial statements and a set of programs to computer, store and retrieve various financial ratios for some companies.
STATEMENT OF PROBLEMS
The Nigeria companies act of 1968 stipulate that all registered companies in Nigeria should file their audited annual balance sheet this will guide the investors in the development of the funds and to provide basis for company taxation. But there are some problems facing the financial accounting of any hotel. These problems includes:-
1. Illegal use of money cards – some managers has taken the privilege of using both credit and debit cards to steal companies money and some do not know how to use this cards thereby causing problems to the hotels.
2. One of the major loopholes of an un-computerized financial accounting system is its ability to fraud a company. This poses a problem to the management of a hotel.
3. Some companies employ inexperienced managers who are not professionals in the field of computing and this will restrict the objectives of the