Home » Project Material » Design And Implementation Of Computerized Accounting System Of A Non-Profitable Organization

Design And Implementation Of Computerized Accounting System Of A Non-Profitable Organization

(A Case Study Of Grail Movement Enugu)

A computerized accounting system for a non-profit organization is a sophisticated financial management tool designed to streamline and enhance the organization’s financial processes. This system integrates various accounting functions, such as bookkeeping, budgeting, and financial reporting, into a cohesive digital framework. By leveraging advanced software, these systems allow non-profit entities to efficiently track and manage their financial transactions, grants, and donations. The integration of keyword-specific functionalities ensures accurate and transparent financial records, facilitating compliance with regulatory requirements and aiding in donor trust. The tailored features of such systems cater to the unique financial needs of non-profits, offering robust solutions for fund accounting, donor management, and program budgeting. In essence, a computerized accounting system plays a pivotal role in enhancing the financial management capabilities of non-profit organizations, promoting transparency, accountability, and effective resource allocation.

ABSTRACT

It is a well-established fact, that proper financial management and adequate planning is the bedrock of every successful organization. Reports generated from the accounts are among the major tools used by the management of any establishment for policy formulation, major decisions taking etc.
Account is the statement of money paid out or to be paid out by an organization, and the ones received or to be received.

Due to the trend towards automation in world order, more data and information are generated in lesser time and the processes and procedures of conducting business and keeping account becomes more complex and complicated. The manual form of keeping account become more tedious, inefficient and cost ineffective due to huge material and human resources required.
There is need for an alternative to manual processing of account, which will ensure security of data and account information, data validation and accuracy, efficiency in accounting system, prevent un-authorized manipulation of data etc.
This project work critically analyzed the processes and procedures of manual methods of account keeping and the case study “Grail Movement”, carefully designed new more efficient procedure, which was coded into an intelligent software, using a programming language suitable for database management.

 

TABLE OF CONTENT

Cover page
Title page
Certification
Dedication
Acknowledgement
Abstract
Table of content

CHAPTER ONE
1.0 Introduction
1.1 Statement of problem
1.2 Purpose of the study
1.3 Aims and objectives
1.4 Scope of the study
1.5 Limitation
1.6 Assumption
1.7 Definition of terms

CHAPTER TWO
2.0 Literature review

CHAPTER THREE
3.0 Description and analysis of the existing system
3.1 Facts finding method used
3.2 Organizational structure
3.3 Input, process, output analysis
3.4 Objective of the existing system
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 Input specification and design
4.2 Output specification and design
4.3 File design
4.4 Procedure chart
4.5 System flow chart
4.6 System requirements

CHAPTER FIVE
5.0 Implementation
5.1 program design
5.2 Program flow chart
5.3 Pseudocodes

CHAPTER SIX
6.0 Documentation

CHAPTER SEVEN
7.1 Recommendation
7.2 Conclusion
Reference

CHAPTER ONE

INTRODUCTION
In a large organization such as the Grail Movement, the account system is the life wire of the administration not respecting the fact that it is a non-profitable organization. It is through proper accounting, that the management can find out their financial performances and the information gotten help them in planning future routine strategies.
Grail Movement is a non-profitable organization, housing other groups, like the flower group, labour group, and catering group. They raise funds within themselves, from the sales of books, willingly, and through individual pledges.

This project is on a computer based accounting system using “Grail Movement” as a test case. This accounting software attained some degree of flexibility. It is intended to track all source of revenue (i.e. money coming in) and liabilities (i.e. expenditures). It is a user-friendly accounting package, which manages the daily accounting operations and provides for the security of the information in the system, input data validation and restricts access to some vital management information.
This software is able to generate reports on demand and statements needed by management for its decision making while promoting the organization functional establishment. This report ranges from individual donations statement of account, trial balance sheet, debtors & debts to profit and loss account within a specified data interval. The report could be viewed on the screen or printed on paper as desired by user.

1.1 STATEMENT OF THE PROBLEM
Before now, Grail movement has been using manual method of accounting system. This system is characterized with many problems which necessitated its computerization. Among these problems are:-
– INCONCURRENCY OF ENTERED DATA
Due to human error, the accountant, after entering the right data from the invoice to the appropriate journal, may come back to post-incorrect amount to the general ledger.
– INACCURATE CALCULATION
This is a situation where the necessary addition is not able to balance with the corresponding subtractions. This human error might be due to fatigue.
– FRAUD
Manual accounting system is prone to fraud. This is trough the distortion of data in the account book, cause by unauthorized access to the book and it’s insecurity.
– POOR DOCUMENTATION AND DISTORTED RECORD KEEPING
This is a situation, where the account books cannot be stored for a long period of time.
– COST INEFFECTIVENESS

1.2 PURPOSE OF THE STUDY
This study has the purpose of designing and implementing a computerized accounting package.
This accounting system will attain some degree of flexibility, be able to produce the required report on demand, be reliably effective and accurate.

1.3 AIMS OF OBJECTIVE
This project is aimed at producing optimal solution to the problems inherent in manual system of accounting in Grail Movement. The objectives include.
EASE (SIMPLICITY)
Having a computerized accounting at Grail movement organization, the work of the account and his co-workers we reduced to a minimum. The job becomes simpler and easier to tackle and can be accomplished within a short period of time.
EFFECTIVENESS
The old system is intended to be computerized, so that it’s operations could be performed faster and reports generated on demand for quicker decision making by the management.
ACCURACY
To be able to obtain at any point in time, an error-free and up-to-date financial state of the organization. An accurate and timely financial statement or information is a good tool for such decision-making.
REDUNDANCY
Using the computerized accounting software saves grail movement the burden of creating work than one file, for a particular item (i.e. of similar content). The system should be able to detect existing entries and not produce copies unless the former to deleted.
EFFICIENCY
This accounting package will reduce access time to stored data as inquires could be made and information gotten without stress.
NEATNESS
Using this software, a neat, tidy and error-free report will be obtained. Also work free of mutilation and cancellations will be produced. The output gives joy and contentment to one who uses it.

1.4 SCOPE OF THE STUDY
This project is intended to cover a wide area, dealing with the methods of fund raising and services rendered. It deals with the entry of moner or transaction made by the company within the account department.
Daily transactions are entered in their respective destinations and accounts balanced accordingly. These entries are posted or transferred to the general ledger module, which is an integration of other subsidiary module. The general ledger is the powerhouse of the system.
At the end of each accounting month/year, the financial statements are produced, neat and error-proof. These include:-
a. Income statement (income and expenditure account)
b. Balance sheet
The calculations necessary for the accurate and speedy as well as neat production of these statements are also taken into consideration.

1.5 LIMITATIONS
There was inadequacy of time for conducting a more detailed study, so as to achieve greater flexibility of the software package and to cover a wider area of account system for a broader generation of report.
However, it would be emphasized here that these limitations do not in anyway invalidate the findings, as proper cares was taken to avoid adverse effect on the study.

1.6 ASSUMPTIONS
In order to establish a solid and unambiguous base, which will facilitate the test of the selected variable, the researcher made the following assumption.
– That the Grail Movement Enugu, chosen for the research is a true representation of a non-profitable organization operating in all the states in Nigeria and internationally
– That Grail movement generates funds by individual pledges and donations.
– It is also assumed that grail movement distributes fund to it’s various group, according to their purposes for its up-keep.
– Finally, the designer assumed that this accounting package is well known to the computer operator. The user is expected to have known or undergone some training on computer applications, so as to fully use the package.

1.7 DEFINITION OF TERMS
Account Payable: Amount you are owing salary earners.
Account Receivable: Amount made by pledges to be redeemed.
Invoice: A document prepared by a supplier, requesting payment for goods and services provided.
Debit: Money that is going out or being given out appears on the left-hand side of an account. All applications of money are debit..
Balance Sheet: A financial statement that shows the financial position of a business at a particular date.

Save/Share This On Social Media:
MORE DESCRIPTION:

Computerized Accounting System Of A Non-Profitable Organization:

A Computerized Accounting System (CAS) for a non-profit organization (NPO) is essential for managing finances, tracking donations, and ensuring compliance with financial regulations. Here are some key components and considerations for setting up a CAS for a non-profit organization:

  1. Accounting Software Selection:
    • Choose accounting software that is suitable for non-profit organizations. Some popular options include QuickBooks Nonprofit, Xero, or specialized NPO accounting software like Aplos or Blackbaud Financial Edge NXT.
  2. Chart of Accounts:
    • Develop a chart of accounts tailored to the needs of your non-profit. It should include categories for donations, grants, program expenses, administrative costs, fundraising expenses, and more.
  3. Donation Tracking:
    • Implement a system for tracking donations, including the donor’s information, donation amount, and purpose (restricted or unrestricted). The software should also generate donation receipts for tax purposes.
  4. Grant Management:
    • If your organization receives grants, set up a system to track grant applications, approvals, expenses, and reporting requirements. Ensure that you meet any grant-specific accounting and reporting guidelines.
  5. Expense Tracking:
    • Categorize and track all expenses related to your organization’s programs, administration, and fundraising activities. Use cost centers or classes in your accounting software to differentiate between these categories.
  6. Budgeting and Financial Planning:
    • Use the accounting software to create and manage budgets for different programs and projects within your organization. Monitor actual spending against the budget to ensure fiscal responsibility.
  7. Bank Reconciliation:
    • Regularly reconcile your bank statements with your accounting records to identify any discrepancies and ensure accuracy.
  8. Financial Reporting:
    • Generate financial reports, including income statements, balance sheets, and cash flow statements, to provide an overview of your organization’s financial health. Customize these reports to meet the needs of your board of directors, donors, and regulatory authorities.
  9. Compliance and Transparency:
    • Ensure compliance with non-profit financial regulations and reporting requirements in your jurisdiction. Non-profits are often subject to specific accounting standards and tax regulations.
  10. Data Security:
    • Implement robust security measures to protect sensitive financial data. Ensure that only authorized personnel have access to the accounting system.
  11. Training and Documentation:
    • Provide training to staff responsible for using the CAS. Maintain clear documentation on accounting procedures and processes to ensure consistency and continuity.
  12. Audit Preparedness:
    • Be prepared for financial audits by maintaining accurate records, supporting documentation, and a well-organized accounting system.
  13. Integration:
    • If your organization uses other software systems (e.g., donor management software), consider integrating them with your CAS to streamline data flow and reduce manual data entry.
  14. Regular Updates:
    • Keep your accounting software up to date with the latest versions and patches to ensure security and functionality.
  15. Continuous Monitoring:
    • Regularly review financial reports and monitor financial performance to identify trends, potential issues, or areas for improvement.

A well-designed Computerized Accounting System for a non-profit organization can streamline financial management, enhance transparency, and facilitate compliance with regulatory requirements, ultimately enabling the organization to focus on its mission and achieve its goals effectively