Importance of payroll:-

Employee’s moral is affected by payroll administration and employee is the main resource of any organization.

Employees should be paid sufficiently to motivate employees.

Scope 

The payroll system has the following scope.

1) Defining the salary structure of an employee.

2) Acceptance of attendance of employees.

3) Defining the leave structure of an employee.

4) Identify employee type & designation.

5) Calculating Gross income, deductions & finally Net Income of an employee.

6] Providing salary details to employees.

7) Generation of reports.

Existing System 

Working of an existing manual payroll system is as follows:

1. Salary structure and leave structure are obtained by the payroll department from the HR department.
2. Attendance record in form of musters is also obtained from the attendance monitoring system.
3. All the employees are identified manually, and records from musters are checked to identify employee types. After identifying the employee type depending on his/her designation Net salary and gross salary are calculated. if any deductions are there then those are also deducted. Payslip is generated by considering their payable days depending on the records obtained from the attendance monitoring system, salary structure, and leave structure.
4. Reports are generated, reports like the total amount given in form of salaries.
5. Monthly reports and yearly reports are also generated. These reports are then transferred to Management.
6. All these calculations are done manually by the payroll department staff.

Limitation of the existing system:

1)   For identifying the employee type Existing manual method takes time as it uses musters to check the records.

2)   Net income, gross income, and all the necessary deductions are done manually in the existing system, which may cause errors in calculations.

3)   All the employee details are maintained in Musters, which involves a lot of redundancy and also it takes a lot of time in order to back up the whole employee details, which physically is not much feasible.

4)   Generation of pay slips is done manually by pay role employees. Which is a time-consuming process.

5)   All the reports, are also developed by payroll employees manually.

All these tasks are time-consuming and can involve errors due to a lot of human interface.

User Environment:

The development environment of the system is client-server.

1. Client-side requirements.

2. Server-side requirements 

Client-side requirements:- 

minimum Hardware requirements:- 

• It requires a minimum of 512 MB ram.
• 10 GB of memory to store the data of customers.
• It requires a monitor i.e L.C.D or desktop.
• It supports to the keyboard of 120  keys(only English)
• It requires an optical mouse.

software requirements:- 

• Front end:- it requires JVM (Java Virtual Machine).
• It supports Microsoft related operating
• Related drivers as specified in the hardware

Software requirements:-

• It requires jdk1.6.0
• MYSQL to maintain the database.

Network connectivity requirement:-

Star topology:- it requires a hub. fiber optic cable in order to connect clients to the server.

Test Case for Payroll Management System:

Test Case ID	Input	Description	Expected Result	Actualresult
1	User name=e1000	Enter the user name with the help of the i/p interface1)Enter the username 2)Enter a valid password 3)Press Login	The system should accept the behavior. The system will display the Home page.
2	User name=”	Enter user name with the help of  i/p interface1)Enter a valid password 2)Press Login	The system will display an error message.
3	User name=employee	Enter user name with the help of  i/p interface1)Enter the username 2)Enter a valid password 3)Press Login	The system should accept the behavior. The system will display the Home page.
4	Password=” invalid”	Enter user name with the help of  i/p interface1)Enter the username 2)Press Login	The system will display an error message.
5	User name=#$kiran	Enter user name1)Enter a user name 2)Password 3)Press Login	The system will display an error messages will be navigated to same page
6	Enter Employee Id=e1000	Enter Employee Id with the help of i/p interface1)Enter Employee Id 2)Press Submit	The system should generate a new password & send to valid employee’s mobile no
7	Enter Employee Id=*&kiran%	Enter Employee Id with the help of i/p interface1)Enter Employee Id 2)Press Submit	The system should not generate a new password& display an Invalid employee id message
8	Enter Employee Id=e1000	If the user selected forgot password link  & entered the Employee ID	The system should send the existing user password to the user via mobile
9	Click on Paygrade Button	If the manager clicks on paygrade button	the system should display available paygrade in the system
10	Click on Edit Button	If the manager click on the paygrade tabs Edit button	the system should allow the manager to edit fields in the paygrade table
11	Click on Save Button	If the manager click on the paygrade tabs Save button	the system should save details changed by the manager
12	Click on Earning Button	If the manager click on Earning button	the system should display available Earning in the system
13	Click on Edit Button	If the manager click on the paygrade tabs Edit button	the system should allow the manager to edit fields in the paygrade table
14	Click on Save Button	If the manager click on the paygrade tabs Save button	the system should save details changed by the manager
15	Click on Deduction Button	If the manager clicks on Deduction Button	the system should display available Deductions in the system
16	Click on the Leave structure Button	If manager click on Leave structure  Button	the system should display available Leave structures in system
17	Click on Employee Details Button	If the manager click on Employee Details Button	system should display available Employee Details  in the system
18	Click on Reports Button	If the manager click Reports Button	the system should display Reports  to the manager
19	Click on Generate payslip Button	If the Payroll Accountant clicks Generate payslip Button	the system should  display the search employee form to payroll Accountant
20	Click on Submit Button	If the Payroll Accountant click Generate payslip’s Submit  Button	the system should  display employee details of the corresponding employee id
21	Click on Generate Button	If Payroll Accountant click Generate payslip generate  Button	the system should  display the employee salary slip of that employee

 

Test Plan of Payroll Management System

General Information:

Summary:

We are testing the software of a Payroll Management System which maintains the information on the salary of every employee of the whole organization & generates payslips of employees.

Environment and Pre-Test Background:

This software is being tested in the Sibar-Mca Computer lab by Mca 2^nd year.

No prior testing has been done on this project.

Test Objective:

Authentication & Authorization.

View Employee Details.

Employee Performance Appraisal

Generates Payslips

Report Generation.

Modify Leave & salary structure

Plan

Software Description:

Sr no:	Process	Input	Output
1	Change Paygrade Details	Click on the Edit Button of Paygrade	Updates DatabasePrompt message to a user for completion
2	Change Leave Structure Details	Click on the Edit Button of Leave Structure	Updates DatabasePrompt message to a user for completion
3	Change Earnings Details	Click on the Edit Button of Earnings	Updates DatabasePrompt message to a user for completion
4	Change Deductions Details	Click on the Edit Button of Deductions	Updates DatabasePrompt message to a user for completion
5	Payslip Generation	Employee Id	Printed payslip

Test Team:

The test team will have the following members:

Tester:

The tester will perform the actual testing.

Business Expert:

Business Experts are those people who have knowledge about the business domain.

Test-Team Manager:

Test-Team Manager will be monitoring the whole testing process.

User:

The user is the End user who will be actually dealing with the software.

Requirement:

Computer with Eclipse any version  Apache tomcat  Java 1.6.0 and MYSQL Software installed on it.

We will require a Software requirement Specification document as well as Vision Document.

Specifications & Evaluations: 

Salary Structure Details:

This will help the Organization to keep information on the salary structures of each employee and will provide facilities to access it.

Leave Structure Details:

This will help the Organization to keep information on the Leave structures of each employee and will provide facilities to access it…

Report Generation 

This will generate various reports demanded by the organization to keep an eye on growth of their organization, working of staff etc

Structural Functions:

Give Specifications:

User will have to register for that Application form will be provided.

After Registration, the User will have a Password. 

Employee Information:

Depending upon the pay grade employee will be classified as either a payroll employee or payroll manager. If the user is a payroll manager of the Organization then we will provide him with facilities to Add, Edit as well as Delete payroll Details.

Payroll employees will be provided with a search option to search particular employees for the generation of his/her payslip.

Report Generation:

The user will be provided with a list of Reports using which he can generate reports by clicking on that options

The user will be provided an interface where he needs to give dates of which report has to be generated.

According to the Report, the user will need to give details on basis of that detail report will be generated.

 Functional Requirements:

Sr no	Functions	Tests
1	Give Specification	UsabilityCorrectness Reliability Security Performance Maintainability Visibility
2	Report Generation	SecurityReliability Correctness Understandability Visibility

Methods & Constraints:

Methodology:

We will be using White box testing for testing the project of payroll management. 

Evaluation:

Sr no	Objective	Priorities	Completeness Criteria
1	Adding Data	High	The system should Add data to the database. It should also prompt acknowledgment to the user.
2	Updating data	High	The system should update the old data with newly updated data. The system should check the authentication of the user and then make changes to the database. It should prompt a message to the user about updating.
3	Deleting data	High	The system should Remove the data demanded by the user from the database. It should check the authentication of the user before deleting the record. It should also confirm that a message is prompted to the user about deletion confirmation.
4	Searching data	High	The system should retrieve data from the database when the search option has been clicked. If data is not found relevant to user demand, a message should be displayed to the user about data not present.
5	Report Generation	High	After selecting a particular report, Data related to that report should be properly retrieved from the database in a proper format.

Download Payroll Management System Java Project.