Design and Implementation of an Expense Manager System

Design and Implementation of an Expense Manager System

Project / Seminar Material
Reference ID: PS-24455-TM

DEDICATION

This research material titled “Design and Implementation of an Expense Manager System” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of an Expense Manager System” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction

    CHAPTER THREE

    SYSTEM ANALYSIS AND DESIGN

    • 3.1 Methodology Adopted
    • 3.1.1 Problem Identification Using SSADM
    • 3.2 Analysis of the Existing System
    • 3.2.1 Dataflow of the Existing System
    • 3.2.2 Disadvantages Of The Existing System
    • 3.2.3 Weakness of the existing System
    • 3.3 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 High Level Model of the Proposed System

    CHAPTER FOUR

    SYSTEM DESIGN AND IMPLEMENTATION

    • 4.1 Objectives of the Design
    • 4.2 Cohesion and Decomposition High level Model
    • 4.3 Control Center / Overall Dataflow Diagram
    • 4.3.1 Proposed System Operation Flowchart
    • 4.4 System Specification and Design
    • 4.4.1 Input and Output Specification
    • 4.4.2 Database Specification and Design
    • 4.4.3 Data Dictionary
    • 4.5 Choice and Justification of Programming Language
    • 4.6 Program Documentation
    • 4.7 Implementation Techniques
    • 4.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    CHAPTER FIVE

    SUMMARY, CONCLUSION AND RECOMMENDATION

    • 5.1 Introduction
    • 5.2 Summary
    • 5.3 Conclusion
    • 5.4 Recommendation

    REFERENCES

    APPENDIX A - “SOURCE CODE”

    APPENDIX B - “OBJECT PROGRAM”

    ABSTRACT

    The Expense Manager is a multi-purpose finance related application intended to run on internet accessible devices. It is designed efficiently to give an individual the best suggestions for finance planning. The aim of the study is to Design and Implement an Online Expense Manager System. In achieving this aim the following objectives were laid out as follows to design and develop an application software that will keep track of all an Organization daily transactions and money lent or borrowed and suggest the best investment options and offers in popular categories. The motivation that led to the implementation of the proposed system is that there is no proper data consistency, some critical inputs may be missed and manual errors may occur and the speed of generating receipt for goods sold and processing data manually is slow and prone to errors. The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. This project will be of benefit to Enterprises, Shopping Malls/Supermarkets and many large companies like; waste companies, and Power holding companies. The expected result is an online Expense Manager System that will sync an application with personal email IDs or social network account which help to serve better recommendations and personalized marketing campaigns.


    Design and Implementation of an Expense Manager System

    CHAPTER ONE

    1.1 Introduction

    The Expense Manager is a multi-purpose finance related application intended to run on internet accessible devices. It is designed efficiently to give an individual the best suggestions for finance planning. The features of the app are designed in a way to help an individual for better finance management planning so the user can keep track of expense records, analyze and optimize stipulated budget. In this application, the user’s data will be collected authenticated permissions and analyze and study their pattern expenses in certain category or by distinct kinds of spending that can be used for studying market trends. These analysis patterns can be derived using some data mining techniques such as clustering, classification and association.

    As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitations of the Study and Definition of technical terms.


    1.2 Background of Study

    In this world of growing technologies everything is digitalized. With large number of money transaction it is difficult for user to keep track of all your transaction. The main aim of this paper is to manage personal and group expenses. Not many applications provide a variety of features within a single application. An application developed that will keep record of user personal expenses, his/her personal contribution towards group expenses, top investment options, view stock market, read authenticated news and grab the best ongoing offers in the market in popular categories.

    The idea of developing this paper in platform arises with the lack of financial awareness in the country as well as frequent concerns being experienced by people to manage their money properly. Some of the problem includes selecting the right investment option suitable for them, reading authenticated financial news, splitting bill among friends and groups, having a good stock market analysis interface and being aware of the latest ongoing promotions at various ecommerce websites. Some of traditional methods used to tackle this problems in daily life is the use of sticky notes. Proficient people deal with problems by using spreadsheet to record expenses, this is easy when the data is small but when the data is large it becomes unmanageable.

    In the existing system, there are problems in certain areas like there no proper data consistency, some critical inputs may be missed and manual errors may occur. The data recorders and handlers have a hectic experience in managing the large chunks of data so, it is believed that a mobile application with a good user interface can easily handle these problems as it can give comprehensive view and the app is intelligent enough to suggest the best options as per the budget selected by the user.


    1.3 Statement of Problems

    Investigation reveals the problems of the Online Expense Manager System research work which are as follows:

    1. Not many applications provide a variety of features within a single application.
    2. There is no proper data consistency, some critical inputs may be missed and manual errors may occur.
    3. The speed of generating receipt for goods sold and processing data manually is slow and prone to errors.
    4. The current process is stressful to end-users due to time factors
    5. Producing the receipt printout for each transaction is costly for a business while keeping them only to find them faded, damaged or lost and therefore of no help is unfortunate to customers.

    1.4 Aim and Objectives of Study

    The aim of the study is to Design and Implement an Online Expense Manager System. In achieving this aim the following objectives were laid out as follows to design and develop an application software that will:

    1. Keep track of all an Organization daily transactions and money lent or borrowed.
    2. Suggest the best investment options and offers in popular categories.
    3. Display stock market and read latest authenticated financial news.
    4. Keep track of the files can at any operate the organization and client’s financial report.
    5. Generate accurate customer’s cash receipt for goods/item sold.

    1.5 Significance/Justification of Study

    The proposed system will be beneficial to Organizations, Enterprises and Business Managers by syncing the application with personal email IDs or social network account which help will serve better recommendations and personalized marketing campaigns. The features of the app are designed in a way to help an individual for better finance management planning so the user can keep track of expense records, analyze and optimize stipulated budget.


    1.6 Scope of Study

    The study focuses on the Design and Implementation of an Expense Manager System that will keep track of all an Organization daily transactions and money lent or borrowed using Rarban stores Ltd Port Harcourt in Rivers State as a case study.


    1.7 Limitations of the Study

    During the course of this study, many things militated against its completion, some of which are:

    1. Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
    2. Research material: availability of research material is a major setback to the scope of the study.
    3. Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
    4. Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).

    1.8 Definition of Terms

    Acquiring Bank: This is a bank or financial institution that accepts payments for the product or services on behalf of a Merchant.

    Computer: This is an electro-mechanical device that is capable of accepting data as inputs, stores it, processes the data and outputs it as result or information.

    Credit Card: It is a payment mechanism that enables consumers to make their online purchase.

    Data: Data are raw facts which undergo processing and become information. They are also the simplest unit of information that can stand on its own.

    Digital Certificate: It is a certificate that enables a merchant to do on-line business and it is been issued by a corporate body.

    Gateway: This is a device that connects two computer networks that cannot be connected in any other way.

    Internet: It is an interaction of computer networks connecting other networks from computers, companies, houses etc.

    ISP Internet Service Provider: This is a company(s) that provides internet access to homes or business users.

    Merchant Account: It’s a contract under which an acquiring bank extends a line of credit to a merchant who wishes to accept payment card association brand

    Program: A program is a sequence of instructions written in a computer to execute a certain task and solve a problem. A program must possess clarity, be specific, effective and user friendly.

    WWW (World Wide Web): It is a multimedia interface that connects us to resources such as documents, e-mails, chat, web sites that are available on the internet with the computer.

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Implementation of an Expense Manager System