DESIGN AND IMPLEMENTATION OF COMPUTERIZED INTERNALLY GENERATED REVENUE INFORMATION SYSTEM CASE STUDY OF ENUGU EAST L.G.A

ABSTRACT

The work presents a design of a computerized internally generated revenue information system  for ENUGU EAST L.G.A. There are several ways in which the term revenue is used. A revenue account is the equivalent of the profit and loss account. Revenue expenditure (as distinct from capital expenditure) is expenditure that is deemed to affect only the current accounting period and is therefore written off to the revenue account during that period. Judgments also have to be made on when a company should or can recognize revenue. In general, it depends more on when contractual obligations are fulfilled than when the money is received; for example, revenue is normally recognized when delivery has been made and the goods have been invoiced even though the payment may not be received for another month.

The computerized internally generated revenue information system  (CIRGS) is a tool that will assist ENUGU EAST L.G.A administrators in interpreting the revenue outcomes of operational decision-making. It will help administrators to decide whether their programs revenue health is better or worse than during previous accounting periods or past budget periods.

ORGANIZATION OF WORK

            This project work is primarily designed to give an insight to Computerized internally generated revenue information system .

            Chapter one talks about introduction to Computerized internally generated revenue information system , study of problem and objectives as well as definition of the scope.

            Chapter two comprises the literature review. Chapter three gives the detailed information about the existing (old) system, while chapter four and five deals with the design and implantation of new system.

            Chapter six document the project work, while chapter seven summaries,  conclusion and suggestions were made.

TABLE OF CONTENTS

Title page                                                                                                        i

Certification                                                                                                    ii

Dedication                                                                                                      iii

Acknowledgement                                                                                          iv

Abstract                                                                                                          v

Table of contents                                                                                            vii

CHAPTER ONE

INTRODUCTION                                                                                         1

1.1       Background of the study                                                                    1         

1.2       State of the problem                                                               2

1.3       Purpose of the study                                                               3

1.4       Aims and objectives                                                                3

1.5       Scope of study                                                                                    5

1.6       Limitations of study                                                               5

1.7       Assumptions                                                                           6

1.8       Definition of terms                                                                             7

CHAPTER TWO

LITERATURE REVIEW                                                                  8

CHAPTER THREE

• Description and analysis of existing system                           15
  • Fact finding method used                                                                   17
  • Organization structure                                                                        19
  • Objectives of Existing system                                                            21
  • Input, Process and Output Analysis                                       22
  • Information Flow Diagrams                                                   26
  • Problems of the Existing System                                            27
  • Justification of the New System                                                         28

CHAPTER FOUR

• Design of the New System                                                     30
  • Input Specification and design                                                           30
  • Output specification and design                                                         32
  • File Design                                                                                          34
  • Procedure chart                                                                                   36
  • System flow chart                                                                               38
  • System requirements                                                               40       

CHAPTER FIVE

• Implementation                                                                                   42
  • Program Design                                                                                  45
  • Program Flowchart                                                                 48
  • Pseudo code                                                                                        54
  • Source Program: Test Run                                                      59

CHAPTER SIX       

Documentation                                                                                               60

CHAPTER SEVEN

• Recommendation                                                                                62
  • Conclusion                                                                                          64

Bibliography                                                                           65

1.0  CHAPTER ONE

INTRODUCTION

The Computerized internally generated revenue information system  (CIRGS) is an operational system that supplies the reports and data that are used for the audit of the Custodial Revenue Statements of the IRS by the General Accounting Office (GAO).  A major objective of the custodial Revenue reporting system is to be continuously and accurately responsive to regular and ad hoc requests for custodial revenue reports.

CIRGS is currently in the Control phase of the IRS CPIC process where it is continuously monitored for cost, schedule, and project performance. The IRS ensures that operational systems are executed in a disciplined, well-managed, and consistent manner through timely oversight, quality control, and executive review.

 The Administrative revenue operations, information systems, and statements are similar to those found in any large corporation. However, the Custodial revenue operations, information systems, and associated statements track tax revenues processed through the lRS pipeline. The pipeline is the IRS’ tax return processing channel that begins at initial receipt of tax returns and remittances and tracks the information/funds through postings on the Master Files, many large databases. 

Revenue and Refunds

This system is used to identify all of the detailed transactions that posted to the Individual Master Files (IMF), Business Master Files (BMF), Individual Retirement Accounts File (IRAF), and Non-Master Files (NMF) during the fiscal year. These detail transactions are broken down into Revenue transactions, Refund transactions, Other Transactions that are part of the fiscal year, and Other Transactions that are not part of the fiscal year. Once these breakouts are done, revenue and refund reversal transactions are matched to the transactions they reverse. Paper and electronic reports are generated and distributed to the Office of the CFO and to GAO. The detailed files provide support for the amounts from the Interim Revenue Accounting Controls System (IRACS). The files are also made available to GAO for sampling and to validate the revenue statements.

Unpaid Assessments

The objective of Unpaid Assessments is to continue to provide the users, Chief Revenue Officer  (CFO), Research, Compliance, and GAO, with required program changes for reporting, researching and auditing of the revenue statements for debit balance and frozen credit modules.  The near term objectives are to support:

STATEMENT OF PROBLEM

Owing to:

The difficulties people face in keeping information/data.

Unwillingness attitude of some ENUGU EAST L.G.A staff when dealing with data/information.

Fragile nature of information/data.

Error encountered in revenue analysis.

Mispresentation of revenue data.

Difficulties people encountered when searching for a given information.

Time wasted in searching for information on packed files.

Time wasted in sorting files.

Important nature of data/information in the growth of any organization.