DESIGN AND IMPLEMENTATION OF REVENUE CYCLE AND ACCESS MANAGEMENT SYSTEM CASE STUDY OF NEPA

4000.00

ABSTRACT

The work presents a design of a Revenue cycle and access management system for NEPA. 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 Revenue cycle and access management system (RCAMS) is a tool that will assist NEPA 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  Revenue cycle and access management system.

            Chapter one talks about introduction to  Revenue cycle and access management 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 Revenue cycle and access management system (RCAMS) 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.

Access control is the ability to permit or deny the use of a particular resource by a particular entity. Access control mechanisms can be used in managing physical resources (such as a movie theater, to which only ticket holders should be admitted), logical resources (a bank account, with a limited number of people authorized to make a withdrawal), or digital resources (for example, a private text document on a computer, which only certain users should be able to read).

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.

BACKGROUND OF STUDY

The National Electric Power Authority (abbreviated NEPA) is an organisation governing the use of electricity in Nigeria. The company runs a football team, NEPA Lagos.

History

In the early 1960s the Niger Dam Authorities (NDA) and Electricity Cooperation amalgamated to form the Electricity Cooperation of Nigeria (ECN). Then, immediately after the Nigerian civil war the management of ECN changed its nomenclature to NEPA. What is currently called the Power Holding Company of Nigeria was formally known as National Electric Power Authority.

For several years despite consistent perceived cash investment by the Federal Government, power outages have been the standard for the Nigerian populace, and are now seen as normal by the citizens of the country.

Local distribution companies

The government has divided the current NEPA distribution sector into separate companies or entities that will be called Local Electric Distribution Companies or Local Distribution Companies (LDC) among the regions.

STATEMENT OF PROBLEM

Owing to:

Owing to:

Accessing the organizational data/information unauthorized

Fraudulent act of some customer/workers

Sensitive nature of bank data/information

Valuable or costly items in bank

Increase in crime in our society

The need arise for the development of Revenue cycle and access management system to eliminate such problems.

DESIGN AND IMPLEMENTATION OF REVENUE CYCLE AND ACCESS MANAGEMENT SYSTEM CASE STUDY OF NEPA