INSTALLATION AND DESIGN OF PAYROLL SYSTEM
INSTALLATION AND DESIGN OF PAYROLL SYSTEM
1.1 INTRODUCTION TO THE study.
Staff morale and productivity are improved when management pays their employees' salary on time. Manual salary preparation is frequently related with numerous issues, which frequently disturb worker morale.
The issue frequently involves mathematical problems in computation, payment delays, underpayment or overpayment, and so forth. An automated method will be designed in this project work to alleviate all of the issues connected with the manual approach.
The most prevalent technique of keeping a company's financial records was manually. A bookkeeper used his best penmanship to maintain the journals, accounts receivable, accounts payable, payroll, and ledgers in order.
Later years saw the deployment of an accounting machine capable of executing standard bookkeeping duties such as tabulating in vertical columns, performing arithmetic functions, and typing horizontal rows.
“QUICKBOOKS” is an example of payroll software. This software enables the employer to manually compute salaries and enter them into the system. Payroll and cheque printing are handled by the system. The Employer gets access to payroll reports, which he or she can print and double-check against what he or she entered before printing.
This enables the Employer to remedy any detectable problems ahead of time. Computerised Payroll Systems enable you to process the entire routine payroll work electronically rather than manually.
A variety of vendors provide Computerised Payroll System. They largely offer the same type of features as different computer programmes, with slightly varied interfaces.
Payroll is more than just distributing cash or checks. However, after collecting data on what the employees did and comparing it to their salaries, some basic payday math will allow the employer to distribute the funds.
1.2 STATEMENT OF THE PROBLEM.
After conducting research and conducting an interview with the administration of HOUDEGBE NORTH AMERICAN UNIVERSITY, I concluded that a “Mobile Payroll System” should be established.
This is because HOUDEGBE NORTH AMERICAN UNIVERSITY expects the administration to make the computation of commission and compensation easier in their payroll calculation activity and to produce a thorough report.
The administration and personnel of HOUDEGBE NORTH AMERICAN UNIVERSITY experience difficulties in computing their payroll. They don't have to waste time calculating salaries, pensions, taxes, and pulling records of a staff's finances. The administrator wastes a lot of time manually calculating each one.
The goal of this project is to make it easier for the administrator to calculate the desired Commission rate for each employee.
With this project, the administrator can easily calculate each employee's total salary and generate a salary slip as well as a detailed year-end report. This will save a lot of time and make administrative work easier in the payroll calculation activity.
1.3 OBJECTIVE OF THE STUDY.
GENERAL OBJECTIVE: The primary goal of this study is to design and create a database for HOUDEGBE NORTH AMERICAN UNIVERSITY that incorporates a computerised payroll that handles rapid transactions, minimises manual employee checking, deductions, and generates the necessary reports.
A computerised payroll system must be capable of maintaining and generating accurate reports on employee earnings. A computerised payroll's primary goal is to generate paychecks and pension plans.
SPECIFIC OBJECTIVE: To reduce the amount of time spent manually screening each employee. It also creates a channel for generating critical information and monitoring the status of employee pension plans and charges.
1.4 THE SCOPE OF THE STUDY.
The research will include the complete school database, with a concentration on payroll but not entirely excluding the school database. The database comprises several features such as the entry of Academic and Non Academic Staff details, the retrieval of student outcomes, and Fees particular to different departments.
It also serves as an entry point for several courses and departments. The Payroll element is concerned with the process of determining each employee's pay plan. It keeps track of the Pension Plan, Taxes, and so forth.
Extra parameters can be added to the database based on each school's needs, but the skeletal structure of any school database has some specific aspects that have been entered for starters.
1.5 THE IMPORTANCE OF THE STUDY.
This section of the paper highlights the significance of developing a computerised payroll system. It includes examples of how to operate a computerised payroll system. Unlike organisations in other continents such as Europe, Asia, and North America, where employees are paid on an hourly basis.
We in benin stick to the traditional Monthly Payment, which lowers the load placed on Payroll processing. Normally, Payroll processors are required to calculate the Paycheck based on hours worked in relation to pay per hour, deduct Tax and other deductibles, Pension Plan, and so on, before printing out the Paycheck.
However, in this case, the Payroll processor I created would calculate the Paycheck based on the days present in the month, employee post (Position in Hierarchy), Type of Employee (Academic Staff or Non Academic Staff), Tax, and Pension Plan.
A computerised payroll system allows for direct deposit, which reduces money spent on printing live checks as well as time/effort spent tallying the Paycheck for each organisation. It allows the employer to double-check, which is critical in discovering errors that could have serious consequences if not caught.
The system provides reports to verify compliance with tax and pension requirements, ensuring that the company strictly adheres to the restrictions imposed by the government of a specific country. This covers monthly, quarterly, and annual wage reports, as well as the creation of employee forms.
Advanced payroll processors even take employee vacation days, sick days, paid trips, personal time, and so on into account when calculating the exact amount the staff is to earn at a given time.
1.6 DEFINITION OF TERMS
PAYROLL: Payroll is the procedure by which an employer compensates employees for the work they have completed. Any company with employees should have a payroll system in place.
PAYROLL SYSTEM: A payroll system is a piece of software that organises all aspects of employee payment and tax filing. Keeping track of work days, calculating wages, taxes, and pensions, and paying/printing checks are examples of such responsibilities.
SQL SERVER: SQL is an abbreviation for Structured Query Language. This Server works in tandem with Visual Studio, as any data entered while the application is up and running is saved to the SQL database. It is a database computer language that is used to retrieve and manage data in relational databases.
VISUAL STUDIO: To construct this Payroll system, Visual Basic or VB.net is used in conjunction with ASP.net. It is a programming language that is used to design or develop windows or GUI (Graphic User Interface) programmes.
SDLC (SOFTWARE development LIFE CYCLE): The software development life cycle is a framework that explains the activities that take place during each step of a software development project.
It begins with system analysis and progresses through several stages till the implementation and maintenance phases.
HTML stands for HYPERTEXT MARKUP LANGUAGE. It is a language that is used to describe web pages. It works in tandem with CSS. It is a case-sensitive programming language with several tags that are used to mark various components of the web page.
CSS stands for Cascading Style Sheets. It is used to style the HTML page, resulting in visually appealing and presentable web pages.
DDL stands for Data Definition Language. It is employed in the definition of data. Make, Change, and Remove.
DML stands for Data Manipulation Language. It is a data manipulation command. Insert, modify, or delete.
DCL stands for data control language. It is a command used to grant permission. Either grant or revoke.
DQL stands for Data Query Language. It is a command from the database. Select.
MD5 is an abbreviation for Message Digest 5. It is employed in the hashing of passwords. This is one of the security features in place at the Mobile Payroll processor.
S.P. stands for Stored Procedure. It is a query language technique that the database employs to insert values.