Design And Implementation Of A Computerized Accounting System Of An Academics System

(A Case Study Of Imt Enugu)

7 Chapters
|
67 Pages
|
7,462 Words
|

A computerized accounting system within an academic setting refers to the automated framework employed to manage financial transactions and records specific to educational institutions. This system integrates advanced software solutions tailored to streamline the financial aspects of academic operations. Key components include modules for recording tuition fees, managing payroll for faculty and staff, tracking expenditures, and generating comprehensive financial reports. Such a system is crucial for enhancing efficiency, accuracy, and transparency in financial processes within educational institutions. By leveraging digital tools, academic institutions can ensure precise financial management, timely reporting, and adherence to budgetary constraints. The integration of a computerized accounting system in academia not only expedites routine financial tasks but also provides valuable insights for strategic decision-making, fostering a more robust and accountable financial infrastructure.

ABSTRACT

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

 

TABLE OF CONTENT

Title page
Certification
Acknowledgement
Abstract
Dedication
Organization of work
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 existing 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 design
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
Accounting is the life wire of any institutional organization. It is required for the execution of production, sales and administration of a institution operation. As a discipline, Accounting is concerned with the acquisition and administration of the use of the firms’ funds as well as profit planning and control Accounting analysis is inevitable for the effective planning and control of any firm.
To effectively plan for the future, the Accounting manager should be able to assess the Accounting position of the firm and relates this to its confronting investment opportunities. Since funds are scarce, Accounting analysis helps the Accounting manager to assess the returns on investment accruing from ploughing the firms’ assets and thereby efficiently allocating resources.
However, Accounting is the employment of the firm’s balance sheet and income statement to establish some relationship between one figure and another in order to highlight the strengths and weakness of the concerned institution. The balance sheet of a firm is also called the Accounting position because it shows the position of the institution 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 accounting analysis are normally expressed as accounting 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 accounting 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 Accounting 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 Accounting manager should be able to use the relevant ratio to convince investors to supply their funds. Also the Accounting 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 Accounting manager makes it mandatory for small-scale institution to engage the services of a Accounting consultant. The increased use of high-speed computers in various facets of institution should popularize the use of Accounting ratios in institution decision. This is because computer would provide the necessary equipment to handle problems associated with voluminous maze of Accounting data due to lack of time or more.
This study therefore, aims at the development of a database for Accounting statements and a set of programs to computer, store and retrieve various Accounting ratios for some institution.

STATEMENT OF PROBLEMS
The Nigeria institution Act of 1968 stipulate that all registered institution 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 institution taxation. But there are some problems facing the Accounting of any institution. These problems includes:-
1. Illegal use of money cards – some managers has taken the privilege of using both credit and debit cards to steal institution money and some do not know how to use this cards thereby causing problems to the institutions.
2. One of the major loopholes of an un-computerized Accounting system is its ability to fraud a institution. This poses a problem to the management of a institution.
3. Some institution employ inexperienced managers who are not professionals in the field of computing and this will restrict the objectives of the computerized system to a certain limit.
4. Insufficient fund- to set up a complete computerized Accounting system requires a huge amount of money. Some institutions find it difficult to afford or cannot afford it.

OBJECTIVES OF THE STUDY
1. The use of password and other security measures enable a institution to prevent unauthorized user of the files.
2. The use of money cards by some customers will act as a security measure against armed robbers and other inconveniences ca-use by the bulkiness of their money.
3. Information can be stored for future use and can also be retrieved at an electronic speed. This will prevent the time wasting while using the manual files.
4. The computer has been proved without any doubt to be far more accurate than either any know person or any previous machine performing mechanical operation with data.
5. Computer works at incredible high speed. It performs millions of calculations, sort and combines information in different ways within a second.

DELIMITATION OF STUDY
This study is focused on IMT Enugu, one of the prominent institutions in Enugu, owned by private individual. It has been chosen as case study because it is expected that given it size, modernity and its promoters. It will satisfy our data need. In examining the management of the institution, this project is limited to the Accounting aspect of the management.

LIMITATION OF THE STUDY
I was constrained by menu factors in carrying out this research work. This was despite my intention to make more research on the issue. Firstly, I was constrained by time factor. The project was not given enough periods in out timetable. And there was some academic constrains that is the combination of lectures, exams and writing of the project proved cumbersome. Secondly, due to the prevailing economic order in the country in general and the agency institution in particular. I had not enough fund to Accounting more extensive research on the subject. Thirdly information were made difficult to obtain by attitudes of some personnel to conserve their duty of secrecy, institution management did not permit the disclosure of account programs.

ASSUMPTION
It is assumed that a computerized Accounting account will be of great advantage to both the institution management and government.
Data can be easily documented and retrieved in most economic manner.
Computer are never tired of carrying out a repetitive task as Accounting manager may be and everything is done at an electronic speed.

DEFINITION OF TERMS
DATA
Raw information when data is processed, it becomes information.
HARDWARE
The physical components of a computer like the keyboard, the video display unit (VDU) etc.
MICRO-PROCESSOR
The part of a computer system that performs the major activities like reasoning calculation etc.
PROGRAM
Series of logically related instructions arranged for the computer to execute or run. It controls the activities of the system (i.e the system program or the application program).
PASSWORD
A word supplied to a computer in order to gain access to the system or a file.
SOFTWARE
The logical components of the system like the program. They are not visible.
ASSETS
These are those items, which belongs to a institution so long as they have value the values can be objectively measured and the ownership by the assets can be proved.
LIABILITIES
These are those item s owned by the institution.
BALANCE SHEET
This portrays the assets and liabilities of a institution at specific point in time. It also is known as the position.
INCOME STATEMENT
This is a summary of all transactions, which have taken place during a period, resulting in either a profit or loss figure.

Save/Share This On Social Media:
MORE DESCRIPTION:

Computerized Accounting System Of An Academics System:

A computerized accounting system for an academic institution, such as a school, college, or university, is essential for managing financial transactions, budgeting, payroll, and reporting. Here are the key components and features of such a system:

Chart of Accounts: Set up a chart of accounts tailored to the specific needs of the academic institution. This chart should include categories for tuition fees, grants, scholarships, salaries, utilities, supplies, and any other relevant income and expenses.

General Ledger: The general ledger is the central repository of financial transactions. Each transaction, such as a payment or revenue entry, is recorded here. The system should allow for easy journal entry and reconciliation.

Accounts Payable: Manage and track invoices from vendors, including payments for textbooks, classroom supplies, and other educational materials. The system should provide features for invoice approval and payment processing.

Accounts Receivable: Track student tuition fees, scholarships, and grants. Generate invoices and statements, and manage the collection process. The system should also provide tools for tracking outstanding balances.

Payroll Management: Handle employee salaries, benefits, and deductions. Ensure compliance with tax regulations and generate payroll reports. Integration with time and attendance systems can help automate this process.

Budgeting and Forecasting: Create and manage budgets for various departments and projects within the academic institution. Monitor actual spending against budgeted amounts and generate forecasts.

Financial Reporting: Generate financial statements such as income statements, balance sheets, and cash flow statements. Customize reports to meet the institution’s specific needs, and ensure compliance with accounting standards.

Asset Management: Track and manage assets such as equipment, computers, and vehicles. Depreciation calculations should be automated.

Bank Reconciliation: Reconcile bank statements with the general ledger to ensure accuracy and identify any discrepancies.

Security and Access Control: Implement strict security measures to protect sensitive financial data. Define user roles and permissions to restrict access to authorized personnel only.

Integration: Ensure that the accounting system can integrate with other systems used by the academic institution, such as student information systems and procurement systems.

Audit Trail: Maintain a detailed audit trail of all financial transactions and changes made within the system. This is crucial for accountability and compliance.

Compliance: Stay up to date with tax regulations and accounting standards specific to educational institutions, as they can differ from those of other industries.

Training and Support: Provide training to staff members who will use the system and offer ongoing support to address any issues or questions.

Backup and Disaster Recovery: Implement regular data backups and have a disaster recovery plan in place to prevent data loss.

Selecting the right accounting software or system for an academic institution should involve a thorough assessment of its specific needs, scalability, and the availability of features required for efficient financial management. Additionally, ongoing maintenance and updates are essential to keep the system current and secure.